A fix is available
APAR status
Closed as program error.
Error description
SQLCODE -418 Conditions that are covered are: 1. The scalar function TIMESTAMP ( ?, ?) 2. SQL stmts of format SELECT ?,?,? FROM and SELECT COL1, ?, COL2 FROM ADDITIONAL SYMPTOMS: 1) ANL1009W Pgm cannot determine the cost of statement: 100000123, Sqlcode = -104 (P) One or more host variables cannot be correctly substituted with marker Parameter Markers (?) are illegal in some "EXPLAIN" requests. - or - an illegal symbol has been encountered within the SQL. Statement ignored and process continues. DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "?". SOME SYMBOLS THAT MIGHT DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 502 0 0 -1 60 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'000001F6' X'00000000' X'00000000' X'FFFFFFFF' X'00 INFORMATION
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 SQL Performance Analyzer. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE -418 * * Conditions that are covered are: * * 1. The scalar function TIMESTAMP * * ( ?, ?) * * 2. SQL stmts of format SELECT ?,?,? * * FROM and SELECT COL1, ?, COL2 FROM * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK51794
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2007-08-27
Closed date
2007-10-19
Last modified date
2007-11-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK30462
Modules/Macros
ANLCLOB ANLPGM31
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R310 PSY UK30462
UP07/10/23 P F710
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":"310"}]
Document Information
Modified date:
04 January 2021