Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: Table space access is not allowed in db2

    Hi all,

    In our setup db2 v9.7 with fixpack 4

    Issues in the tablespace level

    When i tried to select the table i am getting the error.

    Table space access is not allowed.. SQLCODE=-290, SQLSTATE=55039

    I check with the tablespace state it's in 0*0020

    I took the backup of the tablespace to /dev/null

    db2 backup db TIS_DWHT tablespace METRIC_SPD_TAB online to /dev/null

    Tablespace went to normal state 0*0020

    Again I execute the select query for the table i am getting the same errror

    Table space access is not allowed.. SQLCODE=-290, SQLSTATE=55039

    How to resolve this issue?

    Thanks,
    laxman.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the output of:


    Code:
    select tbsp_name,tbsp_id,tbsp_state from sysibmadm.snaptbsp_part
    Andy

  3. #3
    Join Date
    Sep 2012
    Posts
    177
    Andy thanks for you reply.

    METRIC_WGHT_TAB 60 NORMAL ( Tablespace is in normal state)

    People from Datastage tried to load the data using bulk load option, And immediately table went to check pending state with the reason code 1.

    After that I used the command "set integrity for the table with immediate checked"

    It's throws an error with Tablespace access is not allowed. So I took the backup of tablespace and tablespace went to normal state..

    How to fix this issue?

    Thanks,
    laxman.

  4. #4
    Join Date
    May 2013
    Posts
    3
    use the follown command to stop load process

    load ....terminate

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    why would you use load terminate - the load completed
    the db is in backup pending
    use load with copy yes or nonrecoverable
    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

  6. #6
    Join Date
    May 2013
    Posts
    3
    Quote Originally Posted by przytula_guy View Post
    why would you use load terminate - the load completed
    the db is in backup pending
    use load with copy yes or nonrecoverable
    i 'm wrong,i don't know the load has completed

Posting Permissions

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