Updating DASD MANAGER PLUS statistics by using BMCCPRS

Use this procedure to update the DASD MANAGER PLUS database with statistics from the DB2 catalog.

To update DASD MANAGER PLUS statistics by using BMCCPRS

1. Create an action as described in Creating-a-Service-Action.A user-defined Service Action is a group of services (utilities) within a DASD MANAGER PLUS job. This action creates a worklist to run the BMCCPRS utility. For more information about actions, see Maintaining-and-generating-Service-Actions.

   After you specify the action and press Enter, the Action List appears.

2. On the Action List, select the action by typing E (or S) in the Act field beside the action and pressing Enter.
3. Add the BMCCPRS service to the action, as follows:
   1. Type I in the Act field next to the services that should precede the BMCCPRS service and press Enter to add a blank line.
   2. On the blank line, type the following information:
      • Type E (or S) in the Act field.
      • In the Service field, type BMCCPRS.

      • In the Object Nam field, type the fully qualified object name.

        You can use wildcards. For example, QZUD40.% specifies all table spaces in the QZUD40 database.

      • In the Type field, type the two-letter abbreviation for the object type.

        Valid entries are TS (table space), IX (index), and TT (table space set).

   3. Press Enter to display the Service Syntax List panel.

   4. Type E in the Act field next to the syntax and press Enter to display the BMCCPRS panel (below). Optionally, you can add new syntax by typing I.

      BMCCPRS Parameters panel

      DEAE                  BMCCPRS TABLESPACE QZUD40.%             Row 1 to 13 of 13
      Command ===>                                                  Scroll ===> CSR  
                                                                                    
      Service Syntax: BMCCPRS.MVSTAD1-BMCCPRS                                        
                                                                                    
      Type Service Syntax options. Then press End.                        More:      
                                                                                    
      -------------------------- What to Migrate ------------------------------------
      Tablespace Options:                                                            
        TABLE  . . . . . * N      (Y/N/S Y=ALL Tables, N=No Tables, S=Select Tables)
        INDEX  . . . . . N        (Y/N Copy column stats on all indexes)             
                                                                                    
      -------------------------- BMC Statistics Report Options ----------------------
      REPORT . . . . . . Y        (Y/N - Print statistics report)                    
                                                                                    
      -------------------------- Stats Processing Options ---------------------------
      BADOBJECTRC  . . . 4        (0-8 Return code when object is bypassed)          
      MSGLEVEL . . . . . 0        (0/1 0-Normal msgs, 1-Additional msgs)             
      ******************************* Bottom of data ********************************
4. Specify the BMCCPRS utility parameters, as follows:
   1. In the TABLE field, type one of the following options:
      • Type Y to update column statistics on all tables in the table space.
      • Type S to display a selection list of tables to update. The options for S are similar to the options for using BMCSTATS.
      • Type N not to update column statistics on all tables in the table space. The default is N.
   2. In the INDEX field, indicate whether to update column statistics for all of the indexes in the table space and for the table space itself. The default is Y.
   3. In the REPORT field, indicate whether to print a report into the job output of the statistics that you copied or updated. The default is Y.
   4. In BADOBJECTRC and MSGLEVEL fields, accept the defaults.
   5. When you finish editing the BMCCPRS parameters, press END to save your changes, and press END again until you return to the Edit Action Services panel.
   6. Enter S on the Service Syntax List panel to select it.
5. Access the Action Job Generation panel by typing G next to an action on the Action List panel and pressing Enter.The Action Job Generation panel appears.
6. Complete the fields on the Action Job Generation panel and press Enter.
   1. In the Build Worklist, Build JCL, and Submit JCL fields, type S.
   2. (optional) In the Edit Worklist and Edit JCL fields, type S to review the built worklist and built JCL.
7. Depending on the options that you specified on the Action Job Generation panel, complete the following tasks:
   • To override the Product Options File (POF) settings, select Override POF Values.
   • To build the worklist, select Build Worklist.

   • To review the built worklist, select Edit Worklist.

     For detailed information about the worklist commands, see the Worklist-commands.

   • To build the JCL, select Build JCL.

   • To review the built JCL, select Edit JCL.

     When you review the built JCL, you can submit it for execution by typing SUB in the Command line.

   • To run the job automatically after building the worklist and JCL, select Submit JCL.

     As an alternate method (if you selected Edit JCL) type SUB on the ISPF Edit panel.

     Asterisks (*) in the Build Worklist and Build JCL fields indicate that the product has generated them.

8. Press Enter to confirm that you want to submit the BMCCPRS job. If you do not want to submit the job now, press END to return to the Edit Action Services panel.

   Tip

   Alternately, when the JCL appears for you to review it, you can enter SUB on the ISPF Edit panel to submit the JCL.