Pan/SQL maintenance errors

Products

• PanAudit Plus
• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

We've applied the latest Pan/SQL maintenance recently. 

 

After we apply the maintenance, we ran the Pan/SQL maintenance jobs of;

IIJ3STGE1 

CB2ACMDL 

SQLINST4 

 

Now we are getting the following abend 

 

+EZAC0000 CA-EASYTRIEVE system error ESQX has been encountered 

+EZAC0001 Program execution cancelled 

IEF450I xxxxxxx SA10 - ABEND=S000 U0020 REASON=C5E2D8E7 228 

TIME=10.43.05 

U11-656 JOBNAME=xxxxxxx,STPROC= ,STSTEP= ,AUTO SETUP PARMS 

- AGF142I- xxxxxxx SA10 OF1700C U0020 237950 0 0 0.505 0.016 2.10 

 

Easytrieve messages: 

 

EZABX000 An error has occurred in program OF1700C. 

EZABX001 The following messages provide diagnostic information. Please 

contact the person or persons responsible for maintaining this 

application. They may want to see this information or they may 

want it printed. 

###################### Diagnostic Information ###################### 

EZABX003 The error occurred at 10.40 on 06/08/16. 

EZSQL002 SQL program DQSPSXC ended with return code 12. 

EZSQL003 SQL error code 3102, DQSMQLD - Module DSNALI not found in load library. 

EZSQL003 SQL error code 7031, Load failed for DB2 System Call Attach module. 

EZABX024 Program ended in . Check report procedures. Check flow table. 

EZABX020 The program referred to the following files:

 

  

 

 

 

 

 

 

 

 

Environment

Release: PSQLOR00200-2.4-Pan/SQL-for Oracle
Component:

DB2v10 with Pan/SQL 2.4

Resolution

Issue was a double STEPLIB in the JCL. The DB2 Load Libraries were not being used!