| Neueste Versionen | FixList |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
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 |
|
| 12.10.xC5.W1 |
|
