Document Type | Troubleshooting
Category | Administration
Applicable Product Version | 6FS07
Document Number | TADTS059
Issue
After the FS07_185695p patch, there are cases where DICT tables created as public synonyms of the dictionary view are not queried.
When performing the patch task after the patch, a public synonym is created as DICT from the SYSCAT.DICTIONARY view, but when querying this DICT, values like DBA%, ALL%, USER% do not appear.
select table_name from dict where table_name like 'DBA%' or table_name like 'ALL%' or table_name like 'USER%' 0 row selected.
Cause
This issue occurred because after recreating static views through the @scripts/catalogview.sql script, comments on those views were not added separately.
Solutions
You can resolve the issue by running the @script/sv_dict.sql script as the syscat account to reapply the necessary comments on the static views.