PRA#LOAD failing with PFL0004E INDDN must be six characters
search cancel

PRA#LOAD failing with PFL0004E INDDN must be six characters

book

Article ID: 278407

calendar_today

Updated On:

Products

Recovery Analyzer for DB2 for z/OS

Issue/Introduction

Recovery Analyzer for Db2 for z/OS (PRA) PRA#LOAD process failing with PFL0004E - INDDN value must be six characters or less for partitioned tablespaces.

Cause

Using out of date PRA#LOAD JCL which was using an 8 character INDDN DD VTOC0200 card for the VTOC table load.
This caused Fast Load for Db2 for z/OS (PFL) to fail with a PFL0004E error message.

PFL0060I - Fast Load parsing started, syntax follows:
    LOAD DATA INDDN VTOC0200
     MAXTASKS            1
    RESUME NO REPLACE LOG NO
    INTO TABLE PTI.URA_VTOC_1
    (DBNAME              POSITION(1:8)

.
.
.

PFL0004E - INDDN value must be six characters or less for partitioned
           tablespaces
PUT0019I - Elapsed Time: 00:00:00  -  24 JAN 2024 12:19:25

PFL0028I - Fast Load processing ended with return code 008

Resolution

Using out of date PRA#LOAD JCL which was using an 8 character INDDN DD card for the VTOC dataset.

This step calls PFL to load the data into the recovery database.
This 8 character DD name caused PFL to fail with a PFL0004E error message.

The reason for this is because table PTI.URA_VTOC_1 is now a partitioned tablespace and for partitioned tablespaces the length of the INDDN DD
card name must not be more than 6 characters. The extra two characters are used by PFL as increments.

Manually shorten this DD name for the current job to be completed both on the DD card and also in the PFL INDDN card:
Modify the //VTOC0200 DD entry to //VTOC02   DD in the  LOAD#PRA step JCL.
The //VTOC0200 DD entry should remain the same in the PRA#REPT step.

Another option is to regenerate the PRA#LOAD JCL from the Post Install dialog in order to use the current, correct JCL for future runs. 
In Post Install, select 3  Tasks, select SSID and then select task "PRA     Setup PRA#LOAD Batch JCL" and follow the prompts.