PAN/SQL IVP Return Code 16

Document ID : KB000095464
Last Modified Date : 10/05/2018
Show Technical Document Details
Question:
Running CA Pan/SQL IVP job and getting the following errors:
   
000140 - 1 FILE SQLFILE SQL + 
000141 2 (SELECT NAME, CREATOR + 
000142 3 FROM SYSIBM.SYSTABLES + 
000143 4 INTO :NAME, :CREATOR) 
000144 EZTC0500E >>> $ host variable not defined 
000145 EZTC0500E >>> $ host variable not defined 
000146 5 SQL INCLUDE LOCATION * FROM SYSIBM.SYSTABLES 
000147 EZTC0441E >>> $ Intrnl Err 9034 ALLOC SQLDS 
000148 EZTC0441E >>> $ Intrnl Err 9903 
000149 EZTC0622E >>> $ SQL statement not processed due to previous errors 
 
What are some ways I can resolve this?
Answer:
The supplied JCL was not customized fully for the libraries:
//* THE DB2 LOADLIB //* DD DSN=your.db2.SDSNLOAD,DISP=SHR
Please review your JCL and change any lower case to your appropriate libraries. 
 
If the JCL has been successfully modified to reflect your libraries, then please rebind the package/plan.