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 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. I added this section to capture those items that customers might expect to see listed as changes to the User Guide
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
DB2® Query Monitor for z/OS® data set high-level qualifier The high-level qualifier for the Db2 Query Monitor data sets.	Yes	No	CQM.HLQ
Started task proclib The started task proclib.	Yes	No	TASK.PROCLIB
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	FEC.HLQ
Db2 Data Access Common Collect data set high-level qualifier The high-level qualifier for the CQC data sets.	Yes	No	CQC.HLQ
Db2 control file The data set name of the Db2 control file.	Yes	No	HLQ.DBQM.CONTROL.FILE
Db2 interval file The data set name of the interval file.	Yes	No	HLQ.DBQM.INTERVAL.FILE
Db2 profile file The data set name of the Db2 profile file.	Yes	No	HLQ.DBQM.PROFILE.FILE
Parameter file data set name The data set name of the Db2 Query Monitor parameter file.	Yes	Yes	None
Db2 Query Monitor Subsystem name The Query Monitor subsystem name.	Yes	Yes	DBQM
Use OMEGAMON Data Provider (ODP) Indicates whether to use ODP.	No	No	N
OMEGAMON Data Provider Load Library The data set name of the ODP load library.	No	No	None
CQMPARMS volume name The volume name for CQMPARMS.	No	Yes	None
CQMPARMS SMS storage class The storage class for CQMPARMS.	No	Yes	None
DB2 Administration Tool library high-level qualifier The high-level qualifier for the Db2 Admin Tool library.	Yes	No	ADB.V131

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
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
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 access to Db2 Query Monitor for z/OS tables This subtask creates the DDL to grant 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
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 master address space Creates a shutdown script for the master 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
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
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//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
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.
Master procname The master address space PROCNAME.	Yes	Yes	CQMMST34
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 files.	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
OMEGAMON Data Provider Store Name The name of the ODP store.	No	Yes	OMEGAMON
OMEGAMON Data Provider Broker Name The name of the ODP broker.	No	Yes	ODP_BROKER
Publish Interval metrics to ODP Indicates whether to publish interval metrics to ODP.	No	Yes	N
Publish Summary metrics to ODP Indicates whether to publish summary metrics to ODP.	No	Yes	N
Publish SQLCODES metrics to ODP Indicates whether to publish SQLCODE metrics to ODP.	No	Yes	N
Publish Exceptions metrics to ODP Indicates whether to publish exception metrics to ODP.	No	Yes	N

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
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	CQM.CLISTLIB
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	CQMCLIST
Db2 Administration Tool CLIST library The CLIST library for Db2 Admin Tool.	No	No	None
Db2 Administration Tool Table library The table library for Db2 Admin Tool.	No	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 The Db2 Admin Tool library.	Yes	No	ADB.SADBEXEC

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
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 Db2 versions. NFM New function mode on all listed Db2 versions. Level number The version, release, and modification level of the Db2 subsystem. Valid values are 121 and 131.	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. This value is optional and has no default value. If blank, the value of the SQL authorization ID is used instead. For more information about schemas, see Db2 schemas and schema qualifiers (Db2 for z/OS 13 documentation).	No	No	None
Db2 Query Monitor for z/OS grantee The name of the user or groups that will be granted access to the offload tables and batch reports plan.	Yes	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 V12 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