body { margin: 0 0 0 0; padding:0 0 0 0 }
td,div { font-family:Verdana;font-size:10pt;vertical-align:top }
body { margin: 0 0 0 0; padding:0 0 0 0 }
.transcript { background-color:#d2d2d2; }
.messageBlock { margin-left:4px; margin-bottom:3px }
.message { margin-left:100px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre; }
.messageCont { margin-left:100px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre;}
.other { color:#39577a;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.myself { color:#da8103;font-style:normal;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont { font-size:8px;text-align:right; color:#39577a;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.myselfCont { font-size:8px;text-align:right; color:#da8103;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.system { margin-left:4px; word-wrap:break-word;color:#da8103;font-style:normal;font-weight:normal; white-space:-moz-pre-wrap; _white-space:pre; }
.showTimestamp { margin-right:3px; float:right; color:#999999;font-style:normal;font-weight:normal; }
.other1 { color:#ac2000;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont1 { font-size:8px;text-align:right; color:#ac2000;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other2 { color:#3c9fa8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont2 { font-size:8px;text-align:right; color:#3c9fa8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other3 { color:#e25614;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont3 { font-size:8px;text-align:right; color:#e25614;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other4 { color:#0b6ac8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont4 { font-size:8px;text-align:right; color:#0b6ac8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other5 { color:#b23290;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont5 { font-size:8px;text-align:right; color:#b23290;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other6 { color:#02e7c7;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont6 { font-size:8px;text-align:right; color:#02e7c7;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other7 { color:#5b3284;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont7 { font-size:8px;text-align:right; color:#5b3284;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.tsDisplay { display:block }

getting this error when ETL job try to insert data into one table by trucating the existing data.

upon inserting some rows i am hitting this error .

Regards

kanak

db2 " ? sql289n"


SQL0289N Unable to allocate new pages in table space
          "<tablespace-name>". 

Explanation:

One of the following conditions is true on one or more database
partitions:
 

 1 One of the containers assigned to this SMS table space has    
reached the maximum file size. This is the likely cause of the   
error. 

 2 All the containers assigned to this DMS table space are full. 
This is the likely cause of the error. 

 3 A rebalance is in progress, but has not progressed far enough 
to enable the newly added space to be used. 

 4 A redirected restore is being done to containers that are too 
small. 

 5 A rollforward is being done following a redirected restore and
all the containers assigned to this tablespace are full. 

 6 A rollforward skipping add containers is being done and all   
the containers assigned to this tablespace are full. 

 7 An attempt was made to create a table space with less than 5  
usable extents. 

 8 An auto-resize table space has reached its maximum size and   
all of the containers are full. Alternately, there is not enough 
space between the current size and the maximum size for          
containers to be extended or added so an automatic increase in   
space is not possible. 

 9 An automatic storage table space is being created with a value
for initial size that does not result in an equal distribution of
container space. As a result, a higher value is being used but   
this value is larger than the maximum size specified. 

 10 A DMS table space enabled for auto-resize has not reached its
maximum size but one of the file systems on which the containers 
exists is full and the container cannot grow. 

 11 A DMS table space enabled for auto-resize has not reached its
maximum size and the file systems on which the table space       
resides are not full.  However, a container operation (or a      
subsequent rebalance) is in progress and the auto-resize         
capability is suspended until it is complete. 

 

User Response:

Perform the action corresponding to the cause of the error:
 

 1 Either switch to a DMS TABLESPACE or recreate the SMS        
TABLESPACE with more directories (PATHs) such that: (number of   
directories) >= (max tablesize / maxfilesize).  Note that      
maximum file size is operating system dependent. 

 2 Add new container(s) to the DMS table space and try the     
operation again, after the rebalancer has made the new pages     
available for use. 

 3 Wait for the rebalancer to finish. 

 4 Perform the redirected restore again to larger containers. 

 5 Perform the redirected restore again to larger containers. 

 6 Perform the rollforward again allowing add containers, or     
perform a redirected restore to larger containers. 

 7 Resubmit the CREATE TABLESPACE statement, ensuring that the   
table space has at least 5 usable extents. 

 8 Increase the maximum size for the table space. 

 9 Reduce the initial size or increase the maximum size for the  
table space. 

 10 Add a new stripe set of containers to the table space.       
Existing containers will no longer grow, only those new          
containers in the last range of the table space are extended when
an automatic resize occurs. 

 11 Wait for the operation and subsequent rebalance to  
complete.