Wednesday, November 6, 2013

Autoextend

If you get the following error it means the tablespace has ran out of space:

CREATE TABLE UA_CampAttribute ( CampaignID           bigint NOT NULL, AttributeID          bigint NOT NULL, StringValue          varchar(1024), NumberValue          float, DatetimeValue        timestamp, CONSTRAINT cCampAttribute_PK PRIMARY KEY (CampaignID, AttributeID) )                                                           
DB21034E  The command was processed as an SQL statement because it was not a                                                                                        
valid Command Line Processor command.  During SQL processing it returned:                                                                                            
SQL0289N  Unable to allocate new pages in table space "UNICA".  SQLSTATE=57011

Note: You may also get an error like this:
DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC

Easiest way is to turn on autoextend:
db2 => connect to unicadb
   Database Connection Information
 Database server        = DB2/LINUXX8664 10.1.3
 SQL authorization ID   = DB2INST1            
 Local database alias   = UNICADB             
db2 => alter tablespace unica autoresize yes     
DB20000I  The SQL command completed successfully.
db2 => quit                                      
And it should be OK now:
CREATE TABLE UA_CampAttribute ( CampaignID           bigint NOT NULL, AttributeID          bigint NOT NULL, StringValue          varchar(1024), NumberValue          float, DatetimeValue        timestamp, CONSTRAINT cCampAttribute_PK PRIMARY KEY (CampaignID, AttributeID) )                                                           
DB20000I  The SQL command completed successfully.                                                                                                                    

No comments:

Post a Comment