Redefining partitions in a partitioned table space that uses table-controlled partitioning

Table-controlled partitioning does not require an index for partitioning and is defined by PARTITION clauses on the CREATE TABLE statement.

To redefine partitions in a partitioned table space that uses table-controlled partitioning:

1. On the DB2 Administration Menu (ADB2) panel, specify option 1, and press Enter.
2. On the System Catalog (ADB21) panel, enter any selection criteria at the bottom, specify option S, and press Enter.
3. On the Table Spaces (ADB21S) panel, enter the ALT line command against the partitioned table space that you want to redefine:
   

   ADB21S in ------------------ DD1A Table Spaces --------------- Row 1 to 4 of 4 
   Command ===>                                                   Scroll ===> CSR  
                                                                                  
   Commands: GRANT  MIG  DIS  STA  STO  ALL      DROP  MOVETB                             
   Line commands:                                                                 
    T - Tables  D - Database  A - Auth  G - Storage group  ICS - Image copy status
    DIS - Display table space  STA - Start table space  STO - Stop table space    
    ? - Show all line commands                                                                                                                 
                                                                                 C
   Select Name     DB Name   Parts Bpool  L E S I C  Tbls   Act pages  Segsz T L O
          *        *             * *      * * * * *     *           *      * * * *
   ------ -------- -------- ------ ------ - - - - - ----- ----------- ------ - - -
   ALT    TSFGRTB  DBFGRTB       4 BP0    A N A N Y     1          -1     32 R Y 
          TSFGRTB1 DBFGRTB1      3 BP0    A N A N Y     1          -1     32 R Y 
          TSFGRTB2 DBFGRTB2      5 BP0    P N A N N     1          -1      0   Y 
          TSFGRTB4 DBFGRTB4      5 BP0    P N A N N     1          -1     32 R Y 
   

   
4. If the Change Management Prompt (ADB2CMRO) panel is displayed, specify whether you want to use Change Management, and press Enter.
5. On the Redefine Table Space (ADB21SAR) panel, enter VALUES on the command line.

   If VALUES is not listed as a command, the object is not a partitioned table space.

6. On the Alter Partitioned Table (ADB21TAV) panel, edit the limit key value that you want to update and then enter NEXT on the command line.
   

   ADB21TAV  --------------- DD1A Alter Partitioned Table ------- Row 1 to 4 of 4 
   Command ===>                                                   Scroll ===> CSR  
                                                                                       
   Commands: NEXT      COLUMNS  ADD                                          
   Line commands:   INS - Insert Partition
                                                                                  
                                                                                  
   ALTER TABLE : RIVERAF.TBFGRTB                                                  
                                                                                  
                                                                                  
   Sel   Part Limit Key Value                                                     
   --- ------ ------------------------------------------------------------------->
            1 '1111        ',1111.                                                
            2 '2224        ',2224.                                                
            3 '3333        ',3333.                                                
            4 '6666        ',6666.   

   
7. On the Redefine Table Space (ADB21SAR) panel, enter NEXT on the command line.
8. On the Alter Objects (ADB27CA) panel, enter NEXT on the command line:

   ADB27CA n ---------------------- DD1A Alter Objects ---------- Row 1 to 1 of 1 
   Command ===>                                                   Scroll ===> CSR  
                                                                                  
   Commands: NEXT - Generate jobs  ADD - Add objects                             
    ALTOPT - Change alter options                                                
   Line commands:                                                                 
    A - Alter object  D - Delete  S - Select object  REL - Alter related          
    FK - Add FK-affected tables  RI - Add RI-related tables  E - Edit view DDL    
    RS - Reset RI-FK flags  CX - Create index  CFK - Create foreign key           
                                                                                  
       Object   Object                                      RI RI  FK             
   Sel Qual     Name               Ty Info 1   Info 2     Rels Add Add Operation  
       *        *                  *  *        *             * *   *   *          
   --- -------> -----------------> -- -------> -------> ------ --- --- -----------
       DBFGRTB  TSFGRTB            TS                          NA  NA  MODIFY
   

9. Generate an ALT job.