Submitting customization jobs
Submit the customization jobs to customize Db2® SQL Performance Analyzer.
Before you begin
Ensure that the correct jobs are generated.
About this task
The following figure shows part of the Finish Product Customization panel. The table on this panel shows the customization jobs that are generated by Tools Customizer. They are grouped by job sequence number.
CCQPCST Finish Product Customization Row 1 to 23 of 41
Submit the members in the order in which they apply to each DB2 entry. To
submit the job, edit the member and issue the TSO SUBMIT command, or edit
the customized library and submit the jobs from there.
Product to Customize
Product metadata library : ANL.ALIAS.SANLDENU > LPAR . . : MVS1
Product name . . . . . . : DB2 SQL Performance Analyz > Version . : 5.2.0
Line Commands: E - Edit B - Browse
Product customization library . : ANL.PRODUCT.CUST.$MVS1$.ANL520 >
Cmd Member SSID GrpAttch Template Generated Description
- -------- ---- ---- -------- ---------- ------------------------------>
CCQPCMC Finish Product Customization Row 1 to 8 of 8
Command ===> Scroll ===> CSR
Submit the members in the order in which they apply to all DB2 entries. To
submit the job, browse the member and issue the TSO SUBMIT commmand, or browse
the customized library and submit the jobs from there.
Product to Customize
Product metadata library : CQM.CQM330.SCQMDENU > LPAR . . : RS22
Product name . . . . . . : IBM DB2 Query Monitor > Version . : 3.3.0
Configuration ID: CQM > Description: IBM DB2 Query Monitor >
Line Commands: E - Edit B - Browse
Product customization library . : USER01.TCZ.$RS22$.CQM330 >
Cmd Member SSID GrpAttch Template Date Description
- -------- ---- ---- -------- ---------- ------------------------------>
A0V3AA -- -- CQMV33 2017/10/25 Configure Startup CLIST 1
A1V3AA -- -- CQM33C 2017/10/25 Configure Startup CLIST 2
A2#DAAAA DB2A -- CQM#DDL 2017/10/25 Create DB2 Objects
A9#BAAAA DB2A -- CQM#BD8N 2017/10/25 CQM Binds
B3GRAAAA DB2A -- CQMGRAN8 2017/10/25 Grant Execute Authority
B4CNAA -- -- CQMCNTFL 2017/10/25 Create Control File
B5CFAAAA DB2A -- CQMCF2UP 2017/10/25 Update CQM Control File
--------------------------- End of customized jobs ----------------------------CCQPCMC Finish Product Customization Row 1 to 8 of 8
Command ===> Scroll ===> CSR
Submit the members in the order in which they apply to all DB2 entries. To
submit the job, browse the member and issue the TSO SUBMIT commmand, or browse
the customized library and submit the jobs from there.
Product to Customize
Product metadata library : CQM.CQM320.SCQMDENU > LPAR . . : RS22
Product name . . . . . . : IBM DB2 Query Monitor > Version . : 3.2.0
Configuration ID: CQM > Description: IBM DB2 Query Monitor >
Line Commands: E - Edit B - Browse
Product customization library . : USER01.TCZ.$RS22$.CQM320 >
Cmd Member SSID GrpAttch Template Date Description
- -------- ---- ---- -------- ---------- ------------------------------>
A0V3AA -- -- CQMV32 2017/10/25 Configure Startup CLIST 1
A1V3AA -- -- CQM32C 2017/10/25 Configure Startup CLIST 2
A2#DAAAA DB2A -- CQM#DDL 2017/10/25 Create DB2 Objects
A9#BAAAA DB2A -- CQM#BD8N 2017/10/25 CQM Binds
B3GRAAAA DB2A -- CQMGRAN8 2017/10/25 Grant Execute Authority
B4CNAA -- -- CQMCNTFL 2017/10/25 Create Control File
B5CFAAAA DB2A -- CQMCF2UP 2017/10/25 Update CQM Control File
--------------------------- End of customized jobs ----------------------------CCQPCST Finish Product Customization Row 1 to 2 of 2
Command ===> Scroll ===> PAGE
CCQC000I The jobs were generated on the selected DB2 entries.
Submit the members in the order in which they apply to all DB2 entries. To
submit the job, browse the member and issue the TSO SUBMIT command, or browse
the customized library and submit the jobs from there.
Product to Customize
Product metadata library . : DB2TOOL.PTF420.SCKPDENU > LPAR . . : 3090
Product name . . . . . . . : DB2 Path Checker > Version . : 4.2.0
Line Commands: E - Edit B - Browse
Product customization library .: THOMAS.PRODUCT.CUST.$3090$.CKP420
Cmd Member SSID GrpAttch Template Date Description
- -------- ---- ---- -------- ---------- ------------------------------>
A0BND3AA DB2A -- CKPBND31 2013/09/24 Path Checker bind job
A1TSO33 -- -- CKPTSO33 2013/09/24 Create Path Checker invocation
--------------------------- End of customized jobs ----------------------------CCQPCST Finish Product Customization Row 1 to 7 of 7
For a first-time customization, submit the jobs in the members in the order
in which they apply to the DB2 entries. Otherwise, submit only the necessary
jobs that were generated after changes were made. To submit jobs, browse
the members and issue the TSO SUBMIT command.
Line Commands: E - Edit B - Browse
Product customization library .: TSUSRA.HLO210.$RS23$.HLO210 >
Cmd Member SSID GrpAttch Template Date Description
- -------- ---- ---- -------- ---------- ------------------------------>
A01CAA -- -- HLO1CLST 2015/12/19 Configures startup CLIST 1
A12CAA -- -- HLO2CLST 2015/12/19 Configures startup CLIST 2
A2STAA -- -- HLOSTCJ 2015/12/19 Creates STC and components
A3SMAA -- -- HLOSMPJ 2015/12/19 Creates repository maintenance
A4HLVS -- -- HLOHLVS 2015/12/19 Creates the server
A5IN00 -- -- HLOIN00 2015/12/19 Creates the server parms
A6VOBJ -- -- HLOVOBJ 2015/12/19 Creates OBJ file
A7UMAP -- -- HLOUMAP 2015/12/19 Creates user map file
A8DFDIV -- -- HLODFDIV 2015/12/19 Creates server files
A9DRAAAA DA1A -- HLODROP 2015/12/19 Drops repository objects
B0DDAAAA DA1A -- HLODDL 2015/12/19 Creates repository objects
B1RFAAAA DA1A -- HLORFREE 2015/12/19 Frees packages and plans
B2VFAAAA DA1A -- HLOVFREE 2015/12/19 Frees server packages
B3RBAAAA DA1A -- HLORBIND 2015/12/19 Binds packages and plans
B4VBAAAA DA1A -- HLOVBIND 2015/12/19 Binds server packages
B5RGAAAA DA1A -- HLORGRNT 2015/12/19 Grants EXECUTE authority
B6VGAAAA DA1A -- HLOVGRNT 2015/12/19 Grants EXEC to server pkgs
B7CPAA -- -- HLOCPROF 2015/12/19 Creates profile data sets
B8MPAA -- -- HLOMPROF 2015/12/19 Migrates profiles
B9CCAA -- -- HLOCCNTL 2015/12/19 Creates a new control file
C0UCAAAA DA1A -- HLOUCNTL 2015/12/19 Updates control file
C1IVAA -- -- HLOIVP 2015/12/19 Creates IVP jobs
C2ADAA -- -- HLOADBI 2015/12/19 Configures the REXX EXEC
--------------------------- End of customized jobs ----------------------------
TCUSTMZR Finish Product Customization Row 1 to 9 of 15
Command ===> Scroll ===> CSR
For a first-time customization, submit the jobs in the members in the order
in which they apply to the DB2 entries. Otherwise, submit only the necessary
jobs that were generated after changes were made. To submit jobs, browse
the members and issue the TSO SUBMIT command.
Line Commands: E - Edit B - Browse
Product customization library: TWUSR.WRK0160.$RS22$.DYX160
Cmd Member New SSID GrpAttch Template Date Description
* * * * * *
- -------- --- ---- ---- -------- ---------- -------------------------->
A0DROPAB YES SS01 -- DYXDROP 2017/09/26 Drop DB2 Autonomics tables
A1DDL1AB YES SS01 -- DYXDDL1 2017/09/26 Create DB2 Autonomics Objec
A2FREEAB YES SS01 -- DYXFREE 2017/09/26 Free packages and plans
A3BINDAB YES SS01 -- DYXBIND 2017/09/26 Binds packages and plans
A4GRANAB YES SS01 -- DYXGRANT 2017/09/26 Grants EXECUTE authority
A5WLMAB YES SS01 -- DYXWLM 2017/09/26 Create WLM address space fo
A6RUN1AB YES SS01 -- DYXRUN1 2017/09/26 Create batch job to run DB2
A7TSNAAB YES SS01 -- DYXTSNAB 2017/09/26 Create batch job to run RTS
A8SRVCF YES -- -- DYXSRVCF 2017/09/26 Create server config file f
A9AGTCF YES -- -- DYXAGTCF 2017/09/26 Create agent config file fo
B0SSLCR YES -- -- DYXSSLCR 2017/09/26 Generate new key database
B1AGTJB YES -- -- DYXAGTJB 2017/09/26 Create agent job for DB2 Au
B2SRVJB YES -- -- DYXSRVJB 2017/09/26 Create server job for DB2 A
B3AGTST YES -- -- DYXAGTST 2017/09/26 Create agent STC for DB2 Au
B4SRVST YES -- -- DYXSRVST 2017/09/26 Create server STC for DB2 A
--------------------------- End of customized jobs ----------------------------The member-naming conventions depend on whether the customization jobs are for Db2 entries, and LPAR, or the product.
The New filed indicates if the job member is newly created/updated. It is either
YES or NO. YES indicates the job member is newly created or updated, and it needs to be submitted
for customization. NO indicates the job member is not newly created/updated, it does not need to be
submitted for customization.
- Customization jobs for Db2 entries
- The members use the following naming convention:
<job_sequence_number><job_ID><configuration_ID><Db2_entry_ID>where
- job_sequence_number
- Two alphanumeric characters, A0 - Z9, that Tools Customizer assigns to a customization job. The number for the first template in the sequence is A0, the number for the second template is A1, and so on.
- job_ID
- Characters 4 - 5 of the template name, if the template name contains five or more characters. Otherwise, only character 4 is used. For example, for the XYZCRE8I template, the job ID is CR. For the XYZC template, the job ID is C. Db2 SQL Performance Analyzer assigns the template name.
- configuration_ID
- Two alphanumeric characters, AA - 99, that Tools Customizer assigns to a configuration.
- Db2_entry_ID
- Two alphanumeric characters, AA - 99, that Tools Customizer assigns to a Db2 entry.
For example, the XYZBNDDb2_entry_ID_1 and XYZBNDDb2_entry_ID_2 jobs are generated from the XYZBNDGR template, and the XYZ4Db2_entry_ID_1 and XYZ4Db2_entry_ID_2 jobs are generated from the XYZ4 template. If the jobs are generated on two Db2 entries for two configurations, the following member names are listed sequentially: A0BNAAAA, A0BNABAB, A14AAAA, A14ABAB.
- Customization jobs for an LPAR or the product
- The members use the following naming convention:
<job_sequence_number><job_ID>where
- job_sequence_number
- Two alphanumeric characters, A0 - Z9, that Tools Customizer assigns to a customization job. The number for the first template in the sequence is A0, the number for the second template is A1, and so on.
- job_ID
- Characters 4 - 8 of the template name if the template name contains five or more characters. Otherwise, only character 4 is used. For example, for the XYZMAKE template, the job ID is MAKE. For the XYZM template, the job ID is M. Db2 SQL Performance Analyzer assigns the template name, and it is displayed in the Template column.
For example, the XYZBNDGR job is generated from the XYZBNDGR template, and the XYZ4 job is generated from the XYZ4 template. The following member names are listed sequentially: A0BNDGR, A14.
- Customization jobs for configurations
- The members use the following naming convention:
<job_sequence_number><configuration_ID><Db2_entry_ID>where
- job_sequence_number
- Two alphanumeric characters, A0 - Z9, that Tools Customizer assigns to a customization job. The number for the first template in the sequence is A0, the number for the second template is A1, and so on.
- configuration_ID
- Two alphanumeric characters, AA - 99, that Tools Customizer assigns to a configuration.
- Db2_entry_ID
- Two alphanumeric characters, AA - 99, that Tools Customizer assigns to a Db2 entry.
For example, for two configurations on the same Db2 entry, the XYZBIND job is generated from the XYZBNDGR template, and the XYZMAKE9 job is generated from the XYZ4 template. The following member names are listed sequentially: A0AAAA, A1ABAA.
Procedure
Results
What to do next
You can generate more customization jobs for other Db2 entries, view a list of customization jobs that you previously generated, or recustomize Db2 SQL Performance Analyzer.