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