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 Synonym
TSM TEPS
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21668918