Script help

2017-07-18 Thread rou...@univ.haifa.ac.il
Hi to all Need a little help with this script below , need to get the summary amount backup result for the node . Now I got a lot of entries from this script as: Protect: POSTBACK>run q_obj_0 IHPPROD_ORA Nodename Date (D/M/Y) Begin timeEnd time Elapsed

Re: Script help

2016-09-28 Thread Paul van Dongen
lto:ADSM-L@VM.MARIST.EDU] On Behalf Of Robert Ouzen Sent: 24 September 2016 07:55 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Script help Hi to all I have this script to receive information about restore and retrieve activity. SELECT cast((entity) as char(36)) as "Node Adsm2" , DATE

Script help

2016-09-24 Thread Robert Ouzen
Hi to all I have this script to receive information about restore and retrieve activity. SELECT cast((entity) as char(36)) as "Node Adsm2" , DATE(start_time) as DATE, cast((activity) as char(15)) as OPERATION, cast(float(SUM(bytes))/1024/1024/1024 as DEC(8,1)) as GB FROM summary WHERE

script help

2015-03-12 Thread Jeanne Bruno
Hello. Need some help. I'm trying to create a new script for myself and I want to get the PROCESS_NUM from the Processes table in a variable. def script Processes desc=get Process Number update script Processes 'declare process processes.PROCESS_NUM%type' update script Processes 'START:'

Re: script help

2015-03-12 Thread Ron Delaware
, _ email: ron.delaw...@us.ibm.com Storage Services Offerings From: Jeanne Bruno jbr...@cenhud.com To: ADSM-L@VM.MARIST.EDU Date: 03/12/15 14:36 Subject:[ADSM-L] script help Sent by:ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hello. Need some help. I'm trying

Re: need q db f=d script help

2005-03-18 Thread Richard Sims
A correction to that sample server script I posted last evening... Upon getting up this morning, it popped into my head that redirection is not allowed in server scripts (results in error ANR2020E). So, please remove the redirection. sorry about that, Richard Sims On Mar 17, 2005, at 7:42 PM,

Re: need q db f=d script help

2005-03-18 Thread Timothy Hughes
Thanks Richard, Lawrence, Like Richard said the ESTimate DBREorgstats is a new new command for TSM 5.3. You can use this command to estimate how much space can be recovered from the server database by performing a reorganization. Richard Sims wrote: A correction to that sample server script I

need q db f=d script help

2005-03-17 Thread Timothy Hughes
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

Re: need q db f=d script help

2005-03-17 Thread Lawrence Clark
What is a estimate dbreorgstats? Can the TSM DB be reorged? [EMAIL PROTECTED] 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

Re: need q db f=d script help

2005-03-17 Thread Richard Sims
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

script help needed please

2004-03-10 Thread Paulla E Brukner
Hi all, Does anyone have a script I could run on my TSM server (AIX) that will supply me with a list of files backed up per domain,node name and management class? I got close with this one, but can't get the list of files. select node_name,backup_date from backups where domain_name='PRODSQL'

Re: Script Help with Versions Data Exists

2003-07-07 Thread William F. Colwell
Ricky, The current tsm sql engine doesn't have enough columns to give you the answer you are looking for. I suggest this alternate procedure; 1. Do a 'q occ nodename', add up the files and space used values for the primary pools. 2. Do an export command with preview=yes - 'exp nodename

Script Help with Versions Data Exists

2003-07-04 Thread Cahill, Ricky
Does anyone have a script that would tell me how many extra versions (we currently have up to 14) exists on a node and how much space they are taking up?? The library is beggining to creak at the seems a little (STKL180) buying a new one isn't an option so I'm trying to find ways to cut back

Scheduling a Server Command Script Help

2001-08-13 Thread Alessio Moretti
Hi All, I'm trying to find a way to schedule a Server command script like this: generate backupset client1 full31 * devclass=dltclass1 scratch=yes retention=31 wait=yes generate backupset client2 full31 * devclass=dltclass1 scratch=yes retention=31 wait=yes generate backupset client3 full31 *

Re: Scheduling a Server Command Script Help

2001-08-13 Thread Richard Sims
I'm trying to find a way to schedule a Server command script like this: generate backupset client1 full31 * devclass=dltclass1 scratch=yes retention=31 wait=yes generate backupset client2 full31 * devclass=dltclass1 scratch=yes retention=31 wait=yes generate backupset client3 full31 *