** ============================================================================ ** ** Sample response file for IBM DB2 ** -------------------------------- ** To select features and settings to install, uncomment the corresponding ** keywords and specify values for those keywords. You do not need to select ** features if you select the TYPICAL or COMPACT installation options. ** ** Comments are made by placing either an asterisk (*) or a hash symbol (#) at ** the start of a line, or by placing ** or ## after the start of a line to ** comment out the rest of that line. ** All keywords that are currently uncommented (not preceded by * or #) are ** mandatory and must be assigned values for the installation to continue. ** All other keywords are optional. If optional keywords are not specified, ** the installation will proceed using default values. Lines that start out ** with two asterisks are documentation and should not be enabled. ** For more information on configuration parameters, see "Configuring the DB2 database manager with ** configuration parameters" in the DB2 Information Center. ** ** For more information on DB2 registry and environment variables, and configuration ** parameters, see "DB2 registry and environment variables" in the DB2 Information Center. ** ** For more information on how to perform a response file installation, see ** "Response file considerations" in the DB2 Information Center. ** ** Refer to the DB2 Information Center at: ** http://publib.boulder.ibm.com/infocenter/db2luw/v10r1 ** ** ============================================================================ ** General Options ** --------------- ** Only one product can be specified for the following PROD keyword. Specifying ** multiple products in an installation is not supported. PROD = CLIENT ** The FILE keyword determines the base installation path. If you specify a ** path that does not yet have any DB2 product installed, this will install a ** new copy. Otherwise, this will install the product to the same copy. This ** is an optional keyword. *FILE = C:\Program Files\IBM\SQLLIB ** Modify the value of the following LIC_AGREEMENT keyword to indicate that you ** have read and agreed to the license agreement file in the db2/license ** directory on the CD. LIC_AGREEMENT = DECLINE ** ACCEPT or DECLINE ** INSTALL_TYPE keyword is used to select the installation type. If you specify ** a TYPICAL or a COMPACT install type, no COMP keywords are required. In this ** case the installer will select the appropriate components for you. All COMP ** keywords are ignored by the installer unless the INSTALL_TYPE is set to ** CUSTOM. If you select the CUSTOM install type, then ensure that you enable ** all of the COMP keywords that are required for your database environment. ** ** Note: The install type is not related to the language selection. ** ---------------------------------------------------------------------------- INSTALL_TYPE = TYPICAL ** TYPICAL, COMPACT, CUSTOM ** The following components are part of all TYPICAL installations. If you ** perform a typical installation, all of these components will be installed on ** your computer. ** ---------------------------------------------------------------------------- ** DB2 Update Service is a Web tool that lists the available DB2 product ** updates, and provides details about product updates. The DB2 Update Service ** requires an Internet connection. *COMP = DB2_UPDATE_SERVICE ** DB2 Update Service ** First Steps is a graphical tool that will help familiarize you with DB2 ** features and functions. *COMP = FIRST_STEPS ** First Steps ** JDBC Support allows Java samples, not containing embedded SQL (SQLJ), to be ** built and run using the JDBC driver. *COMP = JDBC_SUPPORT ** JDBC Support ** The IBM Software Development Kit (SDK) for Java(TM) provides the support ** required to use Java-based tools, and to create and run Java applications, ** including stored procedures and user-defined functions. *COMP = JDK ** IBM Software Development Kit (SDK) for Java(TM) ** LDAP Exploitation allows DB2 to use an LDAP directory to store database ** directory and configuration information. *COMP = LDAP_EXPLOITATION ** LDAP Exploitation ** OLE DB Support provides a set of interfaces that allow applications to ** uniformly access data stored in different data sources. *COMP = OLE_DB_SUPPORT ** OLE DB Support ** The Replication Tools help you administer, operate, and monitor SQL and Q ** replication. *COMP = REPL_CLIENT ** Replication Tools ** Spatial Extender Client provides the support required for communicating with ** a Spatial Extender Server. *COMP = SPATIAL_EXTENDER_CLIENT_SUPPORT ** Spatial Extender Client ** SQLJ Support allows you to run Java(TM) samples that contain embedded SQL ** (SQLJ) using the JDBC driver. *COMP = SQLJ_SUPPORT ** SQLJ Support ** The following components are not part of TYPICAL installations, and thus can ** only be installed through CUSTOM installs. ** ---------------------------------------------------------------------------- ** The Base Application Development Tools component contains tools and files ** (including header files, libraries, and a precompiler) that are needed for ** developing applications that work with DB2. *COMP = APPLICATION_DEVELOPMENT_TOOLS ** Base Application Development Tools ** The IBM Data Server Provider for .NET is an extension of the ADO.NET ** interface. With the IBM Data Server Provider for .NET, your .NET ** applications can quickly and securely access data from DB2 and IDS ** databases. *COMP = DOTNET_DATA_PROVIDER ** IBM Data Server Provider for .NET ** ODBC Support provides support for applications that use Open Database ** Connectivity (ODBC) to access data. *COMP = ODBC_SUPPORT ** ODBC Support ** The following languages apply to all translated components. Enable the ** language(s) you want installed. If you do not enable any language keywords, ** then the English language (EN) will still be installed by default. ** --------------------------------------------------------------------------- *LANG = BR ** Portuguese - Brazil (pt_BR) *LANG = CN ** Simplified Chinese (zh_CN) *LANG = CZ ** Czech (cs_CZ) *LANG = DE ** German (de_DE) *LANG = DK ** Danish (da_DK) *LANG = ES ** Spanish (es_ES) *LANG = FI ** Finnish (fi_FI) *LANG = FR ** French (fr_FR) *LANG = IT ** Italian (it_IT) *LANG = JP ** Japanese (ja_JP) *LANG = KR ** Korean (ko_KR) *LANG = NO ** Norwegian (no_NO) *LANG = PL ** Polish (pl_PL) *LANG = SE ** Swedish (sv_SE) *LANG = TW ** Traditional Chinese (zh_TW) ** Upgrade Older Release ** --------------------- ** Specify whether you want to upgrade any previous versions of the product. ** Specifying this keyword will remove any previous version and upgrade any ** settings to the new installation. Be aware that during upgrade of the ** current copy, only the product specified in the response file will be ** installed. Other previously installed products need to be upgraded ** separately following this upgrade. *UPGRADE_PRIOR_VERSIONS = FALSE ** TRUE or FALSE ** Copy Name ** --------- ** The copy name is the identifier used to refer to the set of DB2 products ** installed in the same location. You can choose to use this copy as the ** default DB2 copy on the computer. The default DB2 copy is used by ** applications that are not explicitly enabled to use a different copy of DB2. ** You can also choose to use this copy as the default IBM database client ** interface copy. If so, the IBM database client interface (ODBC/CLI driver ** and .Net data provider) in the copy will be the default drivers used by ** applications. For more information refer to the DB2 Documentation. *DB2_COPY_NAME = DB2COPY1 ** char(64) *DEFAULT_COPY = NO ** YES or NO. Default is NO unless this is the only DB2 copy installed. *DEFAULT_CLIENT_INTERFACE_COPY = NO ** YES or NO. Default is the value of the DEFAULT_COPY keyword. ** Start-up Options ** ---------------- ** Automatically start the DB2 governor service on startup *AUTOSTART_GOVERNOR = NO ** YES or NO ** Automatically start the DB2 First Steps on startup *AUTOSTART_FIRST_STEPS = YES ** YES or NO ** Restart the system when the installation has completed. *REBOOT = NO ** YES or NO ** If you have an existing version of DB2 that is running, and this keyword is ** set to YES, your running DB2 processes are terminated without prompt. *KILL_PROCESSES = NO ** YES or NO ** Shortcuts ** --------- ** Specify whether you want to create icon shortcuts. *CREATE_ICONS = YES ** YES or NO ** User Account to be Registered for Performance Monitor ** ----------------------------------------------------- *REMOTE_PERF_COUNT_UID = ** char() userID *REMOTE_PERF_COUNT_PWD = ** char() password ** OLE DB GUID ** ----------- ** You can specify a GUID to use for the OLE DB provider. If you don't specify ** this keyword, it will be generated by the DB2 Installer. *OLEDB_GUID = {1F4977CD-F1A9-490c-8378-F43DA39C0261} ** Instance Creation Settings ** -------------------------- ** Default instance of the current DB2 copy. Its value should be set to the ** prefix name of a DB2 instance that exists in the response file. DEFAULT_INSTANCE = DB2_INST ** char(8) no spaces ** Prefix name of one instance set. To create or update an instance, one set of ** instance keywords must be specified. The instance set is comprised of the ** identifying prefix value for the INSTANCE key followed by the keys that are ** prefixed by the specified INSTANCE prefix value. INSTANCE = DB2_INST ** char(8) no spaces ** Real name of the instance. It can be different from the value of the ** INSTANCE keyword DB2_INST.NAME = DB2 ** char(8) no spaces *DB2_INST.TYPE = CLIENT ** CLIENT *DB2_INST.CLIENT_IMPORT_PROFILE = ** a full path or a file in the same directory as the response file *DB2_INST.AUTHENTICATION = SERVER ** CLIENT, SERVER, or SERVER_ENCRYPT ** Text Search Configuration ** ------------------------- ** IBM Secure Shell Configuration ** ------------------------------ ** Instance DBM CFG Settings ** ------------------------- *DB2_INST.CATALOG_NOAUTH = ** 0, 1, YES or NO *DB2_INST.CLUSTER_MGR = ** TSA, VENDOR:<fully qualified vendor library> *DB2_INST.DFT_ACCOUNT_STR = ** BLANK or char(25) *DB2_INST.DIAGLEVEL = ** 0 - 4 *DB2_INST.DIAGPATH = ** BLANK or char(215) *DB2_INST.DIAGSIZE = ** A value specified in MB and limited by the available disk space in DIAGPATH. Minimum 2 MB must be specified. *DB2_INST.INSTANCE_MEMORY = AUTOMATIC ** AUTOMATIC or a number in range [0, 1000000] for 32-bit and [0, 68719476736] for 64-bit *DB2_INST.HEALTH_MON = ** default is ON; ON or OFF *DB2_INST.FED_NOAUTH = NO ** YES or NO, default is NO *DB2_INST.DIR_CACHE = ** YES or NO *DB2_INST.DISCOVER = ** DISABLE, KNOWN or SEARCH *DB2_INST.DISCOVER_COMM = ** BLANK or NETBIOS, TCPIP *DB2_INST.DISCOVER_INST = ** ENABLE or DISABLE *DB2_INST.JDK_PATH = ** BLANK or char(255) *DB2_INST.SSL_SVR_KEYDB = ** BLANK or char(1023) *DB2_INST.SSL_SVR_STASH = ** BLANK or char(1023) *DB2_INST.SSL_SVR_LABEL = ** BLANK or char(1023) *DB2_INST.SSL_SVCENAME = ** BLANK or char(14) *DB2_INST.SSL_CIPHERSPECS = ** BLANK or char(255) *DB2_INST.SSL_VERSIONS = ** BLANK or char(255) *DB2_INST.SSL_CLNT_KEYDB = ** BLANK or char(1023) *DB2_INST.SSL_CLNT_STASH = ** BLANK or char(1023) *DB2_INST.ALTERNATE_AUTH_ENC = ** NOT_SPECIFIED, AES_ONLY, AES_CMP *DB2_INST.NNAME = ** BLANK or char(8) *DB2_INST.ROUTE_OBJ_NAME = ** BLANK or char(255) *DB2_INST.RQRIOBLK = ** 4096 - 65535 *DB2_INST.SYSADM_GROUP = ** BLANK or char(30) *DB2_INST.SYSCTRL_GROUP = ** BLANK or char(30) *DB2_INST.SYSMAINT_GROUP = ** BLANK or char(30) *DB2_INST.TP_MON_NAME = ** BLANK or char(19) ** Instance Profile Registry Settings ** ---------------------------------- *DB2_INST.DB2ACCOUNT = ** BLANK or char(199) *DB2_INST.DB2BQTIME = ** BLANK or 1 - MAX *DB2_INST.DB2BQTRY = ** BLANK or 0 - MAX *DB2_INST.DB2CHKPTR = ** BLANK, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2_INST.DB2CLIINIPATH = ** BLANK or char(260) *DB2_INST.DB2CODEPAGE = ** BLANK or 0 - MAX *DB2_INST.DB2COUNTRY = ** BLANK or 1 - 999 *DB2_INST.DB2DBDFT = ** BLANK or char(8) *DB2_INST.DB2DEFPREP = ** BLANK, ALL, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2_INST.DB2DISCOVERYTIME = ** BLANK or 20 - MAX *DB2_INST.DB2DMNBCKCTLR = ** BLANK, ? or char() *DB2_INST.DB2INCLUDE = ** BLANK or char() *DB2_INST.DB2IQTIME = ** BLANK or 1 - MAX *DB2_INST.DB2LOCK_TO_RB = ** BLANK or STATEMENT *DB2_INST.DB2NOEXITLIST = ** BLANK, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2_INST.DB2OPTIONS = ** BLANK or -/+[a,c,e[c,s],n,o,p,s,t,v,w,x] and/or -[f,l,r,z]filename *DB2_INST.DB2RQTIME = ** BLANK or 1 - MAX *DB2_INST.DB2_SET_MAX_CONTAINER_SIZE = ** -1 (no limit) or any integer greater than 64MB *DB2_INST.DB2SORCVBUF = ** BLANK or 1024 - 65536 *DB2_INST.DB2SOSNDBUF = ** BLANK or 1024 - 65536 *DB2_INST.DB2_FORCE_NLS_CACHE = ** BLANK, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2_INST.DB2_GRP_LOOKUP = ** BLANK or char() *DB2_INST.DB2INSTOWNER = ** BLANK or char(20) *DB2_INST.DB2DBMSADDR = ** BLANK or char(10) *DB2_INST.DB2_DISABLE_FLUSH_LOG = ** BLANK or ON, OFF *DB2_INST.DB2LOCALE = ** BLANK or YES, NO *DB2_INST.DB2DOMAINLIST = ** BLANK or char() *DB2_INST.DB2NODE = ** BLANK or YES NO *DB2_INST.DB2_USE_PAGE_CONTAINER_TAG = ** BLANK or ON *DB2_INST.DB2TCPCONNMGRS = ** BLANK or 1 - 8 *DB2_INST.DB2_PARTITIONEDLOAD_DEFAULT = ** BLANK or YES, NO *DB2_INST.DB2_INLIST_TO_NLJN = ** BLANK or YES, NO *DB2_INST.DB2_XBSA_LIBRARY = ** BLANK or char() *DB2_INST.DB2LDAP_SEARCH_SCOPE = ** BLANK LOCAL DOMAIN GLOBAL *DB2_INST.DB2ADMINSERVER = ** BLANK or char(64) *DB2_INST.DB2REMOTEPREG = ** BLANK or char(64) *DB2_INST.DB2_ANTIJOIN = ** BLANK or YES, NO, EXTEND *DB2_INST.DB2_COLLECT_TS_REC_INFO = ** BLANK or YES, NO *DB2_INST.DB2PROCESSORS = ** BLANK or 1 - MAX *DB2_INST.DB2ASSUMEUPDATE = ** BLANK or ON, OFF *DB2_INST.DB2_SKIPDELETED = ** BLANK or ON, OFF *DB2_INST.DB2_SQLROUTINE_PREPOPTS = ** BLANK or char() *DB2_INST.DB2_INDEX_TYPE2 = ** BLANK or ON, OFF *DB2_INST.DB2_APM_PERFORMANCE = ** BLANK or ON, OFF *DB2_INST.DB2_FMP_COMM_HEAPSZ = ** BLANK or 1 - MAX *DB2_INST.DB2_EVALUNCOMMITTED = ** BLANK or YES, NO *DB2_INST.DB2_NO_FORK_CHECK = ** BLANK or ON, OFF *DB2_INST.DB2CONSOLECP = ** BLANK or 1 - MAX *DB2_INST.DB2HTSTACKOPTIMIZATION = ** BLANK or 0 - 2 *DB2_INST.DB2_KEEPTABLELOCK = ** BLANK or ON, OFF *DB2_INST.DB2GRAPHICUNICODESERVER = ** BLANK or ON, OFF *DB2_INST.DB2_MINIMIZE_LISTPREFETCH = ** BLANK or YES, NO *DB2_INST.DB2_TRUSTED_BINDIN = ** BLANK or ON, OFF, CHECK *DB2_INST.DB2_CLPPROMPT = ** BLANK or char(99) *DB2_INST.DB2_FORCE_APP_ON_MAX_LOG = ** BLANK or TRUE, FALSE *DB2_INST.DB2_CLP_EDITOR = ** BLANK or char() *DB2_INST.DB2_CLP_HISTSIZE = ** BLANK or 1 - 500 *DB2_INST.DB2_LOAD_COPY_NO_OVERRIDE = ** BLANK or LOCAL, DOMAIN, GLOBAL *DB2_INST.DB2_MAX_NON_TABLE_LOCKS = ** BLANK or 1 - MAX *DB2_INST.DB2_USE_ALTERNATE_PAGE_CLEANING = ** BLANK or ON, OFF *DB2_INST.DB2_SCATTERED_IO = ** BLANK or ON, OFF *DB2_INST.DB2_NO_MPFA_FOR_NEW_DB = ** BLANK or YES, NO *DB2_INST.DB2_OBJECT_TABLE_ENTRIES = ** BLANK or 0 - 50000 *DB2_INST.DB2_VIEW_REOPT_VALUES = ** BLANK or YES, NO *DB2_INST.DB2_SELUDI_COMM_BUFFER = ** BLANK or ON, OFF *DB2_INST.DB2INSTPROF = ** ProgramData\IBM\DB2\ on Windows Vista, and Documents and Settings\All Users\Application Data\IBM\DB2 on Windows 2003 or XP *DB2_INST.DB2_ENABLE_AUTOCONFIG_DEFAULT = ** BLANK, YES, NO *DB2_INST.DB2_OPT_MAX_TEMP_SIZE = ** BLANK or 0 - MAX *DB2_INST.DB2RCMD_LEGACY_MODE = ** YES, ON, TRUE, 1 or NO, OFF, FALSE, 0 *DB2_INST.DB2_LARGE_PAGE_MEM = ** *, DB *DB2_INST.DB2_MEM_TUNING_RANGE = ** a sequence of percentages n, m where n=minfree and m=maxfree *DB2_INST.DB2_MAX_LOB_BLOCK_SIZE = 0 ** 0 - 21487483647 *DB2_INST.DB2AUTH = ** BLANK or char() *DB2_INST.DB2CONNECT_DISCONNECT_ON_INTERRUPT = NO ** YES, TRUE, 1 or NO, FALSE, 0 *DB2_INST.DB2CONNECT_ENABLE_EURO_CODEPAGE = ** BLANK or char() *DB2_INST.DB2FCMCOMM = TCPIP4 ** TCPIP4 or TCPIP6 *DB2_INST.DB2FFDC = ** BLANK, ON, CORE:OFF *DB2_INST.DB2INSTDEF = DB2 ** BLANK or char() *DB2_INST.DB2LOADFLAGS = ** BLANK or char() *DB2_INST.DB2PATH = ** varies by operating system *DB2_INST.DB2TCP_CLIENT_CONTIMEOUT = 0 ** 0 - 32767 *DB2_INST.DB2TCP_CLIENT_RCVTIMEOUT = 0 ** 0 - 32767 *DB2_INST.DB2TRC_DEF_BUFFSIZE = ** BLANK or char() *DB2_INST.DB2YIELD = ** BLANK or char() *DB2_INST.DB2_ASYNC_IO_MAXFILOP = MAXFILOP ** MAXFILOP - MAX *DB2_INST.DB2_BAR_AUTONOMIC_DISABLE = ** BLANK or char() *DB2_INST.DB2_CONNRETRIES_INTERVAL = ** BLANK or char() *DB2_INST.DB2_DXX_PATHS_ALLOWED_READ = ** BLANK or char() *DB2_INST.DB2_DXX_PATHS_ALLOWED_WRITE = ** BLANK or char() *DB2_INST.DB2_HADR_BUF_SIZE = 2*LOGBUFSZ ** BLANK or 0 - MAX *DB2_INST.DB2_LOGGING_DETAIL = ** BLANK or char() *DB2_INST.DB2_MAP_XML_AS_CLOB_FOR_DLC = NO ** YES, NO *DB2_INST.DB2_MAX_CLIENT_CONNRETRIES = ** BLANK or char() *DB2_INST.DB2_MAX_INACT_STMTS = ** 0 - 4294967296 *DB2_INST.DB2_MDC_ROLLOUT = IMMEDIATE ** DEFER, IMMEDIATE or OFF *DB2_INST.DB2_MINIMUM_CLIENT_LEVEL = ** BLANK or char() *DB2_INST.DB2_RESOURCE_POLICY = ** valid path to configuration file *DB2_INST.DB2_SKIPINSERTED = OFF ** ON, OFF *DB2_INST.DB2_SMS_TRUNC_TMPTABLE_THRESH = ** -1, 0-n where n is the number of extents per container that are to be maintained *DB2_INST.DB2_SNAPSHOT_NOAUTH = ** BLANK or char() *DB2_INST.DB2_TAPEMGR_TAPE_EXPIRATION = ** BLANK or char() *DB2_INST.DB2_UPDDBCFG_SINGLE_DBPARTITION = ** YES, 1, TRUE or NO, 0, FALSE *DB2_INST.DB2_USE_DB2JCCT2_JROUTINE = ** ON, YES, 1, TRUE or OFF, NO, 0, FALSE *DB2_INST.DB2_UTIL_MSGPATH = instanceName/tmp directory ** BLANK or char() *DB2_INST.DB2_WORKLOAD = Not set ** BLANK, SAP ** 2nd (non-Application Cluster Transparency) Instance Creation Settings ** --------------------------------------------------------------------- ** Multiple (non-Application Cluster Transparency) DB2 instances can be created ** in the same installation. This section shows how to specify the 2nd instance ** in the rsp file. Note: Only a subset of the instance keywords are listed ** below. You can specify other instance related keywords similar as the 1st ** instance. All keywords in this section are commented out. By default, only ** one instance will be created during the install. ** Prefix name of this instance set. Its value is used by all keywords for the ** same instance. *INSTANCE = DB2_INS2 ** char(8) no spaces *DB2_INS2.NAME = DB2_01 ** Real name of the instance. char(8) no spaces ** Global Profile Registry Settings ** -------------------------------- *DB2ACCOUNT = ** BLANK or char(199) *DB2BQTIME = ** BLANK or 1 - MAX *DB2BQTRY = ** BLANK or 0 - MAX *DB2CHKPTR = ** BLANK, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2CLIINIPATH = ** BLANK or char(260) *DB2CODEPAGE = ** BLANK or 0 - MAX *DB2COUNTRY = ** BLANK or 1 - 999 *DB2DBDFT = ** BLANK or char(8) *DB2DEFPREP = ** BLANK, ALL, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2DISCOVERYTIME = ** BLANK or 20 - MAX *DB2DMNBCKCTLR = ** BLANK, ? or char() *DB2INCLUDE = ** BLANK or char() *DB2IQTIME = ** BLANK or 1 - MAX *DB2LDAPCACHE = ** YES or NO *DB2LDAPHOST = ** BLANK or char() *DB2LDAP_BASEDN = ** BLANK or char() *DB2LDAP_CLIENT_PROVIDER = ** BLANK, MICROSOFT or IBM *DB2LOCK_TO_RB = ** BLANK or STATEMENT *DB2NOEXITLIST = ** BLANK, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2OPTIONS = ** BLANK or -/+[a,c,e[c,s],n,o,p,s,t,v,w,x] and/or -[f,l,r,z]filename *DB2RQTIME = ** BLANK or 1 - MAX *DB2_SET_MAX_CONTAINER_SIZE = ** -1 (no limit) or any integer greater than 64MB *DB2SORCVBUF = ** BLANK or 1024 - 65536 *DB2SOSNDBUF = ** BLANK or 1024 - 65536 *DB2_ENABLE_LDAP = ** BLANK, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2_FORCE_NLS_CACHE = ** BLANK, 0, 1, YES, NO, ON, OFF, Y, N, TRUE, FALSE, T or F *DB2_GRP_LOOKUP = ** BLANK or char() *DB2INSTOWNER = ** BLANK or char(20) *DB2DBMSADDR = ** BLANK or char(10) *DB2_DISABLE_FLUSH_LOG = ** BLANK or ON, OFF *DB2LOCALE = ** BLANK or YES, NO *DB2DOMAINLIST = ** BLANK or char() *DB2NODE = ** BLANK or YES NO *DB2_USE_PAGE_CONTAINER_TAG = ** BLANK or ON *DB2TCPCONNMGRS = ** BLANK or 1 - 8 *DB2_PARTITIONEDLOAD_DEFAULT = ** BLANK or YES, NO *DB2_INLIST_TO_NLJN = ** BLANK or YES, NO *DB2_XBSA_LIBRARY = ** BLANK or char() *DB2LDAP_SEARCH_SCOPE = ** BLANK LOCAL DOMAIN GLOBAL *DB2ADMINSERVER = ** BLANK or char(64) *DB2REMOTEPREG = ** BLANK or char(64) *DB2_ANTIJOIN = ** BLANK or YES, NO, EXTEND *DB2_COLLECT_TS_REC_INFO = ** BLANK or YES, NO *DB2PROCESSORS = ** BLANK or 1 - MAX *DB2ASSUMEUPDATE = ** BLANK or ON, OFF *DB2_SKIPDELETED = ** BLANK or ON, OFF *DB2_SQLROUTINE_PREPOPTS = ** BLANK or char() *DB2_INDEX_TYPE2 = ** BLANK or ON, OFF *DB2_APM_PERFORMANCE = ** BLANK or ON, OFF *DB2_FMP_COMM_HEAPSZ = ** BLANK or 1 - MAX *DB2_EVALUNCOMMITTED = ** BLANK or YES, NO *DB2_NO_FORK_CHECK = ** BLANK or ON, OFF *DB2CONSOLECP = ** BLANK or 1 - MAX *DB2HTSTACKOPTIMIZATION = ** BLANK or 0 - 2 *DB2_KEEPTABLELOCK = ** BLANK or ON, OFF *DB2GRAPHICUNICODESERVER = ** BLANK or ON, OFF *DB2_MINIMIZE_LISTPREFETCH = ** BLANK or YES, NO *DB2_TRUSTED_BINDIN = ** BLANK or ON, OFF, CHECK *DB2_CLPPROMPT = ** BLANK or char(99) *DB2_FORCE_APP_ON_MAX_LOG = ** BLANK or TRUE, FALSE *DB2_CLP_EDITOR = ** BLANK or char() *DB2_CLP_HISTSIZE = ** BLANK or 1 - 500 *DB2_LOAD_COPY_NO_OVERRIDE = ** BLANK or LOCAL, DOMAIN, GLOBAL *DB2_MAX_NON_TABLE_LOCKS = ** BLANK or 1 - MAX *DB2_USE_ALTERNATE_PAGE_CLEANING = ** BLANK or ON, OFF *DB2_SCATTERED_IO = ** BLANK or ON, OFF *DB2_NO_MPFA_FOR_NEW_DB = ** BLANK or YES, NO *DB2_OBJECT_TABLE_ENTRIES = ** BLANK or 0 - 50000 *DB2_VIEW_REOPT_VALUES = ** BLANK or YES, NO *DB2_SELUDI_COMM_BUFFER = ** BLANK or ON, OFF *DB2INSTPROF = ** ProgramData\IBM\DB2\ on Windows Vista, and Documents and Settings\All Users\Application Data\IBM\DB2 on Windows 2003 or XP *DB2_ENABLE_AUTOCONFIG_DEFAULT = ** BLANK, YES, NO *DB2_OPT_MAX_TEMP_SIZE = ** BLANK or 0 - MAX *DB2RCMD_LEGACY_MODE = ** YES, ON, TRUE, 1 or NO, OFF, FALSE, 0 *DB2_LARGE_PAGE_MEM = ** *, DB *DB2_MEM_TUNING_RANGE = ** a sequence of percentages n, m where n=minfree and m=maxfree *DB2_MAX_LOB_BLOCK_SIZE = 0 ** 0 - 21487483647 *DB2AUTH = ** BLANK or char() *DB2CONNECT_DISCONNECT_ON_INTERRUPT = NO ** YES, TRUE, 1 or NO, FALSE, 0 *DB2CONNECT_ENABLE_EURO_CODEPAGE = ** BLANK or char() *DB2FCMCOMM = TCPIP4 ** TCPIP4 or TCPIP6 *DB2FFDC = ** BLANK, ON, CORE:OFF *DB2INSTDEF = DB2 ** BLANK or char() *DB2LOADFLAGS = ** BLANK or char() *DB2PATH = ** varies by operating system *DB2TCP_CLIENT_CONTIMEOUT = 0 ** 0 - 32767 *DB2TCP_CLIENT_RCVTIMEOUT = 0 ** 0 - 32767 *DB2TRC_DEF_BUFFSIZE = ** BLANK or char() *DB2YIELD = ** BLANK or char() *DB2_ASYNC_IO_MAXFILOP = MAXFILOP ** MAXFILOP - MAX *DB2_BAR_AUTONOMIC_DISABLE = ** BLANK or char() *DB2_CONNRETRIES_INTERVAL = ** BLANK or char() *DB2_DXX_PATHS_ALLOWED_READ = ** BLANK or char() *DB2_DXX_PATHS_ALLOWED_WRITE = ** BLANK or char() *DB2_HADR_BUF_SIZE = 2*LOGBUFSZ ** BLANK or 0 - MAX *DB2_LOGGING_DETAIL = ** BLANK or char() *DB2_MAP_XML_AS_CLOB_FOR_DLC = NO ** YES, NO *DB2_MAX_CLIENT_CONNRETRIES = ** BLANK or char() *DB2_MAX_INACT_STMTS = ** 0 - 4294967296 *DB2_MDC_ROLLOUT = IMMEDIATE ** DEFER, IMMEDIATE or OFF *DB2_MINIMUM_CLIENT_LEVEL = ** BLANK or char() *DB2_RESOURCE_POLICY = ** valid path to configuration file *DB2_SKIPINSERTED = OFF ** ON, OFF *DB2_SMS_TRUNC_TMPTABLE_THRESH = ** -1, 0-n where n is the number of extents per container that are to be maintained *DB2_SNAPSHOT_NOAUTH = ** BLANK or char() *DB2_TAPEMGR_TAPE_EXPIRATION = ** BLANK or char() *DB2_UPDDBCFG_SINGLE_DBPARTITION = ** YES, 1, TRUE or NO, 0, FALSE *DB2_USE_DB2JCCT2_JROUTINE = ** ON, YES, 1, TRUE or OFF, NO, 0, FALSE *DB2_UTIL_MSGPATH = instanceName/tmp directory ** BLANK or char() *DB2_WORKLOAD = Not set ** BLANK, SAP ** Information Center Settings ** --------------------------- ** The default location for accessing the DB2 documentation is the IBM website. ** Only edit this section if you wish to access DB2 documentation from a ** different location, such as your local computer or an intranet server. ** The following DB2_DOCHOST keyword is used to specify where the Information ** Center server is installed. For example, "localhost" for the local computer. *DB2_DOCHOST = ** Any valid hostname ** The following DB2_DOCPORT keyword is used to specify the port number of the ** Information Center server. *DB2_DOCPORT = ** 1024-65535 ** Extended Security Settings ** -------------------------- *DB2_EXTSECURITY = YES ** YES or NO *DB2_ADMINGROUP_NAME = DB2ADMNS ** char(30) *DB2_USERSGROUP_NAME = DB2USERS ** char(30) *DB2_LIMIT_FENCEDGROUP = NO ** YES or NO *DB2_ADMINGROUP_DOMAIN = ** char(14) *DB2_USERSGROUP_DOMAIN = ** char(14) ** Check UNC Path Option ** --------------------- ** This option allows you to skip the function to check whether some UNC path ** exists in the PATH environment variable during the silent installation. By ** default, the installer checks the UNC path and stops the installation if it ** is in the PATH env var *CHECK_UNCPATH = YES ** YES or NO ** No Configuration Option ** ----------------------- ** This option allows you to install DB2 with only the mandatory configuration. ** You will need to create a DB2 instance manually in order to use DB2. Other ** configuration may also be required depending on how you intend to use DB2. ** For more information on configuring DB2 please see the Installation & ** Configuration Supplement, DB2 Administration Guide and the DB2 Command ** Reference. *NO_CONFIG = NO ** YES or NO