What Fast Unload option must be specified for history rows to be written to the utilities history table PTI.PTGL500_HISTORY
search cancel

What Fast Unload option must be specified for history rows to be written to the utilities history table PTI.PTGL500_HISTORY

book

Article ID: 11957

calendar_today

Updated On:

Products

Fast Unload for DB2 for z/OS

Issue/Introduction

What option must be specified to instruct the Fast Unload for Db2 for z/OS (PFU) utility to write history records to the history table.

Resolution

PFU-HISTORY UTIL 

PFU-HISTORY — Generate a Record in the History Table 

The PFU-HISTORY keyword specifies whether to generate a record in the utility history table. This table contains execution 
information for the utilities, such as the utility name, job number, user ID, affected databases and tablespaces, and 
when the job started and stopped. One row is inserted into the table for each SELECT statement that is processed. 

** Note: This keyword is specified only in hlq.CDBAPARM(PFU), not in the SYSIN syntax. 


This keyword has the following format: 

PFU-HISTORY {NONE|UTIL(,RC=ANY|RC=nn)} 

NONE 
Does not generate a history record. This setting is the default. 

UTIL 
Generates a history record. If you specify UTIL, you can also specify the following options: 

RC=ANY 
Inserts a row in the history table for each SELECT statement and ignores the return code. This is the default. 

RC=nn 
Suppresses writes to the history table when the return code from the SELECT statement is greater than the value specified for nn 
(a one or two-digit number). For example, if you specify RC=3, rows are not inserted into the history table for SELECT statements with 
errors of 4 or higher. 

Limits: 0 - 99