I have a DB2 9.7 Enterprise Server Edition 32-bits installed on my
laptop - Windows 7 64-bits, and wanted to look into the new CLPPlus
tool. As I can see from the manuals there should be no extra
installation required in order to run CLPPLus, and I can find the
clpplus.bat file in my sqllib\bin directory. But when I try to run it
I get the error message: "\IBM\SQLLIB\BIN\clpplus.bat was unexpected
at this time.".

I try to look in Information Center for a solution but I can find none
related to this particular message. But I cannot find the files
clpplus.jar or jline-0.9.93.jar. Shouldn't these files be installed as
a part of the standard installation?

Regards
Odd Bjørn Andersen,
ErgoGroup AS, Oslo, Norway

Did you run it with the DB2 environment initialized?

Start -> Run > db2cmd

then

\IBM\SQLLIB\BIN\clpplus.bat

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

On 28 Jun, 13:29, Helmut Tessarek <tessa... (AT) evermeet (DOT) cx> wrote:
Yes, I run it from a DB2 Command - Administrator - window.

/Odd Bjørn A.

Hmm, this is strange. Those 2 files you mentioned should be in the
\sqllib\TOOLS directory.

But I just saw from your original post that you are running a 32bit DB2 on a
64bit OS. This is not really supported. Or at least I'm not aware of it. I
didn't even know that you could install a 32bit DB2 on 64bit OS on Windows.

I'm not really a Windows person, so I hope that there are some other people
who can help you with this.

Sorry that I couldn't help.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

On 28 Jun, 13:50, Helmut Tessarek <tessa... (AT) evermeet (DOT) cx> wrote:
OK, thanks anyway.

The reason I have installed it this way (32-bits db2 on a 64-bits
\Windows) is that we are using Proxifier to get access to remote
database servers and Proxifier has problems with 64-bits DB2.

I now can see that the 2 files really exists in sqllib\TOOLS directory
but for some reason clpplus.bat is unable to locate them (I
think....).

Regards
Odd Bjørn

On 28 Jun, 14:00, oddbande <odd.ander... (AT) ergo (DOT) no> wrote:
This is the error message I get:

C:\Program Files (x86)\IBM\SQLLIB\BIN>clpplus
\IBM\SQLLIB\BIN\clpplus.bat was unexpected at this time.

Could it be that the space(s) in the directory name (\Program Files
(x86)) is the reason for this error?

Regards
Odd Bjørn A

Clarification may or my not help put yu n the right path.
CLPPLus is a Java application with no backend.
So there is no need for db2cmd. You ca start it from any shell.
Could it be that your Java setup is messed up?
take a look at the bat file and see if you can invoke CLPPlus directly
using Java.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

On Jun 28, 2:18*pm, oddbande <odd.ander... (AT) ergo (DOT) no> wrote:
I suspect it's the parenthesis characters in the directory name, in
combination with improper/missing quotation marks inside the bat-file.
Here's a Technote about a very similar looking issue outside DB2:
http://www-01.ibm.com/support/docvie...id=swg21418442

HTH

--
Jeroen

On Jun 28, 6:14*pm, The Boss <nlt... (AT) baasbovenbaas (DOT) demon.nl> wrote:
You are probably right. I have looked at the clpplus.bat file, but
since I'm not very familiar with writing advanced batch scripts I have
no chance of knowing where to put those quotation marks. There are
just too much setting of paths in the file...... perhaps I should open
a PMR with IBM Support to have them change it.

Regards
Odd Bjørn