|
Problem IC88599
|
Status: Closed |
CLPPLUS.BAT UNABLE TO PARSE PARENTHESIS |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
CLPPlus shortcut will fail to startup on Windows systems if it
was installed to a directory which contains a
parenthesis/brackets. For example when installing DB2 (32-bit)
to on a Windows (64-bit) system the default directory will be
"C:\Program Files (x86)\IBM\SQLLIB" instead of "C:\Program
Files\IBM\SQLLIB\bin\clpplus.bat"
Workaround:
Create symbolic link from "C:\Program Files\IBM\SQLLIB" to
"C:\Program Files (x86)\IBM\SQLLIB" if DB2 was installed in the
default directory. Note this command is not available on older
versions of Windows such as XP.
C:\Program Files\IBM>mklink /D SQLLIB "C:\Program Files
(x86)\ibm\SQLLIB"
symbolic link created for SQLLIB <<===>> C:\Program Files
(x86)\ibm\SQLLIB
C:\Program Files\IBM>dir
Volume in drive C has no label.
Volume Serial Number is B028-1A6F
Directory of C:\Program Files\IBM
03/02/2012 12:46 PM <DIR> .
03/02/2012 12:46 PM <DIR> ..
20/06/2011 09:12 AM <DIR> SCM
03/02/2012 12:46 PM <SYMLINKD> SQLLIB [C:\Program Files
(x86)\ibm\SQLLIB
]
20/06/2011 09:11 AM <DIR> tivoli
0 File(s) 0 bytes |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.1 FP2 or subsequent fix pack. *
**************************************************************** |
| Local Fix: |
There are three possible workaround:
(1) Install DB2 to a directory which does not contain brackets
(2) Start CLPPlus from the command line by executing
"clpplus.bat"
(3) If DB2 was installed to "C:\Program Files (x86)\IBM\SQLLIB"
create a symbolic link from
"C:\Program Files\IBM\SQLLIB" to point to the real install
directory
C:\Program Files\IBM>mklink /D SQLLIB "C:\Program Files
(x86)\ibm\SQLLIB"
symbolic link created for SQLLIB <<===>> C:\Program Files
(x86)\ibm\SQLLIB
C:\Program Files\IBM>dir
Volume in drive C has no label.
Volume Serial Number is B028-1A6F
Directory of C:\Program Files\IBM
03/02/2012 12:46 PM <DIR> .
03/02/2012 12:46 PM <DIR> ..
03/02/2012 12:46 PM <SYMLINKD> SQLLIB [C:\Program Files
(x86)\ibm\SQLLIB
Then modify the CLPPLus shortcut to point to "C:\Program
Files\IBM\SQLLIB\BIN\..." |
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 Version 10.1 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.11.2012
17.01.2013
17.01.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
