• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 634
  • Last Modified:

Bad container path.. SQLCODE=-298, SQLSTATE=428B2 while create DMS tablespace...help needed

Hi all,

I am trying to create Database managed tablespace. The containers were created as such:
/rapmw/db2data01/ptl01_tbsp
/rapmw/db2data02/ptl01_tbsp
/rapmw/db2data03/ptl01_tbsp
/rapmw/db2data04/ptl01_tbsp
/rapmw/db2data05/ptl01_tbsp
/rapmw/db2data06/ptl01_tbsp
/rapmw/db2data07/ptl01_tbsp

Now, when I tried to create the tablespace in these container usind the following sql, I got the following error:

, DRIVER=4.18.60

The sql that I am running is this :
CREATE LARGE TABLESPACE "TS8K_PTL01_DAT"
      IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"
      PAGESIZE 8 K
        MANAGED BY DATABASE
      USING (DEVICE   '/rapmw/db2data01/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data02/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data03/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data04/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data05/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data06/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data07/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data08/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data09/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data10/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data11/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data12/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data13/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw/db2data14/PTL01_TBSP' 5000,
                  DEVICE  '/rapmw_db2data15/PTL01_TBSP' 5000)
            PREFETCHSIZE 16
            BUFFERPOOL "BP8K_PTL01"
            NO FILE SYSTEM CACHING;

Can I get some feedback on what and I am going wrong here?
Note: At the /rapmw/db2data* level, there are other directory entries, but at the /PTL01_TBSP level, it is empty.

Can anyone help with this too.

Thanks

Enyimba
0
Enyimba
Asked:
Enyimba
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Enyimba,

That's a well known issue that's documented on the IBM/DB2 pages.

  http://www-01.ibm.com/support/docview.wss?uid=swg21406807

Essentially, it's a poorly worded message that indicates that the tablespace would violate how you've already declared the underlying file space.


Kent
0
 
EnyimbaAuthor Commented:
Again, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now