Interesting.... I have never heard of this before, so I have no idea what
it is about.
If you have questions about it, try sending an email to [EMAIL PROTECTED]
and see what they say, or contact your IBM account/marketing
representative. I'm not sure how much more help I can give on the tool you
mentioned. If I learn any more, though, I'll let you know.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
10/30/2002 11:20
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Re: HELP: In TSM (Tivoli storage manager) 5.1 querying its
databse thorugh
java code
http://www6.software.ibm.com/devcon/devcon/docs/tsub0300.htm
Do you know about this IBM tool given in the above link? Is it like a
one
JDBC driver for all platforms for TSM from IBM? Is there any evaluation
version available for this ?
Thanks
-murali
>From: Andrew Raibeck <[EMAIL PROTECTED]>
>Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: HELP: In TSM (Tivoli storage manager) 5.1 querying its
databse
> thorugh java code
>Date: Wed, 30 Oct 2002 09:37:49 -0700
>
>The ODBC driver is available for Windows only (see the README file that
>accompanies the ODBC driver for details on what Windows versions are
>supported). There is no charge to download the ODBC driver.
>
>You can find most TSM code on FTP site ftp.software.ibm.com in directory
>storage/tivoli-storage-management.
>
>From there, you will see "maintenance" and "patches" directories.
>"maintenance" is for .0 releases (i.e. 5.1.5.0) and "patches" is for
>patches (i.e. 5.1.5.2).
>
>The ODBC driver is a component of the backup-archive client. Since it is
>5.1.5.0, you want to traverse into the "maintenance" directory. To find
>it, go to:
>
> maintenance/client/v5r1/Windows/WinNT/v515
>
>Thus the entire directory is:
>
>
>storage/tivoli-storage-management/maintenance/client/v5r1/Windows/WinNT/v515
>
>The files you want all begin with IP22546_ODBC. The ODBC driver package
is
>called IP22546_ODBC.exe.
>
>After you install the driver, run the ODBC Data Source Administrator,
>click on the "Drivers" tab, and verify that 5.1.5.0 is installed.
>
>Regards,
>
>Andy
>
>Andy Raibeck
>IBM Software Group
>Tivoli Storage Manager Client Development
>Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
>Internet e-mail: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]>
>Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>10/30/2002 09:14
>Please respond to "ADSM: Dist Stor Manager"
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject: Re: HELP: In TSM (Tivoli storage manager) 5.1
>querying its databse thorugh
>java code
>
>
>
>Hi,
>Actually I searched all IBM and Tivoli sites with key words ODBC driver
>and Storage and the download pages do not have download for ODBC driver
>for
>TSM 5.1 or TSM. Do you know the URL for that donwload of ODBC driver
>version 5.1.5.0 for TSM for Windows 2000 and do you know if it is free or
>if
>it requires some fees? One more question is is the ODBC driver is only
>for
>Windows 2000 (or) is TSM has ODBC drivers for Solaris and AIX also?
>Thanks
>-murali
>
>
>
>
>
> >From: Andrew Raibeck <[EMAIL PROTECTED]>
> >Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: HELP: In TSM (Tivoli storage manager) 5.1 querying its
>databse
> > thorugh java code
> >Date: Tue, 29 Oct 2002 17:42:12 -0700
> >
> >OK, a couple of things:
> >
> >1) I traced the ODBC driver while getting the connection, and you are
> >right. It looks to me like the JDBC-ODBC bridge is doing more than just
> >connecting with the server; it is also obtaining information about the
>TSM
> >tables, and among other things, does call SQLColAttribute(). The ODBC
> >driver is connecting successfully, but the attempt to get information
> >about the TSM database is failing. Since these two functions appear to
be
> >wrapped in the getConnection() code, we are both right! (Sorry, I am
not
> >familiar with the details of how the JDBC-ODBC bridge works.)
> >
> >2) Looking more closely at my 10 May 2002 post (I provided the link in
my
> >original response on this thread), the customer to whom I responded was
> >seeing similar problems as you, and I recommended 4.2.2.0 or 5.1.0.1 at
> >that time. I'm fairly certain that 5.1.0.1 contained significant
> >enhancements (okay, fixes) that will resolve the trouble you are
seeing.
> >Since 5.1.5.0 contains even more fixes, it is the version I recommend.
>Try
> >that, and let me know how it goes.
> >
> >Regards,
> >
> >Andy
> >
> >Andy Raibeck
> >IBM Software Group
> >Tivoli Storage Manager Client Development
> >Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
> >Internet e-mail: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]>
> >Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> >10/29/2002 17:12
> >Please respond to "ADSM: Dist Stor Manager"
> >
> >
> > To: [EMAIL PROTECTED]
> > cc:
> > Subject: Re: HELP: In TSM (Tivoli storage manager) 5.1
> >querying its databse thorugh
> >java code
> >
> >
> >
> >Hi,
> >I checked that ODBC version and it is 5.01.00.00.
> >If you still have my first email with code, there
> >I am using your code as it is where the line was
> >return DriverManager.getConnection("jdbc:odbc:tsm", "admin",
> > >"admin"); I gave System.out statements in all
> >steps and found that beyond this line it does not proceed.
> >Here I changed the code to get the actual return value for
> >the Connection by putting it inside try block. There is
> >no exception in this step but the Connection object is null.
> >Though why the Session established with server TSM_SERVER1
> >message seen is not clear. Somewhere during Connection
> >it fails. Thats what I found by the System.out statements.
> >I will do your other suggestions. Thanks for such detailed
> >study of the problem.
> >-murali
> >
> >
> >
> >
> >
> >
> > >From: Andrew Raibeck <[EMAIL PROTECTED]>
> > >Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: Re: HELP: In TSM (Tivoli storage manager) 5.1 querying its
> >databse
> > > thorugh java code
> > >Date: Tue, 29 Oct 2002 16:41:12 -0700
> > >
> > > > My ODBC version is 3.51
> > >
> > >3.51 is the version of Microsoft ODBC support you have installed on
>your
> > >system. What I am asking about is the version of TSM ODBC driver you
>have
> > >installed. If you run the ODBC Data Source Administrator
>(odbcad32.exe),
> > >click on the "Drivers" tab, locate the "TSM ODBC Driver" (probably
near
> > >the bottom of the list) and look at the "Version" column, you will
see
> >the
> > >version number of the TSM ODBC driver.
> > >
> > >You are definitely connecting with the TSM server, so the connection
> > >portion of the code is fine. Note the output you showed me earlier:
> > >
> > > >Session established with server TSM_SERVER1: Windows
> > > > Server Version 5, Release 1, Level 0.0
> > > > Server date/time: 10/29/2002 15:25:28 Last access: 10/29/2002
> > >15:15:01
> > > >
> > > >Session established with server TSM_SERVER1: Windows
> > > > Server Version 5, Release 1, Level 0.0
> > > > Server date/time: 10/29/2002 15:25:29 Last access: 10/29/2002
> > >15:25:28
> > > >
> > > >TSM: There is no information about this table.
> > >
> > >The "Session established with server" messages tell me that you are
> > >clearly connecting with the TSM server. You can watch this happen by
> > >running the Admin command line interfact in console mode. Start the
>Admin
> > >CLI like this:
> > >
> > > dsmadmc -console
> > >
> > >Enter your admin ID and password. Then when activity happens on your
>TSM
> > >server, you will see it in the Admin console. Run your Java code and
> >watch
> > >the ODBC driver "talk" to the TSM server.
> > >
> > >The message "TSM: There is no information about this table" is issued
>by
> > >the TSM ODBC driver from either SQLDescribeCol() or
SQLColAttribute().
>My
> > >guess is that it is coming from SQLColAttribute(), which was broken
in
> > >earlier versions of the TSM ODBC driver. Which is one reason I
>recommend
> > >that you install 5.1.5, just to eliminate the driver from the
problem.
> > >
> > >User DSN information is stored in the registry, in
> > >HKEY_CURRENT_USER\Software\ODBC\ODBC.INI. System DSN info looks like
>user
> > >DSN info, except system DSNs are stored in
> > >HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. The README file that
> > >accompanies the ODBC driver has a section, "ODBC Driver Configuration
> > >Details", that discusses the user DSN registry settings. But since
you
> >are
> > >connecting successfully to the TSM server, your DSN is not the
problem.
> >As
> > >I said before, I am able to run your exact same code (except for DSN
> >name,
> > >Admin ID, and password) and get good results.
> > >
> > >If the problem persists, even with the 5.1.5 TSM ODBC driver, then
>review
> > >the TSM ODBC driver README file and follow the advice given in the
> > >"Troubleshooting/Diagnostics" section subsection "Application
Problems"
> >to
> > >obtain the appropriate trace data. Then open a problem with IBM
>support,
> > >and we can work through it that way.
> > >
> > >Regards,
> > >
> > >Andy
> > >
> > >Andy Raibeck
> > >IBM Software Group
> > >Tivoli Storage Manager Client Development
> > >Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
> > >Internet e-mail: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]>
> > >Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> > >10/29/2002 15:20
> > >Please respond to "ADSM: Dist Stor Manager"
> > >
> > >
> > > To: [EMAIL PROTECTED]
> > > cc:
> > > Subject: Re: HELP: In TSM (Tivoli storage manager)
5.1
> > >querying its databse thorugh
> > >java code
> > >
> > >
> > >
> > >Hi,
> > >I found that that the TSM: There is no information about this table.
> > >comes when creating Connection object. Connection does not happen.
> > >In which folder the DSN file to be created? Is it supposed to be in
a
> > >specific folder where the database tables of TSM (I dont know even
that
> > >location with respect to install location of TSM server) is?
> > >Thanks
> > >-murali
> > >
> > >
> > >
> > >
> > >
> > >
> > > >From: Andrew Raibeck <[EMAIL PROTECTED]>
> > > >Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> > > >To: [EMAIL PROTECTED]
> > > >Subject: Re: HELP: In TSM (Tivoli storage manager) 5.1 querying its
> > >databse
> > > > thorugh java code
> > > >Date: Tue, 29 Oct 2002 14:52:10 -0700
> > > >
> > > >I copied and pasted your code, as is, into the two .java files.
Then
>I
> > > >modified the DSN, Admin ID, and password to match my environment,
>then
> > > >compiled the files. The output looked just fine to me, so your code
> >looks
> > > >good.
> > > >
> > > >Which version of the ODBC driver are you using? Please be sure you
>are
> > > >using a current version. 5.1.5.0 is preferable.
> > > >
> > > >Regards,
> > > >
> > > >Andy
> > > >
> > > >Andy Raibeck
> > > >IBM Software Group
> > > >Tivoli Storage Manager Client Development
> > > >Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
> > > >Internet e-mail: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]>
> > > >Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> > > >10/29/2002 14:30
> > > >Please respond to "ADSM: Dist Stor Manager"
> > > >
> > > >
> > > > To: [EMAIL PROTECTED]
> > > > cc:
> > > > Subject: Re: HELP: In TSM (Tivoli storage manager)
>5.1
> > > >querying its databse thorugh
> > > >java code
> > > >
> > > >
> > > >
> > > >Hi,
> > > > After adding in system and user dsn when running I get following
> > >message
> > > >on screen:
> > > >
> > > >C:\my-java>java TSM
> > > >Session established with server TSM_SERVER1: Windows
> > > > Server Version 5, Release 1, Level 0.0
> > > > Server date/time: 10/29/2002 15:25:28 Last access: 10/29/2002
> > >15:15:01
> > > >
> > > >Session established with server TSM_SERVER1: Windows
> > > > Server Version 5, Release 1, Level 0.0
> > > > Server date/time: 10/29/2002 15:25:29 Last access: 10/29/2002
> > >15:25:28
> > > >
> > > >TSM: There is no information about this table.
> > > >
> > > >Any thoughts please?
> > > >Following are the contents of 2 files:
> > > >
> > > >TSMConnect:
> > > >
> > > >import java.sql.*;
> > > >public class TSMConnect
> > > >{
> > > > public Connection connect() throws SQLException
> > > > {
> > > > try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
> > > > catch (ClassNotFoundException e)
> > > > {
> > > > throw new SQLException("Unable to load JdbcOdbcDriver
class");
> > > > }
> > > > // arguments are "jdbc:odbc:yourdsn", "youradmin", "yourpw"
> > > > return DriverManager.getConnection("jdbc:odbc:tsm", "admin",
> > >"admin");
> > > > }
> > > > public void close(Connection dbc, Statement stmt)
> > > >{
> > > > try
> > > > {
> > > > if (stmt != null) stmt.close(); if (dbc != null) dbc.close();
> > > > }
> > > > catch (SQLException sqlex) {}
> > > >}
> > > >public static void main(String args[])
> > > >{
> > > > TSMConnect TC = new TSMConnect(); Connection dbc = null;
Statement
> > >stmt
> > > >=
> > > >null;
> > > > try
> > > >{
> > > > dbc = TC.connect();
> > > > System.out.println("Connection opened.");
> > > > stmt = dbc.createStatement();
> > > > System.out.println("Created a statement.");
> > > >}
> > > >catch (SQLException sqlex)
> > > >{
> > > > System.out.println(sqlex.getMessage());
> > > >}
> > > >finally
> > > >{
> > > > TC.close(dbc, stmt); System.out.println("Connection closed.");
> > > >}
> > > >}
> > > >}
> > > >
> > > >
> > > >TSM:
> > > >
> > > >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 backups";
> > > > TSM tsmObj = new TSM();
> > > > Connection dbc = null;
> > > > Statement stmt = null;
> > > > ResultSet resultSet = null;
> > > > try
> > > >{
> > > > dbc = tsmObj.connect();
> > > > stmt = dbc.createStatement();
> > > > resultSet = stmt.executeQuery(query);
> > > > tsmObj.presentResultSet(resultSet);
> > > >}
> > > >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("NODE_NAME") + ": " +
> > > >rs.getString("FILESPACE_NAME"));
> > > > } while (rs.next());
> > > > }
> > > >}
> > > >}
> > > >
> > > >
> > > >
> > > >Thanks
> > > >- murali
> > >
> > >
> > >_________________________________________________________________
> > >Unlimited Internet access for only $21.95/month. Try MSN!
> > >http://resourcecenter.msn.com/access/plans/2monthsfree.asp
> >
> >
> >_________________________________________________________________
> >Get faster connections -- switch to MSN Internet Access!
> >http://resourcecenter.msn.com/access/plans/default.asp
>
>
>_________________________________________________________________
>Get faster connections -- switch to MSN Internet Access!
>http://resourcecenter.msn.com/access/plans/default.asp
_________________________________________________________________
Get a speedy connection with MSN Broadband. Join now!
http://resourcecenter.msn.com/access/plans/freeactivation.asp
