User displayed DDL of table with 4 partition tablespaces from Toad for DB2 v 4.7. It shown without indexes below:
CREATE TABLE "ZWBPMT"."M_NPF_FC_MO_CRCD_PROT_BAL" (
"AS_OF_DT_SK" INTEGER NOT NULL,
"PROD_ARGT_PROT_BAL_SEQ_NR" SMALLINT NOT NULL,
"PROD_ARGT_SK" BIGINT NOT NULL,
"CRCD_PROT_BAL_PROF_SEQ_SK" BIGINT NOT NULL,
"ACCT_STRUC_ITEM_DM_SEQ_SK" BIGINT NOT NULL,
"ISS_DT_SK" INTEGER NOT NULL,
"ORIG_DT_SK" INTEGER NOT NULL,
"TESR_END_DT_SK" INTEGER NOT NULL,
"ETL_NR" BIGINT NOT NULL,
"ETL_RECORDED_GMTS" TIMESTAMP NOT NULL,
"ETL_SOURCE_OBJECT_CD" CHARACTER(6) NOT NULL,
"TRNF_RT_PCT" DECIMAL(10,6)
)
INDEX IN "BKBPMT01PI01"
PARTITION BY RANGE ( "AS_OF_DT_SK" NULLS LAST ) (
PARTITION YR2008 STARTING 54421 INCLUSIVE ENDING 54787 EXCLUSIVE IN "BKBPMT01PD01",
PARTITION YR2009 STARTING 54787 INCLUSIVE ENDING 55152 EXCLUSIVE IN "BKBPMT01PD02",
PARTITION YR2010 STARTING 55152 INCLUSIVE ENDING 55517 EXCLUSIVE IN "BKBPMT01PD03",
PARTITION YR2011 STARTING 55517 INCLUSIVE ENDING 55882 EXCLUSIVE IN "BKBPMT01PD04" )
DISTRIBUTE BY HASH ( "PROD_ARGT_SK" )
COMPRESS YES;
ALTER TABLE "ZWBPMT"."M_NPF_FC_MO_CRCD_PROT_BAL"
DATA CAPTURE NONE
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE;
--This is system required index
CREATE UNIQUE INDEX "ZWBPMT"."M_NPF_FC_MO_CRCD_PROT_BAL_PK"
ON "ZWBPMT"."M_NPF_FC_MO_CRCD_PROT_BAL"
( "PROD_ARGT_SK" ASC, "PROD_ARGT_PROT_BAL_SEQ_NR" ASC, "AS_OF_DT_SK" ASC )
PARTITIONED
ALLOW REVERSE SCANS COMPRESS YES;
ALTER TABLE "ZWBPMT"."M_NPF_FC_MO_CRCD_PROT_BAL"
ADD CONSTRAINT "M_NPF_FC_MO_CRCD_PROT_BAL_PK" PRIMARY KEY
("PROD_ARGT_SK", "PROD_ARGT_PROT_BAL_SEQ_NR", "AS_OF_DT_SK");
HOWEVER, he used IBM db2look to displ