求高手帮我分析一下~谢谢~~

[复制链接]
查看11 | 回复2 | 2008-7-27 22:25:20 | 显示全部楼层 |阅读模式
2008-10-27-15.49.28.460115+480 I8478548G1508LEVEL: Event
PID : 16223
TID: 3085825728PROC : db2start
INSTANCE: db2inst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 37 bytes
/db2home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0xBFE3FD4C : 2F64 6232 686F 6D65 2F64 6232 696E 7374/db2home/db2inst
0xBFE3FD5C : 312F 7371 6C6C 6962 2F61 646D 2F64 62321/sqllib/adm/db2
0xBFE3FD6C : 7374 6172 3200 0000 0000 0000 0000 0000star2...........
0xBFE3FD7C : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FD8C : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FD9C : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FDAC : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FDBC : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FDCC : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FDDC : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FDEC : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FDFC : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FE0C : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FE1C : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FE2C : 0000 0000 0000 0000 0000 0000 0000 0000................
0xBFE3FE3C : 0000 0000 0000 0000 0000 0000 0000 0000................
2008-10-27-15.49.28.941243+480 I8480057G527 LEVEL: Event
PID : 16239
TID: 3054496672PROC : db2sysc
INSTANCE: db2inst1
NODE : 000
EDUID : 1
EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10
START : Starting FCM Buffer Manager
1 resource group(s).
128 buffers allocated.
Maximum number of buffers supported is 8192.
Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 860172 bytes.
2008-10-27-15.49.28.943282+480 I8480585G536 LEVEL: Event
PID : 16239
TID: 3054496672PROC : db2sysc
INSTANCE: db2inst1
NODE : 000
EDUID : 1
EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
START : Starting FCM Channel Manager
1 resource group(s).
1024 channels allocated.
Maximum number of channels supported is 8192.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 1093648 bytes.
2008-10-27-15.49.28.946001+480 I8481122G533 LEVEL: Event
PID : 16239
TID: 3054496672PROC : db2sysc
INSTANCE: db2inst1
NODE : 000
EDUID : 1
EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10
START : Starting FCM Session Manager
1 resource group(s).
128 sessions allocated.
Maximum number of sessions supported is 64000.
Total session manager memory required for 1 logical and 0 fail-over partitions is 1118208 bytes.
2008-10-27-15.49.28.948543+480 I8481656G414 LEVEL: Event
PID : 16239
TID: 3054496672PROC : db2sysc
INSTANCE: db2inst1
NODE : 000
EDUID : 1
EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500
START : FCM infrastructure started
FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4
2008-10-27-15.49.29.975349+480 E8482071G1196LEVEL: Event
PID : 16225
TID: 3086051008PROC : db2star2
INSTANCE: db2inst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513WDatabase manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09050"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXIA3295", Fix Pack "0".
DATA #2 : System Info, 436 bytes
System: Linux sanwa52 6 2 i686
CPU: total:2 online:2 Cores per socket:2 Threading degree per core:1
Physical Memory(MB): total:3990 free:1097
VirtualMemory(MB): total:9526 free:6633
Swap Memory(MB): total:5536 free:5536
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:1024

msgNumberOfHeaders:65536 msgMaxQueueSize:65536

msgMaxSegmentSize:16 shmMax:2147483648 shmMin:1 shmIDs:4096

shmSegments:4096 semMap:128000 semIDs:1024 semNum:128000

semUndo:128000 semNumPerID:250 semOps:32 semUndoSize:20

semMaxVal:32767 semAdjustOnExit:32767
回复

使用道具 举报

千问 | 2008-7-27 22:25:20 | 显示全部楼层
没有error和severe啊
回复

使用道具 举报

千问 | 2008-7-27 22:25:20 | 显示全部楼层
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09050"
是sql0905 好象没有什么sql09050 .

SQL0905N由于超过资源限制,因此执行不成功。资源名称 = "",限制 = "" CPU 秒("" 服务单元)由 "" 派生的。
说明:
因为超过资源限制,SQL 语句的执行被终止。
超过限制的资源的名称是 ""。它也是资源限制规范表中的列的名称,
限制就是从该表派生出来的。在 CPU 秒数中,超过的限制是 "",在
服务单元中,它是 ""。"" 可能是 ASUTIME,它是每条 SQL
语句所允许的 CPU 秒数。允许的最大 CPU 秒数为 ""。最大服务单元
数为 ""。
用来派生限制量的源为 "",它是资源限制规范表或"系统参数"的名称。
如果该源是系统参数,那么资源限制规范表不包含可用的条目或访问该表时发生
了错误。在任一情况下,该限制都是从安装(系统)参数中获得的。
用户响应:
确定为何此 SQL 语句需要这样长的时间并执行适当的操作。考虑简化该 SQL 语
句、重构表和索引、或者与负责维护该资源限制规范表的安装组联系。
接收此返回码的应用程序可以执行附加的 SQL 语句。
sqlcode:-905
sqlstate:57014
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行