How to force Sysview for Db2 to offload (unload) History file

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

How to enable Sysview Performance Management Option for Db2 for z/OS (IDB2) to offload (unload) the History file.

Resolution

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:

 	/f <jobname>,unload all