IBM Support

Warehous and Derby database locations for Reporting and Monitoring

Question & Answer


Question

Where are the warehous and derby databases that used by Reporting and Monitoring located?

Cause

Data for the Tivoli Enterprise Portal Server workspaces is kept in the derby databases, data for historical reports generated in the Administration Center is kept in the warehous database.

Answer

Starting a DB2 command window and issuing 'db2 list db directory' will show the drive/directory used for the warehous and derby databases.

E:\IBM\db2\BIN>db2 list db directory

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias = TEPS
Database name = TEPS
Local database directory = E:
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = WAREHOUS
Database name = WAREHOUS
Local database directory = E:
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

The derby databases are found in the itm\TMAITM6\DERBY directory on the drive chosen for the installation (E:\) There will be one folder for each monitoring agent.

The warehous data will be stored in a directory structure under \db2\NODE0000.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM TEPS

Document Information

Modified date:
17 June 2018

UID

swg21668918