Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012

    Unanswered: Issues in the tablespace level

    Hi all,

    In our setup db2V9.7 with fixpack 4

    Having the issue with tablespace.

    Initially people from Datastate tried to load the data. It's throwing the error

    Operation not allowed for reason code "1" on table "db2DWH.TIS_DW_METRIC_OCPNCY".. SQLCODE=-668, SQLSTATE=57016, DRIVER=4.14.113

    So i applied the integrity for the table

    set integrity for "db2DWH"."TIS_DW_METRIC_OCPNCY" immediate checked

    Getting the error Table space access is not allowed.. SQLCODE=-290, SQLSTATE=55039, DRIVER=4.12.79

    So i checked with the tablespace level tablespace went to 0x0020

    So i take the backup of the tablespace

    [db2inst1@***~]$ db2 backup db TIS_DWHT tablespace METOCPNCY_TAB online to /dev/null

    Backup successful. The timestamp for this backup image is : 20130502191654

    Then tablespace went to normal state..

    When i executed the select query for the table i am facing the same problem.

    Tablespace access is not allowed?

    How to solve this issue?


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    latest status ? message you get ?
    maybe they start a load and do not specify copy yes / 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

Posting Permissions

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