Restart for stopped spaces after failed load

book

Article ID: 205988

calendar_today

Updated On:

Products

CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS CA Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Fast Load job fail due to insufficient sort space:

PFL0019E - RESTART Table does not match input
           UTILID T913P7LD Checksum 09883    

The UTILID was terminated and the subsequent job was rerun successfully.

How to avoid Stopped tablespace and Index after a failed Load Replace on Restarting the job after terminating the UTILID?  

Environment

Release : 20.0

Component : CA Fast Load for DB2 for z/OS

Resolution

There are two solutions for this condition; 

a. When the job fails don't term the Utility just rerun with Restart Phase.

b. Or change the restart to RW, or FORCE, we document:

STARTUP-ACCESS [ RESET |RW|RO|FORCE|STOP]

Here's a LINK to the doc:

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-fast-load-for-db2-for-z-os/20-0/reference/product-syntax/keyword-descriptions/startup-access-specify-the-startup-access-status.html