home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT03440 Status: Geschlossen

PARTNUM OF A TIMESERIES CONTAINER POPS UP ON THE HOT LIST OF THE BTSCANNER

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
After deleting in a timeseries, every select increases the 
number of dirty hits for the partnum of the container. 
At the end the container pops up on the hot list of the 
btscanner and remains there forever. 
 
And additionally now an onstat -C prof shows "Hot list 
requested" as the status for the btscanner all the time. 
 
$> onstat -C hot 
 
IBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 
00:12:54 -- 165008 Kbytes 
 
B-tree Scanner Information 
 
Index Hot List 
============== 
    Current Item           2     List Created          09:16:46 
    List Size              1     List expires in            300 
sec 
    Hit Threshold       5000     Range Scan Threshold        -1 
 
Partnum        Key            Hits 
0x00100225       1           24292 * 
 
0x00100225  is the partnum of the timeseries container 
 
$> onstat -C prof 
 
IBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 
00:12:42 -- 165008 Kbytes 
 
B-tree Scanner Information 
Profile 
======= 
Active Threads                               1 
Global Commands                        2000000   Building hot 
list 
Number of partition scans                  342 
Main Block                          0x0000000045596cc8 
BTC Admin                           0x0000000044beb7a8 
 
 
BTS info             id   Prio    Partnum      Key     Cmd 
0x455981c0            0   High   0x00000000     0  1000000  Hot 
list requested 
    Number of leaves pages scanned                          0 
    Number of leaves with deleted items                     0 
    Time spent cleaning (sec)                               0 
    Number of index compresses                              0 
    Number of deleted items                                 0 
    Number of index range scans                             0 
    Number of index leaf scans                              0 
    Number of index alice scans                             0
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Anyone using TimeSeries                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IDS-12.10.xC5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
28.07.2014
16.10.2015
16.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
12.10.xC5 FixList
12.10.xC5.W1 FixList