ADSM-L

Re: Query from z/OS-platform to intel-platform

2003-10-13 11:43:27
Subject: Re: Query from z/OS-platform to intel-platform
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 13 Oct 2003 11:41:43 -0400
>> I need to make a query from our z/OS-platform to a TSM Server on  Intel
>> platform.
>>
>> "Normaly" from a DB2 z/OS you can make a DRDA-connection to a DB2 UDB
>> database on a Windows-platformen, if DB2 UDB on Windows-platform content
>> Connect-product (ex DB2 UDB EEE V7). Can TSM-/DB2-database answer a
>> DRDA-request from DB2 z/OS, or do I need a specific driver on
>> z/OS-platformen.
>>
>> Maybe someone have a workaround "script or ....."
>>
>> Thanks in advance
>>
>> - Michael
>
>TSM is just a DB2-like database, eg. it is not really db2 (yet).
>
>To do database queries you can:
>
>1- use select on the dsmadmc commandline like 'select * from syscat.columns'
>or 'select * from tables'
>
>2- use an odbc connector, unfortunately, I've never done that so I don't
>know how....

The TSM database is B-tree rather than DB2: it has some SQL accommodations.
See Appendix A of the Technical Guide redbook for an excellent summary of
what you can do in terms of Select statements and ODBC access.

  Richard Sims    http://people.bu.edu/rbs

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