Database Analyzer for Db2 for z/OS (PDA) Extract execution is abending with the following:
USER COMPLETION CODE=0500
PSW AT TIME OF ERROR 078D1000 9BC5A24C ILC 2 INTC 0D
ACTIVE MODULE ADDRESS=00000000_1BC58000 OFFSET=0000224C
NAME=RALMBLD
DATA AT PSW 1BC5A246 - 00181610 0A0DD603 BA54BA54
IEF450I STEP01 - ABEND=S000 U0500 REASON=00000000
> PDA PROFILE Fatal Abend option was set to YES. Entering debugging mode. <
Extracting EXTRACT Procedure - xxx.yyyyyyyy
No objects defined for the Extract Procedure. If it was created outside of the supported user interface then unpredictable results may occur.
RC=4 Module: RALCBPB, Return code: 004, Reason code: 001
Execution stopped - fatal error encounter - Reason Code 105
The presence of the following message is related to the U0500 abend in RALMBLD:
> PDA PROFILE Fatal Abend option was set to YES. Entering debugging mode. <
The proven way to correct this would be to utilize the PDA panels to regenerate the control cards with the PDA Profile option set to Fatal Abend ==> NO.
Steps:
1. Go into Database Analyzer option P User Profile and verify that Fatal Abend ==> NO is specified.
2. Go into Database Analyzer option EP and use the (S)ubmit line command to generate the JCL for the Extract Procedure in question.