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
DB2 get row partitioning data Error
Moderators: chulett, rschirm, roy
Re: DB2 get row partitioning data Error
Hi,Rohit_ben wrote:
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.
Could you please help me out to resolve this error?
Rohit
this is clearly a DB2 error so you should focus on DB2 for solving it.
The DB2 command line (Unix - it is th shell) is an excellent tool for
looking up DB2 error codes (or just use google):
db2 ? SQL6039
This will show:
An attempt was made to assign a null value to partitioning column
"<column-number>", which is not nullable.
So this is it!
You got a null value in your data and this will not be processed because it is not allowed.
regards
Michael