backspace and delete button in command center

[Toralf Kirsten]

Hi,
we installed db2 v8.1 on red hat linux 9.
Unfortunately, the backspace and the delete button doesn't work in the
right way. Instead of deleting chars, control characters are inputed.
That makes it very hard to input sql commands at the db2 command line
prompt.
For example: DB2> connect to aDatabase^?^?^?^?^[[3~^[[3~^[[3~
Is there the possibility to set an option / parameter anywhere?
Thanks, Toralf

[Mark A]

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> wrote in message
news:bv**********@news.uni-leipzig.de...

Hi,
we installed db2 v8.1 on red hat linux 9.
Unfortunately, the backspace and the delete button doesn't work in the
right way. Instead of deleting chars, control characters are inputed.
That makes it very hard to input sql commands at the db2 command line
prompt.
For example: DB2> connect to aDatabase^?^?^?^?^[[3~^[[3~^[[3~
Is there the possibility to set an option / parameter anywhere?
Thanks, Toralf

Are you talking about the GUI Command Center? If so, you are mistaken or you
have serious problems with your java installation (which may not be
surprising since IBM does not support RH9 because of Java issues). Even
though IBM does not support RH9, if you want to use it, I would install IBM
java 1.41 and set the java path with a dbm configuration command. But IBM
support will not help you on that platform if you ever need to contact them.

If you are talking about the command line interface from a terminal window,
that has nothing to do with DB2.

[Toralf Kirsten]

Thanks Mark,
I'm talking about the command line interface not the command center, you
are right.
We installed the java sdk 1.4.1 and set the path to JAVA_HOME.
Unfortunately, the command center doesn't work by calling db2cc - but
that's another topic.
Most of the time I use the command line. But as I said before, when I
can not use the backspace or delete button it is very hard to set up sql
statements.
We use the bash as basic shell, and here the backspace and delete the
button works fine.
Any hints?
Thanks, Toralf

Mark A wrote:

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> wrote in message
news:bv**********@news.uni-leipzig.de...

Hi,
we installed db2 v8.1 on red hat linux 9.
Unfortunately, the backspace and the delete button doesn't work in the
right way. Instead of deleting chars, control characters are inputed.
That makes it very hard to input sql commands at the db2 command line
prompt.
For example: DB2> connect to aDatabase^?^?^?^?^[[3~^[[3~^[[3~
Is there the possibility to set an option / parameter anywhere?
Thanks, Toralf

Are you talking about the GUI Command Center? If so, you are mistaken or you
have serious problems with your java installation (which may not be
surprising since IBM does not support RH9 because of Java issues). Even
though IBM does not support RH9, if you want to use it, I would install IBM
java 1.41 and set the java path with a dbm configuration command. But IBM
support will not help you on that platform if you ever need to contact them.

If you are talking about the command line interface from a terminal window,
that has nothing to do with DB2.

[Mark A]

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> wrote in message
news:bv**********@news.uni-leipzig.de...

Thanks Mark,
I'm talking about the command line interface not the command center, you
are right.
We installed the java sdk 1.4.1 and set the path to JAVA_HOME.
Unfortunately, the command center doesn't work by calling db2cc - but
that's another topic.
Most of the time I use the command line. But as I said before, when I
can not use the backspace or delete button it is very hard to set up sql
statements.
We use the bash as basic shell, and here the backspace and delete the
button works fine.
Any hints?
Thanks, Toralf

To fix your GUI stuff, if you have installed 1.4.1 issue the following
command and restart DB2:
db2 update dbm cfg using JDK_PATH /opt/IBMJava2-14

If you use the basic bash shell you can just prefix each command with db2
and it should work the same.

[Mark A]

"Mark A" <[e-mail]> wrote in message
news:YY**************@news.uswest.net...

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> wrote in message
news:bv**********@news.uni-leipzig.de...

Thanks Mark,
I'm talking about the command line interface not the command center, you
are right.
We installed the java sdk 1.4.1 and set the path to JAVA_HOME.
Unfortunately, the command center doesn't work by calling db2cc - but
that's another topic.
Most of the time I use the command line. But as I said before, when I
can not use the backspace or delete button it is very hard to set up sql
statements.
We use the bash as basic shell, and here the backspace and delete the
button works fine.
Any hints?
Thanks, Toralf

To fix your GUI stuff, if you have installed 1.4.1 issue the following
command and restart DB2:
db2 update dbm cfg using JDK_PATH /opt/IBMJava2-14

If you use the basic bash shell you can just prefix each command with db2
and it should work the same.

I just tried using the Command Line Processor on RH9 accessing DB2 on the
same machine. Backspace works fine, but delete and repeat (up arrow) do not
work properly (produce garbage).

This may have something to so with fact that DB2 for Linux does not support
the bash shell, something that I have complained about previously. ARE YOU
LISTENING IBM??? They want you to use pdksh, but I tried that and it
doesn't work either, especially if you want to use the standard RH9 KDE gui
interface.

I normally just use the Linux command prompt and prefix everything with
"db2".

[Toralf Kirsten]

Mark,
the GUI works now fine. Thanks for your advice.
Unfortunately, there is no pdksh installed on our machine. I have never
used it before and I really don't know that it exists up to now. I'm
just google'ing ;-)
Is there any option / parameter to use the environment from the
underlying shell, because I'd like to use the bash. That's my favorite
shell, too.
Toralf

Mark A wrote:

"Mark A" <[e-mail]> wrote in message

To fix your GUI stuff, if you have installed 1.4.1 issue the following
command and restart DB2:
db2 update dbm cfg using JDK_PATH /opt/IBMJava2-14

If you use the basic bash shell you can just prefix each command with db2
and it should work the same.

I just tried using the Command Line Processor on RH9 accessing DB2 on the
same machine. Backspace works fine, but delete and repeat (up arrow) do not
work properly (produce garbage).

This may have something to so with fact that DB2 for Linux does not support
the bash shell, something that I have complained about previously. ARE YOU
LISTENING IBM??? They want you to use pdksh, but I tried that and it
doesn't work either, especially if you want to use the standard RH9 KDE gui
interface.

I normally just use the Linux command prompt and prefix everything with
"db2".

[PM \(pm3iinc-nospam\)]

I'm not a nix/nux expert but i think you need to do something like
set TERM=...
or export or ...

/usr/share/terminfo

man TERM or info TERM should provide some info.

PM

[Mark A]

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> wrote in message
news:bv**********@news.uni-leipzig.de...

Mark,
the GUI works now fine. Thanks for your advice.
Unfortunately, there is no pdksh installed on our machine. I have never
used it before and I really don't know that it exists up to now. I'm
just google'ing ;-)
Is there any option / parameter to use the environment from the
underlying shell, because I'd like to use the bash. That's my favorite
shell, too.
Toralf

pdksh is public domain ksh and you can find it by searching the web. I tried
it and it did not work correctly and completely messes up the KDE gui on
Linux. So I don't have any solution other than don't use the DB2 Command
Line Processor, just use a Linux command prompt and prefix DB2 commands with
"db2".

Personally, I don't understand how IBM can claim to support Linux and not
support the bash shell. There are other scripts they provide that have
problems with the bash shell also.

[Ian]

Mark A wrote:

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> wrote in message
news:bv**********@news.uni-leipzig.de...

Mark,
the GUI works now fine. Thanks for your advice.
Unfortunately, there is no pdksh installed on our machine. I have never
used it before and I really don't know that it exists up to now. I'm
just google'ing ;-)
Is there any option / parameter to use the environment from the
underlying shell, because I'd like to use the bash. That's my favorite
shell, too.
Toralf

pdksh is public domain ksh and you can find it by searching the web. I tried
it and it did not work correctly and completely messes up the KDE gui on
Linux. So I don't have any solution other than don't use the DB2 Command
Line Processor, just use a Linux command prompt and prefix DB2 commands with
"db2".

Personally, I don't understand how IBM can claim to support Linux and not
support the bash shell. There are other scripts they provide that have
problems with the bash shell also.

Bash will work just fine as a login shell when using DB2.

IBM requires ksh because many of the scripts supplied with DB2 are ksh
scripts. There is nothing that requires your login shell to be ksh, but
it does need to exist on the system to support these other scripts.
Keep in mind that because bash and ksh both will read $HOME/.profile, and
shell-specific modifications to it may cause issues with the db2_all or rah
scripts (if you're using a partitioned environment). You can generally
workaround this by setting the various RAH* environment variables to
appropriate values.
Good luck,


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Mark A]

> "Ian" <ia*****@mobileaudio.com> wrote in message

Bash will work just fine as a login shell when using DB2.
I never suggested otherwise.
IBM requires ksh because many of the scripts supplied with DB2 are ksh
scripts. There is nothing that requires your login shell to be ksh, but
it does need to exist on the system to support these other scripts.
That is the problem that I am complaining about. I personally think this is
unaceptable.
Keep in mind that because bash and ksh both will read $HOME/.profile, and
shell-specific modifications to it may cause issues with the db2_all or rah scripts (if you're using a partitioned environment). You can generally
workaround this by setting the various RAH* environment variables to
appropriate values.
Why should one have to create their own workaround when bash is the default
(and often only) shell for Linux. The Linux GUI will not work without bash.
In any case, any workarounds should be documented by IBM for each and every
script. If pdksh is required it should be in the DB2 distribution with
instructions on how to install and configure it.
Good luck,

One should not have be "lucky" to get DB2 for Linux to work.