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.


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