By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

SQL0298N Bad container path Error

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
Great, It works now. Thanks for your inputs.

Apr 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.