CLPPLus
in [DB2]
|
From: oddbande on 28 Jun 2010 06:28 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
From: Helmut Tessarek on 28 Jun 2010 07:29 > 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.". 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. */
From: oddbande on 28 Jun 2010 07:33 On 28 Jun, 13:29, Helmut Tessarek <tessa...(a)evermeet.cx> wrote: > > 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.". > > 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. > */ Yes, I run it from a DB2 Command - Administrator - window. /Odd Bjørn A.
From: Helmut Tessarek on 28 Jun 2010 07:50 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. > Yes, I run it from a DB2 Command - Administrator - window. -- Helmut K. C. Tessarek DB2 Performance and Development /* Thou shalt not follow the NULL pointer for chaos and madness await thee at its end. */
From: oddbande on 28 Jun 2010 08:00 On 28 Jun, 13:50, Helmut Tessarek <tessa...(a)evermeet.cx> wrote: > 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. > > > Yes, I run it from a DB2 Command - Administrator - window. > > -- > Helmut K. C. Tessarek > DB2 Performance and Development > > /* > Thou shalt not follow the NULL pointer for chaos and madness > await thee at its end. > */ 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
|
Next
|
Last
Pages: 1 2 Prev: Replacing multiple statements with a MERGE Next: db2 sequence to reset automatically |