Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Connection error.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Connection error.
# 1  
Old 11-30-2011
Connection error.
Hi All.

I have a script, in which its throwing me error like
Code:
/data/ds/dpr_ebicm_uat//etl/cm3_0/entities/BBME/parameters/cm_file_util.plg: line 7: export: `exist.=SQL1024N A database connection does not exist. SQLSTATE=08003': not a valid identifier

whereas i have already made a connection, which is working fine. still it shows me this error could you all please help why this is happening.

Thanks
# 2  
Old 11-30-2011
You made the connection but somehow its not successful.
give us more to debug. eg. how do you connecting, which database etc..
# 3  
Old 11-30-2011
I am making the db2 connect with this statement

Code:
db2 -x "connect to ${DB_NAME} user ${DB_USER} using ${DB_PWD}" > ${TMPOUT}

I ran part of the script and found out that the values put in the variables are correct, but still it shows the connection error.

Not able to figure out y
Last edited by Franklin52; 11-30-2011 at 06:12 AM.. Reason: Please use code tags for code and data samples, thank you
# 4  
Old 11-30-2011
Its not just the matter of replacing the variable.
there are couple of more things ( environment variables ) which needs to be set.
I am not sure what are those values for db2 since I have never worked in this database.

May be others can help you.
# 5  
Old 11-30-2011
Can you post the relevant part of the script that reports the error and also all the environment variables you export?

Also, what is in line 7 of your script?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

weblogic connection timeout error

i am facing an issue that the server give a connection timeout after 60 sec for any request more than that number . i tried to increase the TCP INTERVAL TIMEOUT from the default 60000 ms to more higher number. the server seems to work fine and didn't give me the massage of the timeout but the... (0 Replies)
Discussion started by: core99
0 Replies

2. Shell Programming and Scripting

Perl Oracle connection error

I've a Centralized Server which can connect to all Oracle Databases. When I was trying the below code it doesn't work, But tnsping was working fine. #!D:/perl5/bin/perl.exe use DBI; my $dbh = DBI->connect('dbi:Oracle:QBDIWCE', 'IDUSER', 'SECRET123#' ) || die( $DBI::errstr . "\n" ) ; ... (1 Reply)
Discussion started by: ilugopal
1 Replies

3. Solaris

rsync - remote connection error

Hi , We have installed rsync in two Solaris boxes, when we try to sync files from one machine to another.. it is giving the following error. ld.so.1: rsync: fatal: libiconv.so.2: open failed: No such file or directory rsync: connection unexpectedly closed (0 bytes received so far) rsync... (1 Reply)
Discussion started by: MVEERA
1 Replies

4. UNIX for Dummies Questions & Answers

SFTP Connection error

Hi I when I trying to SFTP a file to a server I am getting this below error: Connecting to 3.12.911.100... ssh_askpass: exec(/usr/lib/ssh/ssh-askpass): No such file or directory Host key verification failed. Connection closed Can you please help me in debugging this error. ... (3 Replies)
Discussion started by: krishna87
3 Replies

5. UNIX for Dummies Questions & Answers

winscp error: Network error connection timed out

Hi all, I am trying to winscp to RHEL5 server and i am ending up with following error. Network error:connection timed out The system is up and running but not able to winscp. Tried SFTP,SCP and FTP protocols in winscp but none worked. I can ssh into this server from another server... (3 Replies)
Discussion started by: lramsb4u
3 Replies

6. Solaris

Solaris 10 ftp connection problem (connection refused, connection timed out)

Hi everyone, I am hoping anyone of you could help me in this weird problem we have in 1 of our Solaris 10 servers. Lately, we have been having some ftp problems in this server. Though it can ping any server within the network, it seems that it can only ftp to a select few. For most servers, the... (4 Replies)
Discussion started by: labdakos
4 Replies

7. IP Networking

duplicate connection error

Hello All, I have one multithreaded server program.Due to fluctuating network, my client is getting disconnected, and after some time i received the new connection from same client, which gets treated as duplicate connection for my server. I have kept my tcp keep alive timer is 10 sec. Can... (0 Replies)
Discussion started by: mustus
0 Replies

8. UNIX for Dummies Questions & Answers

Error in connecting PPP connection

when i connect to SCO-Unix from Windows98 through PPP, the terminal window comes up asking for user name and password, when i enter PPP user name and password, it disconnects. kindly help me to sort out the problem in connection. thanks Nagendra Jaiswal (2 Replies)
Discussion started by: nagendrajaiswal
2 Replies

9. UNIX for Advanced & Expert Users

True64 UNIX connection error

On True64 UNIX v5.1B, Patch version: T64V51BB1AS0001-20021229 OSF540. the system log file in mai.log reported the following messages: reject connections on daemon Daemon0: load average:19 reject connections on daemon Daemon0: load average:24 after a period of time, reported the following... (0 Replies)
Discussion started by: Frank2004
0 Replies

10. UNIX for Advanced & Expert Users

ssh connection error

I am trying to get my CVS client to connect to the repository over ssh. ssh works - I can quite happily log on but when I use the client - which incidentally is eclipse 2.1.3 on Windows using plink/puTTY as an external connection method - I get the following error in /var/log/secure: error:... (2 Replies)
Discussion started by: Jdogg
2 Replies
Login or Register to Ask a Question