Worksheets: Gathering parameter values for Db2 Query Monitor

During the customization process, you will need to provide parameter values for Db2 Query Monitor, for Db2, and for your LPAR.

Use the worksheets in this topic to record the appropriate parameter settings for your purposes, and then use these worksheets during the customization process. The worksheets are organized based on the order of the customization panels in the Tools Customizer.

Product customization library

Description
The product customization library field shown on the Product Parameters panel (CCQPPRD) is read-only.
Table 1. Product Customization library
Parameter Sample or default value Your value
Product customization library
This value displays the name of the data set in which the generated library customization jobs will be stored.
 No This value is derived from the user-specified customization library qualifier on the Tools Customizer Settings panel (CCQPSET).

Common parameters section

Description
The parameters in this task are required for all customizations. During the customization process, you will enter these values on panel CCQPPRD.
Table 2. Required parameters section
Parameter Required? Discovered? Default value Your value
Db2 Query Monitor for z/OS® data set high-level qualifier
The high-level qualifier for the Db2 Query Monitor data sets.
 Yes No None  
Started task proclib
The started task proclib.
 Yes No None  
Started task proclib volume name
The started task proclib volume name.
 Yes No None  
Started task proclib SMS storage class
The started task proclib SMS storage class.
 Yes No None  
FEC data set high-level qualifier
The high-level qualifier for the FEC data sets.
Yes No None  
Db2 Data Access Common Collect data set high-level qualifier
The high-level qualifier for the CQC data sets.
 Yes No None  
Db2 control file
The data set name of the Db2 Control File.
 Yes No None  
Db2 interval file
The data set name of the interval file.
 Yes No None  
Db2 profile file
The data set name of the Db2 profile file.
 Yes No None  
Parameter file data set name
The data set name of the Db2 Query Monitor parameter file.
 Yes Yes None  
CAE Server address
The CAE Server Listener Address.
 No Yes 0.0.0.0  
Db2 Query Monitor Subsystem name
The Query Monitor Subsystem name.
 Yes Yes None  

Customization values for the Discover EXEC

Description
Use the following worksheet to identify and record the customization values for the Tools Customizer Discover EXEC. The values in this worksheet are for extracting information from a product that has already been customized. During the customization process, you will enter these values on panel CCQPDSC.
Note: Complete this worksheet only if you are recustomizing a product that has previously been customized by using Tools Customizer.
Table 3. Customization values for the Discover EXEC
Parameter Sample or default value Your value
Discover EXEC library
The fully qualified data set name that contains the product Discover EXEC.
 The name of the Discover EXEC Library that you entered on the settings panel.  
Discover EXEC name
The name of the Discover EXEC.
 CQMDISC  
Discover output data set
The name of the data set for the output from the product Discover EXEC.
 The name of the discover output library that you entered on the settings panel.  
Db2 Query Monitor for z/OS parameters location
The location of the Db2 Query Monitor parameters file.
 HLQ.V3R4.SCQMSAMP(CQMPARMS)  
Db2 Query Monitor for z/OS CAE Agent parameters location
The location of the Db2 Query Monitor CAE Agent parameters file.
 HLQ.V3R4.SCQMSAMP(CQMCPRMS)  

Task: Create customized Db2 Query Monitor for z/OS jobs

Description
This task creates customized Db2 Query Monitor jobs. During the customization process, you will enter these values on panel CCQPPRD.

This task is required.

Jobs generated
This task generates the following jobs: A0CNTFL, A1#CTLAA, A2INTER, A3PROFS, and A4BINDAA,
Table 4. Customized Db2 Query Monitor jobs
Step or parameter Required? Discovered? Default value Your value
Allocate and initialize the Db2 Control file
This subtask allocates and initializes the Db2 Control File using the specified storage class and volume name.
 Yes No None  
Update the Db2 SSID entries in the Db2 Control File
This subtask updates the Db2 Control File.
 Yes No None  
Allocate and initialize the interval processing file
This subtask allocates and initializes the interval processing file using the specified storage class and volume name.
 Yes No None  
Allocate and initialize the profile file
This subtask allocates and initializes the profile file using the specified storage class and volume name.
 Yes No None  
Bind Db2 Query Monitor packages and plan
This subtask binds the plan for the Db2 Query Monitor packages and plans. Only one bind job is required for each data sharing group.
 Yes No None  

Task: Create necessary Db2 Query Monitor for z/OS jobs for offload

Description
This task creates the necessary Db2 Query Monitor jobs for offload. During the customization process, you will enter these values on panel CCQPPRD.

This task is Optional.

Jobs generated
This task generates the following jobs: B4RBINAA, B5RGRTAA, and B6VRUNAA.
Table 5. Db2 Query Monitor jobs for offload
Step or parameter Required? Discovered? Default value Your value
Create DDL to drop the Db2 Query Monitor for z/OS objects
This subtask creates the DDL to drop the Db2 Query Monitor objects.
 No No None  
Create offload tables
This subtask creates the Db2 Query Monitor offload tables.
 No No None  
Create statement type table
This subtask creates the Db2 Query Monitor statement type table.
 No No None  
Create table comments
This subtask creates table comments.
 No No None  
Create optional indexes
This subtask creates optional indexes.
 No No None  
Offload Interval data to Db2 tables
This subtask offloads interval data to Db2 tables. The following parameters are available for this subtask:
High-level qualifier for interval offload
(Required) The high-level qualifier for the Db2 Query Monitor interval offload.
 No No None  
Load Statement Type Table
This subtask loads the statement type table.
 No No None  
Customize SQL to run the sample queries
This subtask customizes SQL to run sample queries.
 No No None  
Create DDL to grant public access to Db2 Query Monitor for z/OS tables
This subtask creates the DDL to grant public access to Db2 Query Monitor tables.
 No No None  

Task: Create Db2 Query Monitor for z/OS batch reports

Description
This task creates the necessary Db2 Query Monitor jobs for offload. During the customization process, you will enter these values on panel CCQPPRD.

This task is Optional.

Jobs generated
This task generates the following jobs: B4RBINAA, B5VRUNAA.
Table 6. Db2 Query Monitor batch reports
Step or parameter Required? Discovered? Default value Your value
Batch Report data sets high-level qualifier
The data set high-level qualifier for batch reports.
 No No No  
Batch report volume name
The volume name for batch reports.
 No No No  
Batch report SMS storage class
The SMS storage class for batch reports.
 No No No  
Bind the plan for the batch reports
This subtask binds the plan for the Db2 Query Monitor batch reports.
 No No No  
Customize the JCL to run the batch reports
This subtask customizes the JCL to run the Db2 Query Monitor batch reports.
 No No No  
Issue GRANTS for the batch report plan
This subtask generates DCL statements to identify who can execute the batch reports plan.
 No No No  

Task: Customize the Db2 Query Monitor for z/OS started task

Description
This task creates the necessary Db2 Query Monitor jobs for offload. During the customization process, you will enter these values on panel CCQPPRD.

This task is Optional.

Jobs generated
This task generates the following jobs: B6PROC, B7MSTR.
Table 7. Db2 Query Monitor started task
Step or parameter Required? Discovered? Default value Your value
Create the started task for Db2 Query Monitor for z/OS
Creates the started task for Db2 Query Monitor.
Yes No -  
Create a shutdown script for the main address space
Creates a shutdown script for the main address space.
 Yes No -  

Task: Customize the Db2 Query Monitor for z/OS CAE Server or CAE Agent

Description
This task customizes the Db2 Query Monitor CAE Server or CAE Agent. During the customization process, you will enter these values on panel CCQPPRD.

This task is Optional.

Jobs generated
This task generates the following jobs: B8CAE, B9CAESV, C0CUNPX, C1CUPPT.
Table 8. Create the CAE Agent and CAE Server on Windows for Db2 Query Monitor for z/OS
Step or parameter Required? Discovered? Default value Your value
Create the CAE agent for Db2 Query Monitor for z/OS
This subtask creates the CAE Agent.
 - - -  
CAE server address
(Required) The CAE Server address.
 Yes Yes None  
ISPF Listener port
(Required) The port used by the CAE Agent to listen for incoming connections from the ISPF client.
 Yes Yes None  
Server/Listener port
(Required) The port at which the CAE Server listens for incoming connections from the CAE Agent. The SERVER_PORT parameter in CQMCPMRS.
 Yes Yes 3448  
Backup CAE server address
The Backup CAE Server address.
 No Yes 0.0.0.0  
Backup Server/Listener port
The Backup CAE Server listener port.
 No Yes 3448  
Listener agent port low
(Required) The lowest listener port number for the CAE Agent. Valid values are numeric, 5 digits maximum, in a range between 1 and 65535. Default 53000.
 Yes Yes 53000  
Listener agent port high
(Required) The highest listener port number for the CAE Agent. Valid values are numeric, 5 digits maximum, in a range between 1 and 65535. Default 53005.
 Yes Yes 53005  
Agent name
The CAE Agent name.
 No Yes CQMCAE  
Table 9. Create the USS CAE Server for Db2 Query Monitor for z/OS
Step or parameter Required? Discovered? Default value Your value
Create the USS CAE server for Db2 Query Monitor for z/OS
This subtask creates the CAE Server on USS.
 - - -  
USS VAR_HOME path
(Required) The USS VAR_HOME path.
 Yes No userhome/cqmv3r4/var  
USS JAVA path
(Required) The USS Java™ path.
 Yes No /usr/lpp/java/IBM®/J11.0_64  
USS LOG path
(Required) The location to which CAE Agent logs are stored on z/OS.
Note: The directory part of the path of the STDOUT DD statement must be the same as the directory specified for the CQM_LOGS parameter in STDENV. For example, if /u/username/cqm34/bin/start_cae_agent is in the STDOUT DD statement, then the CQM_LOGS must be /u/username/cqm34/logs (the /u/username/cqm34 portion of the path must match for both).
 Yes No /var/cqm/logs  
HTTPS port number
Specifies the HTTPS port on the CAE Server that the CAE Browser Client connects to.
Note: This parameter applies only for deployment of the CAE Server on USS.
 No No 443  
USS binary file path
(Required) The USS binary file path.
 Yes No None  
USS VAR_HOME path
(Required) Specifies the USS VAR_HOME file path, USS binary file path, and USS VAR_HOME path values.
 Yes No None  
UNPAX CAE PTF
This subtask unpaxes the CAE PTF using the specified USS binary file path and USS VAR_HOME path values.
 Yes No

The default USS Binary File Path is /proj/cqmv3r4/bin.

The default USS VAR_HOME Path is /proj/cqmdata.

  

Task: Create the collector parameter file

Description
This task creates the necessary Db2 Query Monitor jobs for offload. During the customization process, you will enter these values on panel CCQPPRD.

This task is Optional.

Jobs generated
This task generates the C2PRMCR job.
Table 10. Specify collector parameters subtask
Step or parameter Required? Discovered? Default value Your value
CQMPARMS volume name
The volume name for CQMPARMS.
 No Yes    
CQMPARMS SMS storage class
The storage class for CQMPARMS.
 No Yes    
Collector AUTHID
The Db2 AUTHID that is used to establish a connection to Db2 during interval processing.
 No Yes Defaults to the user ID under which the started task will run.  
Main procname
The Support Services Address Space PROCNAME.
 Yes Yes None.  
Db2 Query Monitor for z/OS group
Specifies the name (8-byte, character) of group to which this Query Monitor Subsystem belongs.
 No Yes None  
Db2 Query Monitor for z/OS alert limit
The maximum number of alerts that are to be queued for the CAE Agent alert processor.
 No Yes 10  
Collect Db2 catalog objects
Indicates whether or not object statistics are collected for catalog objects.
 No Yes N  
Data set full
Instructs Db2 Query Monitor what to do when a backstore data set cannot be extended.
 No Yes IGNORE  
Interval
The length of the recording interval in minutes.
 No Yes 720  
Interval midnight
Creates intervals for which the starting times are aligned to midnight.
 No Yes Y  
Maximum SQLCODE detail
The limit on the number of times detailed information for each occurrence of an SQLCODE is collected.
 No Yes 0  
Maximum SQLCODES
The limit on the number of unique SQLCODES for which information is collected.
No Yes 0  
Maximum memory allocations
The maximum amount of global shared memory that will be allocated by Db2 Query Monitor for internal Integrated Storage Manager spaces.
 No Yes 4096  
Collect object statistics
Indicates whether or not to collect object statistics.
 No Yes    
Summarization OPTKEYS
The level of granularity for summary buckets.
 No Yes None  
Interval RETAIN count
How many prior intervals are to be retained on DASD after interval processing is complete.
 No Yes 6  
Maximum global shared memory size
The maximum amount of global shared memory in gigabytes that are allocated by Db2 Query Monitor for all purposes.
 No Yes 5  
SMS data class
The SMS data class for the allocation of the Performance History Files.
 No Yes Null  
SMS management class
The SMS management class for the allocation of the Performance History Files.
 No Yes Null  
SMS storage class
The SMS storage class for the allocation of the Performance History Files.
 No Yes Null  
Unit name
The UNITNAME parameter enables you to specify an esoteric name, generic device type or a device address for the backstore data sets.
 No Yes Null  
Volume name
The VOLUME parameter enables you to specify a volume for the backstore data sets.
 No Yes Null  
DB2CDATA DSN mask
The data set name for the DB2CDATA VSAM backstore data set.
 Yes Yes None  
DB2CDATA primary allocation
The primary space quantity for the DB2CDATA Performance History File.
 No Yes 5  
DB2CDATA secondary allocation
The secondary space quantity for the DB2CDATA Performance History File.
 No Yes 2  
DB2CDATA allocation space units
The space units (CYLS or TRKS) for allocation of the DB2CDATA Performance History File.
 No Yes CYLS  
DB2CDATA SMS data class
The SMS data class for the DB2CDATA Performance History File.
 No Yes None  
DB2CDATA SMS management class
The SMS management class for the DB2CDATA Performance History File.
 No Yes None  
DB2CDATA SMS storage class
The SMS storage class for the DB2CDATA Performance History File.
 No Yes None  
DB2CDATA unit name
An esoteric name, generic device type or a device address for the DB2CDATA Performance History File.
 No Yes None  
DB2CDATA volume name
The volume for the DB2CDATA Performance History File.
 No Yes None  
EXCPDATA DSN mask
The data set name for the EXCPDATA VSAM backstore data set.
 Yes Yes None  
EXCPDATA primary allocation
The primary space quantity for the EXCPDATA Performance History File.
 No Yes 5  
EXCPDATA secondary allocation
The secondary space quantity for the EXCPDATA Performance History File.
 No Yes 2  
EXCPDATA allocation space units
The space units (CYLS or TRKS) for allocation of the EXCPDATA Performance History File.
 No Yes CYLS  
EXCPDATA SMS data class
The SMS data class for the EXCPDATA Performance History File.
 No Yes None  
EXCPDATA SMS management class
The SMS management class for the EXCPDATA Performance History File.
 No Yes None  
EXCPDATA SMS storage class
The SMS storage class for the EXCPDATA Performance History File.
 No Yes None  
EXCPDATA unit name
An esoteric name, generic device type or a device address for the EXCPDATA Performance History File.
 No Yes None  
EXCPDATA volume name
The volume for the EXCPDATA Performance History File.
 No Yes None  
EXCPHSTV DSN mask
The data set name for the EXCPHSTV Performance History File.
 Yes Yes None  
EXCPHSTV primary allocation
The primary space quantity for the EXCPHSTV Performance History File.
 No Yes 5  
EXCPHSTV secondary allocation
The secondary space quantity for the EXCPHSTV Performance History File.
 No Yes 2  
EXCPHSTV allocation space units
The space units (CYLS or TRKS) for allocation of the EXCPHSTV Performance History File.
 No Yes CYLS  
EXCPHSTV SMS data class
The SMS data class for the EXCPHSTV Performance History File.
 No Yes None  
EXCPHSTV SMS management class
The SMS management class for the EXCPHSTV Performance History File.
 No Yes None  
EXCPHSTV SMS storage class
The SMS storage class for the EXCPHSTV Performance History File.
 No Yes None  
EXCPHSTV unit name
An esoteric name, generic device type or a device address for the EXCPHSTV Performance History File.
 No Yes None  
EXCPHSTV volume name
The volume for the EXCPHSTV Performance History File.
 No Yes None  
EXCPINDX DSN mask
The data set name for the EXCPINDX Performance History File.
 Yes Yes None  
EXCPINDX primary allocation
The primary space quantity for the EXCPINDX Performance History File.
 No Yes 5  
EXCPINDX secondary allocation
The secondary space quantity for the EXCPINDX Performance History File.
 No Yes 2  
EXCPINDX allocation space units
The space units (CYLS or TRKS) for allocation of the EXCPINDX Performance History File.
 No Yes CYLS  
EXCPINDX SMS data class
The SMS data class for the EXCPTEXT Performance History File.
 No Yes None  
EXCPINDX SMS management class
The SMS management class for the EXCPINDX Performance History File.
 No Yes None  
EXCPINDX SMS storage class
The SMS storage class for the EXCPINDX Performance History File.
 No Yes None  
EXCPINDX unit name
An esoteric name, generic device type or a device address for the EXCPINDX Performance History File.
 No Yes None  
EXCPINDX volume name
The volume for the EXCPINDX Performance History File.
 No Yes None  
EXCPTEXT DSN mask
The EXCPTEXT Performance History File.
 Yes Yes None  
EXCPTEXT primary allocation
The primary space quantity for the EXCPTEXT Performance History File.
 No Yes 5  
EXCPTEXT secondary allocation
The secondary space quantity for the EXCPTEXT Performance History File.
 No Yes 2  
EXCPTEXT allocation space units
The space units (CYLS or TRKS) for allocation of the EXCPTEXT Performance History File.
 No Yes CYLS  
EXCPTEXT SMS data class
Specifies an SMS data class for the EXCPTEXT Performance History File.
 No Yes None  
EXCPTEXT SMS management class
The SMS management class for the EXCPTEXT Performance History File.
 No Yes None  
EXCPTEXT SMS storage class
The SMS data class for the EXCPTEXT Performance History File.
 No Yes None  
EXCPTEXT unit name
An esoteric name, generic device type or a device address for the EXCPTEXT Performance History File.
No Yes None  
EXCPTEXT volume name
The volume for the EXCPTEXT Performance History File.
 No Yes None  
METRDATA DSN mask
The data set name for the METRDATA Performance History File.
 Yes Yes None  
METRDATA primary allocation
The primary space quantity for the METRDATA Performance History File.
 No Yes 5  
METRDATA secondary allocation
The secondary space quantity for the METRDATA Performance History File.
 No Yes 2  
METRDATA allocation space units
The space units (CYLS or TRKS) for allocation of the METRDATA Performance History File.
 No Yes CYLS  
METRDATA SMS data class
The SMS data class for the METRDATA Performance History File.
 No Yes None  
METRDATA SMS management class
The SMS management class for the METRDATA Performance History File.
 No Yes None  
METRDATA SMS storage class
The SMS storage class for the METRDATA Performance History File.
 No Yes None  
METRDATA unit name
An esoteric name, generic device type or a device address for the METRDATA Performance History File.
 No Yes None  
METRDATA volume name
The volume for the METRDATA Performance History File.
 No Yes None  
OBJSDATA DSN mask
The data set name for the OBJSDATA Performance History File.
 Yes Yes None  
OBJSDATA primary allocation
The primary space quantity for the OBJSDATA Performance History File.
 No Yes 5  
OBJSDATA secondary allocation
The secondary space quantity for the OBJSDATA Performance History File.
 No Yes 2  
OBJSDATA allocation space units
The space units CYLS, or TRKS for allocation of the OBJSDATA Performance History File.
 No Yes CYLS  
OBJSDATA SMS data class
The SMS data class for the OBJSDATA Performance History File.
 No Yes None  
OBJSDATA SMS management class
The SMS management class for the OBJSDATA Performance History File.
 No Yes None  
OBJSDATA SMS storage class
The SMS storage class for the OBJSDATA Performance History File.
 No Yes None  
OBJSDATA unit name
An esoteric name, generic device type or a device address for the OBJSDATA Performance History File.
 No Yes None  
OBJSDATA volume name
The volume for the OBJSDATA Performance History File.
 No Yes None  
SQLCDATA DSN mask
The data set name for the SQLCDATA Performance History File.
 Yes Yes None  
SQLCDATA primary allocation
The primary space quantity for the SQLCDATA Performance History File.
 No Yes 5  
SQLCDATA secondary allocation
The secondary space quantity for the SQLCDATA Performance History File.
 No Yes 2  
SQLCDATA allocation space units
The space units (CYLS or TRKS) for allocation of the SQLCDATA Performance History File.
 No Yes CYLS  
SQLCDATA SMS data class
The SMS data class for the SQLCDATA Performance History File.
 No Yes None  
SQLCDATA SMS management class
The SMS management class for the SQLCDATA Performance History File.
 No Yes None  
SQLCDATA SMS storage class
The SMS storage class for the SQLCDATA Performance History File.
 No Yes None  
SQLCDATA unit name
An esoteric name, generic device type or a device address for the SQLCDATA Performance History File.
 No Yes None  
SQLCDATA volume name
The volume for the SQLCDATA Performance History File.
 No Yes None  
TEXTDATA DSN mask
The data set name for the TEXTDATA Performance History File.
 Yes Yes None  
TEXTDATA primary allocation
The primary space quantity for the TEXTDATA Performance History File.
 No Yes 5  
TEXTDATA secondary allocation
The secondary space quantity for the TEXTDATA Performance History File.
 No Yes 2  
TEXTDATA allocation space units
The space units (CYLS or TRKS) for allocation of the TEXTDATA Performance History File.
 No Yes CYLS  
TEXTDATA SMS data class
The SMS data class for the TEXTDATA Performance History File.
 No Yes None  
TEXTDATA SMS management class
The SMS management class for the TEXTDATA Performance History File.
 No Yes None  
TEXTDATA SMS storage class
The SMS storage class for the TEXTDATA Performance History File.
 No Yes None  
TEXTDATA unit name
An esoteric name, generic device type or a device address for the TEXTDATA Performance History File.
 No Yes None  
TEXTDATA volume name
The volume for the TEXTDATA Performance History File.
 No Yes None  
Maximum host variables per alert
The size of the storage allocation for the ALERT HOST VARIABLE SPACE inside the Query Monitor Subsystem.
No Yes 16  
Maximum objects per alert
The size of the storage allocation for the ALERT EXCP OBJECTS SPACE inside the Query Monitor Subsystem.
 No Yes 8  
Debug mode for IBM Software Support
Turns on Db2 Query Monitor debug mode and produces diagnostic messages (in the range CQM9000-CQM-9999) for use by IBM Software Support.
 No Yes N  
Capturing agent for IBM Software Support
Turns on the capturing agent. For use by IBM Software Support. This parameter should not be specified without the advice of IBM Software Support.
 No Yes N  
ISM constraint age
Controls how much time must have passed since the last storage constraint occurrence for a given ISM storage space before the constraint event is considered to have been relieved.
 No Yes 300  
Number of ISM error blocks
Determines the number of ISM Error Blocks that are allocated when Db2 Query Monitor initializes. If this value is too low, message CQM1219W might be issued.
 No Yes 256  
Number of ISM error message blocks
The number of ISM Error Message Blocks that are allocated when Db2 Query Monitor initializes. If this value is too low, duplicate ISM error messages may be issued for the same space and reason instead of incrementing the occurrence count.
 No Yes 256  
ISM error detail
Controls whether CQM1203I and CQM1204I messages are issued to provide detailed information for ISM Storage Constraint situations.
 No Yes Y  

Task: Configure the Product Start-up CLISTs

Description
This task binds the CQM SQL. During the customization process, you will enter these values on panel CCQPPRD.

This task is required.

Jobs generated
This task generates the following jobs: C3CLST1, C3CLST1.
Table 11. Configure the start-up CLISTs
Step or parameter Required? Discovered? Default value Your value
Configure Startup CLISTs
This subtask configures the start-up CLISTS.
 Yes No Selected  
Startup CLIST library
The library for the Db2 Query Monitor CLIST.
 Yes No None  
Startup CLIST volume name
The start-up CLIST volume name.
 Yes No None  
Startup CLIST SMS storage class
The start-up CLIST storage class.
 Yes No None  
SQL Performance Analyzer CLIST library
The SQL Performance Analyzer CLIST library.
 No No None  
Startup CLIST 1
The name of the first startup CLIST. This CLIST allocates the libraries used by Db2 Query Monitor.
 Yes No CQM  
Startup CLIST 2
The start-up CLIST 2.
 Yes No None  

Task: Add Db2 Query Monitor to the Launchpad

Description
This task adds Db2 Query Monitor to the Db2 Administration Tool Launchpad. During the customization process, you will enter these values on panel CCQPPRD.

This task is optional.

Jobs generated
This task generates the C5LNCH job.
Table 12. Add Db2 Query Monitor to the Launchpad
Step or parameter Required? Discovered? Default value Your value
Create REXX to add Db2 Query Monitor to the Launchpad
This step creates the REXX to add Db2 Query Monitor to the Launchpad.
 Yes -    
Db2 Admin Tool library high-level qualifier
The Db2 Admin Tool library high level qualifier.
 Yes No    
Db2 Admin Tool library
The Db2 Admin Tool library.
 Yes No    

Db2 Parameters section

Description
This section contains Db2 parameters. All parameters are required. During the customization process, you will enter these values on panel CCQPDB2.
Table 13. Db2 Parameters section
Parameter Required? Discovered? Default value Your value
Db2 subsystem ID
A distinct instance of a relational database management system (RDBMS) that is not part of a data sharing group. An example of a Db2 subsystem name is DB01.
 Yes Yes None  
Group attach name
The name that is used by the TSO/batch attachment, the call attachment facility (CAF), DL/I batch, utilities, and the Resource Recovery Services attachment facility (RRSAF) as a generic attachment name. An example of a group attach name is DSG1. If the Group attach name field is blank, this causes the Group attach name to be blanked-out for all other products that you customized using Tools Customizer.
 Yes No None  
General Db2 Information
Mode
The mode in which the Db2 subsystem is running. Valid values are:
CM
Compatibility mode on all listed versions except Db2 10.
NFM
New function mode on all listed Db2 versions.
Level number
The version, release, and modification level of the Db2 subsystem. Valid values are 101, 111, and 121.
Note: For Db2 V11 CM or ENFM, you can use a mode of “NFM” and a Level Number of 101.
 Yes No None  
Db2 Libraries - common
Load Library
The data set name of the Db2 load library.
Run Library
The data set name of the Db2 run library.
Exit Library
The data set name of the Db2 exit library.
Bootstrap data set
The data set name of the Db2 bootstrap data set.
 Yes No None  
Db2 Utilities - commons
SYSAFF for Db2 utilities
The SYSAFF for Db2 utilities.
Plan name for the DSNTEP2 utility
The plan name for the DSNTEP2 utility.
 Yes No None  
Db2 Query Monitor for z/OS Collector Parameters
Monitoring profile
The monitoring profile.
 Yes No None  
Db2 Query Monitor for z/OS Configuration Parameters
SQL authorization ID
The ID that has authority to create and manage Db2 Query Monitor performance history objects. The value is required. The default value is the UISERID. The value provided in this field is used in a SET CURRENT SQLID statement in the generated DDL.
Yes No None  
BIND Owner ID
The ID that has authority to bind the plan or package. The value provided in this field is used as owner when binding Db2 Query Monitor packages and batch report packages and plans.
Note: The BIND Owner ID and the SQL authorization ID are often the same, but do not have to be.
 Yes No None  
Db2 Query Monitor for z/OS schema name
The schema name (the creator of the Db2 Query Monitor objects and qualifier of Db2 Query Monitor and batch report packages). The value provided in this field is used in a SET CURRENT SCHEMA statement in the generated DDL and as qualifier when binding Db2 Query Monitor packages and Batch Report packages and plan. It is optional and has no default value. If blank, the value of the SQL authorization ID is used instead. For more information, see: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/intro/src/tpc/DB2z_schemaqualifiers.html
 No No None  
Db2 Query Monitor for z/OS PLAN name
The plan name.
 Yes No None  
Db2 ZPARMS member name
The Db2 ZPARMS member name.
 Yes No None  
Db2 Control File Parameters
Update Db2 control file?
Specifies whether to update the parameters for a Db2 subsystem in the DB2PARMS control file.
 Yes No None  
Db2 Query Monitor for z/OS Database Objects
Create the Db2 Query Monitor for z/OS Database?
Indicates whether or not to create the Db2 Query Monitor database.
Db2 Query Monitor for z/OS database name
The database name.
Db2 Query Monitor for z/OS table space bufferpool
The table space bufferpool.
Db2 Query Monitor for z/OS LOB table space bufferpool
The LOB table space bufferpool.
Use inline LOBs?
Specifies whether INLINE LOBs are to be used for the SQL text entries in the offload tables. Inline LOBs are supported in Db2 V10 and later releases. The page size of the LOB bufferpool determines the amount of data that is inlined.
Db2 Query Monitor for z/OS index bufferpool
The index bufferpool.
STOGROUP
The storage group.
 Yes No None