Thank you Grigori,
I talked to IBM and they suggested the following and it seems to do
the trick. Thanks again for giving me suggestions though.
tsm: TSM>extend db 10000
ANR2248I Database assigned capacity has been extended.
Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976
Grigori
Solonovitch
<g.solonovi...@bk To
ME.COM> ADSM-L@VM.MARIST.EDU
Sent by: "ADSM: cc
Dist Stor
Manager" Subject
<ads...@vm.marist Re: [ADSM-L] Database Cache Hit
.EDU> Ratio
08/02/2009 04:14
AM
Please respond to
"ADSM: Dist Stor
Manager"
<ads...@vm.marist
.EDU>
I think your problem has no relationship with cash ratio:
" The database utilization is too high. 85.4 > 85 Consider a database space
trigger or increase the size of the database."
Just increase database size to have less than 85.
Cash ratio has to be as high as possible.
Grigori G. Solonovitch
Senior Technical Architect
Information Technology Bank of Kuwait and Middle East http://www.bkme.com
Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail:
g.solonovi...@bkme.com
Please consider the environment before printing this Email
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Avy Wong
Sent: Saturday, August 01, 2009 5:58 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Database Cache Hit Ratio
Hello,
In one of my TSM report, I see it says my database cash hit Ratio too
high. What is the normal ratio? What do I have to do to bring it down or
ways to resolve this?
Thank you for your help.
Issue Condition Recommendation
The database utilization is too high. 85.4 > 85 Consider a database space
trigger or increase the size of the database.
[-] Custom Summary
Item Results
Administrative Schedules Successful: 6
Administrative Schedules Errors: 0
Administrative Schedules Failed: 0
Administrative Schedules Missed: 0
Client Schedules Completed with No Errors: 55
Client Schedules Completed with Skipped Files: 35
Client Schedules Completed with Warnings: 0
Client Schedules Completed with Errors: 0
Client Schedules Failed: 0
Client Schedules Missed: 0
Scheduled Nodes with empty contact information: 87
Total GB Backed Up: 1285.66
Total GB Restored:
Total GB Archived: 160.81
Total GB Retrieved: 0.01
Last Database Backup: 2009-08-01 00:46
% Database Utilization: 85.4
Database Cache Hit Ratio: 99.1
% Maximum Recovery Log Utilization: 14.3
Disk Pool Total MB: 2007040.0
% Disk Pool Utilization: 16.1
Disk volumes offline: 0
Number of drives: 7
Number of tape mounts: 144
Total number of minutes tapes were mounted: 3855
Total number of volumes: 333
Number of scratch volumes: 57
Number of unavailable volumes: 0
Number of read-only volumes: 20
Volume Reclamation warning: 126
Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976
Please consider the environment before printing this Email.
"This email message and any attachments transmitted with it may contain
confidential and proprietary information, intended only for the named
recipient(s). If you have received this message in error, or if you are not
the named recipient(s), please delete this email after notifying the sender
immediately. BKME cannot guarantee the integrity of this communication and
accepts no liability for any damage caused by this email or its attachments
due to viruses, any other defects, interception or unauthorized
modification. The information, views, opinions and comments of this message
are those of the individual and not necessarily endorsed by BKME."
