RE: Error while executing the script from the script.

RE: Error while executing the script from the script.

 

  


Hi all,

Does MTK supports extended character sets? I am having german
character in my oracle database but while extracting the contents to the
file, its being replaced with underscore. Any help please...


Regards,
Venkatesan.


-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x92674507.[Email address protected]
Sent: Thursday, November 24, 2005 8:30 PM
To: LazyDBA Discussion
Subject: Re: Error while executing the script from the script.





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





---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.


DB2 & UDB email list listserv db2-l LazyDBA home page