ADSM-L

Re: ODBC Driver Connection

2005-08-11 15:08:34
Subject: Re: ODBC Driver Connection
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 11 Aug 2005 12:08:25 -0700
Debbie, the ODBC driver isn't inherently faster than other methods for
SELECTing data from the TSM database (it is really just a pass-through
mehanism for sending SELECT statements to the server and returning results
to the application).

Increasing the fetch size in the data source configuration can improve
performance for retrieving results from large tables. The default is 50;
I'd suggest trying something like 10000 (you probably wont' see much in
the way of improved performance beyond 10000).

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.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-08-11
11:15:57:

> I have downloaded the TSM ODBC driver. I tried using Access and
extracting
> the table data, but that takes a long time. Does anyone else use the
ODBC
> driver connection, and if so, how do you connect to it to easily select
> data from the tables?
>
> Thanks,
> Debbie

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