A fix is available
APAR status
Closed as program error.
Error description
SQL PA already replace :HV1 with ? before sending the query to explain, so we need to do something similar for & which was introduced in Db2 10 with CONCENTRATE LITERALS. The simple solution is to replace any standalone & tokens with ? SELECT * FROM table1 WHERE NAME = '&' (no replacement! & is within single quotes) SELECT * FROM "STUPIDTABLE&NAME" (no replacement! & is within double quotes) SELECT * FROM table1 WHERE NAME = & (replacement!?)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 SQL Performance Analyzer * * users of component : * * - ISPF Process SQL from a sequential data * * set or PDS member during using command * * EXPLAIN. * * - ISPF Process Packages from the DB2 system * * catalog during using line command SQL . * **************************************************************** * PROBLEM DESCRIPTION: 1.SQLCODE = -104, ERROR: ILLEGAL * * SYMBOL "&". during command EXPLAIN; * * 2.No statements displaied when using * * SQL cmd. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** 1.explain on specific SQL with symbol "&" can not be performed; 2.the message "Unexplainable statements" appears sometimes when sql cmd is used.
Problem conclusion
Code logic was corrected to fix the issues described. Search Keywords: SQLCODE = -104 when symbol "&" present in SQL , "Unexplainable statements"
Temporary fix
Comments
APAR Information
APAR number
PH25182
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-05-07
Closed date
2020-05-26
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69688
Modules/Macros
ANLBATCH ANLBPAM ANLCAT ANLCHECK ANLCLOB ANLCONV ANLCSV ANLDB2X ANLDPRM ANLEEE ANLGPRM ANLGPST ANLMAIN ANLNUXD ANLPICP ANLPIDD ANLPIQLR ANLPITP ANLPLAN ANLPRCR ANLPRER ANLPTCM ANLPTEX ANLPTLD ANLPTRP ANLPTSM ANLQMF ANLSERV ANLSQ2M ANLSQLPA ANLTABS ANLTOHEX ANLTSO ANLUNIC ANLUOPT ANLVER8 ANLWIF ANLWIFF
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R510 PSY UI69688
UP20/05/28 P F005
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"5.1.0"}]
Document Information
Modified date:
04 January 2021