467,209 Members | 1,346 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

SQL0298N Bad container path Error

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.

Apr 10 '06 #1
  • viewed: 9433
Share:
3 Replies
db2udbgirl wrote:
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
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Apr 10 '06 #2
Ian
db2udbgirl wrote:
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)

Apr 10 '06 #3
Great, It works now. Thanks for your inputs.

Apr 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Antony | last post: by
5 posts views Thread by Michael Sperlle | last post: by
1 post views Thread by jamesdylangoldstein@gmail.com | last post: by
reply views Thread by Shadow of Socrates | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.