Datacom/DB IVPUPG02 receiving a -118-RNPNF
Article ID: 131207
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
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.
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.
Environment
z/os, CA Datacom/DB 15.1
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.
That could be an old site which did not have SQL definitions set up.
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
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
Feedback
Yes
No
Powered by
