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
Thursday, October 11, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment