Tuesday, September 17, 2013

(Updated) Quiz: What are these tables for?

Here is a quiz for all those administrators and DB2 fans that have insights into more than the core engine (that is the hint...:).

What are these two tables used for?

hloeser@rotach:~$ db2 "describe table MANAGED_DATABASE"

                           Data type                     Column
Column name                schema    Data type name      Length     Scale Nulls
-------------------------- --------- ------------------- ---------- ----- ------
NAME                       SYSIBM    VARCHAR                    255     0 No   

  1 record(s) selected.

hloeser@rotach:~$ db2 "describe table MANAGED_DATABASE_PROPS"

                           Data type                     Column
Column name                schema    Data type name      Length     Scale Nulls
-------------------------- --------- ------------------- ---------- ----- ------
NAME                       SYSIBM    VARCHAR                    255     0 No   
PROPERTY_KEY               SYSIBM    VARCHAR                    255     0 No   
PROPERTY_VALUE             SYSIBM    VARCHAR                    255     0 Yes  

  3 record(s) selected.


Any guesses or even some background information you want to share?

(Updated) Hint 2: It is related to Data Studio.