CA Datacom SQL ALTER DATABASE -20 or -118

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

Using SQL statement ALTER DATABASE database-name and getting errors, SQLCODEs -20 and -116. Using the ENTITY-NAME which has hyphen(-) character.

ALTER DATABASE DBA-SQLDB DATACOM 
DYNAMIC_EXTEND NO 
; 

___________SQL ERROR SUMMARY START___________ 

SQLCODE = -20, SQLSTATE=42601 
MESSAGE = BAD SYNTAX: <ALTER DATABASE DBA-S> 
WHEN THE ERROR OCCURRED, THE SYNTAX BELOW HAD BEEN PARSED: 
ALTER DATABASE DBA-S 
____________SQL ERROR SUMMARY END____________ 


ALTER DATABASE "SYSUSR.DBA-SQLDB" DATACOM 
DYNAMIC_EXTEND NO 
; 

___________SQL ERROR SUMMARY START___________ 

SQLCODE = -118, SQLSTATE=RNNTF 
MESSAGE = DATABASE SYSUSR.DBA-SQLDB NOT FOUND 
____________SQL ERROR SUMMARY END____________ 

Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

Cause

To perform any SQL processing on the DATABASE, ALTER DATABASE or CREATE AREA, it needs to have a SQLNAME defined. The entity ENTITY-NAME cannot be used.  A Datacom SQLNAME cannot have a hyphen(-) character. The valid character set includes A-Z, 0-9, $, #, @, and _ (underscore).

Resolution

Run DDUPDATE to add the SQLNAME to the DATABASE entity. You can make the change directly to the PROD status entity and no catalog of the database is required.
Sample DDPUPDATE input to make the change:

-UPD DATABASE,DBA-SQLDB(PROD) 
2901 N DBA_SQLDB
-END

 

Additional Information

See DocOps section 2900 to 2901 DATABASE Transactions