IT分销/经销数据库
db2 重启分配内存错误
[db2inst1@localhost ~]$ free
total used free shared buffers cached
Mem: 4149904 1099156 3050748 0 32344 552948
-/+ buffers/cache: 513864 3636040 --还有3G内存空闲
Swap: 2031608 0 2031608
--
[db2inst1@localhost ~]$ db2 connect to suzhou
SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019
--日志如下
2010-11-05-15.35.28.449778+480 E8617819G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.450168+480 E8618772G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.451060+480 E8619708G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.451314+480 E8620661G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.453627+480 E8621517G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.453923+480 E8622470G935 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.454743+480 E8623406G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.455004+480 E8624359G855 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.455319+480 I8625215G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.35.28.455366+480 I8625791G575 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.35.41.425834+480 E8626367G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.426170+480 E8627320G935 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.426997+480 E8628256G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.427251+480 E8629209G855 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.427810+480 I8630065G575 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.35.41.430975+480 E8630641G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.431251+480 E8631594G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.432084+480 E8632530G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.432358+480 E8633483G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.432726+480 I8634339G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.15.773109+480 E8634915G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.15.773446+480 E8635868G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.15.774276+480 E8636804G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.15.774533+480 E8637757G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.15.775178+480 I8638613G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.38.065628+480 E8639189G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.065968+480 E8640142G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.066805+480 E8641078G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.067064+480 E8642031G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.067708+480 I8642887G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.38.069759+480 E8643463G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.070046+480 E8644416G935 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.070838+480 E8645352G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.071094+480 E8646305G855 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.071481+480 I8647161G575 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.46.041798+480 E8647737G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.042139+480 E8648690G935 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.042983+480 E8649626G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.043247+480 E8650579G855 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.043904+480 I8651435G575 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.46.045844+480 E8652011G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.046128+480 E8652964G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.046926+480 E8653900G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.047200+480 E8654853G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.047563+480 I8655709G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.47.820401+480 E8656285G949 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.47.820736+480 E8657235G932 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.47.821567+480 E8658168G949 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.47.821848+480 E8659118G852 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.47.822473+480 I8659971G572 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
total used free shared buffers cached
Mem: 4149904 1099156 3050748 0 32344 552948
-/+ buffers/cache: 513864 3636040 --还有3G内存空闲
Swap: 2031608 0 2031608
--
[db2inst1@localhost ~]$ db2 connect to suzhou
SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019
--日志如下
2010-11-05-15.35.28.449778+480 E8617819G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.450168+480 E8618772G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.451060+480 E8619708G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.451314+480 E8620661G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.453627+480 E8621517G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.453923+480 E8622470G935 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.454743+480 E8623406G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.455004+480 E8624359G855 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.28.455319+480 I8625215G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-79 APPID: 192.168.6.248.61993.10110507352
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.35.28.455366+480 I8625791G575 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-80 APPID: 192.168.6.248.61994.10110507352
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.35.41.425834+480 E8626367G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.426170+480 E8627320G935 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.426997+480 E8628256G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.427251+480 E8629209G855 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.427810+480 I8630065G575 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-81 APPID: 192.168.6.248.61997.10110507354
AUTHID : L_SZ_V5
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.35.41.430975+480 E8630641G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.431251+480 E8631594G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.432084+480 E8632530G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.432358+480 E8633483G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.35.41.432726+480 I8634339G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-82 APPID: 192.168.6.248.61996.10110507354
AUTHID : L_SZ_V5
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.15.773109+480 E8634915G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.15.773446+480 E8635868G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.15.774276+480 E8636804G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.15.774533+480 E8637757G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.15.775178+480 I8638613G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-83 APPID: 192.168.6.248.61998.10110507361
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.38.065628+480 E8639189G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.065968+480 E8640142G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.066805+480 E8641078G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.067064+480 E8642031G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.067708+480 I8642887G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-84 APPID: 192.168.6.248.62001.10110507363
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.38.069759+480 E8643463G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.070046+480 E8644416G935 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.070838+480 E8645352G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.071094+480 E8646305G855 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.38.071481+480 I8647161G575 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-85 APPID: 192.168.6.248.62002.10110507363
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.46.041798+480 E8647737G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.042139+480 E8648690G935 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.042983+480 E8649626G952 LEVEL: Warning
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.043247+480 E8650579G855 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.043904+480 I8651435G575 LEVEL: Severe
PID : 4708 TID : 1855974288 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-86 APPID: 192.168.6.248.62004.10110507364
AUTHID : L_SZ_V6
EDUID : 117 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.46.045844+480 E8652011G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.046128+480 E8652964G935 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.046926+480 E8653900G952 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.047200+480 E8654853G855 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.46.047563+480 I8655709G575 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-87 APPID: 192.168.6.248.62005.10110507364
AUTHID : L_SZ_V6
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
2010-11-05-15.36.47.820401+480 E8656285G949 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.47.820736+480 E8657235G932 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.47.821567+480 E8658168G949 LEVEL: Warning
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.47.821848+480 E8659118G852 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:120
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 203 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
1782579200
2010-11-05-15.36.47.822473+480 I8659971G572 LEVEL: Severe
PID : 4708 TID : 2949639056 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SUZHOU
APPHDL : 0-88 APPID: *LOCAL.db2inst1.101105073648
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (SUZHOU) 0
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.
附件：
suzhou.rar (8.44 KB)
db2support.zip (3.48 MB)
suzhou_memory.rar (4.38 KB)
db2support.zip (3.08 MB)
db2.rar (523.92 KB)
跟踪日志.rar (9.57 MB)
db2diag.0.rar (25.01 KB)
db2diag.0.rar (25.01 KB)
db2.rar (6.38 MB)
db2-11-24.rar (8.03 MB)
128同行回答
这个分挣得真不容易！ 我感谢 wangzhonnew ！收起
浏览567
嘿嘿，基本讨论也都完了，结论也出来了，workaround也有了，可以给你那25分了吧（挣点钱容易么）收起
浏览512
本身v95的多线程就会相比起v8/v9的进程模型会多用一些memory address space（因为所有线程的stack heap之类的都放在一个进程下面了）
如果真的跑32位，又需要很大的内存段，还不如跑v91，至少能节省不少线程的stack/heap（就是那些什么anon (anonymous) 的东东）收起
如果真的跑32位，又需要很大的内存段，还不如跑v91，至少能节省不少线程的stack/heap（就是那些什么anon (anonymous) 的东东）收起
浏览547
to wangzhonnew
我们的系统将来是跑在windows 2003（或2008）上，32位还是64位这个 现在我还不大确定
原来系统是跑着oracle上的，oracle+linux 倒是没有这方面的事情
下次我装一台 windows2003跑一下看看，现在计算机还未到位呢收起
我们的系统将来是跑在windows 2003（或2008）上，32位还是64位这个 现在我还不大确定
原来系统是跑着oracle上的，oracle+linux 倒是没有这方面的事情
下次我装一台 windows2003跑一下看看，现在计算机还未到位呢收起
浏览535
在v95 v97里面，很少有人会用来跑32位系统，如果真的跑32位的大部分都是那种很小的应用，占用个1G内存撑死的
对于比较正常的应用主要都跑在64位里面…… 在64位里面这样128K的寻址空间基本可以忽略不计~~~
每次"db2"进程和engine通讯的时候，都要启动一个db2bp作为后台的连接，db2进程和db2bp用message queue通讯，而db2bp和本地instance就用那个LCL共享内存交换信息了（当然也需要message queue）。而为了效率db2不会每次都弄出一个db2bp然后干掉，自然而然就会保持一个db2bp的后台响应对应的session里面的命令了，也就是一个LCL收起
对于比较正常的应用主要都跑在64位里面…… 在64位里面这样128K的寻址空间基本可以忽略不计~~~
每次"db2"进程和engine通讯的时候，都要启动一个db2bp作为后台的连接，db2进程和db2bp用message queue通讯，而db2bp和本地instance就用那个LCL共享内存交换信息了（当然也需要message queue）。而为了效率db2不会每次都弄出一个db2bp然后干掉，自然而然就会保持一个db2bp的后台响应对应的session里面的命令了，也就是一个LCL收起
浏览528
to mdkii
2、每次新连接自然要新申请空间，新起个名字吧。
数据库都inactive了，哪来的连接啊，看日志 在不停的变化
你可以看我 记录的日志里 （1分钟记录一次，每次的名字都不一样）
1、貌似需要terminate才能释放，只有terminate命令才能把后台的db2bp进程终止掉。
我将修改我的 监控脚本 加入 db2 terminate 看看
to wangzhonnew
每一个local connection都有一个LCL，如果你force application，但是db2bp还存在，你依然会看到那个LCL内存
我不知道 db2 attach to db2inst1 和 db2 get db cfg for suzhou show detail
也会产生LCL连接，我将在监控脚本里去掉这两项，反正最近也没有修改过参数，不用监控了收起
2、每次新连接自然要新申请空间，新起个名字吧。
数据库都inactive了，哪来的连接啊，看日志 在不停的变化
你可以看我 记录的日志里 （1分钟记录一次，每次的名字都不一样）
1、貌似需要terminate才能释放，只有terminate命令才能把后台的db2bp进程终止掉。
我将修改我的 监控脚本 加入 db2 terminate 看看
to wangzhonnew
每一个local connection都有一个LCL，如果你force application，但是db2bp还存在，你依然会看到那个LCL内存
我不知道 db2 attach to db2inst1 和 db2 get db cfg for suzhou show detail
也会产生LCL连接，我将在监控脚本里去掉这两项，反正最近也没有修改过参数，不用监控了收起
浏览517