IC57169: AN ALTER FRAGMENT ON TABLE ATTACH PARTITION COMMAND CAUSES THE IDS TO ASSERT FAIL

APAR status

• Closed as program error.

Error description

• An alter fragment attach partition command executed on a table
  causes the Informix Dynamic Server (IDS) to assert failure,
  below is the stack trace of the problem thread:
  13:07:11
  13:07:11  IBM Informix Dynamic Server Version 11.50.UC1
  13:07:11  Assert Failed: No Exception Handler
  13:07:11   Who: Session(27, informix@, 12721,
  0x4b75cd60)
    Thread(54, sqlexec, 4b730d98, 1)
    File: mtex.c Line: 475
  13:07:11   Results: Exception Caught. Type: MT_EX_OS, Context:
  mem
  13:07:11   Action: Please notify IBM Informix Technical
  Support.
  13:07:11   See Also: /opt/informix/tmp/af.41eabce,
  shmem.41eabce.0
  base: 0x4c4d2000
    len:  36864
     pc: 0x08ac9ab1
    tos: 0x4c4d5ae0
  state: running
     vp: 1
  afstack
  mt_ex_throw_sig
  afsig_handler
  <>__kernel_rt_sigreturn
  fmftopen_with_child
  sqftopen_tab_hierarchy
  openrel
  droptab
  ddaltfrag
  aud_ddaltfrag
  excommand
  sq_execute
  sqmain
  spawn_thread
  startup
  An example of the statement that caused the IDS to assert
  failure:
  alter fragment on table call_details attach cdrpartn20080621 as
  partition cdrpartn20080621 (call_date = "06/21/2008") before
  cdrpartn20080620;
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IDS 11.50.xC1
  ****************************************************************
  PROBLEM DESCRIPTION:
  The users can see a Informix Dynmic Server (IDS) abend due to a
  memory corruption, when they tried to execute an alter table
  attach fragment.  This occurs especially in the case where the
  attached fragment has detached indexes which the IDS decides to
  reuse.
  ****************************************************************
  RECOMMENDATION:
  Please upgrade to the latest 11.50 IDS version.
  ****************************************************************
  

Problem conclusion

• The problem was first fixed in 11.50.xC2 where the alter table
  attach fragment command will not cause the abend while reusing
  the detached indexes of the attaching table.
  

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