By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,018 Members | 930 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,018 IT Pros & Developers. It's quick & easy.

accessing db2 v9 from within cygwin shell

P: n/a
Folks,

I used to be able to access db2 (v8 and prior) from within a cygwin bash
shell after doing some tricks with the DB2CLP variable (see
http://www.cygwin.com/ml/cygwin/2003-02/msg00635.html).

e.g. (w/i bash shell):
export DB2CLP=$CLP_SAVE # saved during db2cmd session

db2 connect to mydb
db2 list tables for all
db2 terminate
With db2 v9 this doesn't work anymore, as the db2 connection seems to be
gone after "db2 connect to mydb": when issuing "db2 list tables for all" I
get now a nasty:
"SQL1024N A database connection does not exist. SQLSTATE=08003"

does anybody know a workaround?
Or do I really have to use that db2cmd abomination?

thx,
H.
Feb 7 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hans Horn wrote:
I used to be able to access db2 (v8 and prior) from within a cygwin bash
shell after doing some tricks with the DB2CLP variable (see
http://www.cygwin.com/ml/cygwin/2003-02/msg00635.html).
I don't know about prior versions - after all their support ended long time ago...

For V9 I use:

export DB2CLP=**$$**

in my .bashrc and I an (relatively) happy...
Do you *really* need a solution for V8?

Jan M. Nelken
Feb 7 '07 #2

P: n/a
Jan,

that works amazings well - thx a bunch!

As to V8, I had a cumbersome solution (described in the 2003 post), so I'm
still in business there!

thx again,
Hans

"Jan Nelken" wrote in message news:52*************@mid.individual.net...
Hans Horn wrote:
>I used to be able to access db2 (v8 and prior) from within a cygwin bash
shell after doing some tricks with the DB2CLP variable (see
http://www.cygwin.com/ml/cygwin/2003-02/msg00635.html).

I don't know about prior versions - after all their support ended long
time ago...

For V9 I use:

export DB2CLP=**$$**

in my .bashrc and I an (relatively) happy...

Do you *really* need a solution for V8?

Jan M. Nelken

Feb 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.