Command Reference

GET DATABASE MANAGER CONFIGURATION

Returns the values of individual entries in the database manager configuration file.

Authorization

None

Required Connection

None or instance. An instance attachment is not required to perform local DBM configuration operations, but is required to perform remote DBM configuration operations. To display the database manager configuration for a remote instance, it is necessary to first attach to that instance.

Command Syntax

>>-GET--+-DATABASE MANAGER-+-+-CONFIGURATION-+----------------->< +-DB MANAGER-------+ +-CONFIG--------+ +-DBM--------------+ +-CFG-----------+

Command Parameters

None

Example
Note: Both node type and platform determine which configuration parameters are listed.

The following is sample output from GET DATABASE MANAGER CONFIGURATION (issued on AIX):

          Database Manager Configuration
 
     Node type = Database Server with local and remote clients
 
 Database manager configuration release level            = 0x0800
 
 CPU speed (millisec/instruction)             (CPUSPEED) = 4.000000e-05
 
 Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY
 Enable intra-partition parallelism     (INTRA_PARALLEL) = NO
 
 Max number of concurrently active databases     (NUMDB) = 8
 Transaction processor monitor name        (TP_MON_NAME) =
 
 Default charge-back account           (DFT_ACCOUNT_STR) =
 Java Development Kit 1.1 installation path (JDK11_PATH) = /home/smith/jdk11
 
 Diagnostic error capture level              (DIAGLEVEL) = 3
 Diagnostic data directory path               (DIAGPATH) =
 
 Default database monitor switches
   Buffer pool                         (DFT_MON_BUFPOOL) = OFF
   Lock                                   (DFT_MON_LOCK) = OFF
   Sort                                   (DFT_MON_SORT) = OFF
   Statement                              (DFT_MON_STMT) = OFF
   Table                                 (DFT_MON_TABLE) = OFF
   Unit of work                            (DFT_MON_UOW) = OFF
 
 Database monitor SQL statement size (bytes) (SQLSTMTSZ) = 256
 
 SYSADM group name                        (SYSADM_GROUP) = BUILD
 SYSCTRL group name                      (SYSCTRL_GROUP) =
 SYSMAINT group name                    (SYSMAINT_GROUP) =
 
 Database manager authentication        (AUTHENTICATION) = CLIENT
 Trust all clients                      (TRUST_ALLCLNTS) = YES
 Trusted client authentication          (TRUST_CLNTAUTH) = CLIENT
 
 Default database path                       (DFTDBPATH) = /home/smith
 
 Database monitor heap size (4KB)          (MON_HEAP_SZ) = 48
 UDF shared memory set size (4KB)           (UDF_MEM_SZ) = 256
 
 Backup buffer default size (4KB)            (BACKBUFSZ) = 1024
 Restore buffer default size (4KB)           (RESTBUFSZ) = 1024
 
 Sort heap threshold (4KB)                  (SHEAPTHRES) = 20000
 
 Directory cache support                     (DIR_CACHE) = YES
 
 Java Virtual Machine heap size (4KB)     (JAVA_HEAP_SZ) = 512
 
 Application support layer heap size (4KB)   (ASLHEAPSZ) = 3000
 Max requester I/O block size (bytes)         (RQRIOBLK) = 32767
 Query heap size (4KB)                   (QUERY_HEAP_SZ) = 15000
 DRDA services heap size (4KB)            (DRDA_HEAP_SZ) = 128
 
 Priority of agents                           (AGENTPRI) = SYSTEM
 Max number of existing agents               (MAXAGENTS) = 200
 Agent pool size                        (NUM_POOLAGENTS) = 4 (calculated)
 Initial number of agents in pool       (NUM_INITAGENTS) = 0
 Max number of coordinating agents     (MAX_COORDAGENTS) = MAXAGENTS
 Max no. of concurrent coordinating agents  (MAXCAGENTS) = MAX_COORDAGENTS
 
 Keep DARI process                            (KEEPDARI) = YES
 Max number of DARI processes                  (MAXDARI) = MAX_COORDAGENTS
 
 Index re-creation time                       (INDEXREC) = RESTART
 
 Transaction manager database name         (TM_DATABASE) = 1ST_CONN
 Transaction resync interval (sec)     (RESYNC_INTERVAL) = 180
 
 SPM name                                     (SPM_NAME) =
 SPM log size                          (SPM_LOG_FILE_SZ) = 256
 SPM resync agent limit                 (SPM_MAX_RESYNC) = 20
 
 TCP/IP Service name                          (SVCENAME) =
 APPC Transaction program name                  (TPNAME) =
 Discovery mode                               (DISCOVER) = SEARCH
 Discovery communication protocols       (DISCOVER_COMM) =
 Discover server instance                (DISCOVER_INST) = ENABLE
 
 IPX/SPX File server name                   (FILESERVER) =
 IPX/SPX DB2 server object name             (OBJECTNAME) =
 IPX/SPX Socket number                      (IPX_SOCKET) = 879E
 
 Directory services type                      (DIR_TYPE) = NONE
 Directory path name                     (DIR_PATH_NAME) = /.:/subsys/database/
 Directory object name                    (DIR_OBJ_NAME) =
 Routing information object name        (ROUTE_OBJ_NAME) =
 Default client comm. protocols        (DFT_CLIENT_COMM) =
 
 No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096
 Number of FCM request blocks              (FCM_NUM_RQB) = 2048
 Number of FCM connection entries      (FCM_NUM_CONNECT) = (FCM_NUM_RQB * 0.75)
 Number of FCM message anchors         (FCM_NUM_ANCHORS) = (FCM_NUM_RQB * 0.75)

These fields are identified as follows:

AGENT_STACK_SZ (OS/2 only)

The amount of memory allocated and committed by the operating system for each agent. This parameter specifies the number of pages for each agent stack on the server.

AGENTPRI

Execution priority assigned to database manager processes and threads on a particular machine.

ASLHEAPSZ

Size (in pages) of the memory shared between a local client application and a database manager agent.

AUTHENTICATION

Determines how and where authentication of a user takes place. A value of CLIENT indicates that all authentication takes place at the client. If the value is SERVER, the user ID and password are sent from the client to the server so that authentication can take place at the server.

BACKBUFSZ

Size (in pages) of the buffer used when backing up the database, if the buffer size is not specified when calling the backup utility.

CONN_ELAPSE (MPP only)

This parameter specifies the number of seconds within which a TCP/IP connection is to be established between two nodes. If the attempt completes within the time specified by this parameter, communications are established. If it fails, another attempt is made to establish communications. If the connection is attempted the number of times specified by the MAX_CONNRETRIES parameter and always times out, an error is returned.

CPUSPEED

CPU speed (in milliseconds per instruction) used by the SQL optimizer to estimate the cost of performing certain operations. The value of this parameter is set automatically when the database manager is installed, but can be modified to model a production environment on a test system, or to assess the impact of upgrading hardware.

DFT_ACCOUNT_STR

Default accounting string.

DFT_CLIENT_ADPT (OS/2 only)

This parameter defines the default client adapter number for the NETBIOS protocol whose server nname is extracted from DCE Directory Services. This parameter can only be used with DCE.

DFT_CLIENT_COMM (DCE only)

Specifies the communication protocols that the client applications on a specific instance can use for remote connections.

DFT_MON_BUFPOOL

Default value of the snapshot monitor's buffer pool switch.

DFT_MON_LOCK

Default value of the snapshot monitor's lock switch.

DFT_MON_SORT

Default value of the snapshot monitor's sort switch.

DFT_MON_STMT

Default value of the snapshot monitor's statement switch.

DFT_MON_TABLE

Default value of the snapshot monitor's table switch.

DFT_MON_UOW

Default value of the snapshot monitor's unit of work (UOW) switch.

DFTDBPATH

Default database path. If no path is specified when a database is created, the database is created on the path specified by this parameter.

DIAGLEVEL

Diagnostic error capture level determines the severity of diagnostic errors recorded in the error log file (db2diag.log).

DIAGPATH

The fully qualified path for DB2 diagnostic information.

DIR_CACHE

Directory cache support. If set to YES, database, node, and DCS directory files are cached in memory. This reduces connect costs by eliminating directory file I/O, and minimizing the directory searches required to retrieve directory information.

DIR_OBJ_NAME

Object name in DCE name space. The object name representing a database manager instance (or a database) in the directory. The concatenation of this value and the dir_path_name value yields a global name that uniquely identifies the database manager instance or database in the name space governed by the directory services specified in the dir_type parameter.

DIR_PATH_NAME

Directory path name in DCE name space. The unique name of the database manager instance in the global name space is made up of this value and the value in the dir_obj_name parameter.

DIR_TYPE

Directory services type. Indicates whether the database manager instance uses the DCE global directory services.

DISCOVER

This parameter defines the type of discovery request supported on a client or server. Discovery requests can be issued from the client configuration assistant or from control center tools. Specify SEARCH to support search discovery, in which the DB2 client searches the network for DB2 databases. Specify KNOWN to support known discovery, in which the discovery request is issued against the administration server specified by the user. Specify DISABLE to disable the client or server from supporting any type of discovery request.

DISCOVER_COMM

This parameter defines the communications protocols that clients use to issue search discovery requests, and servers use to listen for search discovery requests. More than one protocol can be specified, separated by commas, or the parameter can be left blank. Supported protocols are TCPIP and NETBIOS.

DISCOVER_INST

This parameter enables or disables client discovery of an instance.

DOS_RQRIOBLK

DOS requester I/O block size. Applicable only on DOS clients, including DOS clients running under OS/2. This parameter controls the size of the I/O blocks that are allocated on the client and the server.

DRDA_HEAP_SZ

Specifies the size, in pages, of the DRDA heap. This heap is used by the DRDA AS.

FCM_NUM_ANCHORS

This parameter specifies the number of FCM message anchors. Agents use the message anchors to send messages among themselves.

FCM_NUM_BUFFERS

This parameter specifies the number of 4KB buffers that are used for internal communications (messages) among the nodes in an instance.

FCM_NUM_CONNECT

This parameter specifies the number of FCM connection entries. Agents use connection entries to pass data among themselves.

FCM_NUM_RQB

This parameter specifies the number of FCM request blocks. Request blocks are the media through which information is passed between the FCM daemon and an agent.

FILESERVER

IPX/SPX file server name. Specifies the name of the Novell NetWare file server where the internetwork address of the database manager server instance is registered.

Note:

The following characters are not valid: / \ : ; , * ?

INDEXREC

Specifies when invalid database indexes should be recreated. This parameter is used if the database configuration parameter indexrec is set to SYSTEM.

The possible output values are:

ACCESS
RESTART.

INTRA_PARALLEL

This parameter specifies whether the database manager can use intra-partition parallelism.

In a symmetric multiprocessor (SMP) environment, the default for this parameter is YES. In a non-SMP environment, the default for this parameter is NO. This parameter can be used on both partitioned and non-partitioned database systems. Some of the operations that can take advantage of parallel performance improvements when the value of this parameter is YES include database queries and index creation.

IPX_SOCKET

IPX/SPX socket number. Specifies a "well-known" socket number and represents the connection end point in a DB2 server's IPX/SPX internetwork address.

KEEPDARI

Indicates whether to keep a DARI process after each DARI call. If NO, a new DARI process is created and terminated for each DARI invocation. If YES, a DARI process is reused for subsequent DARI calls, and is terminated only when the associated user application exits.

MAX_CONNRETRIES (MPP only)

If an attempt to establish communication between two nodes fails because the value specified by the CONN_ELAPSE parameter is reached (for example, the attempt to establish TCP/IP communication times out), MAX_CONNRETRIES specifies the number of connection retries that can be made to a node. If the value specified for this parameter is exceeded, an error is returned.

MAX_COORDAGENTS

This parameter determines the maximum number of coordinating agents that can exist at one time on a node.

MAX_QUERYDEGREE

This parameter specifies the maximum degree of parallelism used for any SQL statement executing on this instance of the database manager. An SQL statement will not use more than this number of parallel operations when the statement is executed. For a multi-node system, this parameter applies to the degree of parallelism within a single node.

MAX_TIME_DIFF (MPP only)

Each node has its own system clock. This parameter specifies the maximum time difference, in minutes, that is permitted among the nodes listed in the db2nodes.cfg file.

MAXAGENTS

Maximum number of database manager agents that can exist simultaneously on a node, regardless of which database is being used.

MAXCAGENTS

Maximum number of database manager agents that can be concurrently executing a database manager transaction. Cannot exceed the value of maxagents.

MAXDARI

Maximum number of DARI processes that can reside at the database server. Cannot exceed the value of maxagents.

MAXTOTFILOP (OS/2 only)

Maximum number of files open per application. Defines the total database and application file handles that can be used by a specific process connected to a database.

MIN_PRIV_MEM (OS/2 only)

Minimum committed private memory. Specifies the number of pages that the database server process will reserve as private virtual memory when a database manager instance is started (db2start).

MON_HEAP_SZ

Database system monitor heap size. Specifies the amount (in 4KB pages) of memory to allocate for database system monitor data.

NNAME (OS/2 only)

Name of the node or workstation. Database clients use nname to access database server workstations using NetBIOS. If the database server workstation changes the name specified in nname, all clients that access the database server workstation must catalog it again and specify the new name.

nodetype (Node type)

Indicates whether the node is configured as a server with local and remote clients, a client, or a server with local clients.

NUM_INITAGENTS

This parameter determines the initial number of agents that are created in the agent pool when the database manager is started.

NUM_POOLAGENTS

This parameter specifies the size to which the agent pool is allowed to grow. The agent pool contains both idle agents (as in DB2/6000 Version 2), and MPP and SMP associated subagents. If more agents are created, they will be terminated and not return to the pool when they are finished executing.

If the value of this parameter is calculated at run time using other configuration parameters, the label (calculated) appears to the right of the value shown in the output for GET DATABASE MANAGER CONFIGURATION. If -1 (calculated) is shown in the output, the request was issued from a client, and the value was not available.

The obsolete database manager configuration parameter max_idleagents can still be updated through UPDATE DATABASE MANAGER CONFIGURATION, and is interpreted as an update to num_poolagents.

NUMDB

Maximum number of local databases that can be concurrently active (that is, have applications connected to them).

OBJECTNAME

This parameter represents the database manager server instance as an object on the NetWare file server, where the server's IPX/SPX address is stored and retrieved. The value must be entered in uppercase. The value must be unique on the NetWare file server, and it is recommended that it be unique across the IPX/SPX network.

Note:

The following characters are not valid: / \ : ; , * ?

PRIV_MEM_THRESH (OS/2 only)

Private memory threshold. Sets a threshold below which a server will not release the memory associated with a client when that client's connection is terminated.

QUERY_HEAP_SZ

Maximum amount of memory (in pages) that can be allocated for the query heap. A query heap is used to store each query in the agent's private memory.

release (Database manager configuration release level)

Release level of the configuration file.

RESTBUFSZ

Size (in 4KB pages) of the buffer used when restoring the database, if the buffer size is not specified when calling the restore utility.

RESYNC_INTERVAL

Time interval (in seconds) after which a Transaction Manager (TM) or a Resource Manager (RM) retries the recovery of any outstanding indoubt transactions found in the TM or the RM. Applicable when transactions are running in a distributed unit of work (DUOW) environment.

ROUTE_OBJ_NAME (DCE only)

Routing information object name. Specifies the name of the default routing information object entry that will be used by all client applications attempting to access a DRDA server.

RQRIOBLK

Client I/O block size. Specifies the size (in bytes) of the communication buffer between remote applications and their database agents on the database server.

SHEAPTHRESH

Limit on the total amount of memory (in pages) available for sorting across the entire instance.

SPM_NAME

This parameter identifies the name of the Sync Point Manager (SPM) instance to the database manager. The spm_name must be defined in the system database directory and, if remote, in the node directory.

SPM_LOG_FILE_SZ

This parameter identifies the Sync Point Manager (SPM) log file size in 4KB pages. The log file is contained in the spmlog sub-directory under sqllib and is created the first time SPM is started.

SPM_MAX_RESYNC

This parameter identifies the number of simultaneous agents that can perform resync operations.

SQLSTMTSZ

Maximum amount of dynamic SQL statement text (in bytes) that will be returned by the database system monitor.

SS_LOGON (OS/2 only)

By accepting the default for this parameter, a LOGON user ID and password are required before issuing a DB2START or DB2STOP.

START_STOP_TIME (MPP only)

This parameter specifies the time, in minutes, within which all nodes must respond to START DATABASE MANAGER, STOP DATABASE MANAGER, or ADD NODE.

SVCENAME

The name used to update the database manager configuration file at the server. This value must be the same as the Connection Service name specified in the services file.

Note:

It is not recommended that this parameter, which is set by the installation program, be modified by the user. The administration server service name is set to use the DB2 registered TCP/IP port (523).

SYSADM_GROUP

Defines the group name with system administration (sysadm) authority for the database manager instance. This is the highest level of authority within the database manager, and controls all database objects.

SYSCTRL_GROUP

Defines the group name with system control (sysctrl) authority for the database manager instance. This level has privileges allowing operations affecting system resources, but not allowing direct access to data.

SYSMAINT_GROUP

Defines the group name with system maintenance (sysmaint) authority for the database manager instance. This level has authority allowing maintenance operations on all databases associated with an instance, but not allowing direct access to data.

TM_DATABASE

Name of the transaction manager (TM) database for each DB2 instance.

TP_MON_NAME

Name of the transaction processing (TP) monitor product being used.

TPNAME

Name of the remote transaction program that the database client must use when it issues an allocate request to the database manager instance using the APPC communication protocol.

TRUST_ALLCLNTS

This parameter and the TRUST_CLNTAUTH parameter are used to determine where users are validated to the database environment. By accepting the default for this parameter, all clients are treated as trusted clients. This means a level of security is available at the client, and that users can be validated at the client.

TRUST_CLNAUTH

This parameter and the TRUST_ALLCLNTS parameter are used to determine where users are validated to the database environment. By accepting the default for this parameter, all users of trusted clients are validated at the client.

UDF_MEM_SZ

For a fenced user defined function (UDF), specifies the default allocation for memory to be shared between the database process and the UDF. For an unfenced process, specifies the size of the private memory set. In both cases, this memory is used to pass data to a UDF and back to a database.

Usage Notes

If an attachment to a remote instance (or a different local instance) exists, the database manager configuration parameters for the attached server are returned; otherwise, the local database manager configuration parameters are returned.

If an error occurs, the information returned is invalid. If the configuration file is invalid, an error message is returned. The user must install the database manager again to recover.

To set the configuration parameters to the default values shipped with the database manager, use RESET DATABASE MANAGER CONFIGURATION.

For more information about these parameters, see the Administration Guide.

See Also

RESET DATABASE MANAGER CONFIGURATION

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]