APAR status
Closed as program error.
Error description
When you drop and create temporary tables within a stored procedure, the onstat -g sql shows unclear output in the list of temporary tables. Example for the stored procedure: create procedure xx() drop table t1; select first 1 * from sysdefaults into temp t1; drop table t1; select first 1 * from sysprocedures into temp t1; end procedure; After you execute this stored procedure twice the onstat -g sql shows: Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 47 - test NL Not Wait 0 0 9.24 Off Last parsed SQL statement : execute procedure xx() User-created Temp tables : partnum tabname rowsize 200043 t1 5274 200043 t1 264 200043 t1 5274 When you drop the stored procedure and recreate it within the session before you execute it again, the onstat -g sql shows: Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 51 - test NL Not Wait 0 0 9.24 Off Last parsed SQL statement : execute procedure xx() User-created Temp tables : partnum tabname rowsize 200043 t1 5274 200043 t1 264 200043 t1 5274 200043 t1 264 200043 t1 500
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IDS-11.50.xC9 * **************************************************************** * PROBLEM DESCRIPTION: * * Unclear output of onstat -g sql when temporary tables are * * dropped and created within a stored procedure * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS-11.50.xC10. * ****************************************************************
Problem conclusion
Fix is done for IDS-11.50.xC10 and future releases.
Temporary fix
Comments
APAR Information
APAR number
IC80494
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-12-19
Closed date
2017-06-15
Last modified date
2017-06-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
RB50 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 June 2017