Bug #40979 'Error on _ILECALL for API 'QlgCvtTextDescToDesc' (error = -8) from IBMDB2I

• Submitted: 24 Nov 2008 14:24
• Modified: 1 Apr 2009 9:32
• Reporter: Nidhi Shrotriya
• Status: Closed
• Severity: S3 (Non-critical)
• Version: 5.1.29rc
• OS: Other (IBM i5os)
• Assigned to: Nidhi Shrotriya
• CPU Architecture: Any

[24 Nov 2008 14:24] Nidhi Shrotriya

Description:
This issue is reported as part of certification testing of 'IBMDB2I' SE.

Created table with ibmdb2i with a char column. Inserting into table fails with below error.

mysql> create table new1 (c char(10)) engine=ibmdb2i;
Query OK, 0 rows affected (0.49 sec)

mysql> insert into new1 values ('hello');
ERROR 1296 (HY000): Got error 2501 'Error on _ILECALL for API 'QlgCvtTextDescToDesc' (error = -8)' from IBMDB2I

From MySQL server log:
-----------------------
ibmdb2i error 2511: Error on _ILECALL for API 'QlgCvtTextDescToDesc' (error = -8)

How to repeat:
See the above description.

[1 Apr 2009 9:29] Nidhi Shrotriya

Build was missing the -qalign=natural and -qldbl128 flags.
Fixed after build includes the -qalign=natural and -qldbl128 flags.