|
Problem IT03440
|
Status: Closed |
PARTNUM OF A TIMESERIES CONTAINER POPS UP ON THE HOT LIST OF THE BTSCANNER |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* Anyone using TimeSeries *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IDS-12.10.xC5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IDS-12.10.xC5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.07.2014
16.10.2015
16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC5
|
 |
| 12.10.xC5.W1
|
|
