A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' line commands PA and CH fail with a SQLCODEN203 / SQLCODE -213 when issued on panel ADB21T 'Tables, Views, and Aliases' after running the sample job ADBSMORJ, introduced by APAR PI11448.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * Z/OS Version 11, Release 1. * **************************************************************** * PROBLEM DESCRIPTION: A SQLCODE=-203 / SQLCODEN203: * * * * DSNT408I SQLCODE = -203, * * ERROR: A REFERENCE TO * * COLUMN CREATOR IS * * AMBIGUOUS * * DSNT418I SQLSTATE = 42702 * * SQLSTATE RETURN CODE * * * * is received when using the 'PA - * * Referential integrity, show parent * * tables' or 'CH - Referential * * integrity, show child tables' line * * commands on panel ADB21T 'Tables, * * Views, and Aliases' when the supplied * * sample ORDER BY clauses are * * installed or a ORDER BY on CREATOR * * is defined for panel ADB21T. * **************************************************************** * RECOMMENDATION: * **************************************************************** The generated SQL statement contains a SELECT * FROM SYSTABLES and SYSRELS and adding an ORDER BY CREATOR made the statement invalid.
Problem conclusion
Problem has been resolved. APAR PI19368 has been opened to address the issue with SAMP member ADBSMORD containing two references to the panel ID ADB2AR.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PI19043
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2014-05-30
Closed date
2014-06-16
Last modified date
2014-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI18865
Modules/Macros
ADB21T
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI18865
UP14/06/18 P F406
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":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 July 2014