Performance Result of an export/import process

2006-05-25 Thread Bernaldo de Quiros, Iban 1
Did anyone have a performance result for an export/import process of a node using: 1- sequential media 2- server to server comm. Any recommendations ¿? TSM 5.2.2.0 running on solaris 8 to TSM 5.2.6.3 running on solaris 9 Regards, Ibán Bernaldo de Quirós Márquez Technical Specialist cell: +

problems starting dsmcad from inittab on HP-UX

2006-05-25 Thread goc
hi all, i was wondering if someone has experience with this kinda strange behaviour or is it just me and a human error :-) i'm trying to start multiple dsmcad's from inittab with following stuff, but apparently it does not start at all when server boots, is this some HP-UX stuff or TSM's ?

Re: problems starting dsmcad from inittab on HP-UX

2006-05-25 Thread Richard Sims
Goran - Some ideas... - Assure that the position of your mtsmcad entry in inittab is such that /usr/local/bin is mounted by the time it goes to execute. - Have your inittab send the output to a file rather than /dev/null, so you have some diagnostics to look at: don't throw away potentially

Re: problems starting dsmcad from inittab on HP-UX

2006-05-25 Thread goc
- Original Message - From: Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Thursday, May 25, 2006 11:44 AM Subject: Re: problems starting dsmcad from inittab on HP-UX Goran - Some ideas... - Assure that the position of your mtsmcad entry in inittab is such that

Re: Select Statements

2006-05-25 Thread Leigh Reed
Roger I recently had to query the summary table for info regarding the database backups. My requirement was to report how long the database backups were taking. I found that the following select query sufficed. select substr(char(end_time-start_time),3,8) as backup_duration from summary where

Re: Select Statements

2006-05-25 Thread Sandeep Jain
Hi, You can use below select statement to view the full db backup details. SELECT DATE_TIME AS DATE TIME,TYPE,BACKUP_SERIES,VOLUME_NAME FROM VOLHISTORY WHERE TYPE='BACKUPFULL' REPLACE 'BACKUPFULL' WITH 'BACKUPINCR' IF YOU TAKE INCREMENTAL BACKUP With Best Regards, Sandeep Jain

Re: problems starting dsmcad from inittab on HP-UX

2006-05-25 Thread Richard Sims
On May 25, 2006, at 5:58 AM, goc wrote: thanks Rich :-) questions : 1. how to make sure that /usr is mounted by the time to execute ? i'm 99% sure it is :-) On a Unix system, you can usually have a shell script do like: mount | grep /usr/local/bin and test the return code. (It's awkward

Re: problems starting dsmcad from inittab on HP-UX

2006-05-25 Thread goc
thanks again ... as for client comm port are you reffering at tcpclientport directive ? if yes ... then in each *.opt file if have to specify tcpclientport $PORT_NUMBER right ? - Original Message - From: Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Thursday, May 25,

Re: Select Statements

2006-05-25 Thread Roger Silva
Thank You Sandeep, I made changes since some of the fields didn't work for me, but this is what I have: SELECT DATE_TIME AS DATE,TYPE,VOLUME_NAME,LOCATION FROM VOLHISTORY WHERE TYPE='BACKUPFULL' But, what I would like to do is pull just the last or most current BACKUPFULL or BACKUPINCR

Re: Select Statements

2006-05-25 Thread Richard Sims
On May 25, 2006, at 12:24 PM, Roger Silva wrote: Thank You Sandeep, I made changes since some of the fields didn't work for me, but this is what I have: SELECT DATE_TIME AS DATE,TYPE,VOLUME_NAME,LOCATION FROM VOLHISTORY WHERE TYPE='BACKUPFULL' But, what I would like to do is pull just the

Re: Select Statements

2006-05-25 Thread Leigh Reed
select * from volhistory where type='BACKUPFULL' and date_time(current_timestamp-1 day) You can use 'hour' instead of 'day' to get further granularity -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 25 May 2006 17:24 To:

VTL Cartridge Sizing

2006-05-25 Thread Baughman, Ray
We will be installing a VTL in the next Month, and can specify any size of Cartridge we want. Does anyone have any recommendations on sizing? Ray Baughman TSM Engineering Systems Administrator National Machinery LLC Phone 419-443-2257 Fax 419-443-2376 Email [EMAIL PROTECTED]

Re: VTL Cartridge Sizing

2006-05-25 Thread Dearman, Richard
I would suggest don't worry to much about cartridge size more on the number of cartridges. I have 100+ clients backup directly to the vtl daily so I created a larger number of tape devices and 200 100GB cartridges. I migrated the data daily after the nightly backups. On Thu, May 25, 2006 12:14

SQL Select commands

2006-05-25 Thread Luc Beaudoin
Hi all I'm not that good with SQL commands is there any documentation available ... any idea ... thanks Luc Beaudoin Administrateur Réseau / Network Administrator Hopital General Juif S.M.B.D. Tel: (514) 340-8222 ext:8254

Re: Select Statements

2006-05-25 Thread Roger Silva
Thanks Leigh, This worked great ! R On May 25, 2006, at 9:46 AM, Leigh Reed wrote: select * from volhistory where type='BACKUPFULL' and date_time(current_timestamp-1 day) You can use 'hour' instead of 'day' to get further granularity -Original Message- From: ADSM: Dist Stor

AW: AW: TDP for Exchange - Management Class

2006-05-25 Thread Salak Juraj
Hi! . So What the purpose of many management class per node utility If can't .. The purpose is to assign different backup/reposit attributes to respective objects, but not to change that attributes ferocious in time. What you actually designed in the table below means your instruction

Re: Select Statements

2006-05-25 Thread Laura Mastandrea
Where do you get the syntax information for the select statement? i.e. substr , etc. Thank you. To ADSM-L@VM.MARIST.EDU cc

Re: Select Statements

2006-05-25 Thread Richard Sims
On May 25, 2006, at 4:08 PM, Laura Mastandrea wrote: Where do you get the syntax information for the select statement? i.e. substr , etc. I have a selection of SQL references near the bottom of http://people.bu.edu/rbs/ADSM.QuickFacts (seek SQL:) where the following URL is most appropriate

Re: SQL Select commands

2006-05-25 Thread Steven Harris
Luc said Hi all I'm not that good with SQL commands is there any documentation available ... any idea ... thanks Luc Beaudoin Administrateur Réseau / Network Administrator Hopital General Juif S.M.B.D. Tel: (514) 340-8222 ext:8254 Laura said Where do you get the syntax

Re: SQL Select commands

2006-05-25 Thread Chris Pasztor
Hello, SQL reference is in a redbook 5.1 technical guide  see http://www.redbooks.ibm.com/abstracts/SG246554.html?Open ,I do not think I have seen a newer one.. Chris