DSXchange

Hi ,
Im having issue with the DB2 error. I have run the sequence job.Sequence job is finished successfully but when I have checked individual jobs it got aborted. Im seeing the following error . Can anyone please tell me what could be the reason.

"SQLExecute reported: SQLSTATE = 40506: Native Error Code = -1476: Msg = [IBM][CLI Driver][DB2/AIX64] SQL1476N The current transaction was rolled back because of error "-289". SQLSTATE=40506 (CC_DB2DBStatement::executeInsert, file CC_DB2DBStatement.cpp, line 661)"

In your shoes, I would ask your DBA.

developeretl wrote:"SQLExecute reported: SQLSTATE = 40506: Native Error Code = -1476: Msg = [IBM][CLI Driver][DB2/AIX64] SQL1476N The current transaction was rolled back because of error "-289". SQLSTATE=40506 (CC_DB2DBStatement::executeInsert, file CC_DB2DBStatement.cpp, line 661)"

Hi,

in DB2 you could check the error code by running
db2 ? SQL1476N
in the UNIX shell or in the DB2 CLP window(Windows).

In your case this does not help much - is just says that you should have a look sqlcode. This means you should run
db2 ? SQL-289 (or db2 ? sql0289)

And the message there is quite clear:
Unable to allocate new pages in table space

You run out of space!

Your DBA is responsible for the further solution...

best regards
Michael