|
Problem IC81202
|
Status: Closed |
CLPPLUS.BAT UNABLE TO PARSE PARENTHESIS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* Update to v9.7 Fixpack 6 *
**************************************************************** |
| 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 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in v9.7 Fixpack 6. This is a client side fix that
should be applied to the system running CLPPlus. |
| Workaround |
See LOCAL FIX. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88599
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.02.2012
20.10.2012
20.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
