I have a very simple script that queries from a DB2 table. The script has 3 parts - (i) Sets the db2profile (ii) connects to db2 using credentials (iii) executes the query.This script works fine if i run it manually from the command prompt. However when scheduled in crontab, it proceeds fine upto step (ii) but fails with the error - "SQL1024N A database connection does not exist" just when the query is executed.
I could see from the logs that the db2 connection is indeed made successfully (connection sucess message displays and the return code is 0). But I am note sure why they query fails saying that a DB connection does not exist. Any immediate help is greatly appreciated.
Here is my CODE:
Here is the output from the log files when invoked by the crontab
Moderator's Comments:
edit by bakunin: please use CODE-tags for output too. Thank you.
I am on AS3 Update 4 Linux
and am having an issue with an automated ftp script, I tried using the fd/sub proc method and that did not seem to work either. I normally use the following method to perform my ftp's but for some reason it works if I launch the script at the command line but in Cron it... (4 Replies)
Having some trouble with usage of for loop and displaying words. Basically I had 3 words( some times more )
in the variable. I want to get one at a time to process.
I am new to unix scripting so please bear with my question and appreciate your reply. I think this can also me done my awk... (1 Reply)
I am having some issues with my cronjobs not running in solaris 10.
Cron is running:
~> ps -ef | grep cron
root 202 1 0 Jul 18 ? 0:01 /usr/sbin/cron
bender 1646 1562 0 01:57:49 syscon 0:00 grep cron
crontab -l lists the cronjob and I *think* its in the... (8 Replies)
Hi Guys,
I wonder if possible to execute a Db2 commands within a perl scripts without installing or invoking the DBI modules. I have a script that is written in kron shell and it looks like :
DB=`db2 list db directory | egrep "Database alias|Directory entry type"|awk '{printf $0 ;... (0 Replies)
I am currently trying to load data from e.txt into tablea. I am getting error.
db2 connect to qw01p user wcs using abc
db2 "LOAD CLIENT FROM /dswork/ECONT/output/interface/e.txt OF DEL MODIFIED BY coldel| SAVECOUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES XTMPRTI1.txt
REPLACE into WCSADM.TABLEA... (1 Reply)
Does the use of cron (HP-UX 11) present a security risk IF it is only given to accounts which have shell access anyway.
If it does present a risk, what is the risk?
Can a script (or command) run via cron; run anything, write anywhere or read anywhere that the same user can not do outside of... (2 Replies)
AIX & DB2 paging issues
Hello I needs some help on AIX & DB2 paging issues. Recently a db2 query caused paging issues which then lead to memory problems and a server restart. Is there anyway of finding out what db2 queries were causing the problem..
Thanks in advance (2 Replies)
Hi all, I am trying to run a cronjob to push my files to my git repo once a week and output a prompt to a logfile, my script works fine if I invoke it manually but my cronjob wont run for some reason, I have sourced the file, and restarted my Mac to no avail, right now I believe I have the cronjob... (8 Replies)
Hi there,
Now I'm facing error regarding running shell script via cron.
The shell script which is required to get value from database.
Below is the main part of shell script.
#/bin/bash
#connect to database(1)
db2 connect to $database user xxxx using yyyy
#set values from... (3 Replies)
Discussion started by: Rohan Kishibe
3 Replies
LEARN ABOUT PHP
pdo_odbc-dsn
PDO_ODBC-DSN(3) 1 PDO_ODBC-DSN(3)PDO_ODBC DSN - Connecting to ODBC or DB2 databases
The PDO_ODBC Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is odbc:. If you are connecting to a database cataloged in the ODBC driver manager or the DB2 catalog, you can
append the cataloged name of the database to the DSN.
o DSN
- The name of the database as cataloged in the ODBC driver manager or the DB2 catalog. Alternately, you can provide a complete
ODBC connection string to connect to a database as described at http://www.connectionstrings.com/.
o UID - The name of the user for the connection. If you specify the user name in the DSN, PDO ignores the value of the user name
argument in the PDO constructor.
o PWD - The password of the user for the connection. If you specify the password in the DSN, PDO ignores the value of the password
argument in the PDO constructor.
Example #1
PDO_ODBC DSN example (ODBC driver manager)
The following example shows a PDO_ODBC DSN for connecting to an ODBC database cataloged as testdb in the ODBC driver manager:
odbc:testdb
Example #2
PDO_ODBC DSN example (IBM DB2 uncataloged connection)
The following example shows a PDO_ODBC DSN for connecting to an IBM DB2 database named SAMPLE using the full ODBC DSN syntax:
odbc:DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=localhost;PORT=50000;DATABASE=SAMPLE;PROTOCOL=TCPIP;UID=db2inst1;PWD=ibmdb2;
Example #3
PDO_ODBC DSN example (Microsoft Access uncataloged connection)
The following example shows a PDO_ODBC DSN for connecting to a Microsoft Access database stored at C:db.mdb using the full ODBC
DSN syntax:
odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\db.mdb;Uid=Admin
PHP Documentation Group PDO_ODBC-DSN(3)