Rather than using a database trigger simply add more volumes to the database:
Tsm> Define dbvol e:\db1.dsm formatsize=20000 (this will add a 20 GB database volume on drive e:. The Unix file syntax will apply if you are on a Unix based TSM server) Then extend the database into that volume: Tsm> Extend db 20000 Both the define and extend are required to ensure that you actually use the space in your database. Typically, you want to have several db volumes for performance reasons so perhaps rather than one at 20GB you have two at 10GB... For the scratch tape issue: only one way around that problem: check in more scratch tapes: 1. Put a bunch of barcode labeled blank/scratch tapes into the library slots. 2. issue the following command: Tsm> label libvol libraryname search=yes overwrite=yes labelsource=barcode checkin=scratch This will label and check in scratch tapes. If you have already labeled scratch tapes, then put them into the library and: Tsm> checkin libvol libraryname search=yes status=scratch Or use the bulk port on your library (if you have one...) Tsm> checkin libvol libraryname search=bulk status=scratch Help checkin libvol and help label libvol will show you all the options of these commands. And it's probably time to take a TSM training course. Head to our website for details... Kelly J. Lipp VP Manufacturing & CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kerry Campbell Sent: Monday, January 08, 2007 12:09 PM To: [email protected] Subject: [ADSM-L] Database resizing and changing minimum scratch tape requirements Hello All, I appreciate any help you can provide for the commands to do the following: 1) Increase the database size due to the following error: The database utilization is too high. Condition (98.1 > 90) Recommendation: Consider a database space trigger or increase the size of the database. 2) Decreasing the minimum number of scratch tapes required, due to the following error: (Note, I just checked in five tapes as scratch on Friday, and the library is completely populated) There are not enough scratch volumes available. Condition (2 < 5) Recommendation: Check in some scratch tapes. Thanks, Kerry *** CONFIDENTIALITY NOTICE*** This message and any included attachments are from MedSynergies, Inc. and are intended only for the addressee. The contents in this message contain confidential information belonging to the sender that is legally protected. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or contact MedSynergies, Inc. at [EMAIL PROTECTED]
