Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Unanswered: Unable to ALTER or DROP Tablespace Container

    Hi

    I am trying to drop a few container from the various tablespaces in our database. We have over time upgraded the DB2 software from v6 to v8.2 on AIX.

    When we try and drop some of the container, we get the following error in the DB2DIAG.LOG file :
    -------------------
    MESSAGE : ADM6038E Unable to perform an operation on container
    "/db2/ABD/sapdata4/PSAPPOOLI.container002" because it does not exist
    in table space "PSAPPOOLI" (ID "19"). Refer to the documentation for
    SQLCODE -298.
    -------------------
    RETCODE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
    "Bad container path"
    -------------------
    The command we used was :
    ALTER TABLESPACE PSAPPOOLI DROP ( FILE '/db2/ABD/sapdata4/PSAPPOOLI.container002' )
    -------------------

    We are able to alter other containers in the tablespaces, and even add containers. This error only occurs on some containters.

    The files are there at OS level, and have all the correct rights.

    I have searched everywhere for a solution, but nothing has helped. I have done REORGS and used DB2DART.

    The reason for the changes is to improve the DB performance. We have recently moved the data from SSA disks, which were badly configured to a new SAN with RAID.

    Thanks in advance.
    Regards
    Stuart

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    drop container

    have you tried
    list tablespace containers for 19 show detail
    just to see, which container is known
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Oct 2004
    Posts
    2
    Hi przytula
    Yes, I have tried the "list tablespace containers..." command, for all the tablespaces I am working with. Everything appears correct.

    There are 5 containers in the tablespace. # of them were created a long while back, and I have been able to delete 1 of the original 3, but the remaining 2, which are the same size, etc..., return the error I mentioned before.
    Thanks
    Regards
    Stuart

Posting Permissions

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