Output Load Command to Log

[stefanfrost1]

Hi,

I am using datastage 7.5.2 on AIX with DB2 9.1 DPF (MPP) also on AIX. We are using db2 enterprise stage to load data in parallell to each dpf node respectively. Sometimes a load on one node fails and the table ends up in a strange state. Pending on one node but ok on the other. The consequense of this is that the Load cannot be terminated normally. I have been experimenting with different settings in datastage but I can't find a solution to my problem of resetting the load... A great progress would be to se what statement datastage sends to the database in order to fully understand the load, but I just can't find a property that would print the load command to the log.

Does anyone know a property to set so that I can se the Load Command issued by datastage?

[andrewn]

You could try adding user defined variables:

Code: Select all

APT_DB2LOADER_DEBUG=True
APT_DEBUG_DB2=True

I'm not too sure if they will help. They let us see the load instructions sent when loading DB2 z/os tables, don't know about DB2 UDB. Worth a try?

[stefanfrost1]

I have tried

Code: Select all

APT_DEBUG_DB2=True

I gives me alot of great information, sadly not the command itself. I havn't tried

Code: Select all

APT_DB2LOADER_DEBUG=True

The documentation states the following

APT_DB2LOADER_DEBUG
Environemental variable to debug db2load operator.
If APT_DB2LOADER_DEBUG is set, db2load would pipe data into a
on disk rather than to a database.

It doesn't seem to give me what I want, but i'll try it anyway....

...Will post my findings....thanks

[stefanfrost1]

I tried

APT_DB2LOADER_DEBUG
Environemental variable to debug db2load operator.
If APT_DB2LOADER_DEBUG is set, db2load would pipe data into a
on disk rather than to a database.

I didn't provide me with the load command statement, it did however give me some column and load file info. As stated it also didn't load the table so I have to remove it.

Any other suggestions?