A fix is available
APAR status
Closed as program error.
Error description
This APAR addresses eight issues: 1) Panel ADB2USO ('Specify Utility Options - REORG') erroneously issues the following message when input Field NOSYSREC is set to YES and input field SHRLEVEL is set to C: NOSYSREC and SHRLEVEL CHANGE are mutually exclusive options. 2) On panel ADB2USRA ('Specify Utility Options - RUNSTATS DYNAMIC CACHE'), when input field REPORT has NO specified and input field UPDATE has N specified, input field INVALIDATECHACHE should not allow NO to be specified. Otherwise the utility may fail with the following messages: DSNU070I 328 20:37:59.41 DSNUGDFL - KEYWORD OR OPERAND 'INVALIDATECACHE NO' INVALID WITH 'REPORT NO UPDATE NONE' DSNU012I 328 20:37:59.41 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 Issue 3: Line command 'T' on panel ADB21T 'Tables, Views, and Aliases' and line command 'T' on panel ADB21VV 'Views' issues message 'No rows returned' when the associated objects are archive tables. Issue 4: Line command AUX on panel ADB21T 'Tables, Views, and Aliases' for an archive table results in message 'Invalid object type'. Issue 5: Line command T on panel ADB21D 'Databases' shows view objects when it should not. Issue 6: Values specified on input fields for panel ADB2USO1 'REORG TABLESPACE' are not saved. Issue 7: Panel ADB21H 'Schemas' does not show all schema names compared to Data Studio. Issue 8: Utility RECOVER option V on panel ADB2U 'Table Space Utilities' for a partitioned table space generates JCL with "DSNUM 1" for all related parts for the RECOVER TABLESPACE statement.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Issue 1: * * Panel ADB2USO 'Specify Utility * * Options - REORG' erroneously * * issues a mutually exclusive error * * message. * * * * Issue 2: * * Panel ADB2USRA 'Specify Utility * * Options - RUNSTATS DYNAMIC * * CACHE' failed to issue a mutually * * exclusive error message. * * * * Issue 3: * * Line command 'T' on panel * * ADB21T and line command 'T' on * * panel ADB21VV issues message * * 'No rows returned'. * * * * Issue 4: * * Line command AUX on panel ADB21T * * 'Tables, Views, and Aliases' results * * in message 'Invalid object type'. * * * * Issue 5: * * Line command T on panel ADB21D * * 'Databases' shows view objects. * * * * Issue 6: * * Values specified on input fields for * * panel ADB2USO1 'REORG TABLESPACE' * * are not saved. * * * * Issue 7: * * Catalog Navigation for schemas does * * not show all schemas. * * * * Issue 8: * * Utility RECOVER option for a * * partitioned table space generates * * JCL with "DSNUM 1" for all related * * parts for the RECOVER TABLESPACE * * statement. * **************************************************************** Issue 1: Panel ADB2USO 'Specify Utility Options - REORG' erroneously issues mutually exclusive error message when input field NOSYSREC is set to YES and input field SHRLEVEL is set to C. Issue 2: Panel ADB2USRA 'Specify Utility Options - RUNSTATS DYNAMIC CACHE', failed to issue an error message when input field REPORT is set to NO, input field UPDATE is set to N and input field INVALIDATECACHE is set to NO. Issue 3: Line command 'T' on panel ADB21T 'Tables, Views, and Aliases' and line command 'T' on panel ADB21VV 'Views' issues message 'No rows returned' when the associated objects are archive tables. Issue 4: Line command AUX on panel ADB21T 'Tables, Views, and Aliases' for an archive table results in message 'Invalid object type'. Issue 5: Line command T on panel ADB21D 'Databases' shows view objects when it should not. Issue 6: Values specified on input fields for panel ADB2USO1 'REORG TABLESPACE' are not saved. Issue 7: Panel ADB21H 'Schemas' does not show all schema names compared to Data Studio. Issue 8: Utility RECOVER option V on panel ADB2U 'Table Space Utilities' for a partitioned table space generates JCL with "DSNUM 1" for all related parts for the RECOVER TABLESPACE statement.
Problem conclusion
All issues have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH19635
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-11-26
Closed date
2020-02-17
Last modified date
2020-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI67938
Modules/Macros
ADB21 ADB21D ADB21S ADB21T ADB21VV ADB2USO ADB2USO1 ADB2USOO ADB2USRA ADB2USV ADBDMT
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI67938
UP20/02/20 P F002
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]
Document Information
Modified date:
30 March 2021