>> 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