Troubleshooting
Problem
Within IBM Tivoli Monitoring for Tivoli Storage Manager, the size of the DERBY.dat files can sometimes keep increasing and it can be necessary to improve the configuration to reduce the size.
Environment
The DERBY database is used as a prefetch cache and does not store the historical data.
The Historical settings and pruning options are used for the DB2 WAREHOUS database.
Resolving The Problem
The following changes in the Agent config file could help in reducing the DERBY database size:
KSK_PREFETCH_RETENTION_DAYS = 2 (default)
The number of days that the prefetch data is stored in the prefetch cache (DERBY database).
----> Change it to 1
KSK_TAPEUSG_ON, Default Value = 1
Queries the Tivoli Storage Manager server for the tape usage data.
----> Set to 0 to turn off.
To do so:
1. Stop the Tivoli Storage Manager Agent instance(s):
A. Windows
-- Open up the Manage Tivoli Monitoring Services (TEMS)
-- Select each of the Monitoring Agent for Tivoli Storage Manager and stop the agent
B. AIX/Linux
-- itmcmd agent -o instance_name stop sk (command line)
-- Open up the CandleManage
Select each of the Monitoring Agent for Tivoli Storage Manager and Stop the agent
2. Modify the following environment file basing on the agent Operating System:
A. Windows: The environment file is named KSKENV_xxx, where xxx is the instance name of the monitoring agent that you created. The KSKENV_xxx file is located in the Tivoli Monitoring for Tivoli Storage Manager installation directory (for example: \IBM\ITM\TMAITM6).
B. AIX/Linux: The environment files are named sk_ini, and are located in the /opt/tivoli/tsm/reporting/itm/config/.ConfigData/ directory on both Linux and AIX® systems.
by changing the "KSK_PREFETCH_RETENTION_DAYS" parameter to 1 and the "KSK_TAPEUSG_ON" attribute group to 0 (disabling it):
KSK_PREFETCH_RETENTION_DAYS = 1
KSK_TAPEUSG_ON = 0
Save the file.
** CONSIDERATIONS: use any text editor to edit the environment file. ****
3. Restart the Tivoli Storage Manager Agent instance(s):
A. Windows
-- Open up the Manage Tivoli Monitoring Services (TEMS)
-- Select each of the Monitoring Agent for Tivoli Storage Manager and start the agent
B. AIX/Linux
-- itmcmd agent -o instance_name start sk (command line)
-- Open up the CandleManage (GUI)
Select each of the Monitoring Agent for Tivoli Storage Manager and start the agent
Another method to reduce the size of the DERBY DB consists of :
- stop the instance (as for above instructions)
- remove the
<install_dir>/itm/TMAITM6/DERBY/<instance name> files
- restart the instance (as for above instructions).
In this case, all the current contents of the prefetch cache will be lost.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21975447