APAR status
Closed as program error.
Error description
The os command 'echo date' was executed through SYSTEM in stored procedure. create procedure "tosifadm".sel_simple() SYSTEM 'echo START '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo `date` '; SYSTEM 'echo END '; end procedure; SYSTEM was executed repeatedly to demonstrate that on 11.50.xC4 there appeared to be some significant time delay between commands, while on 9.40 server they were executed as if in parallel. It looks like a regression issue of idsdb00164889. Test result in 11.50.xC4 ----------------------------- START Thu Feb 18 14:13:59 CUT 2010 Thu Feb 18 14:14:00 CUT 2010 Thu Feb 18 14:14:01 CUT 2010 Thu Feb 18 14:14:02 CUT 2010 Thu Feb 18 14:14:03 CUT 2010 Thu Feb 18 14:14:04 CUT 2010 Thu Feb 18 14:14:05 CUT 2010 Thu Feb 18 14:14:06 CUT 2010 Thu Feb 18 14:14:07 CUT 2010 Thu Feb 18 14:14:08 CUT 2010 END Test result in 9.40: ---------------------- START Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 Thu Feb 18 14:15:49 CUT 2010 END Threads: tid tcb rstcb prty status vp-class name 17827 700000022d9fc10 7000000203e15c8 1 Fork 1cpu sqlexec IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 8 days 22:44: 19 -- 533344 Kbytes Stack for thread: 17827 sqlexec base: 0x0700000023e45000 len: 69632 pc: 0x00000001000421a8 tos: 0x0700000023e54030 state: sleeping vp: 1 0x00000001000421a8 (oninit)yield_processor_svp 0x000000010004c594 (oninit)mt_yield 0x0000000100051908 (oninit)mt_exec 0x0000000100c6ae5c (oninit)rsystem 0x000000010039e434 (oninit)aud_rsystem 0x0000000100398058 (oninit)ip_evalsystem 0x00000001003a1b68 (oninit)runproc 0x000000010039cab4 (oninit)udrlm_spl_execute 0x0000000100c394d4 (oninit)udrlm_exec_routine 0x0000000100413d68 (oninit)udr_execute 0x0000000100243ef8 (oninit)exroutine 0x0000000100420ba8 (oninit)execproc 0x0000000100792388 (oninit)aud_execproc 0x0000000100422c24 (oninit)excommand 0x00000001005e9c24 (oninit)sq_execute 0x0000000100219de8 (oninit)sqmain 0x00000001003b1f80 (oninit)listen_verify 0x00000001003b06c4 (oninit)spawn_thread 0x0000000100ce98cc (oninit)startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * oninit started by non-informix (DBSA) user on Unix * **************************************************************** * PROBLEM DESCRIPTION: * * On Unix, when the server is started by user DBSA instead of * * user * * informix, simple system commands run by a session run at a * * rate of * * only one per second. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC7, or start oninit as user informix, or * * run system commands from separate sessions. * ****************************************************************
Problem conclusion
Problem first fixed in 11.50.xC7.
Temporary fix
Comments
APAR Information
APAR number
IC66668
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-25
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":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 November 2010