Database Manager Configuration



     Node type = Database Server with local and remote clients



 Database manager configuration release level            = 0x0900



 Maximum total of files open               (MAXTOTFILOP) = 16000

 CPU speed (millisec/instruction)             (CPUSPEED) = 1.389479e-006



 Max number of concurrently active databases     (NUMDB) = 8

 Data Links support                          (DATALINKS) = NO

 Federated Database System Support           (FEDERATED) = NO

 Transaction processor monitor name        (TP_MON_NAME) =



 Default charge-back account           (DFT_ACCOUNT_STR) =



 Java Development Kit 1.1 installation path (JDK11_PATH) = 



 Diagnostic error capture level              (DIAGLEVEL) = 3

 Notify Level                              (NOTIFYLEVEL) = 2

 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



 SYSADM group name                        (SYSADM_GROUP) =

 SYSCTRL group name                      (SYSCTRL_GROUP) =

 SYSMAINT group name                    (SYSMAINT_GROUP) =



 Database manager authentication        (AUTHENTICATION) = SERVER

 Cataloging allowed without authority   (CATALOG_NOAUTH) = NO

 Trust all clients                      (TRUST_ALLCLNTS) = YES

 Trusted client authentication          (TRUST_CLNTAUTH) = CLIENT



 Default database path                       (DFTDBPATH) = D:



 Database monitor heap size (4KB)          (MON_HEAP_SZ) = 32

 UDF shared memory set size (4KB)           (UDF_MEM_SZ) = 256

 Java Virtual Machine heap size (4KB)     (JAVA_HEAP_SZ) = 4096

 Audit buffer size (4KB)                  (AUDIT_BUF_SZ) = 0



 Backup buffer default size (4KB)            (BACKBUFSZ) = 4096

 Restore buffer default size (4KB)           (RESTBUFSZ) = 8192



 Agent stack size                       (AGENT_STACK_SZ) = 16

 Minimum committed private memory (4KB)   (MIN_PRIV_MEM) = 32

 Private memory threshold (4KB)        (PRIV_MEM_THRESH) = 2592



 Sort heap threshold (4KB)                  (SHEAPTHRES) = 10000



 Directory cache support                     (DIR_CACHE) = YES



 Application support layer heap size (4KB)   (ASLHEAPSZ) = 150

 Max requester I/O block size (bytes)         (RQRIOBLK) = 32767

 DOS requester I/O block size (bytes)     (DOS_RQRIOBLK) = 4096

 Query heap size (4KB)                   (QUERY_HEAP_SZ) = 1000

 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

 Max number of logical agents          (MAX_LOGICAGENTS) = MAX_COORDAGENTS



 Keep DARI process                            (KEEPDARI) = YES

 Max number of DARI processes                  (MAXDARI) = MAX_COORDAGENTS

 Initialize DARI process with JVM         (INITDARI_JVM) = NO

 Initial number of fenced DARI process   (NUM_INITDARIS) = 0



 Index re-creation time                       (INDEXREC) = ACCESS



 Transaction manager database name         (TM_DATABASE) = 1ST_CONN

 Transaction resync interval (sec)     (RESYNC_INTERVAL) = 180



 SPM name                                     (SPM_NAME) = MBS19PC

 SPM log size                          (SPM_LOG_FILE_SZ) = 256

 SPM resync agent limit                 (SPM_MAX_RESYNC) = 20

 SPM log path                             (SPM_LOG_PATH) =



 NetBIOS Workstation name                        (NNAME) =



 TCP/IP Service name                          (SVCENAME) = db2cDB2

 APPC Transaction program name                  (TPNAME) =

 IPX/SPX File server name                   (FILESERVER) =

 IPX/SPX DB2 server object name             (OBJECTNAME) =

 IPX/SPX Socket number                      (IPX_SOCKET) = 879E



 Discovery mode                               (DISCOVER) = SEARCH

 Discovery communication protocols       (DISCOVER_COMM) = TCPIP

 Discover server instance                (DISCOVER_INST) = ENABLE



 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) = 

 Default client adapter number         (DFT_CLIENT_ADPT) = 0



 Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY

 Enable intra-partition parallelism     (INTRA_PARALLEL) = NO



 No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024

 Number of FCM request blocks              (FCM_NUM_RQB) = 512

 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)