X-Spam-Check-By:	sourceware.org
To:	cygwin AT cygwin DOT com
From:	"Hans Horn" <hannes AT 2horns DOT com>
Subject:	Re: accessing db2 v9 from cygwin shell
Date:	Thu, 8 Feb 2007 07:50:33 -0800
Lines:	38
Message-ID:	<eqfgsm$uo0$1@sea.gmane.org>
References:	<eqdjh5$k1c$1 AT sea DOT gmane DOT org>
X-IsSubscribed:	yes
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com

Just in case anybody happens to care:

I found a nice solution to this on 
http://groups.google.ca/group/comp.databases.ibm-db2/browse_thread/thread/f0a561a079408485/dd5fbeba774bf9fe#dd5fbeba774bf9fe, 
basically exporting
export DB2CLP=**$$** during bash startup does the trick!

solong,
H.

"Hans Horn" wrote in message news:eqdjh5$k1c$1 AT sea DOT gmane DOT org...
> 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.
> 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. 




--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -