A fix is available
APAR status
Closed as new function.
Error description
Unable to generate reorg with shrlevel C from panel ADB2USO SHRLEVEL is set to N
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool and * * DB2 Object Comparison Tool for z/OS who * * use REORG utility options SHRLEVEL * * REFERENCE and SHRLEVEL CHANGE on panel * * ADB2USO 'Specify Utility Options - * * REORG' when using Change Management (CM). * **************************************************************** * PROBLEM DESCRIPTION: Users cannot specify the SHRLEVEL * * REFERENCE and CHANGE options for the * * REORG utility from panel ADB2USO * * when using the ALT function, Change * * Management or Object Compare. * **************************************************************** * RECOMMENDATION: * **************************************************************** Users cannot edit the SHRLEVEL field on panel ADB2USO after selecting the 'O - Reorg' option from panel ADB2UOPS 'Change Utilities Options'.
Problem conclusion
Temporary fix
Comments
Program has been modified to add support for specifying SHRLEVEL REFERENCE and CHANGE for the REORG utility on panel ADB2USO when using ALT, Change Management or Object Compare. Considering only one MAPPINGTABLE can be specified on panel ADB2USO1 'Specify Utility Options - REORG TABLESPACE' for SHRLEVEL CHANGE of REORG utility, if the apply job is generated as Work Statement List (WSL) and option 'Generate one job' is set to 'NO' on panel ADBPWLO 'Work Statement List options', all REORG statements will be combined into one job. If the apply job is generated as JCL and option 'Generate one job' is set to 'NO' on panel GOC5 'Generate Compare Jobs' and ADBPALT, all REORG statements will be combined into one job. As a result of the DB2 restriction for using SHRLEVEL REFERENCE and CHANGE for certain table spaces, the SHRLEVEL value will be converted according to the following rules: For a REORG statement that has no PART and SCOPE PENDING options: If the table space has the NOT LOGGED attribute, SHRLEVEL CHANGE will be converted to SHRLEVEL REFERENCE For a REORG statement that has PART or SCOPE PENDING options: If a table space has the NOT LOGGED attribute and nonpartitioned indexes are defined, SHRLEVEL CHANGE or REFERENCE will be converted to SHRLEVEL NONE. If a table space has the NOT LOGGED attribute and no nonpartitioned indexes are defined, SHRLEVEL CHANGE will be converted to SHRLEVEL REFERENCE. For a LOB table space: If the associated base table space has the NOT LOGGED attribute, SHRLEVEL CHANGE will be converted to SHRLEVEL REFERENCE. The following warning messages have been added for the conversion: ADBA010W SHRLEVEL CHANGE has been converted to SHRLEVEL REFERENCE. Explanation: The REORG utility does not allow SHRLEVEL CHANGE to be specified in one of the following situations: REORG TABLESPACE is run on a LOB table space in DB2 9. REORG TABLESPACE is run on a table space that has the NOT LOGGED attribute in DB2 9 or later versions. REORG TABLESPACE is run on a LOB table space and its associated base table space has the NOT LOGGED attribute in DB2 10 or later versions. System action: Processing continues. User response: None. ADBA011W SHRLEVEL CHANGE has been converted to SHRLEVEL NONE. Explanation: The REORG utility does not allow SHRLEVEL CHANGE and SHRLEVEL REFERENCE to be specified in one of the following situations: REORG TABLESPACE is run on a LOB table space in DB2 8. REORG TABLESPACE with PART is run on a NOT LOGGED table space on which non-partitioned indexes are defined in DB2 9 or later versions. System action: Processing continues. User response: None. ADBA012W SHRLEVEL REFERENCE has been converted to SHRLEVEL NONE. Explanation: The REORG utility does not allow SHRLEVEL REFERENCE to be specified in one of the following situations: REORG TABLESPACE is run on a LOB table space in DB2 8. REORG TABLESPACE with PART is run on a NOT LOGGED table space on which non-partitioned indexes are defined in DB2 9 or later versions. System action: Processing continues. User response: None. ADBA013W SHRLEVEL NONE has been converted to SHRLEVEL REFERENCE. Explanation: The REORG utility does not support SHRLEVEL NONE to be specified in one of the following situations: REORG TABLESPACE is run on a LOB table space in DB2 10 CM mode or later versions. REORG TABLESPACE is used to materialize the pending definition changes in DB2 10 or later versions. System action: Processing continues. User response: None. Additionally, the warning message ADB7164W has been added for the condition that the logging attribute of the table space is not available while running Object Compare. ADB7164W The logging attribute for >obj_desc< >objname_v< is unknown because the table space is not included in the compared objects. Ensure that the correct SHRLEVEL option is used for the REORG utility. Explanation: SHRLEVEL CHANGE or SHRLEVEL REFERENCE REORG might not be executable on a NOT LOGGED table space because of DB2 restrictions. After the change, when the table space is NOT LOGGED, Object Compare will convert the SHRLEVEL option to a valid value if the user-specified SHRLEVEL is not applicable. This message is displayed when the logging attribute of a table space is unknown because the table space is not included in the compared objects. Ensure the correct SHRLEVEL option is used in the APPLY jobs for the REORG utility. System action: Review the message. If necessary, fix the problem and try again. User response: Processing continues. The Change Management batch program has been modified. New parameters for the REORG utility are added: AUX option for REORG (util_reorg_aux parameter) The util_reorg_shrlevel parameter specifies the AUX option for generated REORG utility statements. This parameter only applies for DB2 10 or later. Values: Y, N, blank Default: blank Y AUX YES will be added. N AUX NO will be added. blank The AUX option will not be added. DEADLINE option for REORG (util_reorg_deadline parameter) The util_reorg_shrlevel parameter specifies the DEADLINE option for generated REORG utility statements. Values: N, timestamp, labeled-duration-expression, blank Default: blank N DEADLINE NONE will be added. timestamp DEADLINE timestamp will be added. labeled-duration-expression DEADLINE labeled-duration-expression will be added. blank The DEADLINE option will not be added. DELAY option for REORG (util_reorg_delay parameter) The util_reorg_shrlevel parameter specifies the DELAY option for generated REORG utility statements. Values: integer, blank Default: blank integer The DELAY option will be added to the utility statement with the specified value. blank The option will not be added to the utility statement. DRAIN option for REORG (util_reorg_drain parameter) The util_reorg_shrlevel parameter specifies the DRAIN option for generated REORG utility statements. Values: W, A, blank Default: blank W The DRAIN WRITERS option will be added to the utility statement. A The DRAIN ALL option will be added to the utility statement. blank The option will not be added to the utility statement. DRAIN_WAIT option for REORG (util_reorg_drain_wait parameter) The util_reorg_shrlevel parameter specifies the DRAIN_WAIT option for generated REORG utility statements. Values: A valid DRAIN_WAIT value for REORG; 0 - 1800, blank Default: blank A valid DRAIN_WAIT value for REORG; 0 - 1800 The DRAIN_WAIT option is added with the specified value. blank The option will not be added to the utility statement. FASTSWITCH option for REORG (util_reorg_fastswitch parameter) The util_reorg_shrlevel parameter specifies the FASTSWITCH option for generated REORG utility statements. Values: Y, N, blank Default: blank Y FASTSWITCH YES will be added. N FASTSWITCH NO will be added. blank The FASTSWITCH option will not be added. LONGLOG option for REORG (util_reorg_longlog parameter) The util_reorg_shrlevel parameter specifies the LONGLOG option for generated REORG utility statements. Values: C, T, D, blank Default: blank C The LONGLOG CONTINUE option will be added to the utility statement. T The LONGLOG TERM option will be added to the utility statement. D The LONGLOG DRAIN option will be added to the utility statement. blank The option will not be added to the utility statement. MAPTABLE option for REORG (util_reorg_maptable_name parameter) The util_reorg_shrlevel parameter specifies the MAPTABLE name for generated REORG utility statements. Values: valid table name; 1 to 128 characters Default: blank MAPTABLE option for REORG (util_reorg_maptable_owner parameter) The util_reorg_shrlevel parameter specifies the MAPTABLE owner for generated REORG utility statements. Values: valid table owner; 1 to 128 characters Default: blank MAXRO option for REORG (util_reorg_maxro parameter) The util_reorg_shrlevel parameter specifies the MAXRO option for generated REORG utility statements. Values: integer, D, blank Default: blank integer The MAXRO option will be added to the utility statement with the specified value. D The MAXRO DEFER option will be added to the utility statement. blank The option will not be added to the utility statement. RETRY option for REORG (util_reorg_retry parameter) The util_reorg_shrlevel parameter specifies the RETRY option for generated REORG utility statements. Values: A valid RETRY value for REORG; 0 - 255, blank Default: blank A valid RETRY value for REORG; 0 - 255 The RETRY option will be added with the specified value. blank The option will not be added to the utility statement. RETRY_DELAY option for REORG (util_reorg_retry_delay parameter) The util_reorg_shrlevel parameter specifies the RETRY_DELAY option for generated REORG utility statements. Values: A valid RETRY_DELAY value for REORG; 1 - 1800, blank Default: blank A valid RETRY_DELAY value for REORG; 1 - 1800 The RETRY_DELAY option will be added with the specified value. blank The option will not be added to the utility statement. SHRLEVEL option for REORG (util_reorg_shrlevel parameter) The util_reorg_shrlevel parameter specifies the SHRLEVEL option for generated REORG utility statements. Values: N, C, R, blank Default: blank N SHRLEVEL NONE is added. C SHRLEVEL CHANGE is added. However, the option might not be specified, or might be converted to SHRLEVEL REFERENCE for some generated REORG table space statements based on SHRLEVEL REFERENCE restrictions according to the DB2 Utility Reference manual. R SHRLEVEL REFERENCE is added. However, the option might not be specified for some generated REORG table space statements based on SHRLEVEL REFERENCE restrictions according to the DB2 Utility Reference manual. blank The SHRLEVEL option will not be added. TIMEOUT option for REORG (util_reorg_timeout parameter) The util_reorg_shrlevel parameter specifies the TIMEOUT option for generated REORG utility statements. Values: T, A, blank Default: blank T The TIMEOUT TERM option will be added. A The TIMEOUT ABEND option will be added. blank The option will not be added to the utility statement. Sample member ADB2UCU8 for DB2 Administration Tool for z/OS Version 10, Release 1 and ADB2UCU1 for DB2 Administration Tool for z/OS Version 10, Release 2 were added to provide the instructions on the post-SMP/e customization steps. INSTRUCTIONS: ------------ UPDATE COMMENTS LINES BELOW IN SADBSAMP MEMBER ADB2UCUS AND CHECK THE VALUES OF EACH VARIABLE ACCORDING TO THE LOCAL ENVIRONMENT REQUIREMENT. -CM USED IN SKEL GOCTIMC IMAGE COPY (OBJECT COMPARE) -CM NOTE:USE A UNIQUE SYMBOLIC VARIABLE TO PREVENT NAMING CONFLICTS. -SET ASYCPYD = &GOCPRE..&DB2SYS..IC.&DBNAME..&TSNAME(+1) -CM USED IN SKEL GOCTIMC IMAGE COPY (OBJECT COMPARE) -CM NOTE:USE A UNIQUE SYMBOLIC VARIABLE TO PREVENT NAMING CONFLICTS. -SET ASYCPYDC = &GOCPRE..&DB2SYS..ICCLN.&DBNAME..&TSNAME(+1) -CM USED IN SKEL GOCTREO REORG (OBJECT COMPARE) -CM NOTE:USE A UNIQUE SYMBOLIC VARIABLE TO PREVENT NAMING CONFLICTS. -SET ASYCPYE = &PREFIX..&DB2SYS..IC.&TNAME(+1) -CM USED IN SKEL GOCTREO REORG (OBJECT COMPARE) -CM NOTE:USE A UNIQUE SYMBOLIC VARIABLE TO PREVENT NAMING CONFLICTS. -SET ASYCPYEC = &PREFIX..&DB2SYS..ICCLN.&TNAME(+1) -CM USED IN SKEL ADBTREO REORG -CM NOTE:USE A UNIQUE SYMBOLIC VARIABLE TO PREVENT NAMING CONFLICTS. -SET ASYCPY1G = &PREFIX..&&SSID..IC.&&DB..&&SN.(+1) -CM USED IN SKEL ADBTREO REORG FOR CLONE TABLE -CM NOTE:USE A UNIQUE SYMBOLIC VARIABLE TO PREVENT NAMING CONFLICTS. -SET ASYCPY1H = &PREFIX..&&SSID..ICCLN.&&DB..&&SN.(+1) -CM THE FOLLOWING IS USED IN IMAGE COPY SKELETON(ADB2USC) -CM WHEN LISTDEF'S ARE USED -CM NOTE:USE A UNIQUE SYMBOLIC VARIABLE TO PREVENT NAMING CONFLICTS. -SET ASYCPY1E = &&US..&&SSID..&&DB..&&SN..&&UQ. -CM THE FOLLOWING IS USED IN IMAGE COPY SKELETON(ADB2USC) -CM WHEN LISTDEF'S ARE USED FOR CLONED OBJECTS -CM NOTE:USE A UNIQUE SYMBOLIC VARIABLE TO PREVENT NAMING CONFLICTS. -SET ASYCPY1F = &&US..&&SSID..&&DB..&&SN..CL.&&UQ. NOTE: Please replace each dash '-' preceding the 'CM' and 'SET' statements with the CLOSED PARENTHESIS SYMBOL.
APAR Information
APAR number
PM74264
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-10-03
Closed date
2013-04-15
Last modified date
2013-05-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK93463 UK93464
Modules/Macros
ADBA01 ADBCCM ADBEALT ADBGAJOB ADBHUSO ADBHUSO1 ADBH5TU1 ADBTEP2 ADBTREO ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2UCU1 ADB2UCU8 ADB2USO ADB2USOP ADB2USO1 ADB2W1 ADB2000 ADB7000
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 May 2013