I altered a table through Toad which set up range partitioning on a table.
I had to make another alteration to the table and the table was showing as not partitioned.
This is the generated DDL for the table:
CREATE TABLE FACT_PERSON_ELG_MM (
PERSON_ELIG_MM_KEY INTEGER NOT NULL,
PART_NBR INTEGER NOT NULL,
YEAR_MTH_ID CHARACTER(6),
PERSON_KEY INTEGER,
ELIG_DEMO_PRF_ID INTEGER,
CNTY_CD CHARACTER(2),
EOM_ELIG_IND CHARACTER(1),
BKDATED_ELIG_IND CHARACTER(1),
ELIG_IND CHARACTER(1),
MCAID_PGM_ID CHARACTER(4),
CREATED_YR_MTH_ID CHARACTER(6),
SPNDWN_IND CHARACTER(1),
RESIDENCE_CNTY_CD CHARACTER(2),
CITY_CD INTEGER,
ZIP_CD CHARACTER(5),
PERSON_CNT_AMT SMALLINT DEFAULT 1,
EXT_MCAID_CD CHARACTER(1) NOT NULL DEFAULT
)
PARTITION BY RANGE ( PART_NBR NULLS LAST ) (
PARTITION 1 STARTING 1 INCLUSIVE ENDING 1 INCLUSIVE IN WFDWH1TS_200201,
....
PARTITION 72 STARTING 72 INCLUSIVE ENDING 72 INCLUSIVE IN WFDWH1TS_200712 );
In the Alter Table Window, the table is shows PARTITIONED false and it should be true.
WORKAROUND:
The Alter Table window Partition property can be changed to TRUE. See Additional Information Section.
STATUS:
Waiting for fix in a future version of Toad for DB2.
Although this is a quick workaround, none of the partitioning information is available for the alter of the table without re-entering it all.
For example, let's say the you want to change the partition and make column 2 belong to tablespace 5.
There's no option of doing that, however the only thing you can do without having to re-enter it, is manual alter statements in the scripts.
The partition information should be listed for altering purposes.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center