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.

2 comments:

notalldb2 said...

Wild guess, data studio newer versions has capability to create and manage jobs, so it would create these tables as part of job management.

Henrik Loeser said...

Well, it goes into the right direction. Data Studio is correct and that the tables are used for managing something... :)

Henrik

LinkWithin

Related Posts with Thumbnails