Output Load Command to Log
Posted: Tue Jun 02, 2009 1:01 am
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?
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?