In RC/Query when doing the DDL command on a Partitioned by Range Tablespace all the partitions are shown, and contain the exact same information.
Is there a way to prevent the DDL for all the partitions from generating?
Example of the first few partitions:
CREATE TABLESPACE CUSTTS
IN DBACCT
USING STOGROUP SGNEW
PRIQTY 48
SECQTY 262080
ERASE NO
BUFFERPOOL BP1
DSSIZE 4G
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
INSERT ALGORITHM 0
PAGENUM ABSOLUTE
DEFINE YES
LOGGED
LOCKSIZE PAGE
MAXROWS 255
CCSID EBCDIC
NUMPARTS 40
(PARTITION 1
USING STOGROUP SGNEW
PRIQTY 48
SECQTY 262080
ERASE NO
PCTFREE 0 FOR UPDATE 0
FREEPAGE 0
GBPCACHE CHANGED
COMPRESS NO
TRACKMOD YES
,PARTITION 2
USING STOGROUP SGNEW
PRIQTY 48
SECQTY 262080
ERASE NO
PCTFREE 0 FOR UPDATE 0
FREEPAGE 0
GBPCACHE CHANGED
COMPRESS NO
TRACKMOD YES
Release : 20.0
Component : CA RC/Query for DB2 for z/OS
In the hilvl.CDBAPARM dataset there is an OFS member. Change the first parameter to a 'Y':
GENERATE_COMMON_PARTITION_SPECIFICATIONS_AT_GLOBAL_LEVEL (N) /* */
/* Y-YES, TO GENERATE THE
/* COMMON PARTITION
/* SPECIFICATIONS AT THE
/* GLOBAL LEVEL INSTEAD OF
/* EVERY PARTITION LEVEL
/* N-NO, TO GENERATE ALL
/* PARTITION SPECIFICATIONS
/* AT EVERY PARTITION LEVEL
With this set to a 'Y' only the common partition specifications generate:
CREATE TABLESPACE CUSTTS
IN DBACCT
USING STOGROUP SGNEW
PRIQTY 48
SECQTY 262080
ERASE NO
BUFFERPOOL BP1
DSSIZE 4G
CLOSE YES
LOCKMAX SYSTEM
SEGSIZE 64
INSERT ALGORITHM 0
PAGENUM ABSOLUTE
DEFINE YES
LOGGED
LOCKSIZE PAGE
MAXROWS 255
CCSID EBCDIC
NUMPARTS 40