# oslevel -s
5300-12-00-0000
# bootinfo -y
64
# bootinfo -K
64
# su - db2inst1
[YOU HAVE NEW MAIL]
$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08027"
with level identifier "03080106".
Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and FixPak
"14".
Product is installed at "/usr/opt/db2_08_01".
diag内容如下
--------------A机的log 下面还有B机log 请慢点翻
2013-05-08-09.04.08.930056+480 I872761C347 LEVEL: Error
PID : 10453020 TID : 1 PROC : ccc
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.130512105640
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrHandleErrorRm, probe:911
RETCODE : ZRC=0x8037008D=-2143879027=SQLJR_SYNTAX "SYNTAX ERROR"
2013-05-08-09.04.08.930227+480 I873109C643 LEVEL: Error
PID : 10453020 TID : 1 PROC : ccc
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.130512105640
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml: 17
sqlerrmc: 0x124C"("011D")"
sqlerrp : sqljrerm
sqlerrd : (1) 0x8037008D (2) 0x0000008D (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2013-05-08-09.04.08.930336+480 I873753C172 LEVEL: Error
PID:10453020 TID:1 NODE:000 Title: **** DRDA ARCB ****
Dump File:/home/db2inst1/sqllib/db2dump/104530201.000
2013-05-08-09.04.08.941318+480 I873926C178 LEVEL: Error
PID:10453020 TID:1 NODE:000 Title: **** AR REQUEST LIST ****
Dump File:/home/db2inst1/sqllib/db2dump/104530201.000
2013-05-08-09.04.08.941427+480 I874105C177 LEVEL: Error
PID:10453020 TID:1 NODE:000 Title: **** DRDA CMNMGR CB ****
Dump File:/home/db2inst1/sqllib/db2dump/104530201.000
2013-05-08-09.04.08.941514+480 I874283C177 LEVEL: Error
PID:10453020 TID:1 NODE:000 Title: **** RECEIVE BUFFER ****
Dump File:/home/db2inst1/sqllib/db2dump/104530201.000
2013-05-08-09.04.08.941600+480 I874461C175 LEVEL: Error
PID:10453020 TID:1 NODE:000 Title: **** SEND BUFFERS ****
Dump File:/home/db2inst1/sqllib/db2dump/104530201.000
2013-05-08-09.04.08.941978+480 I874637C177 LEVEL: Error
PID:10453020 TID:1 NODE:000 Title: **** AR UCINTERFACE ****
Dump File:/home/db2inst1/sqllib/db2dump/104530201.000
2013-05-08-09.04.08.942062+480 I874815C172 LEVEL: Error
PID:10453020 TID:1 NODE:000 Title: *** INPUT SQLDD ***
Dump File:/home/db2inst1/sqllib/db2dump/104530201.000
2013-05-08-09.57.27.536524+480 I874988C347 LEVEL: Error
PID : 11255882 TID : 1 PROC : ccc
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.130512133855
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrHandleErrorRm, probe:911
RETCODE : ZRC=0x8037008D=-2143879027=SQLJR_SYNTAX "SYNTAX ERROR"
2013-05-08-09.57.27.536729+480 I875336C643 LEVEL: Error
PID : 11255882 TID : 1 PROC : ccc
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.130512133855
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml: 17
sqlerrmc: 0x124C"("011D")"
sqlerrp : sqljrerm
sqlerrd : (1) 0x8037008D (2) 0x0000008D (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2013-05-08-09.57.27.536851+480 I875980C172 LEVEL: Error
PID:11255882 TID:1 NODE:000 Title: **** DRDA ARCB ****
Dump File:/home/db2inst1/sqllib/db2dump/112558821.000
2013-05-08-09.57.27.555713+480 I876153C178 LEVEL: Error
PID:11255882 TID:1 NODE:000 Title: **** AR REQUEST LIST ****
Dump File:/home/db2inst1/sqllib/db2dump/112558821.000
2013-05-08-09.57.27.555824+480 I876332C177 LEVEL: Error
PID:11255882 TID:1 NODE:000 Title: **** DRDA CMNMGR CB ****
Dump File:/home/db2inst1/sqllib/db2dump/112558821.000
2013-05-08-09.57.27.555911+480 I876510C177 LEVEL: Error
PID:11255882 TID:1 NODE:000 Title: **** RECEIVE BUFFER ****
Dump File:/home/db2inst1/sqllib/db2dump/112558821.000
2013-05-08-09.57.27.556009+480 I876688C175 LEVEL: Error
PID:11255882 TID:1 NODE:000 Title: **** SEND BUFFERS ****
Dump File:/home/db2inst1/sqllib/db2dump/112558821.000
2013-05-08-09.57.27.556380+480 I876864C177 LEVEL: Error
PID:11255882 TID:1 NODE:000 Title: **** AR UCINTERFACE ****
Dump File:/home/db2inst1/sqllib/db2dump/112558821.000
2013-05-08-09.57.27.556468+480 I877042C172 LEVEL: Error
PID:11255882 TID:1 NODE:000 Title: *** INPUT SQLDD ***
Dump File:/home/db2inst1/sqllib/db2dump/112558821.000
------------------B 机的log
2013-05-07-06.22.56.879630+480 I4142650C443 LEVEL: Severe
PID : 3452978 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-1290 APPID: *LOCAL.db2inst1.130506222256
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF13EE0 : 7E49 8000 ~I..
2013-05-07-06.23.29.506786+480 I4143094C487 LEVEL: Severe
PID : 2388142 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-2714 APPID: *LOCAL.db2inst1.130506222329
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:15
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
2013-05-07-06.23.29.506931+480 I4143582C443 LEVEL: Severe
PID : 2388142 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-2714 APPID: *LOCAL.db2inst1.130506222329
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF13EE0 : 7E49 8000 ~I..
2013-05-07-06.24.02.298173+480 I4144026C487 LEVEL: Severe
PID : 1450174 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-2438 APPID: *LOCAL.db2inst1.130506222402
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:15
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
2013-05-07-06.24.02.298375+480 I4144514C443 LEVEL: Severe
PID : 1450174 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-2438 APPID: *LOCAL.db2inst1.130506222402
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF13EE0 : 7E49 8000 ~I..
2013-05-07-06.24.35.078410+480 I4144958C487 LEVEL: Severe
PID : 2388142 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-3398 APPID: *LOCAL.db2inst1.130506222435
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:15
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
2013-05-07-06.24.35.078631+480 I4145446C443 LEVEL: Severe
PID : 2388142 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-3398 APPID: *LOCAL.db2inst1.130506222435
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF13EE0 : 7E49 8000 ~I..
2013-05-07-06.25.07.519971+480 I4145890C487 LEVEL: Severe
PID : 2388142 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-1107 APPID: *LOCAL.db2inst1.130506222507
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:15
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
2013-05-07-06.25.07.520146+480 I4146378C443 LEVEL: Severe
PID : 2388142 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-1107 APPID: *LOCAL.db2inst1.130506222507
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF13EE0 : 7E49 8000 ~I..
2013-05-07-06.25.40.405388+480 I4146822C487 LEVEL: Severe
PID : 1450174 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-3399 APPID: *LOCAL.db2inst1.130506222540
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:15
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
2013-05-07-06.25.40.405552+480 I4147310C443 LEVEL: Severe
PID : 1450174 TID : 1 PROC : db2agent (CCCDB) 0
INSTANCE: db2inst1 NODE : 000 DB : CCCDB
APPHDL : 0-3399 APPID: *LOCAL.db2inst1.130506222540
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF13EE0 : 7E49 8000 ~I..
请专家帮我看看A机的log和B机的log说明什么问题,经常报 ,偶看不懂了 5555
恳请能告诉我思路和方法
收起