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.
My suspicion is that the problem is with changing environments: the quoted line with the backticks opens a subshell and i am not sure if the db2-session extends to this. Try this:
or something similar, which avoids running the db2-command in the subshell.
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
db2_conn_error
DB2_CONN_ERROR(3) 1 DB2_CONN_ERROR(3)db2_conn_error - Returns a string containing the SQLSTATE returned by the last connection attemptSYNOPSIS
string db2_conn_error ([resource $connection])
DESCRIPTION db2_conn_error(3) returns an SQLSTATE value representing the reason the last attempt to connect to a database failed. As db2_connect(3)
returns FALSE in the event of a failed connection attempt, you do not pass any parameters to db2_conn_error(3) to retrieve the SQLSTATE
value.
If, however, the connection was successful but becomes invalid over time, you can pass the $connection parameter to retrieve the SQLSTATE
value for a specific connection.
To learn what the SQLSTATE value means, you can issue the following command at a DB2 Command Line Processor prompt: db2 '? $sqlstate-
value'. You can also call db2_conn_errormsg(3) to retrieve an explicit error message and the associated SQLCODE value.
PARAMETERS
o $connection
- A connection resource associated with a connection that initially succeeded, but which over time became invalid.
RETURN VALUES
Returns the SQLSTATE value resulting from a failed connection attempt. Returns an empty string if there is no error associated with the
last connection attempt.
EXAMPLES
Example #1
Retrieving an SQLSTATE value for a failed connection attempt
The following example demonstrates how to return an SQLSTATE value after deliberately passing invalid parameters to db2_connect(3).
<?php
$conn = db2_connect('badname', 'baduser', 'badpassword');
if (!$conn) {
print "SQLSTATE value: " . db2_conn_error();
}
?>
The above example will output:
SQLSTATE value: 08001
SEE ALSO db2_conn_errormsg(3), db2_connect(3), db2_stmt_error(3), db2_stmt_errormsg(3).
PHP Documentation Group DB2_CONN_ERROR(3)