Chapter 5. IBM Tivoli Storage Manager database 111
Location: j:\tsm\dbdir2
Total Size of File System (MB): 5,114.41
Space Used on File System (MB): 709.00
Free Space Available (MB): 4,405.41
Location: i:\tsm\dbdir1
Total Size of File System (MB): 5,114.41
Space Used on File System (MB): 708.98
Free Space Available (MB): 4,405.43
TSM:TIRAMISU>q log f=d
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY LOG f=d
Total Space(MB): 2,048
Used Space(MB): 2.80
Free Space(MB): 2,037.20
Active Log Directory: k:\tsm\activelog
Mirror Log Directory:
Archive Failover Log Directory:
Archive Log Directory: L:\tsm\archivelog
Summary
In this chapter we discussed an example of a database restore scenario. You should now
know how to prepare and complete a database restore. In addition, you now understand that
the V5 approach of adding and deleting databases volumes for Tivoli Storage Manager
database relocation no longer works. Relocating server volumes requires a database restore
and results in server downtime. This makes planning in the beginning more important.
Remaining tasks at this point include the configuration of a mirror for the active log or the
definition of an archive log failover directory. However, at this point you should be able to
complete those steps with the information from the administrator’s reference guide and the
manual.
If you are interested in a review of other restore scenarios, refer to 6.3, “Recovery of a V6.1
Tivoli Storage Manager server” on page 128, where we discuss a DRM restore to a new
hardware box.
5.4.3 Increase database space
In case your database grows, you can use the EXTEND DBSPACE command to add
additional space to an existing installation. This requires a restart of the server for the change
to become active. See Example 5-47.
Example 5-47 Extend dbspace command
TSM:TIRAMISU>extend dbspace m:\tsmdb\dbdir3
ANR2017I Administrator SERVER_CONSOLE issued command: EXTEND DBSPACE
m:\tsmdb\dbdir3
ANR2592I Directory(ies) 'm:\tsmdb\dbdir3' has been defined in the database space.
TSM:TIRAMISU>q dbspace
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY DBSPACE
Location: j:\tsm\dbdir2
Total Size of File System (MB): 5,114.41
112 Tivoli Storage Manager V6.1 Technical Guide
Space Used on File System (MB): 709.00
Free Space Available (MB): 4,405.41
Location: i:\tsm\dbdir1
Total Size of File System (MB): 5,114.41
Space Used on File System (MB): 708.98
Free Space Available (MB): 4,405.43
Location: m:\tsmdb\dbdir3
Total Size of File System (MB): 5,114.41
Space Used on File System (MB): 28.22
Free Space Available (MB): 5,086.19
TSM:TIRAMISU>q db f=d
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY DB f=d
Database Name: TSMDB1
Total Size of File System (MB): 15,343
Space Used by Database(MB): 454
Free Space Available (MB): 13,897
Page Size(Bytes):
Total Pages: 33,048
Usable Pages: 32,776
Used Pages: 23,744
Free Pages: 9,032
Buffer Pool Hit Ratio: 97.5
Total Buffer Requests: 53,178
Sort Overflows: 0
Lock Escalation: 0
Package Cache Hit Ratio: 66.3
Last Database Reorganization:
Full Device Class Name: FILE
Incrementals Since Last Full: 0
Last Complete Backup Date/Time: 06/12/2009 14:51:29
Example 5-47 on page 111 documents how we submitted the EXTEND DBSPACE command
and subsequent QUERY DBSPACE and QUERY DB commands to show the directory
assigned to the database. However, in Example 5-48, you can see that the directory is just
empty.
Example 5-48 Database directory stays empty
G:\Program Files\tivoli\tsm\server1>dir m:\tsmdb\dbdir3
Volume in drive M is tsmdb3
Volume Serial Number is 1C55-D0C5
Directory of m:\tsmdb\dbdir3
06/12/2009 08:49 PM <DIR> .
06/12/2009 08:49 PM <DIR> ..
0 File(s) 0 bytes
2 Dir(s) 5,333,258,240 bytes free
Get Tivoli Storage Manager V6.1 Technical Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
