IDB2 Compression
Article ID: 200156
Updated On:
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Database Management for DB2 for z/OS - Performance Suite
Database Management for DB2 for z/OS - SQL Performance Suite
Insight Performance Monitor for DB2 UDB for z/OS
Database Management for DB2 for z/OS - Administration Suite
Database Management for DB2 for z/OS - Recovery Suite
Database Management for DB2 for z/OS - Utilities Suite
Issue/Introduction
Need info about compression.
Environment
Release : 20.0
Component : CA SYSVIEW Performance Management Option for DB2 for z/OS
Resolution
Here is the info about compression:
HISTORY-COMPRESSION=[YES|NO]
(Optional) Specifies whether to compress the records being loaded (using hardware compression). We recommend using YES.
JCL abbreviation: CMP=
Nothing about the % of the compression.
https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/configuring/utilities/trace-and-history-vsam-linear-data-set-utility-idb2uifi/load-online-history-files-idb2uifi-req-loadhist.html
HISTORY-COMPRESSION=[YES|NO]
(Optional) Specifies whether to compress the records being loaded (using hardware compression). We recommend using YES.
JCL abbreviation: CMP=
Nothing about the % of the compression.
https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/configuring/utilities/trace-and-history-vsam-linear-data-set-utility-idb2uifi/load-online-history-files-idb2uifi-req-loadhist.html
Feedback
Yes
No
Powered by
