IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IT31693

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-01-29

  • Closed date

    2020-06-09

  • Last modified date

    2020-06-09

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
10 June 2020