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

have you tried
list tablespace containers for 19 show detail
just to see, which container is known

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