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 ? /etc/i

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: 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 /usr/local/bin is mounte

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 act

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 t

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: Sent: Thursday, May 25, 2006 1:07 PM Su

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 informat

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 las

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: ADSM-L@V

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 Manage

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 instructio

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 g

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