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

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

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Standard Engine (SE)

Software version:

725

Reference #:

IC65265

Modified date:

2010-10-15

Translate my page

Machine Translation

Content navigation