Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Unanswered: ZOS to UDB Cobol

    Need ability for mainframe cobol program to read a federated database.

    Current environment
    Mainframe ZOS DB2 V7.1 DRDA TCP/IP
    Federated server:
    Windows 2003
    DB2UDB V8.2
    Information Intergrator
    DB2 Connect ESE

    I currently have several federated databases that are accessed via QMF and it works fine. I need a ability for a mainframe cobol program to read a federated database to verify a part number.

    What entries do I make on the mainframe? Do I set it up in DRDA?
    Do I make a wrapper in federated server for ZOS?
    I have read most of the current IBM redbooks and they seem to be somewhat out of date.
    Last edited by moogdba; 10-22-05 at 13:38.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    z/os

    as long as the MVS db2 can connect to udb, you can read..handle all tables, known at this udb (local or federated)
    just setup the mvs to access udb
    see : sysibm.locations/user... to define the connection
    see sysadmin of db2 mvs
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •