IC66668: SYSTEM COMMAND IN STORED PROCEDURE EXECUTES SLOWER IN 11.50.XC4 THAN 9.40

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 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