DSNT060I DSNTXAZP HAS SET THE VALUE OF A CLIST PARAMETER WITH A WARNING. WARNING = warning-text

Explanation

The program generated a warning message when assigning a value to a CLIST parameter. warning-text contains more information about the warning:

MORE THAN ONE OWNER IDENTIFIED FOR THE PACKAGES ASSOCIATED WITH THE DB2-SUPPLIED ROUTINE schema.routine. THE CLIST PARAMETER cfg-parm, THE PACKAGE OWNER FOR THE ROUTINE, IS SET TO THE CURRENT MOST COMMON OWNER OF THE ROUTINE PACKAGES: cfg-value.

More than one owner was identified for the packages that are associated a with a Db2-supplied routine. The most common owner was used.

schema.routine-name

The name of the Db2-supplied routine, qualified by the name of the schema in which the routine was created.

cfg-parm

The owner of the packages associated with the specified Db2-supplied routine. It is one of the following CLIST parameters that is associated with the specified routine: RTxnnPK0 where x is a letter B–Q, and nn is numerals 01–44.

cfg-value

The authorization ID identified by cfg-parm is set to this value that is the most common owner of the packages for the specified Db2-supplied routine.

MORE THAN ONE WLM ENVIRONMENT IS USED FOR RUNNING MULTIPLE FUNCTIONS WITH SCHEMA=schema AND NAME=name. THE CLIST PARAMETER cfg-parm, THE WLM ENVIRONMENT FOR THE ROUTINE WITH SCHEMA=schema AND NAME=name, IS SET TO ITS CURRENT MOST FREQUENTLY USED WLM ENVIRONMENT: cfg-value.

More than one WLM environment is used for running multiple functions.

schema

The schema of a Db2-supplied routine.

name

The name of a Db2-supplied routine

cfg-parm

The WLM environment name for the routine with the specified schema and name. It is one of the following CLIST parameters that is associated with the specified routine: RTxnnWLM, where x is a letter B–Q, and nn is numerals 01-44.

cfg-value

The WLM environment name identified by cfg-parm is set to this value that is the most frequently used WLM environment for the specified Db2-supplied routine.

MORE THAN ONE WLM ENVIRONMENT IS USED FOR RUNNING routine-category. THE CLIST PARAMETER cfg-parm, THE DEFAULT WLM ENVIRONMENT FOR routine-category, IS SET TO THE CURRENT MOST FREQUENTLY USED WLM ENVIRONMENT FOR routine-category: cfg-value.

More than one WLM environment is used for running routines from the same category.

routine-category is one of the following values:

• MOST DB2 ROUTINES
• ROUTINES IDENTIFIED TO PROGRAM CONTROL
• SERIALIZED ROUTINES
• DB2 UTILITIES ROUTINES
• DB2 XML PROCESSING ROUTINES
• DB2 JAVA ROUTINES
• DB2 REXX ROUTINES
• UNIFIED DEBUGGER ROUTINES
• THE DB2 CICS ROUTINE
• DB2 MQSERIES ROUTINES
• DB2 WEB SERVICES ROUTINES

cfg-parm is the default WLM environment name for the specified routine-category. It is one of the following CLIST parameters that is associated with the specified routine-category:

• WLMENVG for MOST DB2 ROUTINES
• WLMENVP for ROUTINES IDENTIFIED TO PROGRAM CONTROL
• WLMENV1 for SERIALIZED ROUTINES
• WLMENVU for DB2 UTILITIES ROUTINES
• WLMENVX for DB2 XML PROCESSING ROUTINES
• WLMENVJ for JAVA ROUTINES
• WLMENVR for REXX ROUTINES
• WLMENVD for UNIFIED DEBUGGER ROUTINES
• WLMENVC for THE DB2 CICS ROUTINE
• WLMENVM for DB2 MQSERIES ROUTINES
• WLMENVW for DB2 WEB SERVICES ROUTINES

cfg-value

The cfg-value is set to this value that is the most frequently used WLM environment for the specified routine-category.

MORE THAN ONE OWNER IDENTIFIED FOR DB2-SUPPLIED ROUTINES. THE CLIST PARAMETER AUTHID, THE AUTH ID TO CREATE AND BIND DB2 ROUTINES, IS SET TO THE CURRENT MOST COMMON OWNER OF THE DB2-SUPPLIED ROUTINES: cfg-value.

More than one owner was identified for Db2-supplied routines.

cfg-value

The CLIST parameter AUTHID is set to this value that is the most common owner of the Db2-supplied routines.

MORE THAN ONE OWNER IDENTIFIED FOR DB2-SUPPLIED ROUTINES DEFINED WITH THE SECURITY DEFINER OPTION. THE CLIST PARAMETER SECDEFID, THE AUTH ID TO CREATE AND BIND DB2 SEC DEF ROUTINES, IS SET TO THE CURRENT OWNER OF THE MOST RECENTLY CREATED SECURITY DEFINER DB2-SUPPLIED ROUTINE: cfg-value.

More than one owner was identified for Db2 supplied routines that are defined with the SECURITY DEFINER option.

cfg-parm

The CLIST parameter SECDEFID is set to this value that is the owner of the most recently created Db2-supplied routine that was created with SECURITY DEFINER option.

MORE THAN ONE SQL AUTHORIZATION ID WAS USED FOR SQL PROCESSED BY DB2 INSTALLATION OR SAMPLE JOBS. THE CLIST PARAMETER cfg-parm IS SET TO THE CURRENT MOST COMMON SQL AUTHORIZATION ID USED FOR SQL PROCESSED BY DB2 INSTALLATION OR SAMPLE JOBS: cfg-value.

More than one SQL authorization ID was used for SQL that was processed by Db2 installation or sample jobs. The most common owner was used.

cfg-parm

INSSQLID

The CURRENT SQLID setting to be used when SQL is processed by most Db2 installation and sample jobs.

IVPSQLID

The CURRENT SQLID setting to be used when SQL is processed by Db2 sample (IVP) jobs.

cfg-value

The cfg-parm is set to this value that is the most common SQL authorization ID used for SQL processed by Db2 installation or sample jobs.

MORE THAN ONE OWNER IDENTIFIED FOR PACKAGES AND PLANS BOUND BY DB2 INSTALLATION OR SAMPLE JOBS. THE CLIST PARAMETER cfg-parm IS SET TO THE CURRENT MOST COMMON OWNER OF THE PACKAGES AND PLANS: cfg-value.

More than one owner was identified for packages and plans that are bound by Db2 installation or sample jobs. The most-common owner was used.

cfg-parm

INSPKOWN

The authorization ID to assign as the owner of packages and plans bound by most Db2 installation and sample jobs.

IVPKOWN

The authorization ID to assign as the owner of packages and plans bound by most Db2 sample (IVP) jobs.

cfg-value

The cfg-parm is set to this value that is the most common owner of the packages and plans bound by most Db2 installation and sample jobs.

THE CLIST PARAMETER cfg-parm, THE cfg-parm-desc FOR ROUTINE schema.routine-name, CANNOT BE DISCOVERED. REASON CODE = rsn. IT IS SET TO THE DSNTIDxx INPUT VALUE cfg-value.

A CLIST parameter cannot be discovered for the specified Db2-supplied routine for the specified reason.

cfg-parm and cfg-parm-desc

RTxnnACL

ACCESS CONTROL LIST. The access control list associated with the specified Db2-supplied routine, where x is a letter B–Q and nn is two numerals 01–44.

RTxnnPKO

PACKAGE OWNER. The owner of the packages associated with the specified Db2-supplied routine. where x is a letter B–Q and nn is two numerals 01–44.

RTxnnWLM and

WLM ENVIRONMENT. The WLM environment to be used to run the specified Db2-supplied routine. where x is a letter B–Q and nn is two numerals 01–44.

rsn

1

The Db2 objects required to discover the cfg-parm do not exist.

schema.routine-name

The name of the Db2-supplied routine, qualified by the name of the schema in which the routine was created.

THE CLIST PARAMETER cfg-parm, THE DEFAULT WLM ENVIRONMENT FOR routine-category, CANNOT BE DISCOVERED. REASON CODE = rsn. IT IS SET TO THE DSNTIDxx INPUT VALUE cfg-value.

A CLIST parameter cannot be discovered for the specified reason.

cfg-parm and cfg-parm-desc

WLMENVG

MOST DB2 ROUTINES.

WLMENVP

ROUTINES IDENTIFIED TO PROGRAM CONTROL.

WLMENV1

SERIALIZED ROUTINES.

WLMENVU

DB2 UTILITIES ROUTINES.

WLMENVX

DB2 XML PROCESSING ROUTINES.

WLMENVJ

DB2 JAVA ROUTINES.

WLMENVR

DB2 REXX ROUTINES.

WLMENVD

UNIFIED DEBUGGER ROUTINES.

WLMENVC

THE DB2 CICS ROUTINE.

WLMENVM

DB2 MQSERIES ROUTINES.

WLMENVW

DB2 WEB SERVICES ROUTINES.

rsn

1

The Db2 objects required to discover the cfg-parm do not exist.

THE CLIST PARAMETER cfg-parm, THE cfg-parm-desc, CANNOT BE DISCOVERED. REASON CODE = rsn. IT IS SET TO THE DSNTIDxx INPUT VALUE cfg-value.

A CLIST parameter cannot be discovered for the specified reason.

cfg-parm and cfg-parm-desc

AUTHID

AUTH ID TO CREATE AND BIND DB2 ROUTINES.

BSDSNAM1

BSDS COPY1 NAME

BSDSNAM2

BSDS COPY 2 NAME.

DATACLS3

VSAM CATALOG AND STOGROUP DATA CLASS.

DATACLS6

LOG COPY 1 AND BSDS COPY 2 DATA CLASS.

DATACLS7

LOG COPY 2 AND BSDS COPY 1 DATA CLASS.

DDLOC

DB2 LOCATION NAME.

DDLUNAM

DB2 VTAM LU NAME.

DSNHDECP

DB2 APPLICATION DEFAULTS MODULE NAME.

GENLUNM

DB2 GENERIC VTAM LU NAME.

INSICPRE

SAMPLE IMAGE COPY DATA SETS PREFIX.

INSGRLST

AUTH IDS TO BE GRANTED INSTALL OBJECTS ACCESS.

INSPKOWN

AUTH ID TO OWN PACKAGES BOUND BY INSTALL JOBS.

INSSQLID

AUTH ID TO PROCESS SQL IN INSTALL JOBS.

IPNAME

DB2TCP/IP IPNAME.

IRLMDISC

DISCONNECT IRLM AUTOMATICALLY OPTION.

IRLMGRPN

IRLM XCF GROUP NAME.

IRLMIDEN

IRLM MEMBER UNIQUE IDENTIFIER.

IRLMLKSZ

IRLM LOCK ENTRY INITIAL ALLOCATION SIZE.

IRLMLTE

IRLM NUMBER OF LOCK TABLE ENTRIES.

IRLMMLMT

IRLM MAXIMUM STORAGE FOR LOCKS.

IRLMPGPR

PAGE PROTECT IRLM LOAD MODULES OPTION.

IRLMTRAC

START IRLM COMPONENT TRACES OPTION.

IVPGRLST

AUTH IDS TO BE GRANTED IVP OBJECTS ACCESS.

IVPPKOWN

AUTH ID TO OWN PACKAGES BOUND BY IVP JOBS.

IVPSQLID

AUTH ID TO PROCESS SQL IN IVP JOBS.

LOGSPRE1

FIRST COPY ACTIVE LOG DATA SET PREFIX.

LOGSNUM

NUMBER OF ACTIVE LOG DATA SETS.

LOGSPRE2

SECOND COPY ACTIVE LOG DATA SET PREFIX.

MGMTCLS3

VSAM CATALOG AND STOGROUP MANAGEMENT CLASS.

MGMTCLS6

LOG COPY 1 AND BSDS COPY 2 MANAGEMENT CLASS.

MGMTCLS7

LOG COPY 2 AND BSDS COPY 1 MANAGEMENT CLASS.

MVSSPREF

DB2 SUBSYSTEM COMMAND PREFIX.

NUMCOLUM

NUMBER OF COLUMNS PER TABLE (AVERAGE).

NUMDATAB

NUMBER OF DATABASES IN THE SUBSYSTEM.

NUMPKGS

NUMBER OF PACKAGES IN THE SUBYSTEM.

NUMPKSTS

NUMBER OF SQL STATEMENTS PER PACKAGE (AVERAGE).

NUMPLANS

NUMBER OF PLANS IN THE SUBSYSTEM.

NUMPLPL

NUMBER OF PACKAGE LISTS PER PLAN (AVERAGE).

NUMTABLE

NUMBER OF TABLES PER DATABASE (AVERAGE).

NUMTABSP

NUMBER OF TABLE SPACES PER DATABASE (AVERAGE).

NUMVIEWS

NUMBER OF VIEWS PER TABLE (AVERAGE).

RESYNPRT

TWO-PHASE COMMIT RESYNC TCP/IP PORT NUMBER.

SECDEFID

AUTH ID TO CREATE AND BIND DB2 SEC DEF ROUTINES.

SECPORT

TCP/IP PORT NUMBER FOR SECURE SQL LISTENER.

SGRPATNM

SUBGROUP ATTACH NAME.

STGIJRT

STOGROUP FOR INDEXES CREATED BY DSNTIJRT.

STOGJRT

STOGROUP FOR DB AND TS CREATED BY DSNTIJRT.

STORCLS3

VSAM CATALOG AND STOGROUP STORAGE CLASS.

STORCLS6

LOG COPY 1 AND BSDS COPY 2 STORAGE CLASS.

STORCLS7

LOG COPY 2 AND BSDS COPY 1 STORAGE CLASS.

S32KNOTS

NUMBER OF 32 KB SORT WORK FILE TABLE SPACES.

S32KSGSZ

SEGSIZE OF 32 KB SORT WORK FILE TABLE SPACES.

S4KNOTS

NUMBER OF 4 KB SORT WORK FILE TABLE SPACES.

S4KGSZ

SEGSIZE OF 4 KB SORT WORK FILE TABLE SPACES.

TCPPORT

TCP/IP PORT NUMBER FOR SQL LISTENER.

T32KNOTS

NUMBER OF 32 KB TEMP WORK FILE TABLE SPACES.

T32KGSZ

SEGSIZE OF 32 KB TEMP WORK FILE TABLE SPACES.

T4KNOTS

NUMBER OF 4 KB TEMP WORK FILE TABLE SPACES.

T4KSGSZ

SEGSIZE OF 4 KB TEMP WORK FILE TABLE SPACES.

VBSDSLOG

BSDS AND ACTIVE LOG ICF CATALOG ALIAS.

VOLSDAT3

VSAM CATALOG AND STOGROUP VOLUME SERIAL.

VOLSDAT6

LOG COPY 1 AND BSDS COPY 2 VOLUME SERIAL.

VOLSDAT7

LOG COPY 2 AND BSDS COPY 1 VOLUME SERIAL.

WKDBNAME

WORK FILE DATABASE.

rsn

1

The Db2 objects required to discover the cfg-parm do not exist.

2

The TCPPORT value is -NONE or the SECPORT value is -NONE in the -DISPLAY DDF output.

3

The -DISPLAY DDF output is not formatted as expected

4

The call to the instrumentation facility interface DSNWLI for IFCID 0104 did not return any data.

5

Db2 objects required to discover the cfg-parm were created prior to Db2 12.

6

IRLM startup option has a value whose size is bigger than expected for cfg-parm.

7

Volume is SMS-managed, that is, SYSIBM.SYSVOLUMES.VOLID=’*’.

8

IRLM MLT startup option value exceeds 102400MB.

9

Db2 STC or IRLM STC not found.

10

Db2 STC or IRLM STC SYSOUT data sets not available.

cfg-value

Specifies the value cfg-parm was set to, which is also the input DSNTXAZP DSNTIDxx value.

MORE THAN ONE cfg-parm-object1 IDENTIFIED FOR cfg-parm-object2. THE CLIST PARAMETER cfg-parm, THE cfg-parm-desc, IS SET TO THE CURRENT MOST COMMON cfg-parm-desc: cfg-value.

The following table lists the possible values for cfg-parm-object1 and cfg-parm-object2 for each cfg-parm.

cfg-parm	cfg-parm-object1	cfg=parm-object2
DATACLAS3	DATA CLASS	VSAM CATALOG AND STOGROUP
INSICPRE	PREFIX	SAMPLE IMAGE COPY DATA SETS
MGMTCLS3	MANAGEMENT CLASS	VSAM CATALOG AND STOGROUP
STGIJRT	STORAGE GROUP	INDEXES CREATED BY DSNTIJRT
STOGJRT	STORAGE GROUP	DB AND TS CREATED BY DSNTIJRT
STORCLS3	STORAGE CLASS	VSAM CATALOG AND STOGROUP
S32KSGSZ	SEGMENT SIZE	32 KB SORT WORK FILE TABLE SPACES
S4KSGSZ	SEGMENT SIZE	4 KB SORT WORK FILE TABLE SPACES
T32KSGSZ	SEGMENT SIZE	32 KB TEMP WORK FILE TABLE SPACES
T4KSGSZ	SEGMENT SIZE	4 KB TEMP WORK FILE TABLE SPACES
VBSDSLOG	ALIAS	BSDS AND LOG

The following table lists the cfg-parm-desc for each cfg-parm

cfg-parm	cfg-parm-desc
DATACLS3	VSAM CATALOG AND STOGROUP DATA CLASS
INSICPRE	SAMPLE IMAGE COPY DATA SETS PREFIX
MGMTCLS3	VSAM CATALOG AND STOGROUP MANAGEMENT CLASS
STGIJRT	STOGROUP FOR INDEXES CREATED BY DSNTIJRT
STOGJRT	STOGROUP FOR DB AND TS CREATED BY DSNTIJRT
STORCLS3	VSAM CATALOG AND STOGROUP STORAGE CLASS
S32KSGSZ	SEGSIZE OF 32 KB SORT WORK FILE TABLE SPACES
S4KSGSZ	SEGSIZE OF 4 KB SORT WORK FILE TABLE SPACES
T32KSGSZ	SEGSIZE OF 32 KB TEMP WORK FILE TABLE SPACES
T4KSGSZ	SEGSIZE OF 4 KB TEMP WORK FILE TABLE SPACES
VBSDSLOG	BSDS AND ACTIVE LOG ICF CATALOG ALIAS

cfg-value

Specifies the value cfg-parm was set to, which is also the input DSNTXAZP DSNTIDxx value.

THE CLIST PARAMETER cfg-parm, THE cfg-parm-desc FOR ROUTINE schema.routine-name, IS TRUNCATED TO len CHARACTERS.

FROM: untruncated-value

TO: truncated-value

A CLIST parameter value was truncated.

cfg-parm and cfg-parm-desc

RTxnnACL

ACCESS CONTROL LIST. The access control list associated with the specified Db2-supplied routine, where x is a letter B–Q and nn is two numerals 01–44.

RTxnnPK0

PACKAGE OWNER. The owner of the packages associated with the specified Db2-supplied routine. where x is a letter B–Q and nn is two numerals 01–44.

schema.routine-name

The name of the Db2-supplied routine, qualified by the name of the schema in which the routine was created.

len

Truncated length of cfg-parm.

untruncated-value

Specifies the untruncated current installed value of cfg-parm.

truncated-value

Specifies the truncated current installed value of cfg-parm.

THE CLIST PARAMETER cfg-parm, THE cfg-parm-desc, IS TRUNCATED TO len CHARACTERS.

FROM: untruncated-value

TO: truncated-value

cfg-parm and cfg-parm-desc values:

AUTHID

AUTH ID TO CREATE AND BIND DB2 ROUTINES.

BSDSNAM1

BSDS COPY1 NAME.

BSDSNAM2

BSDS COPY2 NAME.

DDLUNAM

DB2 VTAM LU NAME.

GENLUNM

DB2 GENERIC VTAM LU NAME.

INSGRLST

AUTH IDS TO BE GRANTED INSTALL OBJECTS ACCESS.

INSICPRE

SAMPLE IMAGE COPY DATA SETS PREFIX.

INSPKOWN

AUTH ID TO OWN PACKAGES BOUND BY INSTALL JOBS.

INSSQLID

AUTH ID TO PROCESS SQL IN INSTALL JOBS.

IVPGRLST

AUTH IDS TO BE GRANTED IVP OBJECTS ACCESS.

IVPPKOWN

AUTH ID TO OWN PACKAGES BOUND BY IVP JOBS.

IVPSQLID

AUTH ID TO PROCESS SQL IN IVP JOBS.

LOGSPRE1

FIRST COPY ACTIVE LOG DATA SET PREFIX.

LOGSPRE2

SECOND COPY ACTIVE LOG DATA SET PREFIX.

SECDEFID

AUTH ID TO CREATE AND BIND DB2 SEC DEF ROUTINES.

STGIJRT

STOGROUP FOR INDEXES CREATED BY DSNTIJRT.

STOGJRT

STOGROUP FOR DB AND TS CREATED BY DSNTIJRT.

len

Specifies the length of the truncated current installed value of cfg-parm.

untruncated-value

Specifies the untruncated current installed value of cfg-parm.

truncated-value

Specifies the truncated current installed value of cfg-parm.

THE CLIST PARAMETER cfg-parm, cfg-parm-desc, IS SET TO ITS DEFAULT VALUE cfg-value.

An IRLM startup parameter is not explicitly set when IRLM was started.

cfg-parm and cfg-parm-desc

IRLMLKSZ

IRLM LOCK ENTRY INITIAL ALLOCATION SIZE

IRLMLTE

IRLM NUMBER OF LOCK TABLE ENTRIES

IRLMMLMT

IRLM MAXIMUM STORAGE FOR LOCKS

IRLMPGPR

PAGE PROTECT IRLM LOAD MODULES OPTION

IRLMTRAC

START IRLM COMPONENT TRACES OPTION

cfg-value

The IRLM startup parameter identified by cfg-parm is set to this value that is the default value of the IRLM startup parameter.