ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Datacom/DB IVPUPG02 receiving a -118-RNPNF

book

Article ID: 131207

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services Datacom/AD CA ecoMeter Server Component FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA On Demand Portal CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction

I've been trying to get a successful run of IVPUPG02.
Can you look at this error and give me some suggestions?

The run error is this:
___________SQL ERROR SUMMARY START___________
SQLCODE = -118, SQLSTATE=RNPNF MESSAGE = DSF 'NPNF' CASQLDEFAULT  SYSUSR
____________SQL ERROR SUMMARY END____________
and occurs right before the first COMMIT.
 

Cause

I have seen that error reported and due to CASQLDEFAULT Area missing from Data Dictionary. 

That could be an old site which did not have SQL definitions set up. 

Environment

z/os, CA Datacom/DB 15.1 

Resolution


In short the resolution would be: 
The CASQLDEFAULT database is missing from the Data Dictionary and so you need to execute the DDUPDATE utility using these 3 CAIMAC members as input in this order to 
Define the Database and area then catalog the database. Members can be seen in CABDSAMP library. 
- SQ1BAS defines the Database 
- SQ1DEF contains area and table definitions. 
- SQ1CPY copies the test version to PROD status.
Then Catalog. 

To double check the above diagnostic: 

1- Step1 - 
Check the MUF startup options, did you specify the SQL options: 
DATACOM SQL 
SQLDEFAULT 016,CASQLDEFAULT SQL DBID,ENT-NAME(SQL ONLY) 
SQLOPTION YES,017,DATACOM,120,NO SQL,TTM DBID,MODE,TIMEOUT,VIEW SECRTY 

Please run a CXX report for base 16 (the default SQL database): 
REPORT AREA=CXX,DBID=16 

2- Step2 - 
Please execute DDUTILTY with the following transactions to generate an indented report: 
-USR DATACOM-INSTALL,NEWUSER 
-DEF PATH,P1 
-DEF TRACE,DATABASE.AREA,$INTERNAL 
-DEF TRACE,AREA.TABLE,$INTERNAL 
-END 
-RPT START,DATABASE,CASQLDEFAULT(PROD),P1 
-RPT INDENT 
-END 

3- Step3- 
After the copy to prod SQ1CPY you will need to do a catalog of the CASQLDEFAULT 
database which is base 016. You can use these DDUPDATE cards to catalog the 
database: 
+UPD DATABASE,CASQLDEFAULT(PROD) 
1000 CATALOG 

That could be an old site which did not have SQL definitions set up. 

Additional Information

IVPUPG02 needs to be executed if you have SQL installed.
Otherwise, perhaps site needs to install SQL Databases from scratch: 

How to Install CA Datacom SQL as an Add On for 14.0 and 15.x: 
https://docops.ca.com/ca-datacom/15-1/en/search?q=SQLDD000&max=10&key=DATACOM151 

This is done via the SQLDD000x job from CABDSAMP: 
SQLDD000 
SQLDD001 
SQLDD002 
SQLDD003 
SQLDD004 
SQLDROP