Pinned topic DB2 Command Window with cygwin on Windows
"C:\Program Files\IBM\SQLLIB\BIN\db2cmd.exe" /i /c C:\cygwin\cygwin.bat
Version 9 starts now with the same shortcut, but I get the following error.
Same error on a local database.
Does anyone have this working.
$ db2 connect to dbname user xxxx
Enter current password for xxxx:
Database Connection Information
Database server = DB2/AIX64 9.1.0
SQL authorization ID = xxxx
Local database alias = xxxx
$ db2 list tables
SQL1024N A database connection does not exist. SQLSTATE=08003
rchase 0600005BBN364 PostsACCEPTED ANSWER
Re: DB2 Command Window with cygwin on Windows2006-08-10T18:27:47Z in response to SystemAdminHello,
There is a thread on this same issue in the DB2 Viper forum, here's a link to the original thread: http://www-128.ibm.com/developerworks/forums/dw_thread.jsp?forum=842&thread=130560&cat=19
here's a quick summary:
DB2 v9 has a different mechanism to figure out the PPID for a process. Try the following in the bash shell:
then run the DB2 commands
DB2 Express Community team
melman74 270000FUHH1 PostACCEPTED ANSWER
Re: DB2 Command Window with cygwin on Windows2013-12-14T23:16:15Z in response to rchase
Hi, I'm trying to use this same solution for db210.5 and am getting the same issue, namely that the "db2 connect to sample" immediately followed by "db2 list tables" no longer works as below:jeff@hplaptop2013 ~$ db2 connect to sampleDatabase Connection InformationDatabase server = DB2/NT64 10.5.1SQL authorization ID = JEFFLocal database alias = SAMPLEjeff@hplaptop2013 ~$ db2 list tablesSQL1024N A database connection does not exist. SQLSTATE=08003I did put the "export DB2CLP=**$$**" line in my .bashrc.
Any ideas on how to make this work on cygwin for the latest DB2 express-c for windows?
Thanks for your help,