Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Regular SEGV trap running DB2 10.1 on SUSE 11
297 views
Skip to first unread message
Simon Temple
Aug 31, 2012, 4:03:45 AM8/31/12
to
We can't keep a 10.1 running for more than 20 hours. It's running on a test machine that is hardly used - never more than a single user and single database!
I tried turning off STMM yesterday but that had no effect. I'm no DB2 expert and have run out of ideas.
Is this a known issue that requires a fix pack?
Any suggestions of things to try would be much appreciated.
Details from the trap.txt file follow:
<Header>
DB2 build information: DB2 v10.1.0.0 s120403 SQL10010
timestamp: 2012-08-31-06.54.01.019132
instance name: db2inst1.000
EDU name : db2agent (TESTDB) [-]
EDU ID : 79
Signal #11
uname: S:Linux R:2.6.32-11-pve V:#1 SMP Wed Apr 11 07:17:05 CEST 2012 M:x86_64 N:test
process id: 3591
parent process id: 3589
thread id : 140153989359360 (0x7F7824BFE700)
kthread id : 3882
</Header>
The env listing shows that it is corrupt and probably the cause of the getenv() SEGV
<EnvironmentVariables>
<![CDATA[
HOME=/home/db2inst1
PWD=/home/db2inst1
DB2INSTANCE=db2inst1
DB2INSTDEF=db2inst1
HOSTNAME=test
LANG=en_US.UTF-8
USER=db2inst1
CLASSPATH=/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_license_cu.jar:.
DB2SYSC_EXEC_OWNER=DB2
PATH=/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/bin:/usr/bin:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/bin:/usr/bin:
LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib64:/home/db2inst1/sqllib/function:
db2inst1
BBHEAD
db2inst1
---> corruption starts here with repeating control characters <--
<snip>
The stack:
<POFDisassembly>
getenv + 0x0090 (/lib64/libc.so.6)
0x00007F783579DC70 : 66443B6D00751B48
</POFDisassembly>
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F783647B65A _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x020a
(/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F783647B3EB ossDumpStackTraceV98 + 0x002b
(/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F7836476313 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x0103
(/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F7839C7E2C7 sqlo_trce + 0x0407
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F7839CC7957 sqloEDUCodeTrapHandler + 0x0277
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F783DE3B2D0 address: 0x00007F783DE3B2D0 ; dladdress: 0x00007F783DE2C000 ; offset in lib: 0x000000000000F2D0 ;
(/lib64/libpthread.so.0)
0x00007F783579DC70 getenv + 0x0090
(/lib64/libc.so.6)
0x00007F7814810C0C _ZN3cie16CteCLIConnectionC1ERKSsS2_S2_RNS_8CteErrorE + 0x01ec
(/home/db2inst1/sqllib/lib64/libcieadmin.so.1)
0x00007F7814BE95A6 CIESRVSP_FG + 0x03f6
(/home/db2inst1/sqllib/bin/routine/ciespadm)
0x00007F7814BE91A1 ciesrvsp + 0x0051
(/home/db2inst1/sqllib/bin/routine/ciespadm)
0x00007F78385805F4 sqloInvokeFnArgs + 0x3414
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F783884F7BD _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x062d
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F783884BB34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0x0a44
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F783884A656 _Z9sqlricallP8sqlrr_cb + 0x0116
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
<snip>
I tried turning off STMM yesterday but that had no effect. I'm no DB2 expert and have run out of ideas.
Is this a known issue that requires a fix pack?
Any suggestions of things to try would be much appreciated.
Details from the trap.txt file follow:
<Header>
DB2 build information: DB2 v10.1.0.0 s120403 SQL10010
timestamp: 2012-08-31-06.54.01.019132
instance name: db2inst1.000
EDU name : db2agent (TESTDB) [-]
EDU ID : 79
Signal #11
uname: S:Linux R:2.6.32-11-pve V:#1 SMP Wed Apr 11 07:17:05 CEST 2012 M:x86_64 N:test
process id: 3591
parent process id: 3589
thread id : 140153989359360 (0x7F7824BFE700)
kthread id : 3882
</Header>
The env listing shows that it is corrupt and probably the cause of the getenv() SEGV
<EnvironmentVariables>
<
Bruce
Aug 31, 2012, 6:19:12 AM8/31/12
to
etc to help you diagnose this?
Simon Temple
Aug 31, 2012, 7:07:59 AM8/31/12
to
Hi Bruce
The machine has 4Gb or memory. There is 2535900k free before I start db2. It's also worth mentioning we are running db2ts which starts an IBM JVM process.
db2inst1@test:~> ipcs -l
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 16777216
max total shared memory (kbytes) = 33554432
min seg size (bytes) = 1
------ Semaphore Limits --------
max number of arrays = 4096
max semaphores per array = 250
max semaphores system wide = 256000
max ops per semop call = 32
semaphore max value = 32767
------ Messages Limits --------
max queues system wide = 16384
max size of message (bytes) = 65536
default max size of queue (bytes) = 65536
Like I said I'm no db2 expert so you'll have to ask me to run specific db2 commands if required. :-)
db2inst1@test:~> db2 get db cfg for TESTDB
Database Configuration for Database TESTDB
Database configuration release level = 0x0f00
Database release level = 0x0f00
Database territory = US
Database code page = 1208
Database code set = UTF-8
Database country/region code = 1
Database collating sequence = SYSTEM_819
Alternate collating sequence (ALT_COLLATE) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Date compatibility = OFF
Database page size = 4096
Statement concentrator (STMT_CONC) = OFF
Discovery support for this database (DISCOVER_DB) = ENABLE
Restrict access = NO
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20
Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN
Backup pending = NO
All committed transactions have been written to disk = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = NO
User exit for logging status = YES
Self tuning memory (SELF_TUNING_MEM) = OFF
Size of database shared memory (4KB) (DATABASE_MEMORY) = COMPUTED(179504)
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(15616)
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(98)
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(52461)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(424)
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(84)
Database heap (4KB) (DBHEAP) = AUTOMATIC(4513)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
Log buffer size (4KB) (LOGBUFSZ) = 2149
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 23607
Buffer pool size (pages) (BUFFPAGE) = 1000
SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(8192)
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40000)
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1
Changed pages threshold (CHNGPGS_THRESH) = 80
Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(1)
Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(3)
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages (TRACKMOD) = NO
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC(40)
Average number of active applications (AVG_APPLS) = AUTOMATIC(1)
Max DB files open per application (MAXFILOP) = 61440
Log file size (4KB) (LOGFILSIZ) = 8192
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 12
Changed path to log files (NEWLOGPATH) =
Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0000191.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
HADR database role = 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
HADR target list (HADR_TARGET_LIST) =
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR spool log data limit (4KB) (HADR_SPOOL_LIMIT) = 0
HADR log replay delay (seconds) (HADR_REPLAY_DELAY) = 0
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
First log archive method (LOGARCHMETH1) = DISK:/opt/db2backups/
Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days) (REC_HIS_RETENTN) = 366
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = ON
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = ON
Automatic runstats (AUTO_RUNSTATS) = ON
Real-time statistics (AUTO_STMT_STATS) = ON
Statistical views (AUTO_STATS_VIEWS) = OFF
Automatic sampling (AUTO_SAMPLING) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Statistics profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF
Auto-Revalidation (AUTO_REVAL) = DEFERRED
Currently Committed (CUR_COMMIT) = ON
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = NEW
Enable XML Character operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = BASE
Activity metrics (MON_ACT_METRICS) = BASE
Object metrics (MON_OBJ_METRICS) = EXTENDED
Unit of work events (MON_UOW_DATA) = NONE
UOW events with package list (MON_UOW_PKGLIST) = OFF
UOW events with executable list (MON_UOW_EXECLIST) = OFF
Lock timeout events (MON_LOCKTIMEOUT) = NONE
Deadlock events (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONE
Lock wait event threshold (MON_LW_THRESH) = 5000000
Number of package list entries (MON_PKGLIST_SZ) = 32
Lock event notification level (MON_LCK_MSG_LVL) = 1
SMTP Server (SMTP_SERVER) =
SQL conditional compilation flags (SQL_CCFLAGS) =
Section actuals setting (SECTION_ACTUALS) = NONE
Connect procedure (CONNECT_PROC) =
Adjust temporal SYSTEM_TIME period (SYSTIME_PERIOD_ADJ) = NO
Log DDL Statements (LOG_DDL_STMTS) = NO
Log Application Information (LOG_APPL_INFO) = NO
Default data capture on new Schemas (DFT_SCHEMAS_DCC) = NO
Database is in write suspend state = NO
db2inst1@test:~> db2set -lr
DB2_OVERRIDE_BPF
DB2_PARALLEL_IO
DB2ACCOUNT
DB2ADMINSERVER
DB2BQTIME
DB2BQTRY
DB2CHKPTR
DB2CLIINIPATH
DB2CODEPAGE
DB2COMM
DB2DBDFT
DB2DBMSADDR
DB2INCLUDE
DB2INSTDEF
DB2INSTPROF
DB2IQTIME
DB2LOADREC
DB2LOCK_TO_RB
DB2NTNOCACHE
DB2NTPRICLASS
DB2NTWORKSET
DB2OPTIONS
DB2PATH
DB2PRIORITIES
DB2REMOTEPREG
DB2RQTIME
DB2SORCVBUF
DB2SORT
DB2SOSNDBUF
DB2SYSTEM
DB2_FORCE_NLS_CACHE
DB2_AVOID_PREFETCH
DB2_COLLECT_TS_REC_INFO
DB2_GRP_LOOKUP
DB2_INDEX_FREE
DB2_MMAP_READ
DB2_MMAP_WRITE
DB2DISCOVERYTIME
DB2ENVLIST
DB2MEMDISCLAIM
DB2LIBPATH
DB2CHKSQLDA
DB2PORTRANGE
DB2INSTOWNER
DB2NOEXITLIST
DB2LOADFLAGS
DB2NTMEMSIZE
DB2CHECKCLIENTINTERVAL
DB2_FALLBACK
DB2PROCESSORS
DB2ATLD_PORTS
DB2_SORT_AFTER_TQ
DB2_LIKE_VARCHAR
DB2ASSUMEUPDATE
DB2MAXFSCRSEARCH
DB2BIDI
DB2_NEW_CORR_SQ_FF
DB2CHGPWD_EEE
DB2LOCALE
DB2_SKIPDELETED
DB2LDAPHOST
DB2LDAPCACHE
DB2LDAP_CLIENT_PROVIDER
DB2LDAP_BASEDN
DB2_ENABLE_LDAP
DB2_SYSTEM_MONITOR_SETTINGS
DB2_FCM_SETTINGS
DB2SATELLITEID
DB2_LIC_STAT_SIZE
DB2CONNECT_IN_APP_PROCESS
DB2_NUM_FAILOVER_NODES
DB2_DJ_INI
DB2TCPCONNMGRS
DB2_SQLROUTINE_PREPOPTS
DB2_ANTIJOIN
DB2_DISABLE_FLUSH_LOG
DB2_SELECTIVITY
DB2_EXTENDED_OPTIMIZATION
DB2_ENABLE_SINGLE_NIS_GROUP
DB2_PINNED_BP
DB2_APM_PERFORMANCE
DB2_XBSA_LIBRARY
DB2DOMAINLIST
DB2_FMP_COMM_HEAPSZ
DB2_LOGGER_NON_BUFFERED_IO
DB2_EVALUNCOMMITTED
DB2TERRITORY
DB2_PARTITIONEDLOAD_DEFAULT
DB2_ALLOCATION_SIZE
DB2_NO_FORK_CHECK
DB2_REDUCED_OPTIMIZATION
DB2_USE_PAGE_CONTAINER_TAG
DB2_NUM_CKPW_DAEMONS
DB2_KEEPTABLELOCK
DB2GRAPHICUNICODESERVER
DB2_MINIMIZE_LISTPREFETCH
DB2_INLIST_TO_NLJN
DB2STMM
DB2_MEM_TUNING_RANGE
DB2_TRUSTED_BINDIN
DB2_CLPPROMPT
DB2_FORCE_APP_ON_MAX_LOG
DB2_CLP_EDITOR
DB2_CLP_HISTSIZE
DB2_LOAD_COPY_NO_OVERRIDE
DB2_MAX_NON_TABLE_LOCKS
DB2_SMS_TRUNC_TMPTABLE_THRESH
DB2_USE_ALTERNATE_PAGE_CLEANING
DB2_HADR_BUF_SIZE
DB2_MAX_CLIENT_CONNRETRIES
DB2_CONNRETRIES_INTERVAL
DB2_DOCHOST
DB2_DOCPORT
DB2_TAPEMGR_TAPE_EXPIRATION
DB2_OBJECT_TABLE_ENTRIES
DB2_LOGGING_DETAIL
DB2_VIEW_REOPT_VALUES
DB2_SELUDI_COMM_BUFFER
DB2_RESOURCE_POLICY
DB2TCP_CLIENT_RCVTIMEOUT
DB2_DDL_SOFT_INVAL
DB2_SKIPINSERTED
DB2CONNECT_DISCONNECT_ON_INTERRUPT
DB2_LARGE_PAGE_MEM
DB2_ALTERNATE_GROUP_LOOKUP
DB2_MIN_IDLE_RESOURCES
DB2AUTH
DB2FODC
DB2RSHCMD
DB2RSHTIMEOUT
DB2_DMU_DEFAULT
DB2_MDC_ROLLOUT
DB2_TRUNCATE_REUSESTORAGE
DB2_WORKLOAD
DB2_DXX_PATHS_ALLOWED_READ
DB2_DXX_PATHS_ALLOWED_WRITE
DB2TCP_CLIENT_CONTIMEOUT
DB2_MAX_INACT_STMTS
DB2_USE_FAST_PREALLOCATION
DB2FCMCOMM
DB2_EXTENDED_IO_FEATURES
DB2_UTIL_MSGPATH
DB2_ENABLE_AUTOCONFIG_DEFAULT
DB2_OPT_MAX_TEMP_SIZE
DB2_MAX_LOB_BLOCK_SIZE
DB2_MINIMUM_CLIENT_LEVEL
DB2CONNECT_ENABLE_EURO_CODEPAGE
DB2_RESOLVE_CALL_CONFLICT
DB2_IO_PRIORITY_SETTING
DB2_EVMON_STMT_FILTER
DB2_SERVER_CONTIMEOUT
DB2_DISPATCHER_PEEKTIMEOUT
DB2_CONNECT_GWY_AUTH_SUPP
DB2_EVMON_EVENT_LIST_SIZE
DB2_MEMORY_PROTECT
DB2_SET_MAX_CONTAINER_SIZE
DB2_UPDDBCFG_SINGLE_DBPARTITION
DB2_LIMIT_FENCED_GROUP
DB2_COMPATIBILITY_VECTOR
DB2_CAPTURE_LOCKTIMEOUT
DB2_HADR_NO_IP_CHECK
DB2_HADR_PEER_WAIT_LIMIT
DB2_OPTSTATS_LOG
DB2_ATS_ENABLE
DB2_PMODEL_SETTINGS
DB2_KEEP_AS_AND_DMS_CONTAINERS_OPEN
DB2RESILIENCE
DB2_FORCE_OFFLINE_ADD_PARTITION
DB2_HADR_SOSNDBUF
DB2_HADR_SORCVBUF
DB2_DEFERRED_PREPARE_SEMANTICS
DB2TCP_CLIENT_KEEPALIVE_TIMEOUT
DB2_PMAP_COMPATIBILITY
DB2_HADR_ROS
DB2_STANDBY_ISO
DB2_NCHAR_SUPPORT
DB2_RESTORE_GRANT_ADMIN_AUTHORITIES
DB2_ENFORCE_MEMBER_SYNTAX
DB2_MEMBER_LOAD_WEIGHT_COMPOSITION
DB2_CF_API_SAMPLING_COUNT
DB2_CF_API_SAMPLING_INTERVAL
DB2_CF_API_SPIN_YIELD_THRESHOLD
DB2_CPU_BINDING
DB2_AVOID_SECONDARY_DELETE
DB2_SAL_FAILOVER_REGISTERPAGES_INSTEADOF_INVALIDATE_ALL
DB2_DATABASE_CF_MEMORY
DB2_MCR_RECOVERY_PARALLELISM_CAP
DB2_CONFIG_OS_ENV
DB2_SQLWORKSPACE_CACHE
DB2TCP_SERVER_KEEPALIVE_TIMEOUT
DB2_INDEX_PCTFREE_DEFAULT
DB2_ALLOW_WLB_WITH_SEQUENCES
DB2_XSLT_ALLOWED_PATH
The machine has 4Gb or memory. There is 2535900k free before I start db2. It's also worth mentioning we are running db2ts which starts an IBM JVM process.
db2inst1@test:~> ipcs -l
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 16777216
max total shared memory (kbytes) = 33554432
min seg size (bytes) = 1
------ Semaphore Limits --------
max number of arrays = 4096
max semaphores per array = 250
max semaphores system wide = 256000
max ops per semop call = 32
semaphore max value = 32767
------ Messages Limits --------
max queues system wide = 16384
max size of message (bytes) = 65536
default max size of queue (bytes) = 65536
Like I said I'm no db2 expert so you'll have to ask me to run specific db2 commands if required. :-)
db2inst1@test:~> db2 get db cfg for TESTDB
Database Configuration for Database TESTDB
Database configuration release level = 0x0f00
Database release level = 0x0f00
Database territory = US
Database code page = 1208
Database code set = UTF-8
Database country/region code = 1
Database collating sequence = SYSTEM_819
Alternate collating sequence (ALT_COLLATE) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Date compatibility = OFF
Database page size = 4096
Statement concentrator (STMT_CONC) = OFF
Discovery support for this database (DISCOVER_DB) = ENABLE
Restrict access = NO
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20
Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN
Backup pending = NO
All committed transactions have been written to disk = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = NO
User exit for logging status = YES
Self tuning memory (SELF_TUNING_MEM) = OFF
Size of database shared memory (4KB) (DATABASE_MEMORY) = COMPUTED(179504)
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(15616)
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(98)
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(52461)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(424)
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(84)
Database heap (4KB) (DBHEAP) = AUTOMATIC(4513)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
Log buffer size (4KB) (LOGBUFSZ) = 2149
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 23607
Buffer pool size (pages) (BUFFPAGE) = 1000
SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(8192)
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40000)
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1
Changed pages threshold (CHNGPGS_THRESH) = 80
Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(1)
Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(3)
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages (TRACKMOD) = NO
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC(40)
Average number of active applications (AVG_APPLS) = AUTOMATIC(1)
Max DB files open per application (MAXFILOP) = 61440
Log file size (4KB) (LOGFILSIZ) = 8192
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 12
Changed path to log files (NEWLOGPATH) =
Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0000191.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
HADR database role = 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
HADR target list (HADR_TARGET_LIST) =
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR spool log data limit (4KB) (HADR_SPOOL_LIMIT) = 0
HADR log replay delay (seconds) (HADR_REPLAY_DELAY) = 0
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
First log archive method (LOGARCHMETH1) = DISK:/opt/db2backups/
Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days) (REC_HIS_RETENTN) = 366
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = ON
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = ON
Automatic runstats (AUTO_RUNSTATS) = ON
Real-time statistics (AUTO_STMT_STATS) = ON
Statistical views (AUTO_STATS_VIEWS) = OFF
Automatic sampling (AUTO_SAMPLING) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Statistics profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF
Auto-Revalidation (AUTO_REVAL) = DEFERRED
Currently Committed (CUR_COMMIT) = ON
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = NEW
Enable XML Character operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = BASE
Activity metrics (MON_ACT_METRICS) = BASE
Object metrics (MON_OBJ_METRICS) = EXTENDED
Unit of work events (MON_UOW_DATA) = NONE
UOW events with package list (MON_UOW_PKGLIST) = OFF
UOW events with executable list (MON_UOW_EXECLIST) = OFF
Lock timeout events (MON_LOCKTIMEOUT) = NONE
Deadlock events (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONE
Lock wait event threshold (MON_LW_THRESH) = 5000000
Number of package list entries (MON_PKGLIST_SZ) = 32
Lock event notification level (MON_LCK_MSG_LVL) = 1
SMTP Server (SMTP_SERVER) =
SQL conditional compilation flags (SQL_CCFLAGS) =
Section actuals setting (SECTION_ACTUALS) = NONE
Connect procedure (CONNECT_PROC) =
Adjust temporal SYSTEM_TIME period (SYSTIME_PERIOD_ADJ) = NO
Log DDL Statements (LOG_DDL_STMTS) = NO
Log Application Information (LOG_APPL_INFO) = NO
Default data capture on new Schemas (DFT_SCHEMAS_DCC) = NO
Database is in write suspend state = NO
db2inst1@test:~> db2set -lr
DB2_OVERRIDE_BPF
DB2_PARALLEL_IO
DB2ACCOUNT
DB2ADMINSERVER
DB2BQTIME
DB2BQTRY
DB2CHKPTR
DB2CLIINIPATH
DB2CODEPAGE
DB2COMM
DB2DBDFT
DB2DBMSADDR
DB2INCLUDE
DB2INSTDEF
DB2INSTPROF
DB2IQTIME
DB2LOADREC
DB2LOCK_TO_RB
DB2NTNOCACHE
DB2NTPRICLASS
DB2NTWORKSET
DB2OPTIONS
DB2PATH
DB2PRIORITIES
DB2REMOTEPREG
DB2RQTIME
DB2SORCVBUF
DB2SORT
DB2SOSNDBUF
DB2SYSTEM
DB2_FORCE_NLS_CACHE
DB2_AVOID_PREFETCH
DB2_COLLECT_TS_REC_INFO
DB2_GRP_LOOKUP
DB2_INDEX_FREE
DB2_MMAP_READ
DB2_MMAP_WRITE
DB2DISCOVERYTIME
DB2ENVLIST
DB2MEMDISCLAIM
DB2LIBPATH
DB2CHKSQLDA
DB2PORTRANGE
DB2INSTOWNER
DB2NOEXITLIST
DB2LOADFLAGS
DB2NTMEMSIZE
DB2CHECKCLIENTINTERVAL
DB2_FALLBACK
DB2PROCESSORS
DB2ATLD_PORTS
DB2_SORT_AFTER_TQ
DB2_LIKE_VARCHAR
DB2ASSUMEUPDATE
DB2MAXFSCRSEARCH
DB2BIDI
DB2_NEW_CORR_SQ_FF
DB2CHGPWD_EEE
DB2LOCALE
DB2_SKIPDELETED
DB2LDAPHOST
DB2LDAPCACHE
DB2LDAP_CLIENT_PROVIDER
DB2LDAP_BASEDN
DB2_ENABLE_LDAP
DB2_SYSTEM_MONITOR_SETTINGS
DB2_FCM_SETTINGS
DB2SATELLITEID
DB2_LIC_STAT_SIZE
DB2CONNECT_IN_APP_PROCESS
DB2_NUM_FAILOVER_NODES
DB2_DJ_INI
DB2TCPCONNMGRS
DB2_SQLROUTINE_PREPOPTS
DB2_ANTIJOIN
DB2_DISABLE_FLUSH_LOG
DB2_SELECTIVITY
DB2_EXTENDED_OPTIMIZATION
DB2_ENABLE_SINGLE_NIS_GROUP
DB2_PINNED_BP
DB2_APM_PERFORMANCE
DB2_XBSA_LIBRARY
DB2DOMAINLIST
DB2_FMP_COMM_HEAPSZ
DB2_LOGGER_NON_BUFFERED_IO
DB2_EVALUNCOMMITTED
DB2TERRITORY
DB2_PARTITIONEDLOAD_DEFAULT
DB2_ALLOCATION_SIZE
DB2_NO_FORK_CHECK
DB2_REDUCED_OPTIMIZATION
DB2_USE_PAGE_CONTAINER_TAG
DB2_NUM_CKPW_DAEMONS
DB2_KEEPTABLELOCK
DB2GRAPHICUNICODESERVER
DB2_MINIMIZE_LISTPREFETCH
DB2_INLIST_TO_NLJN
DB2STMM
DB2_MEM_TUNING_RANGE
DB2_TRUSTED_BINDIN
DB2_CLPPROMPT
DB2_FORCE_APP_ON_MAX_LOG
DB2_CLP_EDITOR
DB2_CLP_HISTSIZE
DB2_LOAD_COPY_NO_OVERRIDE
DB2_MAX_NON_TABLE_LOCKS
DB2_SMS_TRUNC_TMPTABLE_THRESH
DB2_USE_ALTERNATE_PAGE_CLEANING
DB2_HADR_BUF_SIZE
DB2_MAX_CLIENT_CONNRETRIES
DB2_CONNRETRIES_INTERVAL
DB2_DOCHOST
DB2_DOCPORT
DB2_TAPEMGR_TAPE_EXPIRATION
DB2_OBJECT_TABLE_ENTRIES
DB2_LOGGING_DETAIL
DB2_VIEW_REOPT_VALUES
DB2_SELUDI_COMM_BUFFER
DB2_RESOURCE_POLICY
DB2TCP_CLIENT_RCVTIMEOUT
DB2_DDL_SOFT_INVAL
DB2_SKIPINSERTED
DB2CONNECT_DISCONNECT_ON_INTERRUPT
DB2_LARGE_PAGE_MEM
DB2_ALTERNATE_GROUP_LOOKUP
DB2_MIN_IDLE_RESOURCES
DB2AUTH
DB2FODC
DB2RSHCMD
DB2RSHTIMEOUT
DB2_DMU_DEFAULT
DB2_MDC_ROLLOUT
DB2_TRUNCATE_REUSESTORAGE
DB2_WORKLOAD
DB2_DXX_PATHS_ALLOWED_READ
DB2_DXX_PATHS_ALLOWED_WRITE
DB2TCP_CLIENT_CONTIMEOUT
DB2_MAX_INACT_STMTS
DB2_USE_FAST_PREALLOCATION
DB2FCMCOMM
DB2_EXTENDED_IO_FEATURES
DB2_UTIL_MSGPATH
DB2_ENABLE_AUTOCONFIG_DEFAULT
DB2_OPT_MAX_TEMP_SIZE
DB2_MAX_LOB_BLOCK_SIZE
DB2_MINIMUM_CLIENT_LEVEL
DB2CONNECT_ENABLE_EURO_CODEPAGE
DB2_RESOLVE_CALL_CONFLICT
DB2_IO_PRIORITY_SETTING
DB2_EVMON_STMT_FILTER
DB2_SERVER_CONTIMEOUT
DB2_DISPATCHER_PEEKTIMEOUT
DB2_CONNECT_GWY_AUTH_SUPP
DB2_EVMON_EVENT_LIST_SIZE
DB2_MEMORY_PROTECT
DB2_SET_MAX_CONTAINER_SIZE
DB2_UPDDBCFG_SINGLE_DBPARTITION
DB2_LIMIT_FENCED_GROUP
DB2_COMPATIBILITY_VECTOR
DB2_CAPTURE_LOCKTIMEOUT
DB2_HADR_NO_IP_CHECK
DB2_HADR_PEER_WAIT_LIMIT
DB2_OPTSTATS_LOG
DB2_ATS_ENABLE
DB2_PMODEL_SETTINGS
DB2_KEEP_AS_AND_DMS_CONTAINERS_OPEN
DB2RESILIENCE
DB2_FORCE_OFFLINE_ADD_PARTITION
DB2_HADR_SOSNDBUF
DB2_HADR_SORCVBUF
DB2_DEFERRED_PREPARE_SEMANTICS
DB2TCP_CLIENT_KEEPALIVE_TIMEOUT
DB2_PMAP_COMPATIBILITY
DB2_HADR_ROS
DB2_STANDBY_ISO
DB2_NCHAR_SUPPORT
DB2_RESTORE_GRANT_ADMIN_AUTHORITIES
DB2_ENFORCE_MEMBER_SYNTAX
DB2_MEMBER_LOAD_WEIGHT_COMPOSITION
DB2_CF_API_SAMPLING_COUNT
DB2_CF_API_SAMPLING_INTERVAL
DB2_CF_API_SPIN_YIELD_THRESHOLD
DB2_CPU_BINDING
DB2_AVOID_SECONDARY_DELETE
DB2_SAL_FAILOVER_REGISTERPAGES_INSTEADOF_INVALIDATE_ALL
DB2_DATABASE_CF_MEMORY
DB2_MCR_RECOVERY_PARALLELISM_CAP
DB2_CONFIG_OS_ENV
DB2_SQLWORKSPACE_CACHE
DB2TCP_SERVER_KEEPALIVE_TIMEOUT
DB2_INDEX_PCTFREE_DEFAULT
DB2_ALLOW_WLB_WITH_SEQUENCES
DB2_XSLT_ALLOWED_PATH
Simon Temple
Sep 4, 2012, 3:42:30 AM9/4/12
to
We're assuming the problem is due to execution environment not DB2.
This problem was encountered running 10.1 in an OpenVZ vm on the Proxmox virtual environment.
We have switched to using a KVM vm and no longer experience this problem.
This problem was encountered running 10.1 in an OpenVZ vm on the Proxmox virtual environment.
We have switched to using a KVM vm and no longer experience this problem.
0 new messages