Add option to add comment on database and query the comment with SQL

Hello,
I can add comment on table, comment on column and comments on many more objects, but it seems difficult to add comment on database and impossible to query it.

Current work-around is to add comment on database at DBA level. I can SSH to Linux server where Db2 server is installed and execute:

db2 "CHANGE DATABASE mydb COMMENT WITH 'my comment' "

and then query the result with:

db2 "LIST DB DIRECTORY" | grep -A 5 mydb | grep "^ Comment"

My idea is to add database comment info on query level. Now on test system we have many databases and because database name is restricted to 8 characters names can not be descriptive. Now we have to maintain the list of database comments externally which is not ideal and prone to errors.

I imagine to add comment using query (this is not vital, because there is already DBA command "CHANGE DATABASE").

CONNECT TO mydb;
COMMENT ON DATABASE IS 'my comment';

Then query it like from some view:

SELECT REMARKS FROM SYSCAT.DATABASE;

or like from some variable:

VALUES(CURRENT_DB_COMMENT);

Additionally: Length of comment using "CHANGE DATABASE" is now restricted to 30 characters only. Make this e.g. 254 character like in table comment. Why? I would like to add additional info in my comment like: a) When comment was created, b) Who named the comment and c) Actual database comment etc. I would like to add comment like:

2026-01-14 - Roger Moore - This is the database comment for movie For Your Eyes Only

Needed By

Quarter

Post comment

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Please enter your email address

RELATED IDEAS

Add option to add comment on database and query the comment with SQL