Plan Analyzer Post Install job ssid0775 LOADRULS step fails with RC=8
search cancel

Plan Analyzer Post Install job ssid0775 LOADRULS step fails with RC=8

book

Article ID: 95425

calendar_today

Updated On:

Products

Plan Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The LOADRULS step in the Plan Analyzer for Db2 for z/OS (PPA) Post Install ssid0775 job fails with RC=08.

Cause

Dataset contention for the SYSDISC, SYSERR, SYSMAP, allocations occurred between the two table loads due to the same
dataset names being used for both tables.

Resolution

This specific error condition caused by dataset contention on the LOADRULS step can be corrected by changing the dataset names
associated with the file allocations for SYSDISC, SYSERR and SYSMAP to be unique between the two LOAD table sections.

Example:
.ALLOC FI(SYSDISC) DA('hlq.PPA.SYSDISC')+ 
 MOD CATALOG UNIT(SYSDA) SPACE(10,10) CYL RLSE 
.ALLOC FI(SYSERR) DA('hlq.PPA.SYSERR')+ 
MOD CATALOG UNIT(SYSDA) SPACE(10,10) CYL RLSE 
.ALLOC FI(SYSMAP) DA('hlq.PPA.SYSMAP')+ 
MOD CATALOG UNIT(SYSDA) SPACE(10,10) CYL RLSE 
...

LOAD DATA.....INTO TABLE PTI.PTPA_ES_RU2RE_1200
********************************************************************* 
.ALLOC FI(SYSDISC) DA('hlq.PPA2.SYSDISC')+ 
MOD CATALOG UNIT(SYSDA) SPACE(10,10) CYL RLSE 
.ALLOC FI(SYSERR) DA('hlq.PPA2.SYSERR')+ 
MOD CATALOG UNIT(SYSDA) SPACE(10,10) CYL RLSE 
.ALLOC FI(SYSMAP) DA('hlq.PPA2.SYSMAP')+
MOD CATALOG UNIT(SYSDA) SPACE(10,10) CYL RLSE 
....
LOAD DATA ...INTO TABLE PTI.PTPA_ES_RULES_1200