Link to home
Start Free TrialLog in
Avatar of Enyimba
Enyimba

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Enyimba
Enyimba

ASKER

Again, thanks!