History file data loaded uncompress
search cancel

History file data loaded uncompress

book

Article ID: 8159

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

User unloaded the history file at %50 and then reload the data to the newly created files but new files filled up before copyng 100% of the requested data that needs to be copied. What's wrong?

 

Environment

Release:
Component: CIDB

Resolution

User job has the following parameters: LOAD JOB CMP=NO in the load job causing the data to be loaded uncompressed. Changing CMP=YES resolved the problem. The following is from From R19 Guide Page 242,

HISTORY-COMPRESSION=[YES | NO] 

(Optional) Specifies whether to compress the records being loaded (using hardware compression). We recommend using YES. 

JCL abbreviation: CMP=