felipecorrea
Active Member
Hi there.....
I ned help with the performance parameters for instance and data base for db2 udb 8.2....
I have some troubles with the memory utilizacion of the enterprise server especialy in db2, because the default parameter is so minimal...
is anybody can send me the configuration???
here is my configuration for production envirinment.
my enterprise server have 4gb ram.
here is my parameters for the instance
------------------------------ Commands Entered
------------------------------
get dbm cfg;
------------------------------------------------------------------------------
get dbm cfg
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote
clients
Database manager configuration release level = 0x0a00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) =
3,306410e-007
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) =
1,000000e+002
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 installation path (JDK_PATH) =
E:\IBM\SQLLIB\java\jdk
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 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
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) =
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) = IBMkrb5
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) =
NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = E:
Database monitor heap size (4KB) (MON_HEAP_SZ) = 66
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 512
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Agent stack size (AGENT_STACK_SZ) = 16
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000
Sort heap threshold (4KB) (SHEAPTHRES) = 10000
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
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) = 8000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 5000
Agent pool size (NUM_POOLAGENTS) =
2500(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS -
NUM_INITAGENTS)
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) =
MAX_COORDAGENTS
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = COBOGPS1
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) = DB2_TRIADA
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC
Node connection elapse time (sec) (CONN_ELAPSE) = 10
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10
HERE IS MY PARAMETERS FOR DATA BASE
------------------------------ Commands Entered
------------------------------
GET DB CFG SHOW DETAIL;
------------------------------------------------------------------------------
GET DB CFG SHOW DETAIL
Database Configuration for Database
Description Parameter Current
Value Delayed Value
---------------------------------------------------------------------------------------------------------------
Database configuration release level = 0x0a00
Database release level = 0x0a00
Database territory = US
Database code page = 1252
Database code set = IBM-1252
Database country/region code = 1
Database collating sequence = UNIQUE
UNIQUE
Alternate collating sequence (ALT_COLLATE) =
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE
DISABLE
Discovery support for this database (DISCOVER_DB) = ENABLE
ENABLE
Default query optimization class (DFT_QUERYOPT) = 0
0
Degree of parallelism (DFT_DEGREE) = 1
1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
NO
Default refresh age (DFT_REFRESH_AGE) = 0
0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
10
Number of quantiles retained (NUM_QUANTILES) = 20
20
Backup pending = NO
Database is consistent = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = NO
User exit for logging status = NO
Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60
60
Data Links Write Token Init Expiry Intvl(DL_WT_IEXPINT) = 60
60
Data Links Number of Copies (DL_NUM_COPIES) = 1
1
Data Links Time after Drop (days) (DL_TIME_DROP) = 1
1
Data Links Token in Uppercase (DL_UPPER) = NO
NO
Data Links Token Algorithm (DL_TOKEN) = MAC0
MAC0
Database heap (4KB) (DBHEAP) = 3000
3000
Size of database shared memory (4KB) (DATABASE_MEMORY) =
AUTOMATIC(182376) AUTOMATIC(182376)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 64
64
Log buffer size (4KB) (LOGBUFSZ) = 512
512
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
5000
Buffer pool size (pages) (BUFFPAGE) = 8000
8000
Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
16000
Number of extended storage segments (NUM_ESTORE_SEGS) = 0
0
Max storage for lock list (4KB) (LOCKLIST) = 2000
2000
Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000
30000
Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 128
128
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)
(SHEAPTHRES)
Sort list heap (4KB) (SORTHEAP) = 128
128
SQL statement heap (4KB) (STMTHEAP) = 8000
8000
Default application heap (4KB) (APPLHEAPSZ) = 6000
6000
Package cache size (4KB) (PCKCACHESZ) = 20000
20000
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384
4384
Interval for checking deadlock (ms) (DLCHKTIME) = 1000
1000
Percent. of lock lists per application (MAXLOCKS) = 22
22
Lock timeout (sec) (LOCKTIMEOUT) = 60
60
Changed pages threshold (CHNGPGS_THRESH) = 60
60
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 30
30
Number of I/O servers (NUM_IOSERVERS) = 1
1
Index sort flag (INDEXSORT) = YES
YES
Sequential detect flag (SEQDETECT) = NO
NO
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
AUTOMATIC
Track modified pages (TRACKMOD) = NO
NO
Default number of containers = 1
1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
32
Max number of active applications (MAXAPPLS) = 5000
5000
Average number of active applications (AVG_APPLS) = 50
50
Max DB files open per application (MAXFILOP) = 500
500
Log file size (4KB) (LOGFILSIZ) = 25000
25000
Number of primary log files (LOGPRIMARY) = 10
10
Number of secondary log files (LOGSECOND) = 100
100
Changed path to log files (NEWLOGPATH) =
Path to log files =
E:\Logs_Prod_DB2\Production\NODE0000\ E:\Logs_Prod_DB2\Production\NODE0000\
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file =
Block log on disk full (BLK_LOG_DSK_FUL) = NO
NO
Percent of max active log space by transaction(MAX_LOG) = 0
0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
0
Group commit count (MINCOMMIT) = 1
1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
100
Log retain for recovery enabled (LOGRETAIN) = OFF
OFF
User exit for logging enabled (USEREXIT) = OFF
OFF
HADR database role = STANDARD
STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) =
HADR remote host name (HADR_REMOTE_HOST) =
HADR remote service name (HADR_REMOTE_SVC) =
HADR instance name of remote server (HADR_REMOTE_INST) =
HADR timeout value (HADR_TIMEOUT) = 120
120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
NEARSYNC
First log archive method (LOGARCHMETH1) = OFF
OFF
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ON
ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM
SYSTEM (ACCESS)
Log pages during index build (LOGINDEXBUILD) = OFF
OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
12
Recovery history retention (days) (REC_HIS_RETENTN) = 366
366
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = OFF
OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
OFF
Automatic reorganization (AUTO_REORG) = OFF
OFF
I ned help with the performance parameters for instance and data base for db2 udb 8.2....
I have some troubles with the memory utilizacion of the enterprise server especialy in db2, because the default parameter is so minimal...
is anybody can send me the configuration???
here is my configuration for production envirinment.
my enterprise server have 4gb ram.
here is my parameters for the instance
------------------------------ Commands Entered
------------------------------
get dbm cfg;
------------------------------------------------------------------------------
get dbm cfg
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote
clients
Database manager configuration release level = 0x0a00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) =
3,306410e-007
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) =
1,000000e+002
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 installation path (JDK_PATH) =
E:\IBM\SQLLIB\java\jdk
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 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
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) =
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) = IBMkrb5
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) =
NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = E:
Database monitor heap size (4KB) (MON_HEAP_SZ) = 66
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 512
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Agent stack size (AGENT_STACK_SZ) = 16
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000
Sort heap threshold (4KB) (SHEAPTHRES) = 10000
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
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) = 8000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 5000
Agent pool size (NUM_POOLAGENTS) =
2500(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS -
NUM_INITAGENTS)
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) =
MAX_COORDAGENTS
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = COBOGPS1
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) = DB2_TRIADA
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC
Node connection elapse time (sec) (CONN_ELAPSE) = 10
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10
HERE IS MY PARAMETERS FOR DATA BASE
------------------------------ Commands Entered
------------------------------
GET DB CFG SHOW DETAIL;
------------------------------------------------------------------------------
GET DB CFG SHOW DETAIL
Database Configuration for Database
Description Parameter Current
Value Delayed Value
---------------------------------------------------------------------------------------------------------------
Database configuration release level = 0x0a00
Database release level = 0x0a00
Database territory = US
Database code page = 1252
Database code set = IBM-1252
Database country/region code = 1
Database collating sequence = UNIQUE
UNIQUE
Alternate collating sequence (ALT_COLLATE) =
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE
DISABLE
Discovery support for this database (DISCOVER_DB) = ENABLE
ENABLE
Default query optimization class (DFT_QUERYOPT) = 0
0
Degree of parallelism (DFT_DEGREE) = 1
1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
NO
Default refresh age (DFT_REFRESH_AGE) = 0
0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
10
Number of quantiles retained (NUM_QUANTILES) = 20
20
Backup pending = NO
Database is consistent = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = NO
User exit for logging status = NO
Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60
60
Data Links Write Token Init Expiry Intvl(DL_WT_IEXPINT) = 60
60
Data Links Number of Copies (DL_NUM_COPIES) = 1
1
Data Links Time after Drop (days) (DL_TIME_DROP) = 1
1
Data Links Token in Uppercase (DL_UPPER) = NO
NO
Data Links Token Algorithm (DL_TOKEN) = MAC0
MAC0
Database heap (4KB) (DBHEAP) = 3000
3000
Size of database shared memory (4KB) (DATABASE_MEMORY) =
AUTOMATIC(182376) AUTOMATIC(182376)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 64
64
Log buffer size (4KB) (LOGBUFSZ) = 512
512
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
5000
Buffer pool size (pages) (BUFFPAGE) = 8000
8000
Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
16000
Number of extended storage segments (NUM_ESTORE_SEGS) = 0
0
Max storage for lock list (4KB) (LOCKLIST) = 2000
2000
Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000
30000
Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 128
128
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)
(SHEAPTHRES)
Sort list heap (4KB) (SORTHEAP) = 128
128
SQL statement heap (4KB) (STMTHEAP) = 8000
8000
Default application heap (4KB) (APPLHEAPSZ) = 6000
6000
Package cache size (4KB) (PCKCACHESZ) = 20000
20000
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384
4384
Interval for checking deadlock (ms) (DLCHKTIME) = 1000
1000
Percent. of lock lists per application (MAXLOCKS) = 22
22
Lock timeout (sec) (LOCKTIMEOUT) = 60
60
Changed pages threshold (CHNGPGS_THRESH) = 60
60
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 30
30
Number of I/O servers (NUM_IOSERVERS) = 1
1
Index sort flag (INDEXSORT) = YES
YES
Sequential detect flag (SEQDETECT) = NO
NO
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
AUTOMATIC
Track modified pages (TRACKMOD) = NO
NO
Default number of containers = 1
1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
32
Max number of active applications (MAXAPPLS) = 5000
5000
Average number of active applications (AVG_APPLS) = 50
50
Max DB files open per application (MAXFILOP) = 500
500
Log file size (4KB) (LOGFILSIZ) = 25000
25000
Number of primary log files (LOGPRIMARY) = 10
10
Number of secondary log files (LOGSECOND) = 100
100
Changed path to log files (NEWLOGPATH) =
Path to log files =
E:\Logs_Prod_DB2\Production\NODE0000\ E:\Logs_Prod_DB2\Production\NODE0000\
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file =
Block log on disk full (BLK_LOG_DSK_FUL) = NO
NO
Percent of max active log space by transaction(MAX_LOG) = 0
0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
0
Group commit count (MINCOMMIT) = 1
1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
100
Log retain for recovery enabled (LOGRETAIN) = OFF
OFF
User exit for logging enabled (USEREXIT) = OFF
OFF
HADR database role = STANDARD
STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) =
HADR remote host name (HADR_REMOTE_HOST) =
HADR remote service name (HADR_REMOTE_SVC) =
HADR instance name of remote server (HADR_REMOTE_INST) =
HADR timeout value (HADR_TIMEOUT) = 120
120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
NEARSYNC
First log archive method (LOGARCHMETH1) = OFF
OFF
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ON
ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM
SYSTEM (ACCESS)
Log pages during index build (LOGINDEXBUILD) = OFF
OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
12
Recovery history retention (days) (REC_HIS_RETENTN) = 366
366
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = OFF
OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
OFF
Automatic reorganization (AUTO_REORG) = OFF
OFF
