IBM Support

IC81202: CLPPLUS.BAT UNABLE TO PARSE PARENTHESIS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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
    

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\..."
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to v9.7 Fixpack 6                                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in v9.7 Fixpack 6.  This is a client side fix that
    should be applied to the system running CLPPlus.
    

Temporary fix

  • See LOCAL FIX.
    

Comments

APAR Information

  • APAR number

    IC81202

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-02-03

  • Closed date

    2012-10-20

  • Last modified date

    2012-10-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC88599

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC81202

Modified date: 20 October 2012