I'm using DB2 v9.1. I created a new DB2 table and then thru Control Center tried to import a tab-delimited file into the table. I've never done this before in DB2, so please bare with me. I got this error:

SQL3015N An SQL error "-290" occurred during processing.

SQL0290N Table space access is not allowed. SQLSTATE=55039


So then I ran this:
db2 quiesce tablespaces for table db2inst1.rf_daily_dump_table exclusive
DB20000I The QUIESCE TABLESPACES command completed successfully


Here is what the db2diag.log looks like at that point:

2010-07-09-22.10.44.244167-300 I9869A397 LEVEL: Error
PID : 25034766 TID : 1 PROC : db2agent (WSIOBJS) 0
INSTANCE: db2inst1 NODE : 000 DB : WSIOBJS
APPHDL : 0-470 APPID: *LOCAL.db2inst1.100709183843
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbTestSetDatapoolState, probe:574
MESSAGE : ZRC=0xFFFFFFFF=-1

2010-07-09-22.10.44.245075-300 I10267A454 LEVEL: Error
PID : 25034766 TID : 1 PROC : db2agent (WSIOBJS) 0
INSTANCE: db2inst1 NODE : 000 DB : WSIOBJS
APPHDL : 0-470 APPID: *LOCAL.db2inst1.100709183843
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbTestSetDatapoolState, probe:574
DATA #1 : String, 57 bytes
poolID = 3, oldState = 7, newState = 0, currentState = 20

2010-07-09-22.10.44.245370-300 I10722A422 LEVEL: Error
PID : 25034766 TID : 1 PROC : db2agent (WSIOBJS) 0
INSTANCE: db2inst1 NODE : 000 DB : WSIOBJS
APPHDL : 0-470 APPID: *LOCAL.db2inst1.100709183843
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : sqluv_rollback , 0, 2, Detected in file:sqluvutl.C, Line:925



Here is a sample of what the tab-delimited file looks like:
"10176" "Bob Doe" 06/23/2010 6/23/10 4:02:26AM 6/23/10 4:18:14AM 999999 "X" " " "Lunch" "3001" 99999 " " " " " " " " " " " " 0




Then I tried importing the tab-delimited file again and got the same error as before. Could someone help me and guide me to what I should be looking for, I don't know what to do from here. Do you need any more information from me?

Thank you.

CC

Are you sure this was an import and not a load operation? Why did you need to quiesce?

It looks like tablespace id 3 is in backup pending. Execut "list tablespaces" and check the state of this tablespace, perform a backup if it's in backup pending.

always execute the commands in command line to have more info
load can be cancelled with load options .. check tablespace status and act accordingly