Page 1 of 1

Bulk load Fail on DB2 table

Posted: Wed Nov 08, 2017 7:24 am
by joycerecacho
Hi everybody.

I am trying to truncate an DB2 Table and then execute a 'BulkLoad' but I am getting the following error:

DB2_REG_FAT: An error occurred while preparing the table partitioning information. The method db2CfgGet returned reason code 0, SQLCODE -1,013. (CC_DB2Connection::obtainPartitioningInfoForTable, file CC_DB2Connection.cpp, line 3,972)

The truncate is in the 'Table Action'.

The job is basically: DATASET > TRANSFORMER > DB2 CONNECTOR

I just saw one topic here about this error however no solution for it.

Any idea?

Thanks in advance.

Posted: Wed Nov 08, 2017 8:25 am
by qt_ky
Here's what I found on that error code:

SQL1013N The database alias name or database name "........" could not be found.