Pan/SQL maintenance errors

Document ID : KB000043975
Last Modified Date : 14/02/2018
Show Technical Document Details

 

Question:

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 XA1970CB SA10 - ABEND=S000 U0020 REASON=C5E2D8E7 228 
TIME=10.43.05 
U11-656 JOBNAME=XA1970CB,STPROC= ,STSTEP= ,AUTO SETUP PARMS 
- AGF142I- XA1970CB 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: 
DB2v10 with Pan/SQL 2.4
 

 

Answer: 

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