Bulk load Fail on DB2 table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
joycerecacho
Participant
Posts: 298
Joined: Tue Aug 26, 2008 12:17 pm

Bulk load Fail on DB2 table

Post 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.
Joyce A. Recacho
São Paulo/SP
Brazil
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Here's what I found on that error code:

SQL1013N The database alias name or database name "........" could not be found.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply