Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: how to connect from db2-aix to Mainframe db2 database

    Can any one direct me some quick steps.
    db2 8.1.x,aix 5.x
    how to check whether we have directconnect running ?
    Thanks in advance.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: how to connect from db2-aix to Mainframe db2 database

    db2 list applications show detail

    Cheers
    sathyaram

    Originally posted by udbdb2
    Can any one direct me some quick steps.
    db2 8.1.x,aix 5.x
    how to check whether we have directconnect running ?
    Thanks in advance.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: how to connect from db2-aix to Mainframe db2 database

    Sorry ... Didn't read the subject of your post earlier ...

    My earlier may not make sense

    You will have to use DB2 Connect


    Cheers
    Sathyaram

    Originally posted by sathyaram_s
    db2 list applications show detail

    Cheers
    sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Mar 2004
    Posts
    1

    Re: how to connect from db2-aix to Mainframe db2 database

    Originally posted by udbdb2
    Can any one direct me some quick steps.
    db2 8.1.x,aix 5.x
    how to check whether we have directconnect running ?
    Thanks in advance.
    Yes, you can connect to db2 on Mainframe from AIX. As you have AIX UDB, it has DRDA architecture. You do not need a DB2 Connect, if you connect through the AIX box to Mainframe.

    1. Verify you have DDF running on Mainframe.
    2. Find out the IP address and port number of mainframe subsystem.
    3. catalog a node on your AIX DB2 Instance ( You need IP address & Port Number ) using CLP on AIX.
    4. Catalog a remote database pointing to the DB2 Mainframe subsystem using CLP on AIX.
    5. On your desktop, using Client Configuration assistant, enable the remote database for ODBC connection.
    6. You can then connect to Mainframe through the ODBC connection from your desktop.

    Thanks

    Narayan

Posting Permissions

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