database development with SSH-Connect

[Marius Müller]

Hi,

maybe someone is able to answer, because i dont know how to solve the
problem.

i study database with db2 (IBM). the server is a Windows2000-Server where i
are able to use the database.

the problem is that i have to use the database from everywhere i can and i
want to use the command line processor.

if i use telnet or ssh to connet to database server i am not able to start
db2cmd.exe because db2cmd.exe will open a new window, but this is not
possible with ssh/telnet.

maybe someone will tell me, what is initialized, wenn i call db2cmd.exe and
why there is a new window opened. Am I able to initialize self something so
no new window will appear an i will be able to use the database command
processor with telnet/ssh.

Thank you for answering.

[Thomas Rask]

I would suggest that you use remote desktop. It will require that
terminal services are installed on the server. Clients are available
as Open Source for various Unix'es.

Thomas

[Sherman Lau]

Hi,

Can you try "db2cmd /w /i" in the telnet session?

Sherman

"Marius Müller" <askfor...@gmx.de> wrote in message
news:15alscwqxpvrh.d...@40tude.net...

[Marius Müller]

On Wed, 21 May 2003 21:23:39 +0200, Thomas Rask wrote:

> I would suggest that you use remote desktop. It will require that
> terminal services are installed on the server. Clients are available
> as Open Source for various Unix'es.
>

if i understand.... you think about something like VPN (virtual private
network)???? ok, thats possible, if i could use it, but it is not
usable....

and i m not able to install something like this on server with database.

is it not possible in another way?

[Thomas Rask]

From an earlier posting by Horst Rechner (Horst....@gmx.de)
2003-01-08 11:19:02 PST

=====================================================================

Hello,

I have a question regarding the remote access of the DB2 7.2 DB2CLP
Interface under Windows 2k. The SSH Server is OpenSSH.

Here is the approach:
---------------------

When I log into the Windows Box and try to start SQLLIB\BIN\DB2.EXE I
get the error:

DB21061E Die Befehlszeilenumgebung wurde nicht initialisiert.
(command line environment could not be initialized)

my next step was

db2cmd.exe DB2CLP.BAT DB2.EXE -t

which started a new console on the remote machine outside my SSH
client
and that was it.

(by the way: the DB2CMD approach does not work either, even when using
db2cmd /c /w /i db2 myCommand > myOutput
because OpenSSH is starting a new shell every time you issue this
command, and after a while, you have 1M shells open)

Then I took a closer look at the environment variables set by
DB2CMD.EXE, and pasted them into my remote SSH window as set
statements
but nothing helped. I always got DB21061E.

My last try was VNCing into the remote machine, starting a normal CLP
with the windows shortcut, and then using the environment variable
which
was set as

DB2CLP=1234567890

to paste it into my SSH client window. And guess: It actually worked!

So here is the question:
------------------------

How do you get this DB2CLP-"ID" by command line in a NT shell without
having to start this infernal DB2-SHell?

=====================================================================

Hope that it helps...

Thomas

[Marius Müller]

On Wed, 21 May 2003 15:44:20 -0400, Sherman Lau wrote:

> Hi,
>
> Can you try "db2cmd /w /i" in the telnet session?

yes, it is possible. if i enter db2 after your command, i am able to
connect to my database, but now there is the problem:

i connect with following command: connect to databasename user username
<ENTER>
ENTER YOUR PASSWORD FOR username: password_of_username <ENTER>

Password is not written with "*****", it is writen clearly e.g.
"123password".

and the database does not answer, but i dont know exactly, wheter the
database is in use of administration.

maybe the password-display can be changed?

Thank you for your hint.

maybe you could explain, what is the meaning of the parameters /w and /i.
i searched with www.google.de but i dont find some answer, but other
problem like mine.

[sha...@us.ibm.com]

Hi Marius,
db2 is a client / server database.
Why not connect to the remote database from (any) client?

[Marius Müller]

On Wed, 21 May 2003 15:23:56 -0700, sha...@us.ibm.com wrote:

> Hi Marius,
> db2 is a client / server database.
> Why not connect to the remote database from (any) client?
>

because i am not able to connect to the server without registering at
login-Server, that is another server as db2-Server.

I have to login at the login-server and to ssh to the db2server, where i
can start db2cmd.exe or something like this.

Maybe, if you have a idea, how it would be possible, tell it and i will try
it.

thanks