Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    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:

    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •