ADSM-L

Re: need q db f=d script help

2005-03-17 19:44:20
Subject: Re: need q db f=d script help
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 17 Mar 2005 19:42:47 -0500
It has been possible to reorganize the TSM db for some time, as
described in the Admin Guide manual.

The ESTimate DBREorgstats is new in TSM 5.3, as described in the TSM
5.3 Technical Guide redbook (*must* reading) and the Admin Guide and
Admin Ref manuals.

For server scripting, the best approach for preservation and
maintainability is to keep scripts in OS files, edit as needed, and
then replace. So, create file dbreorgstats.tsmscript, containing:

/*
------------------------------------------------------------------------
--- */
/*  Script Name:  dbreorgstats
        */
/*  Install via:  DEFine SCRipt dbreorgstats
File=dbreorgstats.tsmscript        */
/*  Invocation:   Run dbreorgstats
        */
/*
------------------------------------------------------------------------
--  */

/* Invoke the reorgstats process synchronously... */
ESTimate DBREorgstats Wait=Yes

/* Now that the above process is done, capture the output in a file
which I     */
/* will look at in the morning...
        */
Query DB Format=Detailed > /var/tmp/dbreorgstats.qdb

exit

Install and run as per the prolog.

   Richard Sims

On Mar 17, 2005, at 3:07 PM, Lawrence Clark wrote:

What is a "estimate dbreorgstats"?
Can the TSM DB be reorged?

Timothy.Hughes AT OIT.STATE.NJ DOT US 03/17/2005 3:02:29 PM >>>
Hello,


I am going to do a estimate dbreorgstats that will run on Sundays.

I would like to write a script or administrative command
to do the following  (q db f=d) a couple of hours after it
ends to get the results. Can anyone to tell me if the following
would be correct. I written very few scripts.


define script dbestimate reorgstats  "select q_db_f=d" ?


Thanks for any replies!

TSM 5.3.0.1
AIX 5.2  RS/6000

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