dsmserv restore db todate... taking too long 1

[rogwall]

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,

 

[Xenocide911]

That's huge, you should start a second server instance after about 110 GB database, and documentation actually says 40 GB. I could see 8 hours.