Win a copy of Succeeding with AI this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Junilu Lacar
Sheriffs:
  • Tim Cooke
  • Jeanne Boyarsky
  • Knute Snortum
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • salvin francis
  • fred rosenberger
  • Frits Walraven

Websphere - DB2 configuration

 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does anyone know of a book that shows how to configure DB2 for the following.
1. To talk to a session database located on a remote server
2. To configure DB2 to talk to database on OS/390.
I want something that i can implement immediately without having to read thru a thick book.
Any help will be appreciated.
Matt
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Configure a DB2 conn to OS/390 (Quick and nasty):
1. Install DB2 Connect
2. Perform the following
db2 catalog tcpip node <node_name> remote <mainframe_ip_or_name> server <port_>
db2 catalog db <db> as <mainframe_db> at node <node_name> authentication dcs
db2 catalog dcs db <db> as <mainframe_db>
db2 terminate
3. Create your datasource pointing to <db>
using the COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
driver
4. Have fun
Rgrds
 
You totally ruined the moon. You're gonna hafta pay for that you know. This tiny ad agrees:
Two software engineers solve most of the world's problems in one K&R sized book
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic