For counter columns in Dynamic System tables where large numeric values have been encountered, we have increased these column values in r12 to s9(11) which will support values up to 99,999,999,999. In other counter columns where we do not expect large numbers, the columns are defined as integers and can handle values to slightly over two billion.
If a very active MUF remains active for very long periods of time, these columns may reach their maximum value. If that occurs, their values either freeze at the high water mark or may reset back to zero. Statistical analysis of these columns after this occurs is not effective. We do not expect this to occur in normal circumstances.
While processing Dynamic System Tables (DSTs) into Snapshot and Delta rows, the large numeric values from DSTs are stored in columns defined as s9(15). This allows the Snapshot and Delta tables to support substantially larger values needed for total rows and Delta summarization functions. However, if you use the AutoCollect functions to summarize a large amount of MUF activity (such as for a year) into a single set of Delta rows, it may exceed the capacity of these numeric columns.
|
Copyright © 2014 CA.
All rights reserved.
|
|