Hi All,
FWIW, the results of an unload/reload operation over the holiday
weekend. Unload was performed to a file devclass, which was defining a
NFS mount point on a NetApp filer. Both systems have Gig-e interfaces.
The time to unload was 17 hours and 48 minutes. Formatting the recovery
log took about 9 minutes (10Gb), and the reload required about 19 1/2
hours. See output below:
TSM version: 5.1.6.4
Server: Sun 420R, Solaris 5.9.
Pre-unload:
database size: 66.2Gb
One database volume (on direct attached Sun T-3 storage). Volume is
118Gb, with assigned capacity of 80Gb, and 82.8% util. See output
below:
q db f=d
Available Space (MB): 118,792
Assigned Capacity (MB): 80,000
Maximum Extension (MB): 38,792
Maximum Reduction (MB): 13,760
Page Size (bytes): 4,096
Total Usable Pages: 20,480,000
Used Pages: 16,960,223
Pct Util: 82.8
Max. Pct Util: 82.8
Physical Volumes: 2
Buffer Pool Pages: 32,768
Total Buffer Requests: 1,748,487,518
Cache Hit Pct.: 99.33
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 0.17
Percentage Changed: 0.00
Last Complete Backup Date/Time: 02/13/04 11:28:18
Unload command output:
ANR4013I UNLOADDB: Dumped 279455129 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 279776429 database entries (cumulative).
ANR4402I UNLOADDB: Database update activity resumed
ANR1361I Output volume /tsm_db/bk03/dbbackup/76705370.DMP closed.
ANR4031I UNLOADDB: Copied 16327272 database pages.
ANR4033I UNLOADDB: Copied 22945 bit vectors.
ANR4034I UNLOADDB: Encountered 0 bad database pages.
ANR4036I UNLOADDB: Copied 429142151 database entries.
ANR4037I UNLOADDB: 38286 Megabytes copied.
ANR4026I UNLOADDB: Process 0, database dump has completed.
ANR4006I UNLOADDB: Volume 1 written by process is
/tsm_db/bk03/dbbackup/76705370.DMP.
real 17:48:31.61
user 34:22.24
sys 27:27.61
Recovery Log format output:
ANR0301I Recovery log format in progress; 10236 megabytes of 10236.
ANR0302I Recovery log formatting took 389006 milliseconds.
ANR0303I Format rate: 6736.2 pages/second.
ANR0304I Page service time: 0.1 ms.
ANR0305I Recovery log format complete.
ANR0306I Recovery log volume mount in progress.
ANR0353I Recovery log analysis pass in progress.
ANR0354I Recovery log redo pass in progress.
ANR0355I Recovery log undo pass in progress.
ANR0352I Transaction recovery complete.
ANR1004I Server formatting complete, database ready for loading.
real 8:50.71
user 29.57
sys 14.16
ANR4039I LOADDB: Loaded 429031901 database entries (cumulative).
ANR1365I Volume /tsm_db/bk03/dbbackup/76705370.dmp closed (end reached).
ANR4039I LOADDB: Loaded 429136297 database entries (cumulative).
ANR4032I LOADDB: Copied 16327272 database records.
ANR4033I LOADDB: Copied 22945 bit vectors.
ANR4035I LOADDB: Encountered 0 bad database records.
ANR4036I LOADDB: Copied 429142151 database entries.
ANR4037I LOADDB: 38286 Megabytes copied.
ANR4004I LOADDB: Database load process completed.
ANR4404I LOADDB: Loaded a consistent dump image - a database audit
(AUDITDB) is NOT required.
ANR2106I : Quiescing database update activity.
ANR2107I : Database update activity is now quiesced.
real 19:28:00.12
user 29:42:10.46
sys 1:41:31.02
Post - output: Database was reduced to 43.66 Gb. Keep in mind that
this was performed last year as well, so some of the db had already been
cleaned up and compacted.
q db f=d:
Available Space (MB): 118,780
Assigned Capacity (MB): 118,780
Maximum Extension (MB): 0
Maximum Reduction (MB): 74,692
Page Size (bytes): 4,096
Total Usable Pages: 30,407,680
Used Pages: 11,304,506
Pct Util: 37.2
Max. Pct Util: 37.2
Physical Volumes: 1
Buffer Pool Pages: 32,768
Total Buffer Requests: 243,646
Cache Hit Pct.: 92.95
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 44,159.04
Percentage Changed: 100.00
Last Complete Backup Date/Time:
If you have any questions or would like additional information, please
let me know.
Luke
|
