Return
-
Title
Migrate a tablespace does not recreate primary index -
Description
Using Toad for DB2 v 4.6.0, tried to migrate the tablespaces and dependant objects and it did not pick up the primary index. Toad for DB2 v4.5.2 is migrating the ddl correctly.
Toad for DB2 v 4.6.0 generated:
ALTER TABLE WF50PU.DM_AG_ELIG_STATUS
ADD CONSTRAINT "WFDW1RI1" PRIMARY KEY
("AG_ELIG_STAT_CD"
ÂToad 4.5.2 generated:
CREATE UNIQUE INDEX "WF50PU"."WFDW1RI1"
ON "WF50PU"."DM_AG_ELIG_STATUS"
("AG_ELIG_STAT_CD" ASC
)
CLUSTER
PCTFREE 10
ALLOW REVERSE SCANS;
ALTER TABLE WF50PU.DM_AG_ELIG_STATUS
ADD CONSTRAINT "SQL100406115640610" PRIMARY KEY
("AG_ELIG_STAT_CD"
);
 -
Resolution
WORKAROUND:
None
Â
STATUS
Waiting for a fix with CR/ST 72,848 on a future release of Toad for DB2.
-
Additional Information
Also
CR 72,849 for Extended Alter
CR 72,850 for Extract DDL
Â