Bug #42531 'CREATE TABLE t1(M-PM-:M-PM->M-PM-; INT)' fails with ibmdb2i
Submitted: 2 Feb 2009 5:49 Modified: 21 Feb 2014 19:35
Reporter: Nirbhay Choubey Email Updates:
Status: Unsupported Impact on me:
None 
Category:Obsolete Severity:S3 (Non-critical)
Version:5.1.30 OS:Other (IBMi 5.4)
Assigned to: CPU Architecture:Any

[2 Feb 2009 5:49] Nirbhay Choubey 
Description:
'CREATE TABLE t1(M-PM-:M-PM->M-PM-; INT)' fails when executed with 'ibmdb2i' storage engine with following error : 

failed: 1005: Can't create table 'testdb.t1' (errno: 2021)

Server job log :
Job 294866/QUSER/QSQSRVR started on 01/22/09 at 00:38:56 in subsystem
QSYSWRK in QSYS. Job entered system on 01/22/09 at 00:38:56.
ACGDTA for 294866/QUSER/QSQSRVR not journaled; reason 1.
Printer device PRT01 not found.
Errors on CHGJOB command for job 294866/QUSER/QSQSRVR.

How to repeat:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1(M-PM-:M-PM->M-PM-; INT);
[21 Feb 2014 19:35] Sveta Smirnova 
Thank you for the report.

Storage engine ibmdb2i is not supported anymore.