IC65265: AN UPDATE COMMAND RESULTS IN A BAD LOG RECORD IN THE TRANSACTION LOG IF THE TABLE HAS ROWSIZE > 16365 ON STANDARD ENGINE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Customer gets errors 241/119 when running an update command on a
    table with a rowsize greater than 16356:
    
    241: Cannot rollback work.
    
    119: ISAM error:  bad log record
    
    test1.sql
    
    drop table  ge_ctrlecrit;
    create table ge_ctrlecrit (ge_inv_dot integer, ge_exercice
    integer, ge_chnerr char(16358));
    insert into ge_ctrlecrit (ge_exercice) values (2009);
    
    begin work;
       update ge_ctrlecrit
       set ge_inv_dot=500
       where ge_exercice=2009;
       update ge_ctrlecrit
       set ge_inv_dot=600
       where ge_exercice=2009;
       update ge_ctrlecrit
       set ge_inv_dot=700
       where ge_exercice=2009;
    rollback work;
    
    $ dbaccess stores7 test1.sql
    
    Database selected.
    
    
    Table dropped.
    
    
    Table created.
    
    
    1 row(s) inserted.
    
    
    Started transaction.
    
    
    1 row(s) updated.
    
    
    1 row(s) updated.
    
    
    1 row(s) updated.
    
    
      241: Cannot rollback work.
    
      119: ISAM error:  bad log record
    Error in line 15
    Near character position 12
    
    Database closed.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 7.25.xC7 and below                                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * AN UPDATE COMMAND RESULTS IN ERRORS 241/119 IF THE TABLE HAS *
    * ROWSIZE > 16365 ON STANDARD ENGINE                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to SE 7.25.xC8                                       *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in 7.25.xC8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65265

  • Reported component name

    IFMX STANDARD E

  • Reported component ID

    5724C4300

  • Reported release

    725

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-12-21

  • Closed date

    2010-10-15

  • Last modified date

    2010-10-15

  • 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

    IFMX STANDARD E

  • Fixed component ID

    5724C4300

Applicable component levels

  • R725 PSY

       UP



Document information


More support for:

Informix Standard Engine

Software version:

725

Reference #:

IC65265

Modified date:

2010-10-15

Translate my page

Content navigation