SQLSTATE=S1000, DBMS.CODE=-7008

anakumar · Post by **anakumar** » Wed Oct 21, 2009 2:13 pm

Getting the following error when trying to insert data into DB2 from Datastage 7.5.2 on solaris 2.10
It is fine when we try to view data

LdBDetailTableTESTTEST..Xfm.DataToInsert: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO J73DISDTA.F554211B(SZEDUS) VALUES (?)
SQLSTATE=S1000, DBMS.CODE=-7008
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]F554211B in J73DISDTA not valid for operation. 3

SZEDUS = "EXPL_DIS "

aoriano · Post by **aoriano** » Thu Oct 22, 2009 7:32 am

This is not a DataStage problem. You should probably show your error message to your DB2 DBA.

I had this problem once, but it was resolved by the DB2 team.

anakumar · Post by **anakumar** » Thu Oct 22, 2009 9:47 am

aoriano,
Thanks for your response.
This query was working fine.
The AS400 was upgraded and we started getting this issue

Is there someway we can confirm that this is only a DB2 issue?

Please let me know
Thanks
Anandha kumar

chulett · Post by **chulett** » Thu Oct 22, 2009 11:06 am

Do you have any details on exactly what "the AS400 was upgraded" means?

anakumar · Post by **anakumar** » Fri Oct 23, 2009 7:48 am

Well we upgraded As400 from 5.2 to 5.3
Not sure if this upgrades the DB2 also

chulett · Post by **chulett** » Fri Oct 23, 2009 7:56 am

It would be good to know, one way or the other. And you still need to take this error to your DB2 DBA.

anakumar · Post by **anakumar** » Mon Oct 26, 2009 7:39 am

Found a solution to this issue. This post can be marked as resolved.

Journal was not enabled on the AS400 and it worked as soon as Journal was enabled.

Thanks for giving some pointers