A fix is available
APAR status
Closed as program error.
Error description
SQLCODE104 when SQLPA encounters Korean characters in CCSID 933. DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL " ". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: VALID GRAPHIC STRING DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNHTOKR SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 502 0 0 -1 306 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'000001F6' X'00000000' X'00000000' X'FFFFFFFF' X'00000132' X'00000000' SQL DIAGNOSTIC INFORMATION ADDITIONAL SYMPTOMS 1. ANLCAT does not function the same as ANLSTAT when specifying multiple COLLECT statements. The following messages are issued: ANL8013I NO INDEX FOUND FOR TABLE ANL8014I NO COLUMN STATS FOR TABLE ANL8016I NO COLUMN DIST STATS 2) Loop in SQLPA online ( under ISPF interface ) when specify "Define output files.... YES" and the CLIST ANLLOOP from member hiqual.SANLVCLS is executed.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of SQL Performance Analyzer. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE104 when SQLPA encounters Korean * * characters in CCSID 933. * * DSNT408I SQLCODE = -104, ERROR: * * ILLEGAL SYMBOL " ". SOME SYMBOLS THAT * * MIGHT BE LEGAL ARE: VALID GRAPHIC * * STRING * * DSNT418I SQLSTATE = 42601 SQLSTATE * * RETURN CODE * * DSNT415I SQLERRP = DSNHTOKR SQL * * PROCEDURE DETECTING ERROR * * DSNT416I SQLERRD = 502 0 0 -1 * * 306 0 SQL DIAGNOSTIC INFORMATION * * DSNT416I SQLERRD = X'000001F6' * * X'00000000' X'00000000' X'FFFFFFFF' * * X'00000132' X'00000000' SQL * * DIAGNOSTIC INFORMATION * * ADDITIONAL SYMPTOMS * * 1. ANLCAT does not function the same * * as ANLSTAT when specifying multiple * * COLLECT statements. The following * * messages are issued: * * ANL8013I NO INDEX FOUND FOR TABLE * * ANL8014I NO COLUMN STATS FOR TABLE * * ANL8016I NO COLUMN DIST STATS * * 2. Loop in SQLPA online ( under ISPF * * interface ) when specify * * "Define output files.... YES" and the * * CLIST ANLLOOP from member * * hiqual.SANLVCLS is executed. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK43853
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2007-04-23
Closed date
2007-05-25
Last modified date
2007-06-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK25547 UK25548
Modules/Macros
ANLCAT22 ANLLOOP ANLPGME7 ANLPGME8 ANLPGM31 ANLPRC3C ANLPRC3R ANLPRE3C ANLPRE3R ANLQMF31
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
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.
[{"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":"220"}]
Document Information
Modified date:
30 March 2021