IBM Support

IT09615: MANY LONGTX CHECKPOINTS BEING SEEN WITH SMALL TRANSACTIONS COVERING ONLY A FEW LOGS WHEN THE WORK IS ROLLED BACK

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ENV:  11.50.FC3 LINUX & 11.50.FC5W1 ON SOLARIS.
    
    The following is being seen when running an onstat -g ckp report
    ...
    
    66025      17:36:56  LongTX     2787:0x4343018    0.6   0.6
    0.0   0      0.0   0.0   0.0   3109      3109    2920     21
    2444     17
    66026      17:37:40  LongTX     2787:0x4792018    0.4   0.3
    0.0   1      0.0   0.0   0.0   1723      1723    1516     34
    1110     25
    66027      17:43:10  CKPTINTVL  2787:0x5ff3018    1.7   1.3
    0.0   0      0.0   0.0   0.0   5741      4449    4623     14
    6267     19
    66028      17:43:58  LongTX     2787:0x64c7018    0.3   0.3
    0.0   2      0.0   0.0   0.0   1608      1608    1861     37
    1247     25
    66029      17:49:10  CKPTINTVL  2787:0x814f018    2.0   1.8
    0.0   2      0.0   0.0   0.0   6289      3478    5149     16
    7346     23
    66030      17:51:20  LongTX     2787:0x8b7c018    0.6   0.5
    0.0   0      0.0   0.0   0.0   3246      3246    3339     25
    2618     19
    66031      17:56:40  CKPTINTVL  2787:0x9ff8018    1.7   1.3
    0.0   0      0.0   0.0   0.0   5262      4141    4685     14
    5274     16
    66032      17:57:28  LongTX     2787:0xa2f8018    0.3   0.2
    0.0   0      0.0   0.0   0.0   1600      1600    1652     33
    771      15
    66033      17:59:04  LongTX     2787:0xa899018    0.3   0.3
    0.0   0      0.0   0.0   0.0   1795      1795    1899     19
    1452     15
    66034      17:59:05  LongTX     2787:0xa8b8018    0.1   0.0
    0.0   0      0.0   0.0   0.0   115       115     472      472
    32       32
    
    The checkpoint interval is 300 (5 minutes) but what is seen is
    many LongTX checkpoints between these and some are only a few
    seconds apart.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of 12.10                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IBM Informix Server 12.10.xC6                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IBM Informix Server 12.10.xC6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT09615

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-06-23

  • Closed date

    2016-01-19

  • Last modified date

    2024-09-24

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 September 2024