IBM Support

IC65692: A BAD LOG RECORD WAS ENCOUNTERED MESSAGE SEEN IN SE LOG FILE IF A ROLLBACK FOLLOWS AN UPDATE ON A TABLE WITH A ROWSIZE > 16365

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as change to accomodate OEM Vendor's code.

Error description

  • Create a table with a rowsize greater than 16365, update the
    table and then issue a rollback. The SE log file shows the
    following message:
    
    For example, run the following SQL:
    
    drop database test;
    create database test with log in '/tmp/test.log' mode ansi;
    CREATE TABLE test (bigchar char(16369));
    INSERT INTO test VALUES ( "Very big char field");
    UPDATE test SET bigchar = "Life in two dimensions is a mass
    production scheme!";
    UPDATE test SET bigchar = "Life in two dimensions is a mass
    production scheme!";
    UPDATE test SET bigchar = "Life in two dimensions is a mass
    production scheme!";
    rollback work;
    
    The SE log file shows the following message:
    
    $ selog logfile -l /tmp/test.log
    DBLOG: Transaction Log File Display C-ISAM Version 7.25.UC6
    Copyright (C) 1981-1997 Informix Software, Inc.
    Software Serial Number AAA#E123456
    
    TY Trx ID User User Name    Date/Time    Lngth FD Recno Filename
    Location Prev Loc Pr Ln
    -- ------ ---- ---------- -------------- ----- -- -----
    ---------------------- -------- -------- -----
    BW  13084  201 informix    1/19 17:30:01    26
                         4        0     0
    FO  13084  201 informix    1/19 17:30:01    51  0
    systables                    30        0     0
    UN  13084  201 informix    1/19 17:30:01    30  0    30
                        81        0     0
    BU  13084  201 informix    1/19 17:30:01    60
    palaka.dbs/test_00101       111        0     0
    FO  13084  201 informix    1/19 17:30:01    51  4
    systables                   171        0     0
    IN  13084  201 informix    1/19 17:30:01   595  4    30
                       222        0     0
    FO  13084  201 informix    1/19 17:30:01    52  5
    syscolumns                  817        0     0
    IN  13084  201 informix    1/19 17:30:01    62  5   138
                       869        0     0
    FO  13084  201 informix    1/19 17:30:01    52  6
    test_00101                  931        0     0
    IN  13084  201 informix    1/19 17:30:01 16403  6     1
                       983        4    26
    UP  13084  201 informix    1/19 17:30:01 -32762  6     1
                      17386      983 16403
    
    A bad log record was encountered.
    
    Please note, where defect idsdb00196556 is coded the rollback
    completes successfully but the error can still be seen in the
    log file. However, in versions where idsdb00196556 still exists
    the rollback fails and the error can also be seen in the log
    file.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of 7.25.xC6                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Selog is a dbatool utility used to read the log file.        *
    * However, while reading the log record, one of the function   *
    * used to use ldint, which returned a short value. As a        *
    * result, selog was throwing a BAD LOG RECORD error. Now the   *
    * problem is fixed.                                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 7.25.xC7 when available or request a patch.       *
    ****************************************************************
    

Problem conclusion

  • Fix is checked into 7.25.xC7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65692

  • Reported component name

    IFMX STANDARD E

  • Reported component ID

    5724C4300

  • Reported release

    725

  • Status

    CLOSED OEM

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-20

  • 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

Applicable component levels

  • R725 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU5Y","label":"Informix Standard Engine"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"725","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2010