A fix is available
APAR status
Closed as new function.
Error description
New Function
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Db2 13 for z/OS users * **************************************************************** * PROBLEM DESCRIPTION: Code to support a future enhancement * * to identify SQL statements. * **************************************************************** Code to support a future enhancement to identify SQL statements. This APAR also makes STMT_HASHID2 and its version available in IFCID 316 and 401 trace. It additionally adds QUERY_HASH and its version in IFCID 401. This IFCID change does not require a future Db2 13 function level. Additional keywords: IFCID316 IFCID401
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH70030
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
D10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2026-02-06
Closed date
2026-03-04
Last modified date
2026-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UO07024
Modules/Macros
DSNDQW04 DSNDQW05 DSNGEDYC DSNGEDYI DSNGEPSH DSNTBCM2 DSNTBFDQ DSNTBSPM DSNUECSE DSNXADQD DSNXEBPG DSNXECLF DSNXECST DSNXECW DSNXECWA DSNXECWU DSNXEIST DSNXELX DSNXERBP DSNXERDS DSNXERT DSNXEUCS DSNXEUFP DSNXIDMH DSNXKDC2 DSNXOBNQ DSNXOD15 DSNXOPTI
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RD10 PSY UO07024
UP26/03/12 P F603
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":"BU048","label":"IBM Software"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB70","label":"Z TPS"}}]
Document Information
Modified date:
02 April 2026