How can I force Insight to offload (unload) my History file?

Products

• RC Compare for DB2 for z/OS
• 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
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

This document explains how to enable Insight to offload (unload) the History file.

Solution:

The UNLOAD Modify command forces the data collector to unload the accounting file, the statistics file or both.

Note:

The SYSOPR userid, defined in the Insight Security file, must be authorized to issue the UNLOAD command. This is done by specifying HISTORY-UNLOAD=YES in the security profile associated with SYSOPR. By default this is the OPERATOR security profile.

This command has the following format:

 	/F <jobname>,UNLOAD {ACCT|STAT|ALL} 

Where:

/F
Issues the MVS MODIFY command. This is the standard abbreviation.

<jobname>
Specifies the jobname of the data collector.

UNLOAD {ACCT|STAT|ALL}
Forces the data collector to unload the accounting file (ACCT), the statistics file (STAT), or both (ALL).

For example, the following command can be entered to unload all of the History records for a running Data Collector job named HAYGR012:

 	/f haygr012,unload all 

Environment

Release:
Component: IDB2