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_tbs p
/rapmw/db2data02/ptl01_tbs p
/rapmw/db2data03/ptl01_tbs p
/rapmw/db2data04/ptl01_tbs p
/rapmw/db2data05/ptl01_tbs p
/rapmw/db2data06/ptl01_tbs p
/rapmw/db2data07/ptl01_tbs p
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_TB SP' 5000,
DEVICE '/rapmw/db2data02/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data03/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data04/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data05/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data06/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data07/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data08/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data09/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data10/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data11/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data12/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data13/PTL01_TB SP' 5000,
DEVICE '/rapmw/db2data14/PTL01_TB SP' 5000,
DEVICE '/rapmw_db2data15/PTL01_TB SP' 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
I am trying to create Database managed tablespace. The containers were created as such:
/rapmw/db2data01/ptl01_tbs
/rapmw/db2data02/ptl01_tbs
/rapmw/db2data03/ptl01_tbs
/rapmw/db2data04/ptl01_tbs
/rapmw/db2data05/ptl01_tbs
/rapmw/db2data06/ptl01_tbs
/rapmw/db2data07/ptl01_tbs
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_TB
DEVICE '/rapmw/db2data02/PTL01_TB
DEVICE '/rapmw/db2data03/PTL01_TB
DEVICE '/rapmw/db2data04/PTL01_TB
DEVICE '/rapmw/db2data05/PTL01_TB
DEVICE '/rapmw/db2data06/PTL01_TB
DEVICE '/rapmw/db2data07/PTL01_TB
DEVICE '/rapmw/db2data08/PTL01_TB
DEVICE '/rapmw/db2data09/PTL01_TB
DEVICE '/rapmw/db2data10/PTL01_TB
DEVICE '/rapmw/db2data11/PTL01_TB
DEVICE '/rapmw/db2data12/PTL01_TB
DEVICE '/rapmw/db2data13/PTL01_TB
DEVICE '/rapmw/db2data14/PTL01_TB
DEVICE '/rapmw_db2data15/PTL01_TB
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER