IT31693: SPORADIC -25824 ALTER FRAGMENT ATTACH ON TABLE FRAGMENT BY RANGEINTERVAL MONTH TO MONTH

APAR status

• Closed as program error.

Error description

• Dates show below are DD/MM/YYYY.
  
  The table in question has the following fragment schema:
  
       fragment by range(datefe) interval(interval(1) month(9) to
  month) store in (dbs1)
        partition part_his_stomvt_2009 VALUES < DATE
  ('01/01/1900') in dbs1
  
  and the alter executed:
  
        alter fragment on table his_stomvt_2009 attach
  his_stomvt_20091001 as
          partition p20091001 VALUES < DATE ('01/11/2009')
  
  Alters like this can sporadically fail with error:
  
      -25824  The upper limit of the fragment must be aligned to
  an interval fragment boundary.
  
  ... despite the attached fragment being correctly aligned on an
  interval fragment boundary (Nov 1, 2009).
  
  Trapping for the error, shows it occurs with the following stack
  at prepare time:
  
      0x00000000014e501d (oninit) afstack
      0x00000000014e9d5d (oninit) afhandler
      0x00000000014ea372 (oninit) affail_interface
      0x0000000000f12f40 (oninit) check_traperror
      0x0000000000797631 (oninit) sqerr
      0x00000000006b78f2 (oninit) checkvalidfrag
      0x00000000006beba8 (oninit) af2cb
      0x00000000006c1f7c (oninit) stmt2cb
      0x00000000006c3d9d (oninit) p_sp2cb
      0x0000000000ade335 (oninit) parsecmd
      0x0000000000adea13 (oninit) sqcmd
      0x0000000000adf09d (oninit) sq_prepare
      0x0000000000bc655e (oninit) sqmain
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Informix Server 12.10.xC14 or 14.10.xC4.           *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC14 and 14.10.xC4.
  

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels