DDPVK30001 KEY RECORD NOT FOUND running DDUPDATE

Products

• Datacom

Issue/Introduction

A database structure has been deleted via an OBSOLETE function. When trying to re-create the database structure via BTG cards, the DDUPDATE job fails due to several

DDPVK30001 KEY RECORD NOT FOUND errors while trying to re-add the KEY . For example:

              *-----------------------------------------------------------------------------------*
              *  CODE ENTITY-TYPE,OCCURRENCE(VERS,PSWD,OVRD),STATUS,LOCK                          *
              *  -BTG KEY,DIR_DATABASE.KEY(T001)                                         ;  PROC  *
              *-----------------------------------------------------------------------------------*
                                                                                                   
                                                                                                   
   **** ERROR ****  RETURN CODE = DDPVK30001  KEY RECORD NOT FOUND                                  
                                              KEY                             00  

Environment

z/OS

DATACOM DATADICTIONARY 15.1 

Cause

The OBSOLETE failed to delete the KEY occurrences that get the DDPVK30001 error.

A query like the following one returns these KEY records (DIR_DATABASE.KEY in this case), even if the table (DIR_DATABASE in this case) no longer exists.

SELECT ENTITY_NAME, RECORD_NAME, ENTITY_VER  
FROM SYSADM.KEY                              
WHERE (STATUS > 'H') AND                    
(RECORD_NAME LIKE 'DIR_DATABASE%')                  
ORDER BY KEY.RECORD_NAME;  

Resolution

1. Run an ORPHANS report via DDUTILTY or DDUPDATE:
   

   -USR DATACOM-INSTALL,NEWUSER
   -RPT ORPHANS,SUPPORT              
   -END                            
   -RPT ORPHANS,AGGREGATE            
   -END     

2. If these KEY records are on the ORPHANS report, backup DataDictionary and DDD databases (usually DBID 2 and 15)
3. Run another ORPHANS report with the DELETE keyword to delete ALL the orphans on DataDictionary:
   

   -USR DATACOM-INSTALL,NEWUSER
   -RPT ORPHANS,SUPPORT,DELETE              
   -END                            
   -RPT ORPHANS,AGGREGATE,DELETE            
   -END    

Additional Information

Details about ORPHANS report can be found on the Listing/Deleting  Orphans section of the Datacom documentation.