Thursday, October 11, 2007

WebSphere Datasource

https://saappq46.dtcc.com:9144/ibm/console/secure/securelogon.do?action=secure Login with Active Directory details ...

Go to "Resources" ---> "JDBC Resources"
You will see a number of drivers go to each and look at the datasoruces ...

for sybase & udb db2 the information is in Datasource definition e.g. bottom of JDBC providers > DB2 Universal JDBC Driver Provider > Data sources > D01Pool.

For NEON its hidden in custom properties that point to an alias, e.g.
JDBC providers > NEON Driver > Data sources > AZNPool > Custom properties
Has an value DataSourceName set to DB_SRVR.
This is a database alias. If you log in to saappq46 and look in /udb/shadow/odbc.ini you will see the server name and port details there.

For all datasources login id is defined at the Datasoruce details screen (e.g. JDBC providers > NEON Driver > Data sources)

Example:
[DB_SRVR]
Description=DB2 connection using NEON's debug driver
APPL=ODBC
MR=0
HD=NO
CPFX=SYSIBM
LINK=TCPIP
HOST=smqsys01
PORT=50006
CD=NO
SUBSYS=DBQ
PLAN=SD2C1010
RPGT=YES
NEONTRACE=LOCKTHREAD NONE
XAEN=TWO-PHASE
XAOP=JTS
#NEONTRACE=LOCKTHREAD INFO BUFFERTRACE log=/tmp/neonlog.txt

No comments: