1. The UDB catsync process does not load all aliases from the input file and the base table for a table alias.
The job writes warning messages like below to SYSPRINT:
WARNING ! THE TABLE/VIEW COLUMN TABLE1.COLUMN WAS NOT FOUND IN
THE REPOSITORY. THE VIEW COLUMN VTABLE2.COLUMN COULD NOT BE INSERTED
2. In addition, Out of bound array exception occurs when processing a table view.
The job ends with the below error message:
ONCODE=8094 Protection exception From entry point WRITE_TO_FILE...
SYMPTOMS:
All aliases are not present in the Repository after catsync and
in the case of out of bounds array, the job ends with 'Protection
exception' error.
IMPACT:
Inaccurate representation of metadata in the repository.
Repository Exchange for UDB r7.2
LU16037 - UDB CATSYNC - TABLE ALIAS AND OUT OF BOUND ARRAY ISSUES