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