Topic
4 replies Latest Post - ‏2010-08-26T08:44:14Z by manshanb
PatrickZeng
PatrickZeng
3 Posts
ACCEPTED ANSWER

Pinned topic why does clpplus require X11 DISPLAY

‏2010-08-25T15:11:14Z |
I tried to start clpplus and it required X11 Display. Why? Isn't it jsut a command line tool?

db2dba@va2apsap170/db2/db2dba/dba/script>clpplus db2dba@localhost:60000/dba

No X11 DISPLAY variable was set, but this program performed an operation which requires it.
DB250006E: Command Line Processor Plus (CLPPlus) failed to start.

db2dba@va2apsap170/db2/db2dba/dba/script>db2level
DB21085I Instance "db2dba" uses "64" bits and DB2 code release "SQL09072" with
level identifier "08030107".
Informational tokens are "DB2 v9.7.0.2", "special_24281", "IP23082_24281", and
Fix Pack "2".
Product is installed at "/db2/db2dba/db2_software".

Any help is appreciated. Thanks!

  • Patrick
Updated on 2010-08-26T08:44:14Z at 2010-08-26T08:44:14Z by manshanb
  • PatrickZeng
    PatrickZeng
    3 Posts
    ACCEPTED ANSWER

    Re: why does clpplus require X11 DISPLAY

    ‏2010-08-25T15:18:09Z  in response to PatrickZeng
    one more question, is it required to do
    db2set DB2_COMPATIBILITY_VECTOR=ORA
    if I just need to use clpplus to do some formating? I don't need PL/SQL feature.

    Thanks.
    • manshanb
      manshanb
      6 Posts
      ACCEPTED ANSWER

      Re: why does clpplus require X11 DISPLAY

      ‏2010-08-26T08:44:14Z  in response to PatrickZeng
      Hi Patrick,

      You don't need to set DB2_COMPATIBILITY_VECTOR in order to use CLPPlus functionalities. As long as you don't use PL/SQL features, you should be able to connect and work with DB2 databases without this parameter being set to ORA.

      Thanks
      Mangesh
  • PatrickZeng
    PatrickZeng
    3 Posts
    ACCEPTED ANSWER

    Re: why does clpplus require X11 DISPLAY

    ‏2010-08-25T19:06:52Z  in response to PatrickZeng
    Got a solution from DB2 support:

    Need to use -nw option for clpplus since 9.7 FP2, otherwise by default it's going to use GUI mode.
  • manshanb
    manshanb
    6 Posts
    ACCEPTED ANSWER

    Re: why does clpplus require X11 DISPLAY

    ‏2010-08-26T08:23:23Z  in response to PatrickZeng
    Hi Patrick,

    We introduced the CLPPlus window(GUI) in V97 FP2 release and made it as default mode. Hence you need to have XServer running on your machine in order to invoke CLPPlus in default mode. clpplus with '-nw' option will take you to the console mode of CLPPlus which doesn't require XServer running on your machine.

    Thanks
    Mangesh