Unable to allocate new pages in table space
Posted: Wed May 03, 2006 2:20 am
Hi,
When i tried to load from a dataset to a Db2 table by using Db2 enterprise stage.
Initially i used an upsert mode with a never satisfying update condition and always inserting records into the table. But most of the records are rejected with out any warnings.
then i used write method option, but the job is aborted with the following message.
Error Idx = 12;
DB2 Driver Embedded SQL message: SQL0289N Unable to allocate new pages in table space "TEDDAT902".
SQLSTATE=57011
;
sqlcode = -289;
sqlstate = 57011
Execute failed
when i tried to manually insert into the table, i got the following message
DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, SQLERRMC: TEDDAT902
Message: Unable to allocate new pages in table space "TEDDAT902".
is this issue related to database or not.
Plz help me in this issue
When i tried to load from a dataset to a Db2 table by using Db2 enterprise stage.
Initially i used an upsert mode with a never satisfying update condition and always inserting records into the table. But most of the records are rejected with out any warnings.
then i used write method option, but the job is aborted with the following message.
Error Idx = 12;
DB2 Driver Embedded SQL message: SQL0289N Unable to allocate new pages in table space "TEDDAT902".
SQLSTATE=57011
;
sqlcode = -289;
sqlstate = 57011
Execute failed
when i tried to manually insert into the table, i got the following message
DB2 SQL error: SQLCODE: -289, SQLSTATE: 57011, SQLERRMC: TEDDAT902
Message: Unable to allocate new pages in table space "TEDDAT902".
is this issue related to database or not.
Plz help me in this issue