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

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