CA Datacom/AD 14 0 sites should also apply PTF RO72082 if Datacom SQL 14 0 PTFs RO69039 and RO70910 have been applied. These are needed if SQL DROP Table feature to be used.
Article ID: 17431
Updated On:
Products
CA Compress Data Compression for MVS
CA Compress Data Compression for Fujitsu
CA Datacom - DB
CA Datacom
CA Datacom - AD
CA Datacom - Server
CA Disk Backup and Restore - MVS
CA DISK BACKUP AND RESTORE- ADD-ON OPTIO
CA DISK BACKUP AND RESTORE
CA Ideal
CA CIS
CA Common Services for z/OS
CA 90s Services
CA Database Management Solutions for DB2 for z/OS
CA Common Product Services Component
CA Common Services
CA ecoMeter Server Component FOC
CA Easytrieve Report Generator for Common Services
CA Infocai Maintenance
CA IPC
Unicenter CA-JCLCheck Common Component
CA Mainframe VM Product Manager
CA Chorus Software Manager
CA On Demand Portal
CA Service Desk Manager - Unified Self Service
CA PAM Client for Linux for zSeries
CA Mainframe Connector for Linux on System z
CA Graphical Management Interface
CA Web Administrator for Top Secret
CA CA- Xpertware
CA Datacom/AD
Issue/Introduction
Description:
After CA Datacom SQL 14.0 PTFs RO69039 (CARS1406) and RO70910 (CARS1407) were applied, a Datacom/AD 14.0 site was unable to use SQL to DROP a Table.
In the case encountered, an ENF 14.1 customer received the following errors when attempting to run job CASQL04 in order to DROP tables as instructed by the ++HOLD action in ENF 14.1 PTF RO54507:
AUTHID=CAS9ENFS
INPUT STATEMENT:
DROP TABLE CAS9ENFS.CICSTERM;
___________SQL ERROR SUMMARY START___________
SQLCODE = -999, SQLSTATE=56S19
MESSAGE = INTERNAL ERROR (DDServ LINE 0341): STMT NOT ALLOWED IN AD MUF
____________SQL ERROR SUMMARY END____________
Solution:
Apply PTF RO72082 to re-allow the use of the DROP function then rerun the failing DROP job.
Environment
Release: DATABB00200-14-Datacom/AD
Component:
Component:
Feedback
Yes
No
Powered by
