Get messages after running DDUPDATE 1000 APPLYCXX to add a KEY dynamically. Where are they documented?
search cancel

Get messages after running DDUPDATE 1000 APPLYCXX to add a KEY dynamically. Where are they documented?

book

Article ID: 14231

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 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 ran DDUPDATE 1000 APPLYCXX to add a KEY dynamically.

I'm getting messages and like to know more about their meaning.



Can you tell me more about the process and what messages to expect?

Environment

z/OS CA Datacom 15.x

Resolution

When you run that 1000 APPLYCXX to add/delete a key , a process ***DBKEY starts in the MUF and when that process completes the new key gets a status LD (see CXX report) and can be used by the applications. 

 

When that process starts , you see message DB02814I with STARTED in the text .

From your MUF : DB02814I - DYNAMIC INDEX ADD STARTED FOR KEY EQTK7 BASE 60 TBL EQT.

 

When the process ends , you get this message with ENDED instead of STARTED .

 

Other messages that are possible are :

 

 

DB02815I

DYNAMIC INDEX fff aaa

Reason:

The asynchronous index work that is associated with an APPLYCXX add or delete request was interrupted. The fff is either ADD or DELETE. If aaa is ABORTED BY EOJ, it was interrupted by a MUF EOJ request. If aaa is REQUEST ABORTED, it was interrupted by a REQABORT request.

Action:

None. The index work that is required to process the APPLYCXX delete request is rescheduled when the first URT is opened against the affected table.

 

DB02816E

DYNAMIC INDEX fff UNEXPECTED RETURN CODE cc(iii)

Reason:

The message details database errors that were encountered during the asynchronous index work that is associated with an APPLYCXX delete or add request. The fff is the function, either ADD or DELETE. The cc is the return code, and iii is the internal return code.

Action:

Determine what caused the return code and correct it. The required index work to process the APPLYCXX delete or add request is rescheduled when the first URT is opened against the affected table.

 

 

Note that when you reqabort the process , cancel the MUF or just EOJ , this ***DBKEY starts again when this base gets opened again . 

Additional Information

See the online documentation on dynamically adding/deleting keys here