DDPAL20001 REDUNDANT ALIAS FOR OCCURRENCE while adding demo database HUMAN-RESOURCE
search cancel

DDPAL20001 REDUNDANT ALIAS FOR OCCURRENCE while adding demo database HUMAN-RESOURCE

book

Article ID: 403763

calendar_today

Updated On:

Products

Datacom/DB

Issue/Introduction

Running a DDUPDATE job to define demo database HUMAN-RESOURCE ends with CC 8 .

The job log shows  

FUNCTION = ADD ALIAS
                   NAME       = HUMAN-SYSTEM

    **** ERROR ****  RETURN CODE = DDPAL20001  REDUNDANT ALIAS FOR OCCURRENCE

Cause

The  ALIAS named HUMAN-SYSTEM already exists in DATADICTIONARY for this same database.

Resolution

The job log shows that an update occurrence is done when adding database entity HUMAN-RESOURCE. That means that the database already exists in Datadictionary and so the ALIAS too.

The CC 8 is expected but is not a error in this case.

Additional Information

To see what database uses this ALIAS HUMAN-SYSTEM , run DDUTILTY using SYIN cards:  

-USR DATACOM-INSTALL,NEWUSER  

-RPT ALIAS,DATABASE,HUMAN-SYSTEM(PROD)

For documentation , see Alias Report