Running utilities on LISTDEF lists

Instead of running utilities against explicitly specified table spaces or indexes, you can run utilities against a predefined list of objects. These lists are defined by the LISTDEF utility.

Procedure

To run utilities on a predefined LISTDEF list:
  1. On the DB2 Administration Menu (ADB2) panel, select option 5.
  2. On the Utility generation using LISTDEFs and TEMPLATEs (ADB25) panel, specify L.
  3. On the LISTDEFs (ADB25L) panel, specify the UT line command next to the LISTDEF list that contains the objects on which you want to run a utility.
    The LISTDEF Utilities (ADB25LU) panel is displayed:
    Figure 1. LISTDEF Utilities (ADB25LU) panel
    DB2 Admin --------------------- DD1A LISTDEF Utilities ------------------ 10:07
Option ===>                                                                    
                                                                               
 Execute utility using                                   DB2 System: DD1A      
    LISTDEF named SYSADM.DBLT0301                        DB2 SQL ID: ADM001     
                                                                               
    C - Copy full            CI - Copy incremental                             
   CC - Copy concurrent                                                        
    E - Mergecopy            EN - Mergecopy newcopy                            
    K - Check index                                                            
    M - Modify                                                                 
    O - Reorg                OU - Reorg unload only    OO - Online reorg       
   OI - Reorg Index                                                            
    P - Report recovery                                                        
    Q - Quiesce                                                                
   RB - Rebuild Index
    R - Runstats Tablespace  RT - Runstats table all   RR - Runstats report    
   RX - Runstats (to invalidate dynamic SQL cache for table spaces)            
   RI - Runstats Index      RIR - Runstats index report                        
  RIX - Runstats (to invalidate dynamic SQL cache for index spaces)            
    V - Recover              VR - Recover torba        VL - Recover logonly    
    U - Unload                                         VP - Recover tologpoint 
   SM - Standard Maintenance  C O R                                            
   DG - Define GDG for copy datasets                                           
   BP - Change batch job parameters                                            
   TU - Specify TEMPLATE usage                                                 
                                                                               
 Utility control options:                           
   Review/change options  . . . . . . NO   (Yes/No) 
   Generate work statement list . . . NO   (Yes/No) 
   Generate template statements . . . NO   (Yes/No) 
   Generate tablespace-only steps . . NO   (Yes/No)
  4. Optional: Specify the following options as needed:
    BP
    If you plan to generate a batch utility job stream and want to change the JOB statement or other system parameters, specify BP and press Enter. On the resulting Batch Job Utility Parameters (ADB2UPA) panel, specify the options that you want to change. Then, press PF3 to save your changes and return to the Tables Utilities (ADB2UT) panel.
    TU
    If you plan to use templates and want to specify which template to use for a given utility option, specify TU. Then, follow the instructions in Associating data set templates with keywords.
  5. In the Option field, specify a utility to run on the selected table. For example, specify C to run the COPY utility.
  6. Change any of the following control options, and press Enter:
    Review/change options
    Specify whether you want to review and change the utility options. If the value is NO, the default options for the selected utility are used.
    Generate work statement list
    Specify whether you want the utility control statements to be added to a work statement list (WSL). If the value is NO, an executable utility job stream is generated instead.
    Generate template statements
    Specify whether you want templates to be used. If the value is YES, Db2 Admin Tool uses the active templates that are defined. (If you want to change these templates, specify the TU option.)

    Db2 Admin Tool does not generate any TSODELETE statements to delete any existing data sets for the template first. To ensure that any existing data sets are deleted, consider using one of the following techniques when you define the template:

    • Specify the data set name pattern as a GDG (generation data group) where the next data set in the sequence is generated (+1), and change the other common options so that the GDGLIMIT is 1. This setup causes the data sets in the group to roll off so that only one data set exists at any one time. For example, a data set pattern name might be specified as &db..&ts..&name..ic(+1).
    • Specify a DISP option of NEW, DELETE, DELETE for the data set, if appropriate.
  7. If the Specify Utility Options panel is displayed, specify any additional options, and press Enter.
    This panel is displayed if Review/change options = YES.

    You must specify the options according to the Db2 syntax rules for utilities. For additional information, restrictions, and recommendations on various utility options, see Db2 online utilities (Db2 13 for z/OS).

  8. If you requested a work statement list (WSL): On the Specify Work Statement List (ADB2WLDA) panel, specify the WSL information, and press Enter.
    The utility statements are added to the WSL.
  9. If you requested a batch job stream: On the ISPF edit session, change the generated job as needed or copy it to another it to another data set.

    You can use standard ISPF editor commands to manually modify the JCL.

  10. Review and submit the generated JCL or run the specified WSL to run the utility.