CLPPLus
in [DB2]
|
From: oddbande on 28 Jun 2010 08:18 On 28 Jun, 14:00, oddbande <odd.ander...(a)ergo.no> wrote: > 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 Skjul sitert tekst > > Vis sitert tekst 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
From: Serge Rielau on 28 Jun 2010 08:19 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
From: The Boss on 28 Jun 2010 12:14 On Jun 28, 2:18 pm, oddbande <odd.ander...(a)ergo.no> wrote: > On 28 Jun, 14:00, oddbande <odd.ander...(a)ergo.no> wrote: > > > > > > > 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 Skjul sitert tekst > > > Vis sitert tekst > > 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 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/docview.wss?rs=180&uid=swg21418442 HTH -- Jeroen
From: oddbande on 29 Jun 2010 04:58 On Jun 28, 6:14 pm, The Boss <nlt...(a)baasbovenbaas.demon.nl> wrote: > On Jun 28, 2:18 pm, oddbande <odd.ander...(a)ergo.no> wrote: > > > > > > > On 28 Jun, 14:00, oddbande <odd.ander...(a)ergo.no> wrote: > > > > 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 Skjul sitert tekst > > > > Vis sitert tekst > > > 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 > > 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/docview.wss?rs=180&uid=swg21418442 > > HTH > > -- > Jeroen- Hide quoted text - > > - Show quoted text - 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
First
|
Prev
|
Pages: 1 2 Prev: Replacing multiple statements with a MERGE Next: db2 sequence to reset automatically |