IBM E16RMLL-I - Tivoli Storage Manager, Руководство по внедрению

Страница: 231 / 828

Chapter 5. Database and recovery log
201
Whenever the system detects that the database needs extra space, it triggers
the expansion, and writes messages to the activity log, as shown in the
query
actlog command in Example 5-9.
Example 5-9 Activity log messages from database expansion
tsm: LOCHNESS_SERVER1>
query actlog
...
02/16/06 13:44:27 ANR4414I Data Base Space expansion Is Needed, 4 Megabytes
needed.
02/16/06 13:44:27 ANR4412I Data Base and Recovery Log Space expansion
triggered.
02/16/06 13:44:28 ANR2240I Database volume C:\TSMDATA\DBP\D0200888.DBF defined.
5.5.2 Recovery log space trigger
To define a new space trigger for the recovery log to automatically create new
volumes (Tivoli Storage Manager generates the volume names), use the
define
spacetrigger log command as in Example 5-10. The expansionprefix parameter
specifies the directory where the volumes will be created.
Example 5-10 Defining and querying the recovery log spacetrigger
tsm: LOCHNESS_SERVER1>
define spacetrigger log fullpct=75 spaceexpansion=30
expansionprefix=d:\tsmdata\rlp\ maximumsize=4096
ANR2279I Recovery Log Space trigger defined and enabled.
tsm: LOCHNESS_SERVER1>
query spacetrigger log
LOG Full LOG Space LOG Expansion LOG Maximum Mirror Mirror
Percentage Expansion prefix Size (Mega- Prefix 1 Prefix 2
Percentage bytes)
---------- ---------- --------------- ----------- -------- --------
75 35 d:\tsmdata\rlp\ 4,096
You can specify a MAXIMUMSIZE from 9 MB through 13000 MB (13 GB) for the
recovery log. Set MAXIMUMSIZE to zero or omit the parameter to disable
checking for maximum size and allow the recovery log to grow to the system
limit. If you need to change the trigger definition later, use the
update spacetrigger
command.