search cancel

Is there any limitation for the history dataset size?


Article ID: 16578


Updated On:


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


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 ?


Component: CIDB


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


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