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
This looks very similar to a thread from a couple of days ago where a DB2 table was declared as partitioned in the job when it really wasn't. Could this also be the case here? Is your DB2 partitioned? If yes, have you declared the column as nullable?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
What column is the table partitioned on? That would be the column number 0 referred to in the error message.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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