Re: SQL Select commands
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
Re: SQL Select commands
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 information for the select statement? i.e. substr , etc. Thank you. Andy Raibeck once put out an sql manual which was specific to the TSM database. I've lost my copy along the way so if you still have a link Andy that would be nice! But, whilst the TSM database is *not* DB2, it looks as if the SQL interface was modelled on DB2 sql. Bear in mind that you only have a select statement and that many of the more complicated subselection constructs are not supported, neither is UNION. but go to the DB2 infocenter http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm. db2.udb.doc/core/c0008880.htm then under Reference, SQL you will find explanations of functions and queries that may prove useful. I most recently used this when I wanted to find the function that returns the day-of-month protion of a timestamp because I wanted to run something different in my housekeeping script on the 9th of every month. The function is DAY. Regards Steve Steven Harris AIX and TSM Admin Brisbane Australia
Re: Select Statements
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 to your quest: http://www.1keydata.com/sql/sql.html Be aware that there are numerous dialects, versions, and subsetting of SQL, just to thwart standardization. Richard Sims
Re: Select Statements
Where do you get the syntax information for the select statement? i.e. substr , etc. Thank you. To ADSM-L@VM.MARIST.EDU cc From Sent by Leigh Reed <[EMAIL PROTECTED]> on 05/25/2006 05:04 AM "ADSM: Dist Stor Manager" Subject Re: [ADSM-L] Select Statements Please respond to "ADSM: Dist Stor Manager" 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 activity='FULL_DBBACKUP' I know this is not exactly what you are asking, but from the construct, you should be able alter it to do exactly the things you require. Also, the following query will return all the fields that are available for database backups in the summary table select * from summary where activity='FULL_DBBACKUP' HTH Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 24 May 2006 21:24 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger DISCLAIMER: This communication, along with any documents, files or attachments, is intended only for the use of the addressee and may contain legally privileged and confidential information. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of any information contained in or attached to this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately and destroy the original communication and its attachments without reading, printing or saving in any manner. This communication does not form any contractual obligation on behalf of the sender or, the sender's employer, or the employer's parent company, affiliates or subsidiaries.
AW: AW: TDP for Exchange - Management Class
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 for TSM are as follow: january 1.st : "Dear TSM, keep all "*\...\full" backups for that long time: %Sched_Exch_daily% " january 2nd.: "Dear TSM, keep all "*\...\full" backups for that long time: %Sched_Exch_daily% " ... january 31.st: "Dear TSM, keep all "*\...\full" backups for that long time: %Sched_Exch_monthly% " february 1.st : "Dear TSM, keep all "*\...\full" backups for that long time: %Sched_Exch_daily% " ... december 31.th: "Dear TSM, keep all "*\...\full" backups for that long time: %Sched_Exch_yearly% " january 1.st : "Dear TSM, keep all "*\...\full" backups for that long time: %Sched_Exch_daily% " ... What does TSM Server think about? I guess if TSM could speek, he´d tell: "Well, that guy is changing his own rules pretty often. I do not understand what he wants to achieve, but he is the boss, I´ll simply do what he tells me to do." :-))) So again, what are the MGMT Classes good for: INCLUDE "*\...\full"EXCH_mine INCLUDE "*\...\copy" EXCH_another INCLUDE "*\...\incremental" EXCH_another_one and what are they NOT good for: INCLUDE "*\...\full" EXCH_mine INCLUDE "*\...\full" EXCH_another INCLUDE "*\...\full" EXCH_another_one >> of many management class per node utility It´s wrong. It is not "per node", it is "per domain". Not utility but setting. Using it you can manage backup X-exchange servers while defining the rules (MGMT) once only. - hope it helps best regards Juraj Salak Von: Robert Ouzen Ouzen Gesendet: Sa 20.05.2006 10:56 An: ADSM-L@VM.MARIST.EDU Betreff: Re: AW: TDP for Exchange - Management Class Hi , Became a little bit confusing . So What the purpose of many management class per node utility If can't use for this purpose describe ? DomainNodename MgmInclude Schedule Opt File Domain_Exchange Exchange EXCH_daily INCLUDE "*\...\full" EXCH_daily Sched_Exch_daily dsm.opt (Default) Domain_Exchange Exchange EXCH_monthly INCLUDE "*\...\full" EXCH_monthly Sched_Exch_montlydsm_monthly.opt Domain_Exchange Exchange EXCH_yearlyINCLUDE "*\...\full" EXCH_yearly Sched_Exch_yearlydsm_yearly.opt If I understand correctly with this configuration every backup the files will be rebinding to the MGM in action !! And the only way to achieve it , is to create also 3 different nodenames . Correct So wasteful Regards Robert Ouzen -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Volker Maibaum Sent: Friday, May 19, 2006 11:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: AW: TDP for Exchange - Management Class Hi, thanks to all for the very helpful feedback! I didn't think of using the "copy backup" for monthly and yearly backups. That will make it a lot easier I guess that I will use the monthly policy for copy backups INCLUDE "*\...\copy" MONTHLY And use a seperate dsm.opt file (dsm.yearly.opt) to bind the yearly copy backups to the proper management class. C:\Programme\Tivoli\TSM\TDPExchange\start_full_yearly_backup.cmd pointing to dsm.yearly.opt regards, Volker > Am Freitag, den 19.05.2006, 11:34 +0200 schrieb Salak Juraj: > Hi Del! > > I might be wrong because I do not use TDP 4 Mails by myself, I am only > RTFM, but I´d think about simplified "solution 2 by Del": > > Background: > I think the only reason for having different requirements for monthly > an yearly backups is TSM storage space, if this were not a problem keeping > monthly backups for as long as yearly backups should be kept would be > preferrable. > > a) create only 1 NODENAME > b) define > INCLUDE "*\...\full" EXCH_STANDARD and maybe > INCLUDE "*\...\incr" EXCH_STANDARD and maybe > INCLUDE "*\...\diff" EXCH_STANDARD > appropriately to your regular (daily) backup requirements > > c) define > INCLUDE "*\...\copy" EXCH_MONTHLY_AND_YEARLY appropriate to maximal > combined requirements of your monthly AND yearly requirements AND > have EXCH_MONTHLY point to separate TSM storage pool (EXCH_VERYOLD) > > d) on regular basis (maybe yearly) check out all full tapes from EXCH_VERYOLD > storage pool from library. > Disadvantage: reclamation of backup storage pool issues because of > offsite tapes in primary storage pool, but this can be solved as well. > > You will end
Re: Select Statements
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 Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 25 May 2006 17:24 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select Statements 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 information. I have been looking for some sort of a "CURRENT TIMESTAMP" or something on those lines? Is there something I can add to get this info? Rog On May 25, 2006, at 3:19 AM, Sandeep Jain wrote: 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 ** Legal Disclaimer *** * ** "This email may contain confidential and privileged material for the sole use of the intended recipient. Any unauthorized review, use or distribution by others is strictly prohibited. If you have received the message in error, please advise the sender by reply email and delete the message. Thank you." *** * * -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: Thursday, May 25, 2006 1:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger This email has been scanned for any virus infection at the sending end.
SQL Select commands
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: VTL Cartridge Sizing
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 pm, Baughman, Ray wrote: > 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] > > >
VTL Cartridge Sizing
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: Select Statements
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@VM.MARIST.EDU Subject: Re: [ADSM-L] Select Statements 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 information. I have been looking for some sort of a "CURRENT TIMESTAMP" or something on those lines? Is there something I can add to get this info? Rog On May 25, 2006, at 3:19 AM, Sandeep Jain wrote: > 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 > > > > ** Legal Disclaimer > *** > * > ** > > "This email may contain confidential and privileged material for the > sole > use of the intended recipient. Any unauthorized review, use or > distribution > by others is strictly prohibited. If you have received the message in > error, > please advise the sender by reply email and delete the message. Thank > you." > > *** > * > * > > > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of > Roger Silva > Sent: Thursday, May 25, 2006 1:54 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Select Statements > > > Hi, > > I am new to the this list and need some advice. > > I am trying to create a select statement I can run to monitor the > Database > Backups of our TSM Servers. I know there are fields in the SUMMARY > portion > of the table that has Start Time, End Time, Activity, Entity, Volume > Name > and Successful fields, but I am not sure as to how to put all this > together > in a nice script that can email to a group of > individuals the status. I am not sure if I need to query several > parts of the database in order to compile this info or not. > > Can anyone help me out? > > Thank You, > Roger > > > > This email has been scanned for any virus infection at the sending end. >
Re: Select Statements
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 last or most current BACKUPFULL or BACKUPINCR information. I have been looking for some sort of a "CURRENT TIMESTAMP" or something on those lines? Is there something I can add to get this info? SELECT DATE_TIME AS "DATE TIME ",TYPE,BACKUP_SERIES,VOLUME_NAME FROM VOLHISTORY WHERE TYPE='BACKUPFULL' OR TYPE='BACKUPINCR' Richard Sims
Re: Select Statements
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 information. I have been looking for some sort of a "CURRENT TIMESTAMP" or something on those lines? Is there something I can add to get this info? Rog On May 25, 2006, at 3:19 AM, Sandeep Jain wrote: 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 ** Legal Disclaimer *** * ** "This email may contain confidential and privileged material for the sole use of the intended recipient. Any unauthorized review, use or distribution by others is strictly prohibited. If you have received the message in error, please advise the sender by reply email and delete the message. Thank you." *** * * -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: Thursday, May 25, 2006 1:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger This email has been scanned for any virus infection at the sending end.
Re: problems starting dsmcad from inittab on HP-UX
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 Subject: Re: problems starting dsmcad from inittab on HP-UX 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 to do anything in Bourne or Bash shell: use Perl whenever possible.) Another technique to test for a mounted file system: Inode number 2 is always the root directory of a file system...its top level. So, if you do 'ls -id /usr/local/bin' and that reports inode number 2, then it's mounted; else it's a much higher inode number, such that the thing is an unoccupied mount point directory. 2. oh yeah ... full paths rox ! 3. this is something new to me i must admit :-S "Assure that your options files are resulting in each dsmcad having its own, unique port number." ??? can you point me in right direction ? Well, you intend to start multiple CAD processes, right? They have to listen on a communications socket, which means a port number. They can't use the same port number - each has to be unique. Which is why you are presumably using multiple options files. Search on 'dsmcad' in the Unix client manual, and see IBM Technote 1079454. Richard Simshttp://people.bu.edu/rbs
Re: problems starting dsmcad from inittab on HP-UX
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 to do anything in Bourne or Bash shell: use Perl whenever possible.) Another technique to test for a mounted file system: Inode number 2 is always the root directory of a file system...its top level. So, if you do 'ls -id /usr/local/bin' and that reports inode number 2, then it's mounted; else it's a much higher inode number, such that the thing is an unoccupied mount point directory. 2. oh yeah ... full paths rox ! 3. this is something new to me i must admit :-S "Assure that your options files are resulting in each dsmcad having its own, unique port number." ??? can you point me in right direction ? Well, you intend to start multiple CAD processes, right? They have to listen on a communications socket, which means a port number. They can't use the same port number - each has to be unique. Which is why you are presumably using multiple options files. Search on 'dsmcad' in the Unix client manual, and see IBM Technote 1079454. Richard Simshttp://people.bu.edu/rbs
Re: Select Statements
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 ** Legal Disclaimer ** "This email may contain confidential and privileged material for the sole use of the intended recipient. Any unauthorized review, use or distribution by others is strictly prohibited. If you have received the message in error, please advise the sender by reply email and delete the message. Thank you." * -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: Thursday, May 25, 2006 1:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger This email has been scanned for any virus infection at the sending end.
Re: Select Statements
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 activity='FULL_DBBACKUP' I know this is not exactly what you are asking, but from the construct, you should be able alter it to do exactly the things you require. Also, the following query will return all the fields that are available for database backups in the summary table select * from summary where activity='FULL_DBBACKUP' HTH Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 24 May 2006 21:24 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger
Re: problems starting dsmcad from inittab on HP-UX
- 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 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 valuable information. - Put like "#!/bin/sh" at the top of your Bourne shell scripts. - Use full execution paths in your dsmcad.sh (a good practice, that keeps us all out of trouble :-). - Assure that your options files are resulting in each dsmcad having its own, unique port number. Richard Sims thanks Rich :-) questions : 1. how to make sure that /usr is mounted by the time to execute ? i'm 99% sure it is :-) 2. oh yeah ... full paths rox ! 3. this is something new to me i must admit :-S "Assure that your options files are resulting in each dsmcad having its own, unique port number." ??? can you point me in right direction ? thanks a LOT goran
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 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 valuable information. - Put like "#!/bin/sh" at the top of your Bourne shell scripts. - Use full execution paths in your dsmcad.sh (a good practice, that keeps us all out of trouble :-). - Assure that your options files are resulting in each dsmcad having its own, unique port number. Richard Sims
problems starting dsmcad from inittab on HP-UX
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/inittab mtsmcad::once:/usr/local/bin/dsmcad.sh > /dev/null 2>&1 # Starting multiple TSMCAD's # more /usr/local/bin/dsmcad.sh dsmcad -optfile=/opt/tivoli/tsm/client/ba/bin/dsm_dss_app.opt dsmcad -optfile=/opt/tivoli/tsm/client/ba/bin/dsm_bapp.opt # ls -l /usr/local/bin/dsmcad.sh -rwxr--r-- 1 root sys 121 May 4 11:51 /usr/local/bin/dsmcad.sh i assume the error is in 744 permission on dsmcad.sh part ... and you ? the server is 5.3.3.1 AIX , clients are 5.3 thanks goran