Hello all,
I am on DB29.5 Data Warehouse Edition(DWE) I am unable to complete a tablespace container definition because of this error:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1757N A USING clause without an ON DATABASE PARTITION clause is missing.
SQLSTATE=428B1
During SQL processing it returned:SQL1756N More than one clause specifies containers without the ON NODES clause. SQLSTATE=428B1
The Tablespace definition that I am using
CREATE LARGE TABLESPACE "DWS_TS_00049_001" IN DATABASE PARTITION GROUP PDPG PAGESIZE 16384 MANAGED BY DATABASE
USING (FILE '/db2fs1p1/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs2p1/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs3p1/bcuaixd/edwd/DWS_TS_00049_001' 300 ) ON DBPARTITIONNUMS (1)
USING (FILE '/db2fs1p2/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs2p2/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs3p2/bcuaixd/edwd/DWS_TS_00049_001' 300 ) ON DBPARTITIONNUMS (2)
USING (FILE '/db2fs1p3/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs2p3/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs3p3/bcuaixd/edwd/DWS_TS_00049_001' 300 ) ON DBPARTITIONNUMS (3)
EXTENTSIZE 16 PREFETCHSIZE AUTOMATIC
BUFFERPOOL BP_16K
OVERHEAD 5.750000 TRANSFERRATE 0.400000
AUTORESIZE YES INCREASESIZE 1 M
MAXSIZE 50M
NO FILE SYSTEM CACHING
DROPPED TABLE RECOVERY ON;
Ok, out of curiosity, I changed the partition parameters as follows:
CREATE LARGE TABLESPACE "DWS_TS_00049_001" IN DATABASE PARTITION GROUP PDPG PAGESIZE 16384 MANAGED BY DATABASE
USING (FILE '/db2fs1p1/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs2p1/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs3p1/bcuaixd/edwd/DWS_TS_00049_001' 300 ) ON DATABASE PARTITION (1)
USING (FILE '/db2fs1p2/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs2p2/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs3p2/bcuaixd/edwd/DWS_TS_00049_001' 300 ) ON DATABASE PARTITION (2)
USING (FILE '/db2fs1p3/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs2p3/bcuaixd/edwd/DWS_TS_00049_001' 300,
FILE '/db2fs3p3/bcuaixd/edwd/DWS_TS_00049_001' 300 ) ON DATABASE PARTITION (3)
and got the following error.
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "DATABASE PARTITION" was found following
"_00049_001' 300 ) ON". Expected tokens may include: "<node_keyword>".
SQLSTATE=42601
Can anyone help me with the correct syntax ASAP?
Thanks everyone
when you define the tablespace you used
IN DATABASE PARTITION GROUP PDPG
each partition group can contain a different subset of the database partitions,
so in your case, PDPG contains all 24
you can create another partition group which will only contain 1 to 3 and then use it in your definition of the tablespace