SQL0298N Bad container path Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db2udbgirl - 10 Apr 2006 04:37 GMT

I have a DMS tablespace named D_0001 which has 3 containers and hosts a
single partitioned table. I would like to reduce only the size of the
first container (p1data/tbspace/D_0001). Hence I used the command
alter tablespace D_0001 reduce (FILE '/p1data/tbspace/D_0001' 100)

But it failed with SQL0298N Bad container path. SQLSTATE=428B2. This
error doesn't make sense to me. Any help is appreciated

/home/oip] > find / -name D_0001 2> /dev/null
/p1data/tbspace/D_0001
/p2data/tbspace/D_0001
/p3data/tbspace/D_0001

/home/oip] > ls -l /p1data/tbspace/D_0001
-rw------- 1 oip instiadm 6467452928 Apr 10 01:50
/p1data/tbspace/D_0001
/home/oip] > ls -l /p2data/tbspace/D_0001
-rw------- 1 oip instiadm 6467452928 Apr 10 01:50
/p2data/tbspace/D_0001
/home/oip] > ls -l /p3data/tbspace/D_0001
-rw------- 1 oip instiadm 6467452928 Apr 10 01:50
/p3data/tbspace/D_0001
/home/oip] >

Thanks,
db2udbgirl.

Reply to this Message

Gregor Kovač - 10 Apr 2006 10:08 GMT

> SQL0298N

What the description of the error says, permissions can be a problem.
Looking at your ls ourput I see that D_0001 is only read/write for user oip,
but it has to be read/write accessible to the instance id.
Hope this helps a bit.

Best regards,
Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

| Gregor Kovac | Gregor.Kovac@mikropis.si |

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

Reply to this Message

Ian - 10 Apr 2006 15:49 GMT

> I have a DMS tablespace named D_0001 which has 3 containers and hosts a
> single partitioned table. I would like to reduce only the size of the
> first container (p1data/tbspace/D_0001). Hence I used the command
> alter tablespace D_0001 reduce (FILE '/p1data/tbspace/D_0001' 100)

It fails because that command is trying to reduce the size of the
container named '/p1data/tbspace/D_0001' on ALL partitions. Since
that container only exists on one partition (partition 1, I assume),
try:

alter tablespace D_0001
reduce (FILE '/p1data/tbspace/D_0001' 100)
on dbpartitionnum (1)

Reply to this Message

db2udbgirl - 10 Apr 2006 22:31 GMT

Great, It works now. Thanks for your inputs.

Reply to this Message