It looks like it cant find the database. Did you define it as an ODBC
source? Look in contol panel->admin tools-> ODBC and make sure
its there.
"Bandaru
Jayaprakash "
<db2udbdba-ezmlms To
hield-x39886926.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
11/24/2005 12:42 Subject
AM Error while executing the script
from the script.
Hi,
We are the getting following error message while executing the script
from the server
to extract the data from the Sybase database.
This script is generated by MTK.
From the windows, it is successful.
Any help is appreciated.
DataMove_fis_broker_data.sh
----------------------------
#!/usr/bin/ksh
# parm1 = Source user name
# parm2 = Source password
SRC_USERNAME=
SRC_PASSWORD=
# What is the label for the source database?
# This can be an ODBC data source name or host IP address:port
#SRC_DATABASE=
#SRC_DATABASE=
SRC_DATABASE=
# Are you using a native driver to access the source database?
SRC_NATIVE=TRUE
# If you want to use this file on a different machine,
# update USERDIR to the directory containing mtk jar files
# and update PROJPATH to the directory for the project.
USERDIR=/D2home/a342114/TxHist/
#USERDIR=/D2home/a342114/TxHist/mtk/
PROJPATH=/D2home/a342114/TxHist/
# The file named here needs to be moved with this batch file
# and this entry needs to be updated to reflect its new location.
FILE=${PROJPATH}Verify_fis_broker.out
# MTK does not need to be installed on the target machine,
# but the jar files listed in the classpath below are needed.
#If using the Sybase native driver, add jconn2.jar to this classpath.
#CLASSPATH=/D2source/sybase1252/jConnect-5_5/classes/jconn2.jar:${USERDI
R}ifxjdbc.jar:${USERDIR}mtk.jar:${USERDIR}xmistore.jar
:${USERDIR}cwm.jar:${CLASSPATH}
#CLASSPATH=/D2source/sybase1252/jConnect-5_5/classes/jconn2.jar:${USERDI
R}ifxjdbc.jar:${USERDIR}mtk.jar:${USERDIR}xmistore.jar
:${USERDIR}cwm.jar:${CLASSPATH}
CLASSPATH=/D2source/sybase1252/jConnect-5_5/classes/jconn2.jar:${USERDIR
}:${USERDIR}mtk.jar:${USERDIR}xmistore.jar:${USERDIR}c
wm.jar:${CLASSPATH}
#javahome=/D2home/a353001/j2re1_3_1_13/bin/
java com.ibm.db2.tools.mtk.model.verification.MTKVerification -update
-noverify -file ${FILE} -src ${SRC_DATABASE} -native ${S
RC_NATIVE}
echo "Data Extract"
/opt/sybase125/shared-1_0/JRE-1_4/bin/java
com.ibm.db2.tools.mtk.model.datamovement.MTKDataSybase -file ${FILE}
-user ${SRC_US
ERNAME} -pwd ${SRC_PASSWORD}
echo "End"
----------------------------------------------------------------------
Error Log:
Tue Nov 22 08:47:40 EST 2005 ERROR MTKCONNECTION failed to get
Sybase 11 connection
Tue Nov 22 08:47:40 EST 2005 ERROR MTKCONNECTION JZ00L: Login
failed. Examine the SQLWarnings chained to this exception for the
reason(s).
Tue Nov 22 08:47:40 EST 2005 ERROR MTKCONNECTION +++ Login
failed.
Tue Nov 22 08:47:40 EST 2005 ERROR MTKCONNECTION +++ Login
failed.
Tue Nov 22 08:47:40 EST 2005 ERROR DATAPREPARE Exception
caught:
in MTKDataPreparation.getData(workItems):
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings
chained to this exception for the reason(s).
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:546)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3653)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:510)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:432)
at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:247)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:22
3)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:198)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:132)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
com.ibm.db2.tools.mtk.util.MTKConnection.initDB(MTKConnection.java:394)
at
com.ibm.db2.tools.mtk.model.datamovement.MTKDataPreparation.connect(MTKD
ataPreparation.java:1178)
at
com.ibm.db2.tools.mtk.model.datamovement.MTKDataPreparation.getData(MTKD
ataPreparation.java:1226)
at
com.ibm.db2.tools.mtk.model.datamovement.MTKDataPreparation.run(MTKDataP
reparation.java:1133)
at
com.ibm.db2.tools.mtk.model.datamovement.MTKDataSybase.main(MTKDataSybas
e.java:59)
Tue Nov 22 08:47:40 EST 2005 ERROR DATAPREPARE Exception caught
in
MTKDataPreparation.run():
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings
chained to this exception for the reason(s).
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:546)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3653)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:510)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:432)
at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:247)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:22
3)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:198)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:132)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
com.ibm.db2.tools.mtk.util.MTKConnection.initDB(MTKConnection.java:394)
at
com.ibm.db2.tools.mtk.model.datamovement.MTKDataPreparation.connect(MTKD
ataPreparation.java:1178)
at
com.ibm.db2.tools.mtk.model.datamovement.MTKDataPreparation.getData(MTKD
ataPreparation.java:1226)
at
com.ibm.db2.tools.mtk.model.datamovement.MTKDataPreparation.run(MTKDataP
reparation.java:1133)
at
com.ibm.db2.tools.mtk.model.datamovement.MTKDataSybase.main(MTKDataSybas
e.java:59)
Thanks,
Jayprakash.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page