SQL 1084C
(1) db2level
[db2inst1@server1 ~]$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL09052"
with level identifier "03030107".
Informational tokens are "DB2 v9.5.0.2", "s080811", "MI00238", and Fix Pack
"2".
Product is installed at "/opt/ibm/db2/server/exp/V9.5".
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL09052"
with level identifier "03030107".
Informational tokens are "DB2 v9.5.0.2", "s080811", "MI00238", and Fix Pack
"2".
Product is installed at "/opt/ibm/db2/server/exp/V9.5".
(2) db2pd -osinfo
[db2inst1@server1 ~]$ db2pd -osinfo
Operating System Information:
OSName: Linux
NodeName: server1
Version: 2
Release: 6
Machine: i686
NodeName: server1
Version: 2
Release: 6
Machine: i686
CPU Information:
TotalCPU OnlineCPU ConfigCPU Speed(MHz) HMTDegree Cores/Socket
2 2 2 2095 1 2
TotalCPU OnlineCPU ConfigCPU Speed(MHz) HMTDegree Cores/Socket
2 2 2 2095 1 2
Physical Memory and Swap (Megabytes):
TotalMem FreeMem AvailMem TotalSwap FreeSwap
1654 997 n/a 997 997
TotalMem FreeMem AvailMem TotalSwap FreeSwap
1654 997 n/a 997 997
Virtual Memory (Megabytes):
Total Reserved Available Free
2651 n/a n/a 1994
Total Reserved Available Free
2651 n/a n/a 1994
Message Queue Information:
MsgSeg MsgMax MsgMap MsgMni MsgTql MsgMnb MsgSsz
n/a 65536 65536 1024 65536 65536 16
MsgSeg MsgMax MsgMap MsgMni MsgTql MsgMnb MsgSsz
n/a 65536 65536 1024 65536 65536 16
Shared Memory Information:
ShmMax ShmMin ShmIds ShmSeg
3499999999 1 4096 4096
ShmMax ShmMin ShmIds ShmSeg
3499999999 1 4096 4096
Semaphore Information:
SemMap SemMni SemMns SemMnu SemMsl SemOpm SemUme SemUsz SemVmx SemAem
32000 1024 32000 32000 250 32 n/a 20 32767 32767
SemMap SemMni SemMns SemMnu SemMsl SemOpm SemUme SemUsz SemVmx SemAem
32000 1024 32000 32000 250 32 n/a 20 32767 32767
(3) more /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.
# Controls IP packet forwarding
net.ipv4.ip_forward = 0
net.ipv4.ip_forward = 0
# Controls source route verification
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.rp_filter = 1
# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.conf.default.accept_source_route = 0
# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0
kernel.sysrq = 0
# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1
# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_syncookies = 1
# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536
kernel.msgmnb = 65536
# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536
kernel.msgmax = 65536
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 7794967295
#kernel.shmmax = 573741824
#4294967295
# Controls the maximum number of shared memory segments, in pages
#kernel.shmall = 862144
kernel.shmall = 86214400
kernel.shmmax = 7794967295
#kernel.shmmax = 573741824
#4294967295
# Controls the maximum number of shared memory segments, in pages
#kernel.shmall = 862144
kernel.shmall = 86214400
(4) db2 get dbm cfg show detail
[db2inst1@server1 ~]$ db2 get dbm cfg show detail
Database Manager Configuration
Node type = Database Server with local and remote clients
Description Parameter Current Value Delayed Value
---------------------------------------------------------------------------------------------------------------
Database manager configuration release level = 0x0c00
---------------------------------------------------------------------------------------------------------------
Database manager configuration release level = 0x0c00
CPU speed (millisec/instruction) (CPUSPEED) = 4.959614e-07 4.959614e-07
Max number of concurrently active databases (NUMDB) = 8 8
Federated Database System Support (FEDERATED) = NO NO
Federated Database System Support (FEDERATED) = NO NO
Java Development Kit installation path (JDK_PATH) = /home/db2inst1/sqllib/java/jdk32 /home/db2inst1/sqllib/java/jdk32
Diagnostic error capture level (DIAGLEVEL) = 3 3
Notify Level (NOTIFYLEVEL) = 3 3
Diagnostic data directory path (DIAGPATH) = /home/db2inst1/diagpath /home/db2inst1/diagpath
Database manager authentication (AUTHENTICATION) = SERVER SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO NO
Trust all clients (TRUST_ALLCLNTS) = YES YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT CLIENT
Bypass federated authentication (FED_NOAUTH) = NO NO
Notify Level (NOTIFYLEVEL) = 3 3
Diagnostic data directory path (DIAGPATH) = /home/db2inst1/diagpath /home/db2inst1/diagpath
Database manager authentication (AUTHENTICATION) = SERVER SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO NO
Trust all clients (TRUST_ALLCLNTS) = YES YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT CLIENT
Bypass federated authentication (FED_NOAUTH) = NO NO
Default database path (DFTDBPATH) = /home/db2inst1 /home/db2inst1
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(90) AUTOMATIC(90)
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(317542) AUTOMATIC(317542)
Backup buffer default size (4KB) (BACKBUFSZ) = 1024 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024 1024
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(317542) AUTOMATIC(317542)
Backup buffer default size (4KB) (BACKBUFSZ) = 1024 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024 1024
Agent stack size (AGENT_STACK_SZ) = 256 256
Sort heap threshold (4KB) (SHEAPTHRES) = 0 0
Sort heap threshold (4KB) (SHEAPTHRES) = 0 0
Directory cache support (DIR_CACHE) = YES YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000 1000
Max requester I/O block size (bytes) (RQRIOBLK) = 32767 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000 1000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10 10
Priority of agents (AGENTPRI) = SYSTEM SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100) AUTOMATIC(100)
Initial number of agents in pool (NUM_INITAGENTS) = 0 0
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200) AUTOMATIC(200)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS) AUTOMATIC(MAX_COORDAGENTS)
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100) AUTOMATIC(100)
Initial number of agents in pool (NUM_INITAGENTS) = 0 0
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200) AUTOMATIC(200)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS) AUTOMATIC(MAX_COORDAGENTS)
Keep fenced process (KEEPFENCED) = YES YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS) AUTOMATIC(MAX_COORDAGENTS)
Initial number of fenced processes (NUM_INITFENCED) = 0 0
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS) AUTOMATIC(MAX_COORDAGENTS)
Initial number of fenced processes (NUM_INITFENCED) = 0 0
Index re-creation time and redo index build (INDEXREC) = RESTART RESTART
SPM log size (SPM_LOG_FILE_SZ) = 256 256
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(1024) AUTOMATIC(1024)
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(512) AUTOMATIC(512)
db2start/db2stop timeout (min) (START_STOP_TIME) = 10 10
(5) db2 create database sample
[db2inst1@server1 ~]$ db2 create database sample
SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019
SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019
(6) db2diag
2011-05-26-17.36.37.525681+480 E45968G1187 LEVEL: Event
PID : 5241 TID : 3086583488 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09052"
with level identifier "03030107".
Informational tokens are "DB2 v9.5.0.2", "s080811", "MI00238", Fix Pack "2".
DATA #2 : System Info, 436 bytes
System: Linux server1 6 2 i686
CPU: total:2 online:2 Cores per socket:2 Threading degree per core:1
Physical Memory(MB): total:1654 free:1032
Virtual Memory(MB): total:2651 free:2029
Swap Memory(MB): total:997 free:997
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:1024
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:3499999999 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
PID : 5241 TID : 3086583488 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09052"
with level identifier "03030107".
Informational tokens are "DB2 v9.5.0.2", "s080811", "MI00238", Fix Pack "2".
DATA #2 : System Info, 436 bytes
System: Linux server1 6 2 i686
CPU: total:2 online:2 Cores per socket:2 Threading degree per core:1
Physical Memory(MB): total:1654 free:1032
Virtual Memory(MB): total:2651 free:2029
Swap Memory(MB): total:997 free:997
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:1024
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:3499999999 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
2011-05-26-17.51.17.186242+480 I48662G671 LEVEL: Error (OS)
PID : 5253 TID : 3042962320 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:110
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
CALLED : OS, -, shmget OSERR: ENOMEM (12)
DATA #1 : String, 38 bytes
Failure getting shared memory segment.
DATA #2 : Shared memory key, PD_TYPE_SHM_KEY, 4 bytes
0
DATA #3 : Shared memory flags, PD_TYPE_SHM_FLAGS, 4 bytes
4033
PID : 5253 TID : 3042962320 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:110
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
CALLED : OS, -, shmget OSERR: ENOMEM (12)
DATA #1 : String, 38 bytes
Failure getting shared memory segment.
DATA #2 : Shared memory key, PD_TYPE_SHM_KEY, 4 bytes
0
DATA #3 : Shared memory flags, PD_TYPE_SHM_FLAGS, 4 bytes
4033
2011-05-26-17.51.17.213236+480 E49334G476 LEVEL: Error
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloRequestMemPinSet, probe:80
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 28 bytes
Failed to allocate hugepages
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloRequestMemPinSet, probe:80
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 28 bytes
Failed to allocate hugepages
2011-05-26-17.51.17.213965+480 I49811G547 LEVEL: Error (OS)
PID : 5253 TID : 3042962320 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:100
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
CALLED : OS, -, shmctl OSERR: EIDRM (43)
DATA #1 : String, 34 bytes
Failure locking segment in memory.
PID : 5253 TID : 3042962320 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:100
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
CALLED : OS, -, shmctl OSERR: EIDRM (43)
DATA #1 : String, 34 bytes
Failure locking segment in memory.
2011-05-26-17.51.17.215404+480 E50359G511 LEVEL: Error
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloRequestMemPinSet, probe:60
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 63 bytes
Can not continue with DB2_PINNED_BP=true, disabling to continue
2011-05-26-17.51.17.215409+480 I50871G490 LEVEL: Error
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:120
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 35 bytes
Memory segment could not be pinned.
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:120
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 35 bytes
Memory segment could not be pinned.
2011-05-26-17.51.17.215412+480 I51362G912 LEVEL: Warning
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1516
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 286 bytes
Failed to allocate the desired database shared memory set.
Check to make sure the configured DATABASE_MEMORY + overflow
does not exceed the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
113967104
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1516
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 286 bytes
Failed to allocate the desired database shared memory set.
Check to make sure the configured DATABASE_MEMORY + overflow
does not exceed the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
113967104
2011-05-26-17.51.17.231917+480 I52275G671 LEVEL: Error (OS)
PID : 5253 TID : 3042962320 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:110
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
CALLED : OS, -, shmget OSERR: ENOMEM (12)
DATA #1 : String, 38 bytes
Failure getting shared memory segment.
DATA #2 : Shared memory key, PD_TYPE_SHM_KEY, 4 bytes
0
DATA #3 : Shared memory flags, PD_TYPE_SHM_FLAGS, 4 bytes
4033
PID : 5253 TID : 3042962320 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:110
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
CALLED : OS, -, shmget OSERR: ENOMEM (12)
DATA #1 : String, 38 bytes
Failure getting shared memory segment.
DATA #2 : Shared memory key, PD_TYPE_SHM_KEY, 4 bytes
0
DATA #3 : Shared memory flags, PD_TYPE_SHM_FLAGS, 4 bytes
4033
2011-05-26-17.51.17.232307+480 E52947G476 LEVEL: Error
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloRequestMemPinSet, probe:80
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 28 bytes
Failed to allocate hugepages
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloRequestMemPinSet, probe:80
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 28 bytes
Failed to allocate hugepages
2011-05-26-17.51.17.232989+480 I53424G547 LEVEL: Error (OS)
PID : 5253 TID : 3042962320 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:100
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
CALLED : OS, -, shmctl OSERR: EIDRM (43)
DATA #1 : String, 34 bytes
Failure locking segment in memory.
PID : 5253 TID : 3042962320 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:100
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid memory addr"
DIA8561C A invalid memory block was encountered.
CALLED : OS, -, shmctl OSERR: EIDRM (43)
DATA #1 : String, 34 bytes
Failure locking segment in memory.
2011-05-26-17.51.17.233405+480 E53972G511 LEVEL: Error
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloRequestMemPinSet, probe:60
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 63 bytes
Can not continue with DB2_PINNED_BP=true, disabling to continue
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloRequestMemPinSet, probe:60
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 63 bytes
Can not continue with DB2_PINNED_BP=true, disabling to continue
2011-05-26-17.51.17.233413+480 I54484G490 LEVEL: Error
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:120
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 35 bytes
Memory segment could not be pinned.
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:120
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : String, 35 bytes
Memory segment could not be pinned.
2011-05-26-17.51.17.233958+480 I54975G826 LEVEL: Severe
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1718
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 202 bytes
Failed to allocate the minimum possible database shared memory set.
There is insufficient system resources to allocate the database
shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
88342528
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1718
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 202 bytes
Failed to allocate the minimum possible database shared memory set.
There is insufficient system resources to allocate the database
shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
88342528
2011-05-26-17.51.17.237849+480 I55802G548 LEVEL: Severe
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:20
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
PID : 5255 TID : 3080711056 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.110526095116
AUTHID : DB2INST1
EDUID : 16 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:20
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
(7) db2trc
dump file
15 exit DB2 UDB oper system services sqlorqueInternal fnc (2.3.15.579.0)
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59045000
rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
15 exit DB2 UDB oper system services sqlorqueInternal fnc (2.3.15.579.0)
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59045000
rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
16 entry DB2 UDB SQO Memory Management sqlofmblkEx cei (1.3.129.33.2)
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59047000
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59047000
bytes 12
Data1 (PD_TYPE_PTR,4) Pointer:
0x00aa24c0
0x00aa24c0
17 mbt DB2 UDB SQO Memory Management sqlofmblkEx cei (6.3.129.33.2.32770)
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59054000
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59054000
Marker:PD_OSS_FREED_MEMORY
Description: Freeing memory
bytes 12
Description: Freeing memory
bytes 12
Data1 (PD_TYPE_PTR,4) Pointer:
0x00aa24c0
0x00aa24c0
18 exit DB2 UDB SQO Memory Management sqlofmblkEx cei (2.3.129.33.2)
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59056000
rc = 0
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59056000
rc = 0
19 exit DB2 UDB oper system services sqlorque2 fnc (2.3.15.580.0)
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59058000
rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
pid 5488 tid 10714352 cpid 7 node 0 sec 1 nsec 59058000
rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
folw file
pid = 13840 tid = 2511952 node = -1
1 sqlexPluginUnload entry
2 | sqlofmblkEx entry
3 | sqlofmblkEx mbt [Marker:PD_OSS_FREED_MEMORY ]
4 | sqlofmblkEx exit
5 | sqlofmblkEx entry
6 | sqlofmblkEx mbt [Marker:PD_OSS_FREED_MEMORY ]
7 | sqlofmblkEx exit
8 sqlexPluginUnload exit
2 | sqlofmblkEx entry
3 | sqlofmblkEx mbt [Marker:PD_OSS_FREED_MEMORY ]
4 | sqlofmblkEx exit
5 | sqlofmblkEx entry
6 | sqlofmblkEx mbt [Marker:PD_OSS_FREED_MEMORY ]
7 | sqlofmblkEx exit
8 sqlexPluginUnload exit
pid = 5488 tid = 10714352 node = 0
9 sqloClearAlarmApp entry
10 | sqloSigMask entry
11 | sqloSigMask exit
12 | sqlohsig entry
13 | sqlohsig exit
14 sqloClearAlarmApp exit
15 sqlorqueInternal exit [rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT]
16 sqlofmblkEx entry
17 sqlofmblkEx mbt [Marker:PD_OSS_FREED_MEMORY ]
18 sqlofmblkEx exit
19 sqlorque2 exit [rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT]
20 clp_bp_con data [probe 21]
21 | sqlossig entry
22 | sqlossig exit
23 | sqlorque2 entry
24 | | sqlogmblkEx entry
25 | | | sqloGetPrivatePoolHandle entry
26 | | | sqloGetPrivatePoolHandle exit
27 | | sqlogmblkEx mbt [Marker:PD_OSS_ALLOCATED_MEMORY ]
28 | | sqlogmblkEx exit
29 | | sqlorqueInternal entry
30 | | | sqloSetAlarmApp entry
31 | | | | sqloSigMask entry
32 | | | | sqloSigMask exit
33 | | | | sqlohsig entry
34 | | | | sqlohsig exit
35 | | | sqloSetAlarmApp exit
1886 | | | sqloClearAlarmApp entry
1887 | | | | sqloSigMask entry
1888 | | | | sqloSigMask exit
1889 | | | | sqlohsig entry
1890 | | | | sqlohsig exit
1891 | | | sqloClearAlarmApp exit
1892 | | sqlorqueInternal exit [rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT]
1893 | | sqlofmblkEx entry
1894 | | sqlofmblkEx mbt [Marker:PD_OSS_FREED_MEMORY ]
1895 | | sqlofmblkEx exit
1896 | sqlorque2 exit [rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT]
1897 clp_bp_con data [probe 21]
1898 | sqlossig entry
1899 | sqlossig exit
1900 | sqlorque2 entry
1901 | | sqlogmblkEx entry
1902 | | | sqloGetPrivatePoolHandle entry
1903 | | | sqloGetPrivatePoolHandle exit
1904 | | sqlogmblkEx mbt [Marker:PD_OSS_ALLOCATED_MEMORY ]
1905 | | sqlogmblkEx exit
1906 | | sqlorqueInternal entry
1907 | | | sqloSetAlarmApp entry
1908 | | | | sqloSigMask entry
1909 | | | | sqloSigMask exit
1910 | | | | sqlohsig entry
1911 | | | | sqlohsig exit
10 | sqloSigMask entry
11 | sqloSigMask exit
12 | sqlohsig entry
13 | sqlohsig exit
14 sqloClearAlarmApp exit
15 sqlorqueInternal exit [rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT]
16 sqlofmblkEx entry
17 sqlofmblkEx mbt [Marker:PD_OSS_FREED_MEMORY ]
18 sqlofmblkEx exit
19 sqlorque2 exit [rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT]
20 clp_bp_con data [probe 21]
21 | sqlossig entry
22 | sqlossig exit
23 | sqlorque2 entry
24 | | sqlogmblkEx entry
25 | | | sqloGetPrivatePoolHandle entry
26 | | | sqloGetPrivatePoolHandle exit
27 | | sqlogmblkEx mbt [Marker:PD_OSS_ALLOCATED_MEMORY ]
28 | | sqlogmblkEx exit
29 | | sqlorqueInternal entry
30 | | | sqloSetAlarmApp entry
31 | | | | sqloSigMask entry
32 | | | | sqloSigMask exit
33 | | | | sqlohsig entry
34 | | | | sqlohsig exit
35 | | | sqloSetAlarmApp exit
1886 | | | sqloClearAlarmApp entry
1887 | | | | sqloSigMask entry
1888 | | | | sqloSigMask exit
1889 | | | | sqlohsig entry
1890 | | | | sqlohsig exit
1891 | | | sqloClearAlarmApp exit
1892 | | sqlorqueInternal exit [rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT]
1893 | | sqlofmblkEx entry
1894 | | sqlofmblkEx mbt [Marker:PD_OSS_FREED_MEMORY ]
1895 | | sqlofmblkEx exit
1896 | sqlorque2 exit [rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT]
1897 clp_bp_con data [probe 21]
1898 | sqlossig entry
1899 | sqlossig exit
1900 | sqlorque2 entry
1901 | | sqlogmblkEx entry
1902 | | | sqloGetPrivatePoolHandle entry
1903 | | | sqloGetPrivatePoolHandle exit
1904 | | sqlogmblkEx mbt [Marker:PD_OSS_ALLOCATED_MEMORY ]
1905 | | sqlogmblkEx exit
1906 | | sqlorqueInternal entry
1907 | | | sqloSetAlarmApp entry
1908 | | | | sqloSigMask entry
1909 | | | | sqloSigMask exit
1910 | | | | sqlohsig entry
1911 | | | | sqlohsig exit
(8) db2diag -rc 0x870F00B9
[db2inst1@server1 diagpath]$ db2diag -rc 0x870F00B9
[db2inst1@server1 diagpath]$ db2diag -rc 0x870F00B9
Input ZRC string '0x870F00B9' parsed as 0x870F00B9 (-2029059911).
ZRC value to map: 0x870F00B9 (-2029059911)
ZRC class :
Global Processing Error (Class Index: 7)
Component:
SQLO ; oper system services (Component Index: 15)
Reason Code:
185 (0x00B9)
Global Processing Error (Class Index: 7)
Component:
SQLO ; oper system services (Component Index: 15)
Reason Code:
185 (0x00B9)
Identifer:
SQLO_SEM_TIMEOUT
SQLO_QUE_TIMEOUT
Identifer (without component):
SQLZ_OSS_INTERNAL_ERROR_31
SQLO_SEM_TIMEOUT
SQLO_QUE_TIMEOUT
Identifer (without component):
SQLZ_OSS_INTERNAL_ERROR_31
Description:
Return code from sqlowait when time out value has been reached
Return code from sqlowait when time out value has been reached
Associated information:
Sqlcode -902
SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed.
Sqlcode -902
SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed.
Number of sqlca tokens : 1
Diaglog message number: 1
Diaglog message number: 1
(9) db2 ? SQL0902C
F:Program FilesIBMSQLLIBBIN>db2 ? SQL0902C
SQL0902C 发生系统错误 (原因码："<原因码>")。无法处理后续的 SQL
语句。
说明:
发生了系统错误。
用户响应:
记录消息中的消息号 (SQLCODE) 和原因码。
如果跟踪是活动的，那么在操作系统命令提示符处调用"独立跟踪设施"。然后与
技术服务代表联系，并提供以下信息：
* 问题描述
* SQLCODE 和嵌入式原因码
* 如果可能的话，还应提供 SQLCA 内容
* 如果可能的话，还应提供跟踪文件。
技术服务代表联系，并提供以下信息：
* 问题描述
* SQLCODE 和嵌入式原因码
* 如果可能的话，还应提供 SQLCA 内容
* 如果可能的话，还应提供跟踪文件。
联合系统用户：找出使请求失败的数据源中的问题（请参阅《故障诊断指南》以
确定哪个数据源导致 SQL 语句处理失败），并对该数据源执行必需的诊断步骤。
数据源的问题确定过程各有不同，因此参阅适用的数据源手册。
确定哪个数据源导致 SQL 语句处理失败），并对该数据源执行必需的诊断步骤。
数据源的问题确定过程各有不同，因此参阅适用的数据源手册。
sqlcode：-902
sqlstate：58005
(10) db2 ? sql1084c
F:Program FilesIBMSQLLIBBIN>db2 ? sql1084c
SQL1084C 不能分配共享内存段。
说明:
数据库管理器的内存资源不足时将返回此错误。激活数据库时，数据库管理器未
能分配共享内存。
能分配共享内存。
用户响应:
通过运行以下命令来检查所有数据库配置参数的值以确保为它们设置的值都在建
议范围内：
议范围内：
* DB2 AUTOCONFIGURE APPLY NONE
要增加数据库管理器可用的内存量，可执行以下操作：
* 增大 instance_memory 配置参数的值。
* 增大用于限制数据库管理器可用操作系统内存量的操作系统内核设置的值。
* 在 Linux 系统上，SHMMAX 配置参数的缺省值对于 DB2 LUW 并不足够大。请
参阅 DB2 信息中心中的"修改内核参数（Linux）"主题。
* 增大用于限制数据库管理器可用操作系统内存量的操作系统内核设置的值。
* 在 Linux 系统上，SHMMAX 配置参数的缺省值对于 DB2 LUW 并不足够大。请
参阅 DB2 信息中心中的"修改内核参数（Linux）"主题。
要减小数据库使用的内存量，可执行以下操作：
* 减小 database_memory 配置参数的值。
增大或减小这些设置时，应按较小的增量执行此操作（每次增大或减小 5% 到 10
%），直到成功为止。
%），直到成功为止。
如果在具有足够内存资源的情况下仍然发生该问题，请与技术服务代表联系并提
供下列信息：
供下列信息：
* 问题描述
* SQLCODE 或消息号
* 如果可能的话，还应提供 SQLCA 内容
* 数据库管理器配置设置
* 数据库配置设置
* SQLCODE 或消息号
* 如果可能的话，还应提供 SQLCA 内容
* 数据库管理器配置设置
* 数据库配置设置
(11) db2 ? sql0930n
F:Program FilesIBMSQLLIBBIN>db2 ? sql0930n
SQL0930N 没有足够的存储空间可用来处理语句。
说明:
请求了需要其他内存页的数据库，但是，没有更多页可用于数据库管理器。
无法处理该语句。
用户响应:
可以采用的解决方案包括：
* 验证系统是否有足够的实际内存和虚拟内存。
* 除去后台进程。
* 如果在 DUOW 再同步期间出错，那么请减小 RESYNC_INTERVAL 数据库管理器
配置参数值。
* 如果错误发生在引用例程（UDF、存储过程或方法）的语句上，那么可能是包
含自变量和返回值所需要的存储量大于系统上的可用内存。如果例程是使用
BLOB、CLOB、DBCLOB 参数或返回值定义的，具有很大的大小（例如 2GB），
可能会发生此情况。
* 除去后台进程。
* 如果在 DUOW 再同步期间出错，那么请减小 RESYNC_INTERVAL 数据库管理器
配置参数值。
* 如果错误发生在引用例程（UDF、存储过程或方法）的语句上，那么可能是包
含自变量和返回值所需要的存储量大于系统上的可用内存。如果例程是使用
BLOB、CLOB、DBCLOB 参数或返回值定义的，具有很大的大小（例如 2GB），
可能会发生此情况。
如果上面列示的可能解决方案无法解决问题，那么可能需要考虑更改例程的定义。
sqlcode：-930
sqlstate：57011 和 5UA0L
(12) db2 list db directory
[db2inst1@server1 diagpath]$ db2 list db directory
SQL1057W The system database directory is empty. SQLSTATE=01606
SQL1057W The system database directory is empty. SQLSTATE=01606
(13)db2ilist
[db2inst1@server1 diagpath]$ db2ilist
db2inst1
db2inst1
(14)db2pd -memsets
[db2inst1@server1 diagpath]$ db2pd -memsets
[db2inst1@server1 diagpath]$ db2pd -memsets
Database Partition 0 -- Active -- Up 0 days 00:38:19
Memory Sets:
Name Address Id Size(Kb) Key DBP Type Unrsv(Kb) Used(Kb) HWM(Kb) Cmt(Kb) Uncmt(Kb)
DBMS 0x10000000 98306 33152 0x7FF11361 0 0 5248 11392 11648 11648 21504
FMP 0x12060000 131075 22592 0x0 0 0 2 0 192 22592 0
Trace 0x00000000 65537 8487 0x7FF11374 0 -1 0 8487 0 8487 0
Name Address Id Size(Kb) Key DBP Type Unrsv(Kb) Used(Kb) HWM(Kb) Cmt(Kb) Uncmt(Kb)
DBMS 0x10000000 98306 33152 0x7FF11361 0 0 5248 11392 11648 11648 21504
FMP 0x12060000 131075 22592 0x0 0 0 2 0 192 22592 0
Trace 0x00000000 65537 8487 0x7FF11374 0 -1 0 8487 0 8487 0
著作权归作者所有
如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！
赞0Ctrl+Enter 发表
添加新评论0 条评论