注册登录
提 问
English中文版
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.

附件：

附件图标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)

关注1
评论
参与129

128同行回答
|
按赞同排序
按时间排序

nowhillnowhill系统工程师
改小DATABASE_MEMORY  为1600M改小 afclc_bpool 为900M我昨天把内存改小了，就没有出现错误了to wangzhonnew，我是不是把 内存 改回去？显示全部
改小DATABASE_MEMORY  为1600M
改小 afclc_bpool 为900M

我昨天把内存改小了，就没有出现错误了
to wangzhonnew，我是不是把 内存 改回去？收起
IT分销/经销 · 2010-11-17
浏览541
评论
nowhillnowhill系统工程师
我怎么才能知道 db2  发生过 数据库inactive（连接全部断开后），然后 又 active了（新的连接上去了）这个我自己观察了 一下，2010-11-16-19.58.39.965181+480 E5309G467          LEVEL: EventPID     : 6827  &...显示全部
我怎么才能知道 db2  发生过 数据库inactive（连接全部断开后），然后 又 active了（新的连接上去了）

这个我自己观察了 一下，
2010-11-16-19.58.39.965181+480 E5309G467          LEVEL: Event
PID     : 6827                 TID  : 1074785168  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-45173              APPID: 192.168.5.202.1714.101116065438
AUTHID  : L_SZ_V6
EDUID   : 23802                EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-00.10.05.392697+480 E5777G463          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-48449              APPID: *LOCAL.db2inst1.101116161002
AUTHID  : L_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: SUZHOU   : ACTIVATED: NO

2010-11-17-00.10.11.345104+480 E6241G464          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-48449              APPID: *LOCAL.db2inst1.101116161002
AUTHID  : L_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-00.10.14.660059+480 E6706G463          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-48459              APPID: *LOCAL.db2inst1.101116161014
AUTHID  : S_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: SUZHOU   : ACTIVATED: NO

2010-11-17-00.10.20.785913+480 E7170G464          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-48459              APPID: *LOCAL.db2inst1.101116161014
AUTHID  : S_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-08.47.17.006506+480 E7635G466          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-49158              APPID: 192.168.5.202.1396.101117004714
AUTHID  : L_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: SUZHOU   : ACTIVATED: NO


这些日志说明了：
2010-11-16-19.58.39.965181+480 E5309G467          LEVEL: Event      
--晚上7点多，大家都下班了，连接都断开了，所有数据库inactive了
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-00.10.05.392697+480 E5777G463          LEVEL: Event
--00:10 job开始了，数据库active了
START   : DATABASE: SUZHOU   : ACTIVATED: NO

2010-11-17-00.10.11.345104+480 E6241G464          LEVEL: Event
--job跑完，数据库inactvie 了
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-00.10.14.660059+480 E6706G463          LEVEL: Event
--job又连接上去了，又active了
START   : DATABASE: SUZHOU   : ACTIVATED: NO

2010-11-17-00.10.20.785913+480 E7170G464          LEVEL: Event
--job跑完，有inactive了
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-08.47.17.006506+480 E7635G466          LEVEL: Event
--早上八点多 上班了，数据库又active
START   : DATABASE: SUZHOU   : ACTIVATED: NO

不知道 我理解的对不对？收起
IT分销/经销 · 2010-11-17
浏览536
评论
nowhillnowhill系统工程师
to to wangzhonnew  我手工跑了 一下 cd /home/db2inst1/cron_trcDATE=`date +%Y-%m-%d-%H-%M-%S`;export DATE;free -m >cron_$DATE.txtdb2 attach to db2inst1 >>cron_$DATE.txtdb2 get dbm cfg show detail  >>cron_$DATE.txtdb2 get db cfg for ...显示全部
to
to wangzhonnew  我手工跑了 一下
cd /home/db2inst1/cron_trc
DATE=`date +%Y-%m-%d-%H-%M-%S`;export DATE;
free -m >cron_$DATE.txt
db2 attach to db2inst1 >>cron_$DATE.txt
db2 get dbm cfg show detail  >>cron_$DATE.txt
db2 get db cfg for suzhou show detail  >>cron_$DATE.txt
db2pd -dbptnmem >>cron_$DATE.txt
db2pd -memset >>cron_$DATE.txt
db2pd -mempool >>cron_$DATE.txt
db2pd -memset -db suzhou >>cron_$DATE.txt
db2pd -mempool -db suzhou >>cron_$DATE.txt
db2pdcfg -catch diagstr="sqeLocalDatabase::FirstConnect, probe:110"
db2trc on -t -f db2trc_$DATE.dmp
db2 connect to suzhou
db2trc off
db2pdcfg -catch clear
db2trc flw -t db2trc_$DATE.dmp db2trc_$DATE.flw  >>cron_$DATE.txt
db2trc fmt db2trc_$DATE.dmp db2trc_$DATE.fmt   >>cron_$DATE.txt
pmap -x 6827  >>cron_$DATE.txt

日志里出现这个：

2010-11-17-09.36.42.539064+480 I10557G315         LEVEL: Event
PID     : 21440                TID  : 3971728     PROC : db2pdcfg
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, pdErrorCatch, probe:30
START   : Error catch set for diag text "sqeLocalDatabase::FirstConnect, probe:110"

2010-11-17-09.36.44.998409+480 I10873G280         LEVEL: Event
PID     : 21454                TID  : 2750672     PROC : db2pdcfg
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, pdErrorCatch, probe:20
START   : All error catch flag settings cleared.

有问题的吗？收起
IT分销/经销 · 2010-11-17
浏览537
评论
nowhillnowhill系统工程师
to  wangzhonnew  抱歉  昨天job没有跑成功，今天继续今天看日志，在00:10阶段没有 发生内存溢出的情况2010-11-16-10.34.06.070972+480 I1549G315          LEVEL: EventPID     : 9759&n...显示全部
to  wangzhonnew  抱歉  昨天job没有跑成功，今天继续
今天看日志，在00:10阶段没有 发生内存溢出的情况

2010-11-16-10.34.06.070972+480 I1549G315          LEVEL: Event
PID     : 9759                 TID  : 4962512     PROC : db2pdcfg
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, pdErrorCatch, probe:30
START   : Error catch set for diag text "sqeLocalDatabase::FirstConnect, probe:110"

2010-11-16-10.34.08.533389+480 I1865G280          LEVEL: Event
PID     : 9774                 TID  : 3087456     PROC : db2pdcfg
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, pdErrorCatch, probe:20
START   : All error catch flag settings cleared.

2010-11-16-13.23.59.875596+480 I2146G527          LEVEL: Error
PID     : 6827                 TID  : 2930764688  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-43721              APPID: 192.168.6.110.3924.101116051825
AUTHID  : S_SZ_V6
EDUID   : 23804                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, common communication, sqlcctcptest, probe:11
MESSAGE : Detected client termination
DATA #1 : Hexdump, 2 bytes
0xAEAF78C8 : 3600                                       6.

2010-11-16-13.23.59.875870+480 I2674G509          LEVEL: Error
PID     : 6827                 TID  : 2930764688  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-43721              APPID: 192.168.6.110.3924.101116051825
AUTHID  : S_SZ_V6
EDUID   : 23804                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, common communication, sqlcctest, probe:50
MESSAGE : sqlcctest RC
DATA #1 : Hexdump, 2 bytes
0xAEAF78E8 : 3600                                       6.

2010-11-16-13.23.59.876031+480 I3184G497          LEVEL: Error
PID     : 6827                 TID  : 2930764688  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-43721              APPID: 192.168.6.110.3924.101116051825
AUTHID  : S_SZ_V6
EDUID   : 23804                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint, probe:10
CALLED  : DB2 UDB, common communication, sqlcctest
RETCODE : ZRC=0x00000036=54

2010-11-16-13.23.59.876261+480 I3682G1087         LEVEL: Warning
PID     : 6827                 TID  : 2930764688  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-43721              APPID: 192.168.6.110.3924.101116051825
AUTHID  : S_SZ_V6
EDUID   : 23804                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint, probe:16
CALLSTCK:
  [0] 0xB4749B9A _Z16sqltLogCallStackjjjjj + 0x1A
  [1] 0xB4789EA4 _ZN8sqeAgent19AgentBreathingPointEi + 0x7CA
  [2] 0xB471C63D _Z12sqldReadNormP13SQLD_DFM_WORKi + 0x1309
  [3] 0xB68EC17F /home/db2inst1/sqllib/lib32/libdb2e.so.1 + 0x33D517F
  [4] 0xB68EAEBC _Z7sqldfrdP13SQLD_DFM_WORK + 0xF4
  [5] 0xB68E2C96 _Z12sqldRowFetchP8sqeAgentP8SQLD_CCBjjPP10SQLD_VALUEP8SQLZ_RIDjP12SQLD_ID_LISTP9SQLP_LSN8 + 0xC90
  [6] 0xB6961142 _Z10sqlriFetchP8sqlrr_cbP9sqlri_taoi + 0xD6
  [7] 0xB6964A36 _Z7sqlritaP8sqlrr_cb + 0xB0
  [8] 0xB6961872 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0xC2
  [9] 0xB4B94F70 _Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x18C

2010-11-16-13.38.09.888591+480 E4770G538          LEVEL: Warning
PID     : 6851                 TID  : 2901408656  PROC : db2acd
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10512W  Health indicator "Statistics Collection Required"
          ("db.tb_runstats_req") is in state "Update statistics required" on
          "database" "db2inst1.SUZHOU  ". Collection (Object Name, Timestamp,
          Value, Detail): " ("SYSIBM"."SYSTABLES", , 6, RUNSTATS)".

2010-11-16-19.58.39.965181+480 E5309G467          LEVEL: Event
PID     : 6827                 TID  : 1074785168  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-45173              APPID: 192.168.5.202.1714.101116065438
AUTHID  : L_SZ_V6
EDUID   : 23802                EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-00.10.05.392697+480 E5777G463          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-48449              APPID: *LOCAL.db2inst1.101116161002
AUTHID  : L_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: SUZHOU   : ACTIVATED: NO

2010-11-17-00.10.11.345104+480 E6241G464          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-48449              APPID: *LOCAL.db2inst1.101116161002
AUTHID  : L_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-00.10.14.660059+480 E6706G463          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-48459              APPID: *LOCAL.db2inst1.101116161014
AUTHID  : S_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: SUZHOU   : ACTIVATED: NO

2010-11-17-00.10.20.785913+480 E7170G464          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-48459              APPID: *LOCAL.db2inst1.101116161014
AUTHID  : S_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP    : DATABASE: SUZHOU   : DEACTIVATED: NO

2010-11-17-08.47.17.006506+480 E7635G466          LEVEL: Event
PID     : 6827                 TID  : 1073736592  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : SUZHOU
APPHDL  : 0-49158              APPID: 192.168.5.202.1396.101117004714
AUTHID  : L_SZ_V6
EDUID   : 23796                EDUNAME: db2agent (SUZHOU)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: SUZHOU   : ACTIVATED: NO

2010-11-17-08.52.03.361174+480 E8102G1260         LEVEL: Error
PID     : 6851                 TID  : 2935901072  PROC : db2acd
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10500E  Health indicator "Monitor Heap Utilization"
          ("db2.mon_heap_util") breached the "upper" alarm threshold of "95 %"
          with value "100 %" on "instance" "db2inst1".  Calculation:
          "((db2.mon_heap_cur_size/db2.mon_heap_max_size)*100);" = "((393216 /
          393216) * 100)" = "100 %".  History (Timestamp, Value, Formula): "
          (2010-11-17 08:47:02.593934, 33, ((131072 / 393216) * 100)),
          (2010-11-17 08:42:02.868291, 33, ((131072 / 393216) * 100)),
          (2010-11-17 08:37:03.140906, 33, ((131072 / 393216) * 100)),
          (2010-11-17 08:32:02.794512, 33, ((131072 / 393216) * 100)),
          (2010-11-17 08:27:03.348642, 33, ((131072 / 393216) * 100)),
          (2010-11-17 08:22:02.570887, 33, ((131072 / 393216) * 100)),
          (2010-11-17 08:17:02.802206, 33, ((131072 / 393216) * 100)),
          (2010-11-17 08:12:02.943759, 33, ((131072 / 393216) * 100)),
          (2010-11-17 08:07:03.171085, 33, ((131072 / 393216) * 100))"

昨天日志就怎么多，没有发生内存申请不到的情况

我怎么才能知道 db2  发生过 数据库inactive（连接全部断开后），然后 又 active了（新的连接上去了）
日志里能看出来吗？？收起
IT分销/经销 · 2010-11-17
浏览527
评论
limin19821limin19821系统工程师乐酷天
盖到73楼了，真不赖！显示全部
盖到73楼了，真不赖！收起
IT分销/经销 · 2010-11-16
浏览510
评论
stephensun123stephensun123软件开发工程师SAP China
db2pd -mempool -db suzhou  这些命令 会不会 连接数据库？ 导致数据库一直保持着连接？[/url] db2pd不会去连接数据库，直接attach到mem上面，也不需要latch显示全部
db2pd -mempool -db suzhou  这些命令 会不会 连接数据库？ 导致数据库一直保持着连接？

[/url]
db2pd不会去连接数据库，直接attach到mem上面，也不需要latch收起
互联网服务 · 2010-11-16
浏览566
评论
szhangkangszhangkang项目经理aaa
下载下来 看看内存分配的错误显示全部
下载下来 看看内存分配的错误收起
互联网服务 · 2010-11-16
浏览532
评论
limin19821limin19821系统工程师乐酷天
db2pd -memset -db suzhou >>cron_$DATE.txtdb2pd -mempool -db suzhou >>cron_$DATE.txt这两句执行的时候应该是需要suzhou数据库是激活状态，不然应该会报错。Database SUZHOU not activated on database partition x.显示全部
db2pd -memset -db suzhou >>cron_$DATE.txt
db2pd -mempool -db suzhou >>cron_$DATE.txt
这两句执行的时候应该是需要suzhou数据库是激活状态，不然应该会报错。

Database SUZHOU not activated on database partition x.收起
IT分销/经销 · 2010-11-16
浏览539
评论
nowhillnowhill系统工程师
to wangzhonnew 用db2pdcfg -catch来抓那个sqeLocalDatabase::FirstConnect, probe:110  ， 然后别忘了改db2cos脚本这个我已经在抓了我准备 每分钟 跑下面的脚步cd /home/db2inst1/cronDATE=`date +%Y-%m-%d-%H-%M-%S`;export DATE;free -m >cron_$DATE.txtdb2 ...显示全部
to wangzhonnew
用db2pdcfg -catch来抓那个sqeLocalDatabase::FirstConnect, probe:110  ， 然后别忘了改db2cos脚本
这个我已经在抓了

我准备 每分钟 跑下面的脚步

cd /home/db2inst1/cron
DATE=`date +%Y-%m-%d-%H-%M-%S`;export DATE;
free -m >cron_$DATE.txt
db2 attach to db2inst1 >>cron_$DATE.txt
db2 get dbm cfg show detail  >>cron_$DATE.txt
db2 get db cfg for suzhou show detail  >>cron_$DATE.txt
db2pd -dbptnmem >>cron_$DATE.txt
db2pd -memset >>cron_$DATE.txt
db2pd -mempool >>cron_$DATE.txt
db2pd -memset -db suzhou >>cron_$DATE.txt
db2pd -mempool -db suzhou >>cron_$DATE.txt
pmap -x 6827  >>cron_$DATE.txt

数据库他不会 一直 active吧?
db2pd -mempool -db suzhou  这些命令 会不会 连接数据库？ 导致数据库一直保持着连接？收起
IT分销/经销 · 2010-11-16
浏览547
评论
wangzhonnewwangzhonnew软件工程师IBM Canada Ltd.
用db2pdcfg -catch来抓那个sqeLocalDatabase::FirstConnect, probe:110  ， 然后别忘了改db2cos脚本显示全部
用db2pdcfg -catch来抓那个sqeLocalDatabase::FirstConnect, probe:110  ， 然后别忘了改db2cos脚本收起
IT分销/经销 · 2010-11-16
浏览550
评论

提问者

nowhill
nowhill
系统工程师
关注
回答280
评论329

相关问题

  • 引入缺乏第三方服务生态的信创数据库，会不会令甲方被厂商锁定而失去议价能力？
  • 对于业务系统的历史数据存放、查询，哪种类型的数据库更为合适？
  • 超融合能否扛起全闪做支撑交易类数据库最佳平台的大旗？
  • 金融行业容器数据库对比传统数据库的主要变化在哪里？或者是架构上哪一层发生了变化？
  • 如果数据库较大，全量迁移时间较长，如何尽可能缩短停机窗口？

    • 相关资料

  • 分布式数据库金融应用发展报告-2023
  • IDC+中国金融行业国产分布式数据库白皮书
  • Redhat7.6 Oracle 19C RAC部署手册
  • Redhat7.0 Oracle 12C RAC部署手册
  • Redhat7.5 Oracle 18C RAC部署手册

    • 相关文章

  • 南大通用对数据库领域国家标准编制与实施的贡献浅析
  • Redis 的优势是如何在保单业务中发挥出来的
  • 数据库行业解决方案都写了啥
  • 企业传统Oracle数据库迁移国产数据库核心难点总结
  • 招聘：建信金科基础技术中心数据库产品团队

    • 问题状态

  • 发布时间：2010-11-05
  • 关注会员：1 人
  • 问题浏览：73139
  • 最近回答：2011-06-24

    • 关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们
    © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30

    X社区推广