db2假死现象频繁相关日志2012-11-05-08.18--寻求解答
2012-11-05-08.14.25.151141+480 E333352574G774 LEVEL: WarningPID : 15126 TID: 2791304080PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-439 APPID: 172.100.12.108.260.121105000457
AUTHID: YYGL
EDUID : 4512 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2_DATASPACE" (ID "10")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.14.26.050041+480 E333353349G773 LEVEL: Warning
PID : 15126 TID: 2791304080PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-439 APPID: 172.100.12.108.260.121105000457
AUTHID: YYGL
EDUID : 4512 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2SPACE_MPM" (ID "11")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.14.34.719758+480 E333354123G770 LEVEL: Warning
PID : 15126 TID: 2840587152PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-443 APPID: 172.100.12.109.1284.12110500042
AUTHID: YYGL
EDUID : 4510 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.14.35.601536+480 E333354894G774 LEVEL: Warning
PID : 15126 TID: 2840587152PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-443 APPID: 172.100.12.109.1284.12110500042
AUTHID: YYGL
EDUID : 4510 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2_DATASPACE" (ID "10")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.14.39.537345+480 E333355669G773 LEVEL: Warning
PID : 15126 TID: 662694800 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-513 APPID: 172.100.12.130.17412.1211050015
AUTHID: YYGL
EDUID : 4516 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2SPACE_MPM" (ID "11")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.14.40.447651+480 E333356443G770 LEVEL: Warning
PID : 15126 TID: 662694800 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-513 APPID: 172.100.12.130.17412.1211050015
AUTHID: YYGL
EDUID : 4516 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.14.52.041559+480 E333357214G774 LEVEL: Warning
PID : 15126 TID: 662694800 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-513 APPID: 172.100.12.130.17412.1211050015
AUTHID: YYGL
EDUID : 4516 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2_DATASPACE" (ID "10")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.14.52.923241+480 E333357989G773 LEVEL: Warning
PID : 15126 TID: 662694800 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-513 APPID: 172.100.12.130.17412.1211050015
AUTHID: YYGL
EDUID : 4516 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2SPACE_MPM" (ID "11")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.15.45.380822+480 E333358763G774 LEVEL: Warning
PID : 15126 TID: 2791304080PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-439 APPID: 172.100.12.108.260.121105000457
AUTHID: YYGL
EDUID : 4512 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2_DATASPACE" (ID "10")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.15.45.396592+480 E333359538G773 LEVEL: Warning
PID : 15126 TID: 662694800 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-513 APPID: 172.100.12.130.17412.1211050015
AUTHID: YYGL
EDUID : 4516 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2SPACE_MPM" (ID "11")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.15.46.352418+480 E333360312G770 LEVEL: Warning
PID : 15126 TID: 2791304080PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-439 APPID: 172.100.12.108.260.121105000457
AUTHID: YYGL
EDUID : 4512 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.15.46.377998+480 E333361083G774 LEVEL: Warning
PID : 15126 TID: 662694800 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-513 APPID: 172.100.12.130.17412.1211050015
AUTHID: YYGL
EDUID : 4516 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2_DATASPACE" (ID "10")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.16.06.004197+480 E333361858G770 LEVEL: Warning
PID : 15126 TID: 662694800 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-513 APPID: 172.100.12.130.17412.1211050015
AUTHID: YYGL
EDUID : 4516 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.16.06.902136+480 E333362629G774 LEVEL: Warning
PID : 15126 TID: 662694800 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-513 APPID: 172.100.12.130.17412.1211050015
AUTHID: YYGL
EDUID : 4516 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2_DATASPACE" (ID "10")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.16.29.109479+480 E333363404G770 LEVEL: Warning
PID : 15126 TID: 2840587152PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-443 APPID: 172.100.12.109.1284.12110500042
AUTHID: YYGL
EDUID : 4510 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.16.30.007173+480 E333364175G774 LEVEL: Warning
PID : 15126 TID: 2840587152PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-443 APPID: 172.100.12.109.1284.12110500042
AUTHID: YYGL
EDUID : 4510 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2_DATASPACE" (ID "10")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.17.33.266995+480 E333364950G770 LEVEL: Warning
PID : 15126 TID: 2789206928PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-493 APPID: 172.100.12.110.2308.12110500161
AUTHID: YYGL
EDUID : 4519 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.17.34.155166+480 E333365721G774 LEVEL: Warning
PID : 15126 TID: 2789206928PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-493 APPID: 172.100.12.110.2308.12110500161
AUTHID: YYGL
EDUID : 4519 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2_DATASPACE" (ID "10")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.18.04.810830+480 E333366496G773 LEVEL: Warning
PID : 15126 TID: 2789206928PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-493 APPID: 172.100.12.110.2308.12110500161
AUTHID: YYGL
EDUID : 4519 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2SPACE_MPM" (ID "11")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.18.05.646388+480 E333367270G770 LEVEL: Warning
PID : 15126 TID: 2789206928PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-493 APPID: 172.100.12.110.2308.12110500161
AUTHID: YYGL
EDUID : 4519 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.18.13.579562+480 E333368041G773 LEVEL: Warning
PID : 15126 TID: 2791304080PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-439 APPID: 172.100.12.108.260.121105000457
AUTHID: YYGL
EDUID : 4512 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2SPACE_MPM" (ID "11")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.18.13.949931+480 E333368815G770 LEVEL: Warning
PID : 15126 TID: 2779769744PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-436 APPID: 172.100.12.116.260.121105000345
AUTHID: YYGL
EDUID : 4502 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.18.14.111944+480 E333369586G773 LEVEL: Warning
PID : 15126 TID: 2836392848PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-332 APPID: 172.100.12.15.3076.121104233518
AUTHID: YYGL
EDUID : 4293 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "DB2SPACE_MPM" (ID "11")
or increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
2012-11-05-08.18.14.556124+480 E333370360G770 LEVEL: Warning
PID : 15126 TID: 2791304080PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : ORCL
APPHDL: 0-439 APPID: 172.100.12.108.260.121105000457
AUTHID: YYGL
EDUID : 4512 EDUNAME: db2agent (ORCL)
FUNCTION: DB2 UDB, sort/list services, sqlsOptimizeNumMergeRuns, probe:10
MESSAGE : ADM9000WPrefetching was disabled during sort merge; performance may
be suboptimal.If this message persists, consider increasing the
buffer pool size for temporary table space "TEMPSPACE1" (ID "1") or
increase the value of the SORTHEAP DB configuration parameter to
reduce the extent of sort spilling.
页:
[1]