How do I resolve the following error in my Fast Load job: PFL0403E - Restart Table - Object xxxxxx.xxxxxxx in use by another Utility UTLIID xxxxxx.xxxxxxxx.

Document ID : KB000026132
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

While running a CA Fast Load 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.

Answer:

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 CA commands required to display or terminate the utility in use.

To display the CA 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 .P439FU 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 .P439PFU      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.

 

Additional Information:

Bookshelf (R18 and earlier) : Value Pack Reference Guide - Chapter 3: Using the DB2 Command Processor

R18 and above: Docops platform:  https://docops.ca.com ( select product 'CA DB2 DB Management Common Functions' or enter docops.ca.com/db2mgmt to access directly).  Enter 'DB2 Command Processor' in the search box for the product space.