A fix is available
APAR status
Closed as program error.
Error description
Parser error during WSL Validate step of compare.
Local fix
Creating new APAR.
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * who use Object Compare on a table or view * * that has a schema name greater than * * eight characters * **************************************************************** * PROBLEM DESCRIPTION: Object Compare ends with a parser error * * and RC=8 following PL/I ONCODE 340 in * * program ADB2PA, procedure * * ADD_SYMBOL_COLS_CTLG. * **************************************************************** An SQL ID greater than eight characters was used by Db2 Admin Tool in an EXEC SQL SET CURRENT SQLID statement. However, SET CURRENT SQLID does not support an SQL ID greater than eight characters. The resulting error SQL code caused ONCODE 340 and early termination of SQL parsing. Keywords: MSGIBM0342S ONCODE0340
Problem conclusion
The problem has been resolved. ++HOLD: Bind required for adb2prp.
Temporary fix
Comments
APAR Information
APAR number
PH53653
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-03-31
Closed date
2023-07-24
Last modified date
2023-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI92880
Modules/Macros
ADB2LCC ADB2PA ADB2PA3 ADB2PA4 ADB2PA6 ADB2PRP ADB2WCL ADB2WVL ADB3000 ADBCRCM ADBCRCR
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI92880
UP23/07/27 P F307
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 August 2023