APAR status
Closed as program error.
Error description
When a session was terminated by "FORCE_DDL_EXEC" it could not create a second temporary table by "select ... into temp ..." Version:IDS11.50FC6W1+idsdb00197176+idsdb00197101+idsdb00197225 OS:AIX 5.3 Reproduce steps: 1) In a dbaccess window, run: select * from acct_item_23 into temp tmp_1 with no log; 2) When the first session is running, execute the following sql in a second dbaccess window: set environment force_ddl_exec "30"; set lock mode to wait 10; begin; alter fragment on table acct_item_23 DETACH dbs1 acct_item_23_old; set environment force_ddl_exec "off"; rollback; 3) After the first session is terminated, then continue to run the following in the first dbaccess window: --begin work; -- it does not affect the result select * from acct_item_23 into temp tmp_2 with no log; Then it returns the follow error message: 229: Could not open or create a temporary file. 122: ISAM error: transaction not available
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * FORCE_DDL users * **************************************************************** * PROBLEM DESCRIPTION: * * When doing SELECT INTO temp table, if such transaction gets * * aborted, temp table is not cleaned up properly on rollback. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC7 and above. * ****************************************************************
Problem conclusion
Fix provided in IDS 11.50.xC7.
Temporary fix
Comments
APAR Information
APAR number
IC66718
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-02-26
Closed date
2010-11-15
Last modified date
2010-11-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
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSY
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":"B15","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
15 November 2010