A fix is available
APAR status
Closed as new function.
Error description
Create a new job in SDSNSAMP that can be use to update a user-supplied DSNTIDxx member with ZPARM values that are currently used by DB2. This could then be used as input to the DB2 install CLIST for migration to the next version of DB2.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of the DB2 installation CLIST in * * DB2 UDB for z/OS Version 8 and DB2 Version * * 9.1 for z/OS are affected by this change. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides a tool that can be * * used to update a CLIST defaults input * * member (DSNTIDXA) with the current * * ZPARM and buffer pool settings that are * * defined in the specified DB2 subsystem. * * * * The following are also addressed in * * this APAR: * * 1. The DEALLOC PERIOD field in the * * DSNTIPA panel does not currently * * accept values with a format of * * minutes,seconds if the minutes is * * set to 0. * * 2. The following opaque ZPARMs are * * recognized by the CLIST defaults * * input member update tool but is not * * currently supported by the install * * CLIST: * * - OPTIXIO * * - PTASKROL * * - RPITWC (V9 only) * * - PTCDIO * * - SJMISSKY * * - SQLINTRP * * - UNION_COLNAME_7 * **************************************************************** * RECOMMENDATION: Apply PTF. * **************************************************************** When using the installation CLIST to install or migrate to a new version of DB2, one can save the configuration options into an output member often referred to as DSNTIDxx member. The saved DSNTIDxx member can subsequently be used as input to the CLIST when migrating to a new version. Although the CLIST provides an update function for maintaining the settings in the DSNTIDxx member, often times, this is not used and the ZPARM settings are manually updated in the DSNTIJUZ job. In the process, the values in the current DSNTIDxx member are outdated which makes the subsequent migration process time consuming, error-prone and cumbersome. The DEALLOC PERIOD field in panel DSNTIPA does not currently allow users to specify 0 for minutes when one specifies a value in the minutes,seconds format. As a result, when one specifies a valid value of 0,30 for DEALLOC PERIOD, the 'Value out of range' error message is returned. Finally, the install CLIST does not currently recognize certain opaque ZPARMs. If the following opaque ZPARMs are added to the CLIST input member (DSNTIDXA) and the install CLIST is used to customized the install and migration jobs, then these opaque ZPARMs will not be included in the generated DSNTIJUZ job: - OPTIXIO - PTASKROL - RPITWC (V9 only) - PTCDIO - SJMISSKY - SQLINTRP - UNION_COLNAME_7
Problem conclusion
Temporary fix
Comments
This APAR adds a job called DSNTIJXZ in SDSNSAMP that executes a batch program called DSNTXAZP. This job can be used to update the CLIST defaults input member to use the ZPARM and buffer pool settings that are currently defined in the specified DB2 subsystem. The DSNTIPA panel was updated to accept values specified in the minutes,seconds format in the following range: minutes - 0 to 1440 seconds - 0 to 59 The install CLIST was updated to support the following opaque ZPARM parameters: - OPTIXIO - PTASKROL - RPITWC (V9 only) - PTCDIO - SJMISSKY - SQLINTRP - UNION_COLNAME_7 ====================== Additional Information ====================== The user ID specified to run job DSNTIJXZ requires DB2 MONITOR1 privilege. The DSNTXAZP batch program expects the following arguments: //DSNTIXZ EXEC PGM=DSNTXAZP,PARM='ssid action' where: ssid - The first argument is the DB2 subsystem ID action - The second argument is the type of action to be performed which can be one of the following values: UPDATE_ALL - This action will create a new CLIST defaults input member and update it using the current ZPARM and buffer pool settings. UPDATE_BPOOL - This action will create a new CLIST defaults input member and update it using the current buffer pool settings only (no ZPARM) UPDATE_ZPARM - This action will create a new CLIST defaults input member and update it using the current ZPARM settings only (no buffer pool) The following DD statements are required by DSNTXAZP: XAINPUT : This is used as input to the DSNTXAZP program. It contains the current CLIST defaults input member which will be used as the source for creating a new CLIST defaults input member. The version of the input member should match the version of the current selected DB2 subsystem. XAOUTPUT : This is used as output by the DSNTXAZP program. It contains the generated CLIST defaults input member with updated ZPARM and buffer pool settings. This should be a member of a PDS defined with RECFM=FB and LRECL=80. SYSPRINT : This is used as output by the DSNTXAZP program for informational and error messages. It also includes a report on the parameters that were processed and modified. Refer to the SAMPLE GENERATED REPORT section for details on the report. ======================= SAMPLE GENERATED REPORT ======================= CLIST INPUT MEMBER GENERATION REPORT ** 2010-06-15 09:25:35 1 ----------------------------------------------------------- CLIST PARAMETER REPORT: 2 0001 PARAMETER NAME = ABEXP ZPARM/BUFFERPOOL PARAMETER = ABEXP PARAMETER TYPE = CHAR DATA SHARING SCOPE = M MINIMUM VALUE = NO MAXIMUM VALUE = YES CURRENT CLIST VALUE = YES CURRENT INSTALLED VALUE = YES STATUS = RETAINED 0002 PARAMETER NAME = ABIND ZPARM/BUFFERPOOL PARAMETER = ABIND PARAMETER TYPE = CHAR DATA SHARING SCOPE = M MINIMUM VALUE = NONE MAXIMUM VALUE = NONE CURRENT CLIST VALUE = YES CURRENT INSTALLED VALUE = NO STATUS = UPDATED : nnnn PARAMETER NAME = DB2REL ZPARM/BUFFERPOOL PARAMETER = N/A PARAMETER TYPE = CHAR DATA SHARING SCOPE = M MINIMUM VALUE = NONE MAXIMUM VALUE = NONE CURRENT CLIST VALUE = 910 CURRENT INSTALLED VALUE = N/A STATUS = RETAINED : CHANGE SUMMARY REPORT: 3 CLIST PARAMETER ZPARM/BUFFERPOOL PARAMETER VALUE -------------------------------------------------------------- ABEXP -SAME- YES * ABIND 4 -SAME- 8 NO (YES) 5 : * BUFMAX00 BP0 VPSIZE 6 10000 (20000) : DB2REL -NONE- 7 910 : * NUMCONCR 4 CTHREAD 8 220 (200) OVDSMAX DSMAX 20000 : -------------------------------------------------------------- SOURCE MEMBER : DSN910.SDSNSAMP(DSNTIDXA) 9 CREATED MEMBER : DB2.CLIST.MEMBER(DSNTIDX0) 10 PARAMETERS PROCESSED : n 11 PARAMETERS MODIFIED : m 12 -------------------------------------------------------------- ** For this example, the width of the CHANGE SUMMARY REPORT was shortened to fit this page but the actual width is longer. NOTES: 1. The date and time on when the CLIST defaults input member was created is provided in the report. 2. The first part of the report is the CLIST PARAMETER REPORT which provides details for each parameter that was written out to the generated CLIST input member. 3. The second part of the report is the CHANGE SUMMARY REPORT which provides a quick view of the parameters that were updated and parameters that have different ZPARM names or buffer pool related parameters. 4. Modified parameters can easily be identified since they are prefixed with '*' in the first column. 5. Modified values have two sets of values displayed. The first one is the new value and the second value enclosed in parenthesis ( ) is the old value. 6. For CLIST input member parameters that map to a buffer pool setting, the corresponding buffer pool parameter is displayed. 7. For CLIST defaults input member parameters used only by the install CLIST, that do not map to any ZPARM or buffer pool parameter, the value '-NONE-' is displayed on the second column. 8. ZPARM parameters who have the same names as the CLIST input member parameter have the value '-SAME-' displayed on the second column while ZPARM parameters whose names are different from the CLIST input member parameter have the actual ZPARM name displayed on the second column. 9. The name of the source CLIST defaults input member. 10. The name of the CLIST defaults input member created. 11. The total number of CLIST defaults input member parameters processed. 12. The total number of CLIST defaults input member parameters modified.
APAR Information
APAR number
PM10726
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-03-24
Closed date
2010-07-23
Last modified date
2010-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK59105 UK59106
Modules/Macros
DSN@XAZP DSNTIJSG DSNTIJXZ DSNTINST DSNTINS1 DSNTIPA DSNTXAZH DSNTXAZM DSNTXAZP DSNWZIFA DSNWZIF8 HDB8810J HDB9910J
| GC18741810 | GC18960207 | GC18984609 | GC18984906 |
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 September 2010