ADSM-L

Re: [ADSM-L] TSM database up 86.4% Utiltised

2009-11-09 04:27:34
Subject: Re: [ADSM-L] TSM database up 86.4% Utiltised
From: Grigori Solonovitch <G.Solonovitch AT BKME DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 9 Nov 2009 12:25:44 +0300
You can use:
1) run ESTIMATE DBREORGSTATS wait=yes
    If it gives quite big reduction for database reorganization:
    - unload DB to tape by dsmserv UNLOADDB;
    - re-format existing DB by dsmserv LOADFORMAT;
    - load DB back by dsmserv LOADDB;
    - audit reorganized DB by dsmserv AUDITDB fix=yes, if required;
2) or just increase DB size by:
    - format additional volume by dsmfmt -db;
    - add new volume by DEFINE DBVOLUME;
    - expand DB by EXTEND DB.

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.Solonovitch AT bkme 
DOT com

Please consider the environment before printing this Email


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Jimmy Furlong
Sent: Monday, November 09, 2009 12:08 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TSM database up 86.4% Utiltised

HI

My TSM database is as follows is getting full  what can I do to reduce the
size of the database there is a expire inventory job running everyday for 1
Hr.

Jimmy Furlong

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."

<Prev in Thread] Current Thread [Next in Thread>