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,
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.
The Alter Table window Partition property can be changed to TRUE. See Additional Information Section.
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.