• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Remote access to database/data

wernercd

ADSM.ORG Member
#1
TSM Server 7.1.4, DB2 10.5.3, RHEL 6.6...

I'm trying to access the data remotely. Using any tool I can throw at it, everything burns at password entry. More detailed write up here at Dba.StackOverflow.

Using ODBC, IBM DataConnect, Sql Server Linked Server, etc... nothing I do seems to work.

How can I access the DB2 Server from a Windows Server?
 

marclant

ADSM.ORG Moderator
#3
How can I access the DB2 Server from a Windows Server?
Did you try the DB2 ODBC driver?
IBM® Tivoli® Storage Manager Versions 6.1 and later use the DB2® open database connectivity (ODBC) driver to query the database and display the results.

DB2 provides its own ODBC driver which can also be used to access the Tivoli Storage Manager server DB2 database. For more information on the DB2 native ODBC driver, refer to DB2 documentation at: http://pic.dhe.ibm.com/infocenter/db2luw/v10r5. Search on Introduction to DB2 CLI and ODBC
source: http://www.ibm.com/support/knowledg...sm.srv.doc/t_srv_db_sql_querying.html?lang=en
 

Rhuobhe

ADSM.ORG Member
#5
I am trying to pull some reports from TSM 7.1.7 using Excel ODBC connection. I followed the steps but I am getting an error connecting saying that I don't have enough privilege to connect to the database (DB2). I don't know enough about DB2 to go in and grant my admin account 'connect' permission.

SQL1060N
SQLSTATE=08004

Is the the correct method to do this? I remember using this client years ago using TSM 5.5 on a Version 5 client but it looks like the Client has been removed from the IBM client ftp.

Thank you
 

marclant

ADSM.ORG Moderator
#7
Is the the correct method to do this?
You need to use the instance owner ID and password in Step 4.

Notes :
The UID/PWD in the db2cli.ini file should be a valid operating system userid/password on the system where the Tivoli Storage Manager server is installed. For example, the server instance userid and password.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 17 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 53 60.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.5%
  • Other (please comement)

    Votes: 7 8.0%

Forum statistics

Threads
31,469
Messages
134,129
Members
21,569
Latest member
srinathkodela
Top