Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI SQL Explorer for Db2 13.1.

Running the Update job

Use the following procedure to run the Update job.

  1. (optional) Update one or more values in the input file.For more information, see Editing-the-Update-file.

  2. Delete the Extract portion of the job from the JCL.In the following example, the Extract job ends after the first SYSIN. The Update job begins with the job card information that follows.

    //MVSIXT1M JOB (PDOM,1605A), 'MIGRATE STATS',REGION=0K,
    //             MSGCLASS=X,CLASS=A,NOTIFY=&SYSUID                    
    /*ROUTE XEQ BMCPLX1                                                 
    /*JOBPARM SYSAFF=DB2A                                               
    //*-----------------------------------------------------------------
    //*        MEMBER: PSSSMIGR                                         
    //*        EXECUTION OF MIGRATE ACCESS PATH STATISTICS              
    //*-----------------------------------------------------------------
    //MIGRATE EXEC PGM=PSSAWK,REGION=0M,                                
    //  PARM='-f SRC(PSSMIEXT)  -v SSID=DEDR -v PLAN=DAAVRMD1'
    //STEPLIB  DD DISP=SHR,DSN=BMCPERF.LOAD                      
    //         DD DISP=SHR,DSN=CSGI.SASC.V700C.LINKLIB                  
    //         DD DISP=SHR,DSN=SYS3.DEDR.DSNEXIT                        
    //         DD DISP=SHR,DSN=SYS2.DSNLOAD
    //BMCPSWD  DD DISP=SHR,DSN=AFDQA.AFD.PASSWORD                       
    //ABNLIGNR DD DUMMY                                                 
    //SRC      DD DISP=SHR,DSN=BMCPERF.CLIST                     
    //UPDATE   DD DISP=SHR,DSN=MVSIXT3.SQLXPLR.UPDATE                   
    //SYSTERM  DD SYSOUT=*                                              
    //SYSUDUMP DD SYSOUT=*                                              
    //SYSPRINT DD SYSOUT=*                                              
    //SYSIN    DD *                                                       
     DDFLOC DEDR                                                          
     MIGSTATS TABLESPACE PSSQX91.PSSS0391                                 
     DBNAME PSSQX91 TSSQX91                                               
     TSNAME PSSS0391 TSSS0391                                             
     TBCREATOR PSS TSS                                                    
     IXCREATOR PSS TSS                                                    
     IXNAME PSSX0%_D91S03T01 TSSX0%_D91S03T01                             
     INCLUDE (CS,RT)                                                      
    /*                                                                    
    //*                                                                   
    //*-----------------------------------------------------------------*/
    //*--THE FOLLOWING JCL IS FURNISHED FOR THE SECOND JOB.            -*/
    //*--MODIFY THE JOBCARD AND SUBMIT AFTER THE MIGRATE STEP          -*/
    //*--COMPLETES.                                                    -*/
    //                                                                    
    //*//MVSIXT1M JOB (PDOM,1605A), 'MIGRATE STATS',REGION=0K,
    //*//             MSGCLASS=X,CLASS=A,NOTIFY=&SYSUID                   
    //*/*ROUTE XEQ BMCPLX1                                                 
    //*/*JOBPARM SYSAFF=DB2A                                               
    //*                                                                   
    //*-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-  
    //*                   * * *  NOTE  * * *                              
    //*        VERIFY THAT THE DSNEXIT AND DSNLOAD LIBRARIES            
    //*        IN THE STEPLIB BELOW ARE FOR THE SSID IN THE             
    //*        PARM STRING JUST BELOW.  MODIFY AS NEEDED.               
    //*-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
    //UPDATE  EXEC PGM=PSSAWK,REGION=0M,                      
    //  PARM='-f SRC(PSSMIUPD)  -v SSID=DHZB -v PLAN=DAAVRMD1'
    //STEPLIB  DD DISP=SHR,DSN=BMCPERF.LOAD
    //         DD DISP=SHR,DSN=CSGI.SASC.V700C.LINKLIB        
    //         DD DISP=SHR,DSN=SYS3.DHZ.DSNEXIT               
    //         DD DISP=SHR,DSN=SYS2.DSNLOAD
    //BMCPSWD  DD DISP=SHR,DSN=AFDQA.AFD.PASSWORD             
    //ABNLIGNR DD DUMMY                                       
    //SYSTERM  DD SYSOUT=*                                    
    //SYSUDUMP DD SYSOUT=*                                    
    //SRC      DD DISP=SHR,DSN=BMCPERF.CLIST           
    //UPDATE   DD DISP=SHR,DSN=MVSIXT3.SQLXPLR.UPDATE         
    //SYSPRINT DD SYSOUT=*                                    
    //SYSIN    DD *                                           
     DDFLOC DHZ                                               
     MIGSTATS UPDATE ALL                                      
     COMMIT NOERROR                                                     
     COMMITFREQ TS                                                      
     ONERROR QUIT     
     RETRIES 5        
     DELETE YES       
     STATSTIME CURRENT
    /*

    For the example shown in the preceding figure, you would remove the first job and the lines preceding the job card.

  3. Uncomment the information about the second job card by deleting the three leading characters (//*) in each line that is part of the second job card.

    /*                                         
    //*                                                                   
    //*-----------------------------------------------------------------*/
    //*--THE FOLLOWING JCL IS FURNISHED FOR THE SECOND JOB.            -*/
    //*--MODIFY THE JOBCARD AND SUBMIT AFTER THE MIGRATE STEP          -*/
    //*--COMPLETES.                                                    -*/
    //                                                                    
    //*//MVSIXT1M JOB (PDOM,1605A), 'MIGRATE STATS',REGION=0K,
    //*//             MSGCLASS=X,CLASS=A,NOTIFY=&SYSUID                   
    //*/*ROUTE XEQ BMCPLX1                                        
    //*/*JOBPARM SYSAFF=DB2A
  4. If the target SSID is on a different MVS system from the source SSID, move the JCL to the correct MVS system and run the JCL on the target SSID.You might also need to verify that the DSNEXIT and DSNLOAD libraries are correct for the target SSID.

  5. Submit the Update job.The following figure shows an example of the output from the Update job.

     --BMC AMI SQL Explorer for Db2 PARMS- RELEASED mmm yyyy
                                                    
    (C) COPYRIGHT 1996 - 2021 BMC SOFTWARE, INC.
                                                    
     SSID=DEDR  PLAN=DAAVRMD1                        
     DDFLOC DEDR                                     
     MIGSTATS UPDATE ALL                             
     COMMIT NOERROR                                  
     COMMITFREQ TS                                   
     ONERROR QUIT                                    
     RETRIES 5                                       
     DELETE YES                                      
     STATSTIME CURRENT                               
                                                    
     REMOTE CONNECTION TO DEDR SUCCESSFUL            
     REMOTE DB2 VERSION DSN09015                     
                                                    
     TS PSSQX91.PSSS0391                UPDATED      
       TB PSS.PSST01_D91S03             UPDATED      
         IX PSS.PSSX01_D91S03T01        UPDATED      
         IX PSS.PSSX02_D91S03T01        UPDATED       
         IX PSS.PSSX03_D91S03T01        UPDATED                               
         IX PSS.PSSX04_D91S03T01        UPDATED                               
     **COMMIT UPDATES/INSERTS**                                               
                                                                             
     RECORD FORMAT FOR EACH OBJECT TYPE                                       
                                                                             
     :TS,DBNAME,NAME,NACTIVE,STATSTIME                                        
     :TB,CREATOR,NAME,CARD,NPAGES,PCTROWCOMP,STATSTIME                        
     :TA,PARTITION,CARD,NPAGES,PCTPAGES,NACTIVE,PCTROWCOMP,IBMREQD,STATSTIME  
     :CO,NAME,COLCARD,HIGH2KEY,LOW2KEY,STATSTIME                              
     :CD,NAME,TYPE,NUMCOLUMNS,CARD,FREQUENCY,IBMREQD,COLGROUPCOLNO,COLVALUE,STATSTIME
        **CD (FOR DB2) V9                                                     
     :CD,NAME,TYPE,NUMCOLUMNS,CARD,FREQUENCY,IBMREQD,COLGROUPCOLNO,COLVALUE,STATSTIME,QUANTILENO
        **DB2 V9 CD TYPE H, THE TWO FOLLOWING RECORDS                         
     :C1,LOWVALUE                                                             
     :C2,HIGHVALUE                                                            
     :CS,10,CNAME,PARTITION,COLCARD,STATSTIME,IBMREQD,STATS_FORMAT,COLCARDDATA
     :CS,20,CNAME,PARTITION,HIGHKEY                                           
     :CS,21,CNAME,PARTITION,HIGH2KEY                                          
     :CS,22,CNAME,PARTITION,LOWKEY                                            
     :CS,23,CNAME,PARTITION,LOW2KEY                                           
     :IX,CREATOR,NAME,NLEAF,NLEVELS,CLUSTERRATIO,FIRSTKEYCARD,FULLKEYCARD,STATSTIME
        **IX (FOR DB2) V9                                                    
     :IX,CREATOR,NAME,NLEAF,NLEVELS,CLUSTERRATIO,FIRSTKEYCARD,FULLKEYCARD,STATSTIME,DATAREPEATFACTORF
     :KT,10,SCHEMA,NAME,KEYSEQ,STATSTIME,STATS_FORMAT                        
     :KT,20,SCHEMA,NAME,KEYSEQ,HIGH2KEY                                      
     :KT,21,SCHEMA,NAME,KEYSEQ,LOW2KEY                                       
     :KD,10,SCHEMA,NAME,KEYSEQ,STATSTIME,CARDF,NUMKEYS,IBMREQD,FREQUENCYF,QUANTILENO,TYPE
     :KD,20,SCHEMA,NAME,KEYSEQ,KEYVALUE                                      
     :KD,21,SCHEMA,NAME,KEYSEQ,KEYGROUPKEYNO                                 
     :KD,22,SCHEMA,NAME,KEYSEQ,HIGHVALUE                                     
     :KD,23,SCHEMA,NAME,KEYSEQ,LOWVALUE                                      
     :KS,10,SCHEMA,NAME,KEYSEQ,PARTITION,STATSTIME,CARDF,IBMREQD,STATS_FORMAT
     :KS,20,SCHEMA,NAME,KEYSEQ,PARTITION,HIGHKEY                             
     :KS,21,SCHEMA,NAME,KEYSEQ,PARTITION,HIGH2KEY                            
     :KS,22,SCHEMA,NAME,KEYSEQ,PARTITION,LOWKEY                              
     :KS,23,SCHEMA,NAME,KEYSEQ,PARTITION,LOW2KEY                             
     :KA,10,SCHEMA,NAME,KEYSEQ,PARTITION,STATSTIME,CARDF,IBMREQD,TYPE,NUMKEYS,FREQUENCYF,QUANTILENO
     :KA,20,SCHEMA,NAME,KEYSEQ,PARTITION,KEYVALUE                            
     :KA,21,SCHEMA,NAME,KEYSEQ,PARTITION,KEYGROUPKEYNO                       
     :KA,22,SCHEMA,NAME,KEYSEQ,PARTITION,HIGHVALUE                           
     :KA,23,SCHEMA,NAME,KEYSEQ,PARTITION,LOWVALUE                            
    :RT,SCHEMA,NAME,ROUTINETYPE,SPECIFICNAME,PARM_COUNT,CARDINALITY,INITIAL_INSTS,INITIAL_IOS,INSTS_PER_INVOC,IOS_PER_INVOC

      MIGSTATS UPDATE SUMMARY mm/dd/yyyy 06:28 PM                            
                                                                            
     OBJECT             INPUT  UPDATED ERROR  WARNING                        
     ------------------ ------ ------- ------ -------                        
     TABLESPACE              1       1      0       0                        
     TABLES                  1       1      0       0                        
     TABSTATS                4       4      0       0                        
     COLUMNS                20      20      0       0                        
     COLDIST                48      48      0       0                        
     INDEXES                 4       4      0       0                        
     SYSKEYTARGETS           3       3      0       0                        
     SYSKEYTARGETSTATS      12      12      0       0                        
     SYSKEYTGTDIST           2       2      0       0                        
     SYSKEYTGTDISTSTATS      8       8      0       0                        
     COLSTATS                4       4      0       0                        
     ROUTINES             1058    1058      0       0

Related topic

Migrating access path statistics




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI SQL Explorer for Db2 12.1