Unanswered: Import tab-delimited file to new DB2 table
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:
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?
always execute the commands in command line to have more info
load can be cancelled with load options .. check tablespace status and act accordingly
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be