IBM Support

IT31587: -244/-126 ON SECONDARY WHEN TABLE WITH SIZE THAT REQUIRES REMAINDER PAGES AND UPDATE NEEDS BEFORE/AFTER IMAGE

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

  • On a secondary you'll receive:
    
       244: Could not do a physical-order read to fetch next row.
       126: ISAM error: bad row id
    
    after an update in primary, for a table that uses remainder
    pages due to col sizes, on a row and the update needs, due to
    the size, a before / after image for the HUPDATE.
    
    Primary will show the row correctly.
    
    create table "informix".table1
      (
        a_serial_col serial not null ,
        a_char_with_index char(10) not null ,
        a_big_char char(4096),
        other_big_char char(4096),
        another_big_char char(4096)
      );
    
    revoke all on "informix".table1 from "public" as "informix";
    
    create unique index "informix".ix103_1 on "informix".table1
    (a_serial_col) using btree ;
    create unique index "informix".ix103_2 on "informix".table1
    (a_char_with_index)  using btree ;
    
    Insert 2 rows:
    
    1|KEY1|A char with some info on it so it gets some space used,
    I'll explain later why|Other char with some info as well|Another
    one with info|
    2|KEY2|A char with some info on it so it gets some space used,
    I'll explain later why|Other char with some info as well|Another
    one with info|
    
    UPDATE table1 SET a_big_char = "Update with a very big char so
    the update doesn't fit on a HUPDATE record and needs the HUPDBEF
    & HUPDAFT records"
    WHERE a_char_with_index="KEY2";
    
    A SELECT * FROM table1;  will return correctly first row and
    then the 244/126 error for the updated row.
    

Local fix

Problem summary

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

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IT31587

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

  • Closed date

    2020-12-10

  • Last modified date

    2020-12-10

  • 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

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

Document Information

Modified date:
11 December 2020