ADSM-L

Re: ODBC access to TSM from VBScript

2002-09-09 14:59:04
Subject: Re: ODBC access to TSM from VBScript
From: Ung Yi <yi-1 AT MEDCTR.OSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 9 Sep 2002 14:58:36 -0400
Thanks,

this looks good.

Yi


>>> storman AT US.IBM DOT COM 09/06/02 11:35AM >>>
Actually now that  think about it, I don't think my response below really
answered the question about created a "linked server". The procedure I
outlined shows how to import TSM tables into MS SQL. This just goes to
show how little I know about MS SQL! (sorry, I just installed it this
morning, and have never really used it before).

I was able to create a "linked server" with the following steps:

1) Start the SQL Server Enterprise Manager.

2) Navigate to "Microsoft SQL Servers" --> "SQL Server Group" --> "STORMAN
(Windows NT)" --> "Security". Note that "STORMAN" is my Windows machine
name. Open up the "Security" tree.

3) Right-click on "Linked Servers" and select "New Linked Server...".

4) In the "Linked server" text box, put "TSM". Select the "Other data
source" radio button, then from the "Provider name" drop-down list, select
"Microsoft OLE DB Provider for ODBC Drivers". In the "Provider string"
text box, enter the following:

   DSN=yourdsn;UID=youradmin;PWD=yourpassword

Where "yourdsn" is the name of your TSM ODBC driver DSN, "youradmin" is
your TSM Admin ID, and "yourpassword" is your TSM Admin password. For
example, if my DSN is "amr_odbc", my Admin ID is "storman", and my
password is "xxxxx", then I would enter:

   DSN=amr_odbc;UID=storman;PWD=xxxxx

Leave the other text box fields blank.

In the "Server option" section, "Data access" is checked, but the other
checkboxes are unchecked. Click "OK".

5) "TSM" should now appear in the "Linked Servers" tree. Open up "TSM" and
click on "Tables". In a few moments, you should see the TSM table names
appear in the right-hand pane.

I imagine that you know what to do with a linked server once you have
one... I have not yet figured out what to do with it.   ;-)

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.




Andrew Raibeck/Tucson/IBM@IBMUS
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/06/2002 07:45
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: ODBC access to TSM from VBScript



Yes, I've been able to get this to work with MS SQL 7.0 Desktop Edition
(should work with Enterprise Edition as well, I just haven't tried it).

Here are the steps I followed:

1) Start the SQL Server Enterprise Manager.

2) Navigate from "Microsoft SQL Servers" --> "SQL Server Group" -->
"STORMAN (Windows NT)" --> "Databases". Note: STORMAN is my Windows
machine name.

3) Right click on "Databases" and select "New Database..." from the pop-up
menu. This brings up the "Database Properties" dialog.

4) Select the "General" tab (should be the default). In the "Name" text
box, I put "TestTSM". Then click "OK".

5) Right click on the "TestTSM" database, and select "All Tasks/Import
Data..." from the pop-up menu. This brings up the "DTS Import Wizard"
dialog. Click "Next" to continue.

6) In the "Source" drop-down list, select "TSM ODBC Driver". Select the
"User/System DSN" radio button (normally the default), then select your
TSM ODBC driver DSN from the drop-down list. Enter your TSM Admin ID in
the "Username" text box, and your TSM Admin password in the "Password"
text box. Click "Next".

7) In the "Destination" drop-down list, select "Microsoft OLE DB Provider
for SQL Server". This is probably already selected for you by default. In
the "Server" drop-down list, select your SQL server (mine shows STORMAN).
Select the "Use Windows NT authentication" radio button. In the "Database"
drop-down list, select "TestTSM" (should already be selected). Click
"Next".

8) Select the "Copy table(s) from the source database" radio button, then
click "Next".

9) You should now see a list of the tables from the TSM server. Check the
tables you wish to copy (I picked the ADSM.ADMINS table), then click
"Next".

10) You should now be in the "Save, Schedule and Replicate Package"
dialog. Check "Run immediately" (should be the default) and leave
everything else unchecked. Click "Next".

11) Click "Finish". The table(s) you selected will be copied. Click "Done"
when the copy is complete.

12) Now in the Enterprise Manager, navigate to the "TestTSM" database, and
click on the "+" sign to open the tree. Click on "Tables".

13) The right-hand pane of the the Enterprise Manager should show a list
of tables in the TestTSM database. Among those tables will be the ones you
chose to copy from the TSM server (in my example, I see the ADMINS table).
Right-click on the table, then select "Open Table/Return all rows" from
the pop-up menu. The rows from the ADMINS table should appear.

And that's it!

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.




Ung Yi <yi-1 AT MEDCTR.OSU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/04/2002 13:58
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: ODBC access to TSM from VBScript



Wow.

Can you create a linked server from SQL Server to TSM database(in a
supported way)?

Thanks,
yi

<Prev in Thread] Current Thread [Next in Thread>