How to resolve PFL0403E Object in Use message during Fast Load execution.

Products

• Fast Load for DB2 for z/OS
• Database Management for DB2 for z/OS - Utilities Suite
• Fast Unload for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

During execution of a Fast Load for Db2 for z/OS (PFL) job, the following message was received:

PFL0403E - Error message - Restart Table - Object xxxxxx.xxxxxxx in use by another Utility UTLIID xxxxxx.xxxxxxxx

This indicates that an object is already in use by the utility named in this message.

Resolution

Wait for the other utility to complete and resubmit the job or terminate the other utility and resubmit the job.

The DB2 Command Processor (Option C from the Main Menu) allows you to enter the commands required to display or terminate the utility in use.

To display the Database Management for Db2 for z/OS utilities in process enter DC for the Utility code:

Enter: - DISPLAY CA UTILITY (*)

The utility ID will be provided in the output of the DISPLAY commands. The utility ID will be followed by the UTILID parameter
in the output of the DISPLAY command.

For example, in the following display, the UTILID is userid .xxxxxxx and the utility type is UNLOAD. The STATUS parameter will
identify the process/status of the utility. The user must determine what action must then be performed on the utility.

    PUT3003I  UTILID              = userid .xxxxxxx      CHECKSUM = 16233 
              UTYPE               = UNLOAD               USERID   = userid    
              TIME ACCESSED       = 2008-09-01 01.35.32 
              STATUS              = INACTIVE 
              PHASE               = UNKNOWN 

If the utility needs to be terminated Enter:
- TERM CA UTILITY (utilid)

If the utility needs to continue then the failing job should be restarted after the utility has completed.