search cancel

Is there any limitation for the history dataset size?

book

Article ID: 16578

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS

Issue/Introduction



Is there any kind of limitation on the size of the history dataset? The current dataset(HSTACCTG) dataset has allocated 4.2 trks. User wants to bump it to 10 million+. Will INSIGHT be able to handle such large file with out my performance degradation or any other issues ? Is there an option to compress INSIGHT data ?

Environment

Release:
Component: CIDB

Resolution

Insight can handle a 8TB(10 millions tracks) dataset fine without any performance degradation.  The following information is taken from the Insight Guide:

HISTORY-COMPRESSION=[YES|NO] 

Specifies whether to compress the records that are written to the history data sets. CA SYSVIEW for DB2 uses hardware compression to compress history records, which generate little CPU overhead. The option can be turned on and off without reallocating the ACCT and STAT files. 

These files can have both uncompressed and compressed records mixed in the same file. 

Default: YES