Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2006
    Posts
    6

    Unanswered: Need for DB2 Connect with Websphere Application server

    If an Java environment has the latest version of Websphere Application Server installed, are there any advantages in using DB2 connect to connect to the database versus a direct connectivity via the WAS?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you are using DB2 for Linux, UNIX, and Windows, I don't know of any benefit.

    If you are connecting to DB2 for z/OS (mainframe) or iSeries (AS/400), then you need a DB2 Connect license.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Apr 2006
    Posts
    6
    Its in a z/OS environment, currently using DB2 Connect but there are issues with it processing a file larger than 350 MB for some reason. Looking at the possibility of bypassing DB2 Connect and doing a direct connect with the WAS.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Sorry, what do you mean 'doing a direct connect with the WAS' ?

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

  5. #5
    Join Date
    Apr 2006
    Posts
    6

    DB2 connect clarification

    Using the DB2 Universal JDBC Provider (XA) with type 4 driver which is supported in WAS running on z/OS to connect directly to the z/OS host DB2 Server as oppose to using DB2 connect.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Technically, DB2 connect provides the same driver as WAS.

    Licensewise, AFAIK, if you are connecting to zOS you'll have to pay extra money for the license

    HTH

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

Posting Permissions

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