A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS panel ADB21K 'Packages' SQ - SQL in package line command fails with a SQLCODE -104 / SQLCODEN104 when the users TSO PROFILE shows NOPREFIX and the DB2 release is DB2 10 in New Function Mode / NFM. Additional symptom: SQLCODEN199 DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD T. TOKEN
Local fix
Issue a TSO PROFILE PREFIX command and set an appropriate value for the prefix.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use DB2 10 New Function Mode * * (NFM) with TSO PROFILE NOPREFIX and * * execute the 'SQ' line command on panel * * ADB21K 'Packages' or ADB21L 'Collections' * * to view the SQL statements in package(s). * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS * * 'SQ' line command on panel ADB21K or * * ADB21L fails wit SQLCODEN104/ * * SQLCODE=-104 when the user's TSO * * PROFILE uses NOPREFIX and the DB2 * * release is DB2 10 New Function Mode: * * * * DSNT408I SQLCODE = -104, * * ERROR: ILLEGAL SYMBOL "T". * * SOME SYMBOLS THAT MIGHT BE * * LEGAL ARE: * * <ERR_STMT> <WNG_STMT> * * GET SQL SAVEPOINT HOLD FREE * * ASSOCIATE * * DSNT418I SQLSTATE = 42601 * * SQLSTATE RETURN CODE * **************************************************************** * RECOMMENDATION: * **************************************************************** The DB2 Administration Tool for z/OS 'SQ' line command on panel ADB21K or ADB21L fails with SQLCODEN104/SQLCODE=-104 when the user's TSO PROFILE uses NOPREFIX and the DB2 release is DB2 10 New Function Mode: DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "T". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE ASSOCIATE DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
Problem conclusion
Programs have been updated to resolve the reporting problem. A similar problem (SQLCODEN104) also exists on other panels when a user's TSO PROFILE uses NOPREFIX and has been resolved. For DB2 Administration Tool for z/OS Version 10.1, these panels are affected: ADB26COW 'Stored Procedure BIND Options' ADB2ELI 'Interpretation of Row from PLAN_TABLE' ADBP6CPM 'Create Row Permission panel' ADBP6CFZ 'Alter SQL Scalar Bind Options panel' ADBP6CCM 'Create Column Mask panel' ADBPZRP 'Manage RUNSTATS Profile panel' For DB2 Administration Tool for z/OS Version 7.2, this panel is affected: ADB26COW 'Stored Procedure BIND Options panel'
Temporary fix
Comments
APAR Information
APAR number
PM46964
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-09-01
Closed date
2011-11-10
Last modified date
2012-06-27
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK73725 UK73726
Modules/Macros
ADBPZRP ADBP6CCM ADBP6CFZ ADBP6CPM ADB2ELI ADB21K ADB21L ADB26COW
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.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
27 June 2012