Professional Web Applications Themes

Environment Variables - IBM DB2

How do I find a list of ALL environment variables, their meaning, and their options? Windows 32, v8.1.2 Stan...

  1. #1

    Default Environment Variables

    How do I find a list of ALL environment variables, their meaning, and their options?

    Windows 32, v8.1.2

    Stan
    Stanley Guest

  2. #2

    Default Re: Environment Variables

    Have a look at the DB2 UDB V8.1 Administration Guide - Performance Volume. There is an appendix there which lists Environment and Registry variables.
    That is where I would start.

    --

    Bob
    Consulting I/T Specialist
    IBM Toronto Lab
    IBM Software Services for Data Management
    [My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]
    "Stanley Sinclair" <net> wrote in message news:google.com...
    How do I find a list of ALL environment variables, their meaning, and their options?

    Windows 32, v8.1.2

    Stan
    Bob Guest

  3. #3

    Default Re: Environment Variables

    Thanks, Bob,

    I found loads of valuable environmental variables through the Control
    Center Configuration Advisor.

    But IBM is very fond of making new env vars for every program or
    add-in, and I cannot find those secret variables.

    I installed Net Search Extender (NSE), and find that the Extenders
    have a gizillion env vars of their own. All of which are hidden
    without any information in help files or doentation.

    For example, NSE needs to have variables set. There are either no
    defaults, or no way to find what the variables are, nor their options,
    nor what they do.

    Trying to setup NSE gives an error message, "Environment Variable
    DB2DBDFT Not Set." There is no reference to DB2DBDFT anywhere in any
    doentation.

    Why am I being tortured?

    Stan
    Stanley Guest

  4. #4

    Default Re: Environment Variables

    I am afraid that I cannot help you with NSE - sorry ... but as for DB2DBDFT - which version of DB2 are you using? I did find DB2DBDFT in the V8.1 Admin Guide - Performance Volume as mentioned earlier. In V7.2 it is also found in the same doentation. I cannot comment on the online information as I generally use the doentation as opposed to the Configuration Advisor information etc.

    For your reference:

    DB2DBDFT All Platforms Default=null

    Specifies the database alias name of the database to be used for implicit connects. If an application has no database connection but SQL statements are issued, an implicit connect will be made if the DB2DBDFT environment variable has been defined with a default database.

    Good luck moving forward ...
    --

    Bob
    Consulting I/T Specialist
    IBM Toronto Lab
    IBM Software Services for Data Management
    [My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]
    "Stanley Sinclair" <net> wrote in message news:google.com...
    Thanks, Bob,

    I found loads of valuable environmental variables through the Control
    Center Configuration Advisor.

    But IBM is very fond of making new env vars for every program or
    add-in, and I cannot find those secret variables.

    I installed Net Search Extender (NSE), and find that the Extenders
    have a gizillion env vars of their own. All of which are hidden
    without any information in help files or doentation.

    For example, NSE needs to have variables set. There are either no
    defaults, or no way to find what the variables are, nor their options,
    nor what they do.

    Trying to setup NSE gives an error message, "Environment Variable
    DB2DBDFT Not Set." There is no reference to DB2DBDFT anywhere in any
    doentation.

    Why am I being tortured?

    Stan
    Bob Guest

  5. #5

    Default Re: Environment Variables

    db2set -lr
    lists all supported env vars (it lists db2dbdft, btw).

    db2set -?
    gives help on using db2set

    Entering db2dbdft at the search page produces multiple hits, including this
    one in the SQL Reference:
    An application process in the unconnected state enters the connected state
    when it successfully executes a CONNECT or SET CONNECTION statement. If
    there is no connection in the application but SQL statements are issued, an
    implicit connect will be made provided the DB2DBDFT environment variable has
    been defined with a default database.


    "Stanley Sinclair" <net> wrote in message
    news:google.com... 


    Mark Guest

  6. #6

    Default Re: Environment Variables

    Stanley Sinclair wrote: 

    See the "Administration Guide, Performance" and look in
    Appendix A - "DB2 Registry and Environment Variables".


    Good luck,





    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
    -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
    Ian Guest

  7. #7

    Default Re: Environment Variables

    <<See the "Administration Guide, Performance" and look in Appendix A
    - "DB2 Registry and Environment Variables".>>

    Remember ROFL? That's what you must be doing, because I cannot find
    the above. Ie, I cannot find the Administration Guide at all.

    Please lead me to it from a rebooted computer, with no desktop.
    Windows 2000, db2 V8.1.2.

    Thanks, Stan
    Stanley Guest

  8. #8

    Default Re: Environment Variables

    Stanley - try here on the web - all the manuals are there ...

    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/index..d2w/report

    Going another level down to the SEARCH:

    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/techlib_v8.d2w/report

    Searching on DB2DBDFT for example will give you a list of doentation .... the Admin Guide is in this list:

    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infocenter.d2w/report?target=mainFrame&fn=r0005657.htm

    You should be able to go from there...

    --

    Bob
    Consulting I/T Specialist
    IBM Toronto Lab
    IBM Software Services for Data Management
    [My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]
    "Stanley Sinclair" <net> wrote in message news:google.com...
    <<See the "Administration Guide, Performance" and look in Appendix A
    - "DB2 Registry and Environment Variables".>>

    Remember ROFL? That's what you must be doing, because I cannot find
    the above. Ie, I cannot find the Administration Guide at all.

    Please lead me to it from a rebooted computer, with no desktop.
    Windows 2000, db2 V8.1.2.

    Thanks, Stan
    Bob Guest

  9. #9

    Default Re: Environment Variables

    Stanley Sinclair wrote: 

    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main

    I suppose you can use the DB2 Information Center (not that I can find
    anything in it!), or you can scroll down to download the PDF copy of
    the manuals.


    Good luck,




    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
    -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
    Ian Guest

  10. #10

    Default Re: Environment Variables

    Forget the information center - search on "DB2 Registry and Environment
    Variables"
    at this site: http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

    Stanley Sinclair wrote:
     

    Blair Guest

  11. #11

    Default Re: Environment Variables

    Stanley Sinclair wrote: 

    If you installed the DB2 HTML Doentation CD it's not too bad:

    (With DB2 HTML Doc CD installed): 1. Click Start->Programs->IBM
    DB2->Information->DB2 Doentation Set (opens a browser).

    (Without DB2 HTML Doc CD installed): 1. Open
    http://publib.boulder.ibm.com/infocenter/db2help/ in your web browser.

    Then either 2. Click Reference->Registry and environment
    variables->General registry variables.

    Or 2. Click Index->D->DB2DBDFT

    Dan

    Dan Guest

Similar Threads

  1. Setting Environment Variables
    By nicholas.nicholaides in forum Coldfusion Server Administration
    Replies: 6
    Last Post: May 18th, 07:29 PM
  2. J2EE environment variables
    By StefanPelders in forum Coldfusion Server Administration
    Replies: 0
    Last Post: November 28th, 11:54 AM
  3. HTA environment variables?
    By McKirahan in forum ASP Components
    Replies: 2
    Last Post: September 10th, 07:16 PM
  4. Environment Variables - How to
    By Sarah Tanembaum in forum Windows Server
    Replies: 11
    Last Post: June 28th, 07:51 PM
  5. who interpretes the environment variables
    By ujjwal bhoota in forum UNIX Programming
    Replies: 3
    Last Post: July 10th, 01:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139