IC85939: HUGE MEMORY CONSUMPTION ON INSERT INTO LIST

APAR status

• Closed as program error.

Error description

• You are executing inserts into a variable of LIST of custom row
  and you notice that engine allocates a huge amount of additional
  memory.
  
  For example, the custom row definition:
  
  create row type 'informix'.custom_type
  (
  id int8,
  table varchar(50)
  );
  
  The list definition:
  
  custom_list list(custom_type not null);
  
  The sample insert statement:
  
  insert into table(custom_list) select  ROW(v_id,
  v_table)::event_type from db:table1;
  
  If executed frequently, online.log will report about additional
  segments allocation:
  
  <...>
  16:50:48  Memory sizes:resident:217728 KB, virtual:4940480 KB,
  no SHMTOTAL limit
  16:50:48  Segment locked: addr=0x23a550000, size=8388608
  16:50:50  Dynamically allocated new virtual shared memory
  segment (size 8192KB)
  16:50:50  Memory sizes:resident:217728 KB, virtual:4948672 KB,
  no SHMTOTAL limit
  16:50:50  Segment locked: addr=0x23ad50000, size=8388608
  16:50:50  Dynamically allocated new virtual shared memory
  segment (size 8192KB)
  16:50:50  Memory sizes:resident:217728 KB, virtual:4956864 KB,
  no SHMTOTAL limit
  16:50:50  Segment locked: addr=0x23b550000, size=8388608
  16:50:52  Dynamically allocated new virtual shared memory
  segment (size 8192KB)
  16:50:52  Memory sizes:resident:217728 KB, virtual:4965056 KB,
  no SHMTOTAL limit
  16:50:52  Segment locked: addr=0x23bd50000, size=8388608
  16:50:52  Dynamically allocated new virtual shared memory
  segment (size 8192KB)
  16:50:52  Memory sizes:resident:217728 KB, virtual:4973248 KB,
  no SHMTOTAL limit
  16:50:52  Segment locked: addr=0x23c550000, size=8388608
  16:50:53  Dynamically allocated new virtual shared memory
  segment (size 8192KB)
  16:50:53  Memory sizes:resident:217728 KB, virtual:4981440 KB,
  no SHMTOTAL limit
  16:50:53  Segment locked: addr=0x23cd50000, size=8388608
  16:50:54  Dynamically allocated new virtual shared memory
  segment (size 8192KB)
  16:50:54  Memory sizes:resident:217728 KB, virtual:4989632 KB,
  no SHMTOTAL limit
  16:50:54  Segment locked: addr=0x23d550000, size=8388608
  <...>
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Applications that insert into collections in a loop inside   *
  * of stored procedures.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC6                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC6
  

Temporary fix

Comments

• http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp
  http://www.ibm.com/support/fixcentral
  

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