rogwall
IS-IT--Management
- Dec 2, 2005
- 6
Hi,
My TSM DB stats are as follows:
tsm: TSM>q db
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
167,928 167,928 0 40,628 4,096 42,989,568 32,403,255 75.4 75.8
tsm: TSM>q log
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
10,232 10,232 0 10,228 4,096 2,618,880 263 0.0 17.8
On the BCP server I try to restore DB from FLAT files with the following command.
./dsmserv restore db todate=12/01/2005
it is taking 8 hrs to get the restore completed. Isn't that too slow for just 167 GB DB size?
There are total of 32,528,025 pages. Please comment and suggest.
Thank you,
My TSM DB stats are as follows:
tsm: TSM>q db
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
167,928 167,928 0 40,628 4,096 42,989,568 32,403,255 75.4 75.8
tsm: TSM>q log
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
10,232 10,232 0 10,228 4,096 2,618,880 263 0.0 17.8
On the BCP server I try to restore DB from FLAT files with the following command.
./dsmserv restore db todate=12/01/2005
it is taking 8 hrs to get the restore completed. Isn't that too slow for just 167 GB DB size?
There are total of 32,528,025 pages. Please comment and suggest.
Thank you,