Hi,
Thanks.
See, the log file gives neatly the backup details for each schedule along
with exceptions that occurred as given at end.  How do I get in one query
all this information along with Exceptions if any for a schdule at a given
time?  Could you please provide me with a query that will work even if the
ACTLOG gets bigger (as I have seen when ACTLOG becomes bigger in size the
query does not give full results as it breaks in the middle with the message
'communication session ended. reconnect to get the results'.)
Thanks
-murali
11/08/2002 14:02:34 Total number of objects inspected:    9,996
11/08/2002 14:02:34 Total number of objects backed up:       74
11/08/2002 14:02:34 Total number of objects updated:          0
11/08/2002 14:02:34 Total number of objects rebound:          0
11/08/2002 14:02:34 Total number of objects deleted:          0
11/08/2002 14:02:34 Total number of objects expired:        372
11/08/2002 14:02:34 Total number of objects failed:          18
11/08/2002 14:02:34 Total number of bytes transferred:     9.61 MB
11/08/2002 14:02:34 Data transfer time:                    1.58 sec
11/08/2002 14:02:34 Network data transfer rate:        6,225.75 KB/sec
11/08/2002 14:02:34 Aggregate data transfer rate:        289.51 KB/sec
11/08/2002 14:02:34 Objects compressed by:                    0%
11/08/2002 14:02:34 Elapsed processing time:           00:00:34

From: "Damron, Nancy E." <Nancy.Damron AT PSHS DOT NET>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: kindly help - dsmsched.log: is it only fro local client  inTS
M?
Date: Tue, 19 Nov 2002 13:49:33 -0800

Hi
The act log is the only centralize location that will give you information
on all your backups. The dsmsched.log is just that...a log of the schedule
that ran on that box.

-----Original Message-----
From: murali ramaswamy [mailto:muralirama29 AT HOTMAIL DOT COM]
Sent: Tuesday, November 19, 2002 1:42 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: kindly help - dsmsched.log: is it only fro local client inTSM?


Hi,
  Can you please tell if the dsmsched.log in Tivoli Storage Manager the
location of which is configured through the TSM client GUI is only for
displaying log information for the local client ( the client installed in
the same box) only?     I have on my machine(Windows2000) installed both
TSM
server and client and there is another machine in network mc-A
which is also Windows2000, on which I installed TSM client.  In the
dsmsched.log, after scheduling backups on my machine and mc-A, I see only
information about my machine backups and not about mc-A.  But on querying
ACTLOG I could see information of backup about mc-A also.  So is this log
only for client which is installed on my box and is there not any
centralized server log that could give all backups from all other clients
for this TSM server?
Thanks
-murali




>From: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
>Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Re: Please help - ANS1311E Server out of data storage space
inTSM
>Date: Tue, 19 Nov 2002 15:54:08 -0500
>
>For the 4.2 Web Admin drill down with:
>
>Object view
>    Server Storage
>      Disk Storage Pools
>
>Then select your disk pool, then Update it and set
>"Cache Migrated Files" to Yes.
>
>From command line it is the Update STG command.
>
>David Longo
>
> >>> muralirama29 AT HOTMAIL DOT COM 11/19/02 02:36PM >>>
>Hi,
>   How do I do the disk caching etc through Web Admin GUI page on the
>server?
>   I did not set anything manually (I dont know where to do that).  Is
>it
>disabled by default?  How do I move data of volumes through GUI or any
>tool?
>Thanks
>-murali
>
>
>
>
>
>
> >From: J D Gable <josh.gable AT EDS DOT COM>
> >Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> >To: ADSM-L AT VM.MARIST DOT EDU
> >Subject: Re: Please help - ANS1311E Server out of data storage space
>in
> >TSM
> >Date: Tue, 19 Nov 2002 13:25:11 -0600
> >
> >Do you have disk caching enabled?  If so, disable it, move the data
>off of
> >your
> >disk volumes, and try it again.  I have an open PMR about this very
>issue.
> >We
> >are running TSM 5.1.1.6 on an AIX 4.3.3 server.
> >
> >Josh
> >
> >murali ramaswamy wrote:
> >
> > > Hi,
> > > I get the following error message
> > > ANS1311E Server out of data storage space in  TSM (Tivoli storage
> >manager)
> > > 5.1 in dsmsched.log and the backup fails though I have more than
>4GB
> >space
> > > in the only drive C: on my windows 2000 machine.  Please help on
>how
> >this
> > > error message could be avoided and fixed.
> > > Thanks
> > > -murali
> > >
> > > >From: Andrew Raibeck <storman AT US.IBM DOT COM>
> > > >Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > > >To: ADSM-L AT VM.MARIST DOT EDU
> > > >Subject: Re: HELP ON wzrdhlpr.exe command lIn TSM (Tivoli storage
> >manager)
> > > >5.1?
> > > >Date: Sun, 3 Nov 2002 01:01:03 -0700
> > > >
> > > >1) My primary advice is that you follow the advice I gave you
>before,
> >and
> > > >work on getting the ODBC driver set up correctly. I pointed you
>to
> > > >detailed diagnostic information in the README file, and offered to
>have
> > > >you send me the results so that I can get a better understanding
>of the
> > > >problem. Once the ODBC driver is set up correctly, it will work as
>I
> >have
> > > >already shown you.
> > > >
> > > >2) While it may work okay, I do not recommend using the
>wzrdhlpr.exe
> >file
> > > >that ships with the TSM server, as it is not intended for end-user
>use.
> > > >Instead, you should be using the administrative command line
>interface
> > > >that ships with the TSM client, dsmadmc.exe.
> > > >
> > > >3) To read the file "murali", get rid of the imports for
> > > >java.io.InputStream and InputStreamReader, and get rid of the "is"
>and
> > > >"reader" variables (and all lines refering to those variables).
> >Instead,
> > > >use FileReader. You can also get rid of the declaration for
>"process".
> > > >Also, uncomment the code at the end of the "try" block.
> > > >
> > > >4) exec() launches the command in a separate process but does not
>wait
> >for
> > > >that process to end. Therefore you should use the process's
>waitFor()
> > > >method to make the parent process wait for the child process to
>finish
> > > >before processing continues. Note that waitFor() throws
> > > >InterruptedException. Also, make sure to use the "/c" option
>after
> >"cmd".
> > > >
> > > >    import java.io.FileReader;
> > > >    ...
> > > >
> > > >    try {
> > > >       ...
> > > >       String command = "cmd /c dsmadmc -id=raibeck
>-password=bab5com
> > > >select * from sessions > murali";
> > > >       Runtime.getRuntime().exec(command).waitFor();
> > > >       br = new BufferedReader(new FileReader("murali"));
> > > >       System.out.println("br = " + br);
> > > >       String line;
> > > >       while ((line = br.readLine())!=null) {
> > > >          System.out.println("line:"+line);
> > > >       }
> > > >    }
> > > >    catch(InterruptedException intex)
> > > >    {
> > > >       System.out.println(intex.getMessage());
> > > >    }
> > > >    ...
> > > >
> > > >5) You may find it desirable to add the -commadelimited or
> >-tabdelimited
> > > >option to dsmadmc, which will help in parsing the resulting
>output. See
> > > >the TSM Administrator's Reference, Chapter 3, for more
>information
> >about
> > > >the command line interface.
> > > >
> > > >Regards,
> > > >
> > > >Andy
> > > >
> > > >Andy Raibeck
> > > >IBM Software Group
> > > >Tivoli Storage Manager Client Development
> > > >Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
> > > >Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)
> > > >
> > > >The only dumb question is the one that goes unasked.
> > > >The command line is your friend.
> > > >"Good enough" is the enemy of excellence.
> > > >
> > > >
> > > >
> > > >
> > > >murali ramaswamy <muralirama29 AT HOTMAIL DOT COM>
> > > >Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > > >11/01/2002 09:14
> > > >Please respond to "ADSM: Dist Stor Manager"
> > > >
> > > >
> > > >         To:     ADSM-L AT VM.MARIST DOT EDU
> > > >         cc:
> > > >         Subject:        Re: HELP ON wzrdhlpr.exe command lIn TSM
> >(Tivoli
> > > >storage manager) 5.1?
> > > >
> > > >
> > > >
> > > >Hi,
> > > >   When I execute the command on MSDOS prompt it writes the output
>to
> >the
> > > >file murali but when I do the same through java code as shown at
>end it
> > > >does
> > > >not write and it does not give any erros either.  Any thoughts?
>(I
> >tried
> > > >to
> > > >capture the console output without redirecting to a file first.
>But
> >that
> > > >hangs as on console it shows number of pages and for each page
>waits
> >for
> > > >user input of pressing Enter key or C key.)
> > > >Thanks
> > > >Code is below:
> > > >
> > > >D:\Program Files\tivoli\tsm\console>wzrdhlpr -id=admin
>-password=admin
> > > >-tab
> > > >select * from sessions > murali
> > > >
> > > >
> > > >import java.io.InputStream;
> > > >import java.io.InputStreamReader;
> > > >import java.io.Reader;
> > > >import java.io.BufferedReader;
> > > >import java.io.IOException;
> > > >import java.sql.*;
> > > >
> > > >public class TSM extends TSMConnect
> > > >{
> > > >   public static void main(String args[])
> > > >{
> > > >    if (args.length != 0)
> > > >   {
> > > >     System.out.println("Usage: java TSM");
> > > >     System.exit(1);
> > > >   }
> > > >   String query = "SELECT * FROM columns";
> > > >   TSM tsmObj = new TSM();
> > > >   Connection dbc = null;
> > > >   Statement stmt = null;
> > > >   ResultSet resultSet = null;
> > > >   Process process = null;
> > > >   InputStream is = null;
> > > >   Reader reader = null;
> > > >   BufferedReader br = null;
> > > >   try
> > > >{
> > > >
> > > >     dbc = tsmObj.connect();
> > > >     stmt = dbc.createStatement();
> > > >     resultSet = stmt.executeQuery(query);
> > > >     tsmObj.presentResultSet(resultSet);
> > > >     Runtime.getRuntime().exec("cmd d:");
> > > >     Runtime.getRuntime().exec("cmd /c cd D:\\Program
> > > >Files\\tivoli\\tsm\\console\\");
> > > >     String command = "cmd wzrdhlpr -id=admin -password=admin
>select *
> >from
> > > >sessions > murali";
> > > >     //process =
> > > >     Runtime.getRuntime().exec(command);
> > > >     /*is = process.getInputStream();
> > > >     reader = new InputStreamReader(is);
> > > >     br = new BufferedReader(reader);
> > > >     String line;
> > > >     while ((line = br.readLine())!=null) {
> > > >       System.out.println("line:"+line);
> > > >     }*/
> > > >}
> > > >catch(IOException ioex)
> > > >{
> > > >    System.out.println(ioex.getMessage());
> > > >}
> > > >catch (SQLException sqlex)
> > > >{
> > > >     System.out.println(sqlex.getMessage());
> > > >   }
> > > >finally
> > > >{
> > > >   tsmObj.close(dbc, stmt);
> > > >}
> > > >}
> > > >public void presentResultSet(ResultSet rs) throws SQLException
> > > >{
> > > >   if (!rs.next()) System.out.println("No records to display");
> > > >   else
> > > >   {
> > > >     do
> > > >     {
> > > >       //System.out.println(rs.getString("TABNAME") + ": " +
> > > >rs.getString("COLNAME") + ": "
> > > >+rs.getInt("COLNO")+":"+rs.getString("TYPENAME") + ": "
> > > >+rs.getString("REMARKS"));
> > > >      } while (rs.next());
> > > >   }
> > > >}
> > > >}
> > >
> > > _________________________________________________________________
> > > Add photos to your e-mail with MSN 8. Get 2 months FREE*.
> > > http://join.msn.com/?page=features/featuredemail
> ><< josh.gable.vcf >>
>
>
>_________________________________________________________________
>The new MSN 8: advanced junk mail protection and 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>
>"MMS <health-first.org>" made the following
>  annotations on 11/19/2002 03:55:44 PM
>---------------------------------------------------------------------------
---
>This message is for the named person's use only.  It may contain
>confidential, proprietary, or legally privileged information.  No
>confidentiality or privilege is waived or lost by any mistransmission.
If
>you receive this message in error, please immediately delete it and all
>copies of it from your system, destroy any hard copies of it, and notify
>the sender.  You must not, directly or indirectly, use, disclose,
>distribute, print, or copy any part of this message if you are not the
>intended recipient.  Health First reserves the right to monitor all
e-mail
>communications through its networks.  Any views or opinions expressed in
>this message are solely those of the individual sender, except (1) where
>the message states such views or opinions are on behalf of a particular
>entity;  and (2) the sender is authorized by the entity to give such
views
>or opinions.
>
>===========================================================================
===


_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963