ADSM-L

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

2003-10-13 11:05:29
Subject: Re: Query from z/OS-platform to intel-platform
From: Remco Post <r.post AT SARA DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 13 Oct 2003 17:03:35 +0200
On Mon, 13 Oct 2003 16:55:35 +0200
"Pedersen.Michael Benny MIP" <MIP AT KMD DOT DK> wrote:

> Hi all,
>
> 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....

--
Met vriendelijke groeten,

Remco Post

SARA - Reken- en Netwerkdiensten                      http://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008    Fax. +31 20 668 3167

"I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end." -- Douglas Adams

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