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)"
Db2 error -289
Moderators: chulett, rschirm, roy
Re: Db2 error -289
Hi,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)"
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