Zoltan,
Your cache hit percentage is way too low, but that is not going to impact on
your database backup
performance anyway.
I am not sure that you need to increase the number of bufferpool pages.
My database is larger and has a smaller bufferpool with a better cache hit %.
If you are happy that TSM is not busy doing numerous other processes or backups
while you
are performing your backup then the areas you need to be looking at are
processor and device constraints.
I f you have RMF, that will give you a good overview of what is slowing your
database backup,
in particular look at your disk activity rate and response times.
These should be broadly speaking similar for all your devices.
If you have one that is way worse than any of the others then you may want to
add a new volume and move the database off the bad volume.
If you do not have RMF you will need to have a look at the SMF records.
Available Space (MB): 20,940
Assigned Capacity (MB): 20,940
Maximum Extension (MB): 0
Maximum Reduction (MB): 3,204
Page Size (bytes): 4,096
Total Usable Pages: 5,360,640
Used Pages: 4,492,151
Pct Util: 83.8
Max. Pct Util: 84.4
Physical Volumes: 9
Buffer Pool Pages: 12,288
Total Buffer Requests: 614,410,512
Cache Hit Pct.: 98.63
Cache Wait Pct.: 0.00
Hope this helps,
John
Available Space (MB): 17,496
Assigned Capacity (MB): 17,496
Maximum Extension (MB): 0
Maximum Reduction (MB): 3,020
Page Size (bytes): 4,096
Total Usable Pages: 4,478,976
Used Pages: 3,700,667
Pct Util: 82.6
Max. Pct Util: 82.6
Physical Volumes: 8
Buffer Pool Pages: 20,480
Total Buffer Requests: 63,986,411
Cache Hit Pct.: 95.31
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 376.67
**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.
Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group.
**********************************************************************
|
