Are you running the .profile for the user (which generally would contain
the db2profile script which sets up the DB2 environment)
What does your crontab entry look like?
"manasa" <db2udbdba-ezmlmshield-x37821516.[Email address protected]
26/02/2008 10:24 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
script in crontab
Hi DBA,
When I am using the following script directly, it is
runing but when
I am trying through crontab, it is giving the following error.
#!/bin/sh
db2instance=LOYUAT
db2user=siebel
db2pwd=s1motaneli
logdir="/siebel/Sales/UAT"
datadir="/siebel/Sales/UAT"
loadfile="Transfer_DWH_Files_"`date +"%Y%m%d%H%M%S"`
db2 "connect to $db2instance user $db2user using $db2pwd"
>>
$logfile
ERROR:
SQL10007N Message "-1390" could not be retrieved. Reason
code: "6".
Connection to DB failed
Please help to solve the problem.
Thanks.
Disclaimer: This communication is for the exclusive use of the intended
recipient(s) and shall not attach any liability on the originator or ITC
Infotech India Ltd./its Holding company/ its Subsidiaries/ its Group
Companies. If you are the addressee, the contents of this e-mail are
intended for your use only and it shall not be forwarded to any third
party, without first obtaining written authorization from the originator
or ITC Infotech India Ltd./ its Holding company/its Subsidiaries/ its
Group Companies. It may contain information which is confidential and
legally privileged and the same shall not be used or dealt with by any
third party in any manner whatsoever without the specific consent of
ITC Infotech India Ltd./ its Holding company/ its Subsidiaries/ its Group
Companies.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************************
The information contained in or attached to this message is intended only for the people it is addressed to. If you are not the intended recipient, any use, disclosure or copying of this information is unauthorised and prohibited. This information may be confidential or subject to legal privilege.
It is not the expressed view of Medibank Private Limited or any of its subsidiaries unless it is authorised by a person with actual authority.
To the fullest extent allowed by law, Medibank Private cannot accept liability for any virus damage caused by this message.
Medibank Private Limited ABN 47 080 890 259.
***********************************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page