IBM Support

How to Uncatalog dcs database when database name has more than 8 characters from DB2 DCS directory

How To


Summary

When a dcs database name length of more than 8 characters is cataloged, it cannot be uncataloged with the same database name due to a bug.
For example,

- catalog dcs database, which has database length of more than 8 characters
$ db2 catalog dcs database sampledata as dbalias

DB20000I The CATALOG DCS DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is
refreshed.

- uncatalog dcs database with the same database name, which was used to catalog dcs
$ db2 uncatalog dcs db sampledata

SQL1316N No entry was found in the Database Connection Services directory for
the specified local database name.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmTAAU","label":"Programming Interface-\u003ECLP"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

ibm17063545

Page Feedback