DB2 get row partitioning data Error
Posted: Mon Aug 02, 2010 4:01 am
Hi
One of my DataStage parallel jobs is getting aborted and the director shows the following error messages.
tfpCustIp,0: DB2 get row partitioning data Error.
tfpCustIp,0: SQLCODE = -6039; SQLSTATE=
tfpCustIp,0: SQL6039N Partitioning column "0" is currently defined as not nullable.
tfpCustIp,0: DB2 Get Row Partitioning Information failed.
tfpCustIp,0: Failure during execution of operator logic.
My job design is as follows:
DB2/UDB Select -----> Transformer -----> Funnel -----> Transformer(name:tfpCustIp) -----> DB2/UDB Write-Append
Could you please help me out to resolve this error?
(This is my first post to DsXchange so please let me know if you have any concern regarding my post)
Rohit
One of my DataStage parallel jobs is getting aborted and the director shows the following error messages.
tfpCustIp,0: DB2 get row partitioning data Error.
tfpCustIp,0: SQLCODE = -6039; SQLSTATE=
tfpCustIp,0: SQL6039N Partitioning column "0" is currently defined as not nullable.
tfpCustIp,0: DB2 Get Row Partitioning Information failed.
tfpCustIp,0: Failure during execution of operator logic.
My job design is as follows:
DB2/UDB Select -----> Transformer -----> Funnel -----> Transformer(name:tfpCustIp) -----> DB2/UDB Write-Append
Could you please help me out to resolve this error?
(This is my first post to DsXchange so please let me know if you have any concern regarding my post)
Rohit