We help IT Professionals succeed at work.

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

Enyimba
Enyimba asked
on
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
Comment
Watch Question

Data Warehouse / Database Architect
Commented:
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

Author

Commented:
Again, thanks!