DB2性能调整优化问题
| 服务器是IBM Netfinity 5600,PIII 800,1G内存,OS是win2000版.目前数据库有90多个table,大的一个表有二十多万数据,备份后的image有900多兆.我们每天都有比较多的查询,增加及删改记录操作,感觉速度有点慢了,有时候有连接数据库的页面时速度特慢,只好重启WebSphere控制台的server.下面贴出DBM和DM的配置参数,请高手指点如何调整优化. Database Manager Configuration Node type = Database Server with local and remote clients Database manager configuration release level = 0x0900 Maximum total of files open (MAXTOTFILOP) = 16000 CPU speed (millisec/instruction) (CPUSPEED) = 8.659645e-007 Max number of concurrently active databases (NUMDB) = 8 Data Links support (DATALINKS) = NO Federated Database System Support (FEDERATED) = YES Transaction processor monitor name (TP_MON_NAME) = Default charge-back account (DFT_ACCOUNT_STR) = Java Development Kit 1.1 installation path (JDK11_PATH) = Diagnostic error capture level (DIAGLEVEL) = 3 Notify Level (NOTIFYLEVEL) = 2 Diagnostic data directory path (DIAGPATH) = Default database monitor switches Buffer pool (DFT_MON_BUFPOOL) = OFF Lock (DFT_MON_LOCK) = OFF Sort (DFT_MON_SORT) = OFF Statement (DFT_MON_STMT) = OFF Table (DFT_MON_TABLE) = OFF Unit of work (DFT_MON_UOW) = OFF SYSADM group name (SYSADM_GROUP) = SYSCTRL group name (SYSCTRL_GROUP) = SYSMAINT group name (SYSMAINT_GROUP) = Database manager authentication (AUTHENTICATION) = SERVER Cataloging allowed without authority (CATALOG_NOAUTH) = YES Trust all clients (TRUST_ALLCLNTS) = YES Trusted client authentication (TRUST_CLNTAUTH) = CLIENT Default database path (DFTDBPATH) = D: Database monitor heap size (4KB) (MON_HEAP_SZ) = 32 UDF shared memory set size (4KB) (UDF_MEM_SZ) = 256 Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048 Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 Backup buffer default size (4KB) (BACKBUFSZ) = 1024 Restore buffer default size (4KB) (RESTBUFSZ) = 1024 Agent stack size (AGENT_STACK_SZ) = 16 Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32 Private memory threshold (4KB) (PRIV_MEM_THRESH) = 1296 Sort heap threshold (4KB) (SHEAPTHRES) = 10000 Directory cache support (DIR_CACHE) = YES Application support layer heap size (4KB) (ASLHEAPSZ) = 15 Max requester I/O block size (bytes) (RQRIOBLK) = 32767 DOS requester I/O block size (bytes) (DOS_RQRIOBLK) = 4096 Query heap size (4KB) (QUERY_HEAP_SZ) = 1000 DRDA services heap size (4KB) (DRDA_HEAP_SZ) = 128 Priority of agents (AGENTPRI) = SYSTEM Max number of existing agents (MAXAGENTS) = 500 Agent pool size (NUM_POOLAGENTS) = 10 (calculated) Initial number of agents in pool (NUM_INITAGENTS) = 0 Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS Max number of logical agents (MAX_LOGICAGENTS) = MAX_COORDAGENTS Keep DARI process (KEEPDARI) = YES Max number of DARI processes (MAXDARI) = MAX_COORDAGENTS Initialize DARI process with JVM (INITDARI_JVM) = NO Initial number of fenced DARI process (NUM_INITDARIS) = 0 Index re-creation time (INDEXREC) = ACCESS Transaction manager database name (TM_DATABASE) = 1ST_CONN Transaction resync interval (sec) (RESYNC_INTERVAL) = 180 SPM name (SPM_NAME) = DBSERVER SPM log size (SPM_LOG_FILE_SZ) = 256 SPM resync agent limit (SPM_MAX_RESYNC) = 20 SPM log path (SPM_LOG_PATH) = NetBIOS Workstation name (NNAME) = TCP/IP Service name (SVCENAME) = db2cDB2 APPC Transaction program name (TPNAME) = IPX/SPX File server name (FILESERVER) = IPX/SPX DB2 server object name (OBJECTNAME) = IPX/SPX Socket number (IPX_SOCKET) = 879E Discovery mode (DISCOVER) = SEARCH Discovery communication protocols (DISCOVER_COMM) = TCPIP Discover server instance (DISCOVER_INST) = ENABLE Directory services type (DIR_TYPE) = NONE Directory path name (DIR_PATH_NAME) = /.:/subsys/database/ Directory object name (DIR_OBJ_NAME) = Routing information object name (ROUTE_OBJ_NAME) = Default client comm. protocols (DFT_CLIENT_COMM) = Default client adapter number (DFT_CLIENT_ADPT) = 0 Maximum query degree of parallelism (MAX_QUERYDEGREE) = 1 Enable intra-partition parallelism (INTRA_PARALLEL) = NO No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024 Number of FCM request blocks (FCM_NUM_RQB) = 512 Number of FCM connection entries (FCM_NUM_CONNECT) = (FCM_NUM_RQB * 0.75) Number of FCM message anchors (FCM_NUM_ANCHORS) = (FCM_NUM_RQB * 0.75) ---------------------------------------------------------------------------------------------------------------- Database Configuration for Database jingmei Database configuration release level = 0x0900 Database release level = 0x0900 Database territory = US Database code page = 1252 Database code set = IBM-1252 Database country code = 1 Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE Directory object name (DIR_OBJ_NAME) = Discovery support for this database (DISCOVER_DB) = ENABLE Default query optimization class (DFT_QUERYOPT) = 5 Degree of parallelism (DFT_DEGREE) = 1 Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO Default refresh age (DFT_REFRESH_AGE) = 0 Number of frequent values retained (NUM_FREQVALUES) = 10 Number of quantiles retained (NUM_QUANTILES) = 20 Backup pending = NO Database is consistent = NO Rollforward pending = NO Restore pending = NO Multi-page file allocation enabled = NO Log retain for recovery status = RECOVERY User exit for logging status = NO Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60 Data Links Number of Copies (DL_NUM_COPIES) = 1 Data Links Time after Drop (days) (DL_TIME_DROP) = 1 Data Links Token in Uppercase (DL_UPPER) = NO Data Links Token Algorithm (DL_TOKEN) = MAC0 Database heap (4KB) (DBHEAP) = 1621 Catalog cache size (4KB) (CATALOGCACHE_SZ) = 498 Log buffer size (4KB) (LOGBUFSZ) = 32 Utilities heap size (4KB) (UTIL_HEAP_SZ) = 50505 Buffer pool size (pages) (BUFFPAGE) = 151517 Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000 Number of extended storage segments (NUM_ESTORE_SEGS) = 0 Max storage for lock list (4KB) (LOCKLIST) = 1467 Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 128 Sort list heap (4KB) (SORTHEAP) = 256 SQL statement heap (4KB) (STMTHEAP) = 2048 Default application heap (4KB) (APPLHEAPSZ) = 256 Package cache size (4KB) (PCKCACHESZ) = 4000 Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384 Interval for checking deadlock (ms) (DLCHKTIME) = 10000 Percent. of lock lists per application (MAXLOCKS) = 6 Lock timeout (sec) (LOCKTIMEOUT) = -1 Changed pages threshold (CHNGPGS_THRESH) = 60 Number of asynchronous page cleaners (NUM_IOCLEANERS) = 5 Number of I/O servers (NUM_IOSERVERS) = 3 Index sort flag (INDEXSORT) = YES Sequential detect flag (SEQDETECT) = YES Default prefetch size (pages) (DFT_PREFETCH_SZ) = 32 Track modified pages (TRACKMOD) = OFF Default number of containers = 1 Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32 Max number of active applications (MAXAPPLS) = 500 Average number of active applications (AVG_APPLS) = 150 Max DB files open per application (MAXFILOP) = 64 Log file size (4KB) (LOGFILSIZ) = 250 Number of primary log files (LOGPRIMARY) = 6 Number of secondary log files (LOGSECOND) = 10 Changed path to log files (NEWLOGPATH) = Path to log files = D:/DB2/NODE0000/SQL00001/SQLOGDIR/ First active log file = S0001015.LOG Group commit count (MINCOMMIT) = 1 Percent log file reclaimed before soft chckpt (SOFTMAX) = 80 Log retain for recovery enabled (LOGRETAIN) = RECOVERY User exit for logging enabled (USEREXIT) = OFF Auto restart enabled (AUTORESTART) = ON Index re-creation time (INDEXREC) = SYSTEM (ACCESS) Default number of loadrec sessions (DFT_LOADREC_SES) = 1 Number of database backups to retain (NUM_DB_BACKUPS) = 12 Recovery history retention (days) (REC_HIS_RETENTN) = 366 TSM management class (TSM_MGMTCLASS) = TSM node name (TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) oprs 回复于：2004-10-29 15:50:07 光看参数没用的，几个问题 1.你的websphere和db2是在一台服务器上，还是分开的? 2.速度变慢的时候察看资源，cpu，内存占用情况如何？ 3。事务操作进行得比较多，那么reorg, runstats有没有做过？ 4。看下你的db2diag.log里，有锁升级的信息么？ huyuhui001 回复于：2004-10-29 16:19:26 1.Multi-page file allocation enabled = NO，应该运行db2empfa把它置ON 2.Buffer pool size (pages) (BUFFPAGE) = 151517，从这个看你的buffer pool是有参数控制的，是4Kpage的tablespace。建议不要用参数控制buffer pool，针对每个pagesize的tablespace建立不同的bufferpool。而且，buffer pool也太小了。 3.LOG的总量太小，而且LOG的文件个数也太少了。 4.Lock timeout (sec) (LOCKTIMEOUT) = -1，这个应该控制的尽量小，它的单位是秒，有利于减少lock，因为lock升级不是好事情。 5.其他一些HEAP的参数需要在实际中去不断测试。不过DB2在32位系统中是有内存限制的，这个要控制好，否则DB就没法启动了。 6.定期对所有表做reorg和runstat，更新系统信息，有利于系统优化处理SQL语句。 以上是我个人的观点，仅供参考。 joey945 回复于：2004-10-29 23:04:12 首先要向oprs和huyuhui001表示感谢! 详细情况如下: 1.WebSphere3.5和DB2 7.1是在分开的两台服务器上,WebServer上也安装了DB2,放WAS表.两台服务器的硬件一样,操作系统一样. 2.速度变慢的时候察看过资源，记得连不上的问题刚出现时看过一两次WebServer的CPU占用,有一个JAVA进程占的比较多,后来我装了个Resource Analyzer3.5,经常去看资源情况,好像CPU又没有增加太多,顺便想问如何根据Resource Analyzer3.5显示的数据来判断WAS配置有无问题?(我曾经调整过数据源的buffer pool和servlet engine的并发连接数,但都没用).估计不是WAS服务器的问题,因为出现情况前没动过WAS服务器.内存占用情况没有明显的较大变化. 3.事务操作进行得比较多的表都做过reorg, runstats没有做过,但我一般是先查reorgchk update statistics on table table_name,如果指示要做就reorg,然后再reorgchk update statistics on table table_name,同时做了runstats了吧?但我发现有个问题就是runstats加了indexes all运行后,指示需要reorg的索引依然指示要reorg,没变化. 4.db2diag.log我也看过,是有许多锁的信息,什么样的信息表示锁升级?请指点? 5.关于lock timeout=-1的问题,设置一个较小的值是会比较好,但我看过一篇文章说"一定要首先询问应用程序开发者或您的供应商以确保应用程序能够处理锁超时",所以如果不确定应用程序能不能处理锁超时,是否还是设为-1比较稳妥? 另外有几个问题: 1.我发现数据库的状态是inconsistent,看资料说是内存缓冲区中已更新的数据还没有刷新到硬盘上时会是此状态,这个有没有影响?怎么消除此状态? 2.配置参数是我在几个月前加了内存后用control center的配置向导配置的,直到出现问题这段时间没有经常连接不上,只是感觉查询速度比以前慢了,因为经常查询的那些表经常也在增加,数据量多.用配置向导培植时有些提问的地方我不太清楚的,比如"每分钟的事物数",因为不太清楚,就让它是默认值60,这些参数我怎么才能具体获得呢?有否影响?缓冲池等参数也是这里自动得出来的. 3.当初创建数据库时用的是默认表空间,即syscattablespace,temptablespace1和usertablespace1,现在发现这样不好,我想把经常有增删改操作的表放在一个表空间,特别大数量的表单独放一个表空间,其它一个表空间,即三个用户表空间,怎么样从现在的表空间迁移过来呢? 4.10月20号左右曾经把六个表的数据分离了一部分(把2004-01-01以前的清掉,纪录少了一半多),然后都做了reorg(没有管索引),好像这之后查询速度提高很多,但出现了经常连接不上数据库的情况,可能跟这个有关系?其它没什么变动.出现这种情况的时候,症状就是不连接数据库的JSP页面没问题,连接数据库的就慢慢的很久出不来,后显示"找不到服务器",如果再持续一段时间就连不连接数据库的页面都出不来了. 急盼大家的帮助! oprs 回复于：2004-10-31 10:17:25 1. 锁的问题会导致系统性能显著下降，把你的db2diag.log贴出来kk，锁升级信息类似于 "data_management sqlEscalateLocks.."这种就是了，直接的解决方法就是调大locklist和maxlocks的值，你可以试试把这两个值分别增大到5000和20， 2。locktimeout好不要设为-1，否则你的应用有可能长时间没有响应，设个60s左右的超时时间，当然你的应用需要捕获相应的超时返回信息并返回到页面上 3。把查询速度慢的sql从应用里分离出来，用dynexpln分析一下，如果有table scan的情况，一定要避免，非常影响性能 4。inconsistent在你的库有为提交的事务时出现，没有什么影响 5。配置参数向导的值可以做为参考，但有时候也不见得就是佳，那些问题的回答你只能根据你们应用的实际情况进行估计阿 6。迁移表空间，好要把容器分布到不同的物理硬盘上，靠增加物理io能力来提高性能，一般对大数据量表由明显的效果，另外把userspace设为dms吧 7。如果不连接数据库的页面后都回出不来的话，那肯定是was服务器上的问题了，一定要注意你的应用又没有内存泄露，或连接资源有没有关闭 8。was下有不少参数也是要调整的，像数据源下和连接有关的参数，像服务器的jvm，线程池等有关的参数。不过我接触早的was也是4.0的，3.5实在是古董了；），4.0还有之前的was都不怎么样，有很多问题，5.0以上的版本要稳定很多，好还是升级把 希望对你有帮助 :P :mrgreen: joey945 回复于：2004-10-31 23:22:03 以下是2004-10-29的部分db2diag,因为太多所以只贴这一部分(从时间点2004-10-29-14.40.53.359000开始有一些信息值得注意).我很疑惑的是orderdetail这个表在2004-10-29-00.07.39这个时间不可能有人用啊,怎么会有锁呢?没有释放?(以前我也看到过类似不可能在当时使用的表的锁定信息) 请oprs帮我分析一下这个log.能否告诉我怎么看db2diag.log?我在网上没查到相关资料.谢谢! 另外,数据库服务器只有一个物理硬盘,另一个硬盘是做的同步镜像.迁移表空间不能靠增加物理io能力来提高性能,所以是否有必要迁移? 2004-10-29-00.07.39.859000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:988 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 9935, S -- Result (0 = success): 0 ...... 2004-10-29-10.01.59.203000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1448 Appid:D3984109.5D12.041029020102 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.01.59.718000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1448 Appid:D3984109.5D12.041029020102 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 10017, S -- Result (0 = success): 0 2004-10-29-10.02.04.484000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1448 Appid:D3984109.5D12.041029020102 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10024, 5012 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 10021, S -- Result (0 = success): 0 2004-10-29-10.02.05.000000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1448 Appid:D3984109.5D12.041029020102 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 10017, S -- Result (0 = success): 0 2004-10-29-10.03.20.859000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1576 Appid:D3984109.D712.041029020259 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.03.21.375000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1576 Appid:D3984109.D712.041029020259 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 10017, S -- Result (0 = success): 0 2004-10-29-10.03.27.046000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1576 Appid:D3984109.D712.041029020259 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.03.27.875000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1452 Appid:D3984109.CA12.041029020246 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.03.35.812000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1452 Appid:D3984109.CA12.041029020246 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.03.51.937000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1576 Appid:D3984109.D712.041029020259 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.04.28.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.04.51.625000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1260 Appid:D3984109.5413.041029020447 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.04.52.640000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.05.01.281000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10018, S -- Result (0 = success): 0 2004-10-29-10.05.18.000000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.05.18.843000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10017, S -- Result (0 = success): 0 2004-10-29-10.05.33.453000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.06.06.984000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.06.11.078000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1436 Appid:D3984109.E011.041029010317 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10017, S -- Result (0 = success): 0 2004-10-29-10.06.20.265000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1436 Appid:D3984109.E011.041029010317 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10023, S -- Result (0 = success): 0 2004-10-29-10.06.21.375000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1516 Appid:D3984109.0406.041028145323 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10027, 5013 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10024, S -- Result (0 = success): 0 2004-10-29-10.06.34.734000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1516 Appid:D3984109.0406.041028145323 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10023, 5011 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10020, S -- Result (0 = success): 0 2004-10-29-10.06.44.125000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1516 Appid:D3984109.0406.041028145323 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10017, S -- Result (0 = success): 0 2004-10-29-10.07.11.140000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.07.31.453000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1436 Appid:D3984109.E011.041029010317 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10023, S -- Result (0 = success): 0 2004-10-29-10.07.35.968000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1052 Appid:D3984109.8C0F.041028140625 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.07.43.984000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1516 Appid:D3984109.0406.041028145323 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10023, 5011 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10020, S -- Result (0 = success): 0 2004-10-29-10.07.44.812000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1436 Appid:D3984109.E011.041029010317 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10017, S -- Result (0 = success): 0 2004-10-29-10.07.53.718000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1516 Appid:D3984109.0406.041028145323 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.07.59.390000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1516 Appid:D3984109.0406.041028145323 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10018, S -- Result (0 = success): 0 2004-10-29-10.08.00.312000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1436 Appid:D3984109.E011.041029010317 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.08.13.625000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:756 Appid:D3984109.C112.041028143228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10018, S -- Result (0 = success): 0 2004-10-29-10.08.18.828000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:756 Appid:D3984109.C112.041028143228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10023, S -- Result (0 = success): 0 2004-10-29-10.08.19.765000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1516 Appid:D3984109.0406.041028145323 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10024, 5012 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10021, S -- Result (0 = success): 0 2004-10-29-10.08.20.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.08.20.984000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.08.25.812000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.08.28.906000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.08.30.609000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8881, S -- Result (0 = success): 0 2004-10-29-10.08.31.140000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 9982, S -- Result (0 = success): 0 2004-10-29-10.08.31.703000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 9976, S -- Result (0 = success): 0 2004-10-29-10.08.31.984000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.08.32.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.08.32.593000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8880, S -- Result (0 = success): 0 2004-10-29-10.08.37.843000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10024, 5012 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10021, S -- Result (0 = success): 0 2004-10-29-10.08.38.296000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.08.38.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8880, S -- Result (0 = success): 0 2004-10-29-10.08.38.671000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.08.39.140000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.08.39.281000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8881, S -- Result (0 = success): 0 2004-10-29-10.08.39.687000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 9731, S -- Result (0 = success): 0 2004-10-29-10.08.39.984000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 9733, S -- Result (0 = success): 0 2004-10-29-10.08.41.593000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.08.42.046000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.08.42.203000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8881, S -- Result (0 = success): 0 2004-10-29-10.08.42.515000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.08.43.187000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.08.43.328000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8880, S -- Result (0 = success): 0 2004-10-29-10.08.51.171000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.08.51.796000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.08.52.562000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.08.56.390000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:756 Appid:D3984109.C112.041028143228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.09.07.406000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10024, 5012 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10021, S -- Result (0 = success): 0 2004-10-29-10.09.08.234000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.09.09.109000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10027, 5013 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10024, S -- Result (0 = success): 0 2004-10-29-10.09.10.484000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.09.11.640000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8881, S -- Result (0 = success): 0 2004-10-29-10.09.13.109000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.09.14.593000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.09.14.828000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8880, S -- Result (0 = success): 0 2004-10-29-10.09.18.062000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.09.21.546000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.09.38.625000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10018, S -- Result (0 = success): 0 2004-10-29-10.09.57.250000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.10.13.015000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10023, 5011 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10020, S -- Result (0 = success): 0 2004-10-29-10.10.13.687000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.10.14.187000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.10.14.765000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.10.15.078000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 6868, S -- Result (0 = success): 0 2004-10-29-10.10.17.093000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.10.18.046000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10027, 5013 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 6877, S -- Result (0 = success): 0 2004-10-29-10.10.26.734000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10023, 5011 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 9978, S -- Result (0 = success): 0 2004-10-29-10.10.27.000000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 9973, S -- Result (0 = success): 0 2004-10-29-10.10.31.765000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.10.32.062000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.10.32.296000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.10.37.312000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1036 Appid:D3984109.BF12.041028143226 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.10.38.953000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.10.39.343000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 6874, S -- Result (0 = success): 0 2004-10-29-10.10.40.453000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.10.40.609000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10027, 5013 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 6875, S -- Result (0 = success): 0 2004-10-29-10.10.51.890000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.10.58.812000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.10.59.578000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10024, 5012 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10021, S -- Result (0 = success): 0 2004-10-29-10.11.09.375000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.11.09.562000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 6865, S -- Result (0 = success): 0 2004-10-29-10.11.10.156000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.11.10.312000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10027, 5013 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 6875, S -- Result (0 = success): 0 2004-10-29-10.11.10.906000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.11.16.421000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10023, S -- Result (0 = success): 0 2004-10-29-10.11.16.703000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.11.16.937000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.11.17.156000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.11.17.390000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.11.27.609000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.11.27.890000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.11.29.656000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.11.29.828000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 6862, S -- Result (0 = success): 0 2004-10-29-10.11.30.453000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.11.30.593000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1388 Appid:D3984109.9B12.041028143116 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 6871, S -- Result (0 = success): 0 2004-10-29-10.11.40.015000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.11.40.468000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.11.40.593000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8880, S -- Result (0 = success): 0 2004-10-29-10.11.40.812000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.11.41.265000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.11.41.375000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8881, S -- Result (0 = success): 0 2004-10-29-10.11.44.953000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10018, S -- Result (0 = success): 0 2004-10-29-10.11.46.640000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.11.51.156000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.11.51.453000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.11.51.687000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.11.53.734000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1164 Appid:D3984109.5513.041029020455 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10024, 5012 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10021, S -- Result (0 = success): 0 2004-10-29-10.11.56.921000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10023, 5011 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8014, S -- Result (0 = success): 0 2004-10-29-10.11.57.093000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 8953, S -- Result (0 = success): 0 2004-10-29-10.11.57.578000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8014, S -- Result (0 = success): 0 2004-10-29-10.11.57.734000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1080 Appid:D3984109.B412.041029020228 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 8947, S -- Result (0 = success): 0 2004-10-29-10.11.58.453000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.11.59.796000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.12.00.515000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.12.01.203000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.12.09.984000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.12.10.343000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.12.10.609000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.12.10.843000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.12.11.109000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.12.17.828000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.12.21.531000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.12.21.687000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.12.21.984000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;67) DB2ADMIN.ORDERHEAD -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.12.22.468000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.12.22.640000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10023, 5011 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.12.22.953000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:900 Appid:D3984109.5613.041029020519 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;67) DB2ADMIN.ORDERHEAD -- Locks, Request Type : 10016, S -- Result (0 = success): 0 2004-10-29-10.12.25.093000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10023, S -- Result (0 = success): 0 2004-10-29-10.12.25.390000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.12.25.640000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.12.40.078000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10027, 5013 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10024, S -- Result (0 = success): 0 2004-10-29-10.12.42.156000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10018, S -- Result (0 = success): 0 2004-10-29-10.12.48.875000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10021, 5010 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10018, S -- Result (0 = success): 0 2004-10-29-10.12.49.312000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.12.49.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8889, S -- Result (0 = success): 0 2004-10-29-10.12.49.687000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.12.50.156000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29-10.12.50.375000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 8890, S -- Result (0 = success): 0 2004-10-29-10.12.53.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10020, 5010 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10017, S -- Result (0 = success): 0 2004-10-29-10.13.07.734000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.13.19.125000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10024, 5012 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10021, S -- Result (0 = success): 0 2004-10-29-10.13.19.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.13.19.671000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.24.234000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.13.28.921000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10024, 5012 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10021, S -- Result (0 = success): 0 2004-10-29-10.13.29.203000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.29.453000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.29.656000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.13.29.906000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.30.140000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.13.30.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.30.640000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.13.30.875000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.31.062000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.13.31.281000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.31.468000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.13.31.687000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.38.015000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10016, 5008 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10013, S -- Result (0 = success): 0 2004-10-29-10.13.38.578000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.13.38.828000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10025, 5012 -- Table (ID) Name : (2;69) DB2ADMIN.STOCKDETAIL -- Locks, Request Type : 10022, S -- Result (0 = success): 0 2004-10-29-10.13.43.437000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;11) DB2ADMIN.PODETAIL -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.13.45.875000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:716 Appid:D3984109.BD0F.041028140857 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10023, 5011 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10020, S -- Result (0 = success): 0 2004-10-29-10.13.48.015000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10017, 5008 -- Table (ID) Name : (2;66) DB2ADMIN.STOCKTRADEHEAD -- Locks, Request Type : 10014, S -- Result (0 = success): 0 2004-10-29-10.13.48.859000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.13.49.328000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1460 Appid:D3984109.D612.041028143235 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10022, 5011 -- Table (ID) Name : (2;12) DB2ADMIN.STOCKTRADEDETAIL -- Locks, Request Type : 10019, S -- Result (0 = success): 0 2004-10-29-10.13.50.500000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10026, 5013 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 10023, S -- Result (0 = success): 0 2004-10-29-10.13.58.078000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10018, 5009 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 10015, S -- Result (0 = success): 0 2004-10-29-10.13.58.593000 Instance:DB2 Node:000 PID:1060(db2syscs.exe) TID:1440 Appid:D3984109.5813.041029020522 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 10019, 5009 -- Table (ID) Name : (2;37) DB2ADMIN.COMPANY -- Locks, Request Type : 6765, S -- Result (0 = success): 0 2004-10-29 oprs 回复于：2004-11-01 08:45:21 统统都是sqldEscalateLocks ，参考我前面说的条，调大locklist和maxlocks的值，直到不会出现sqldEscalateLocks的信息为止 db2diag.log的资料不是太多，你看下置顶帖和搜索一下这个论坛的db2diag，有几个帖子有介绍 你的情况，我觉得迁移表空间不会有什么明显的效果 joey945 回复于：2004-11-03 17:35:12 请大家帮我看看这个日志,因为记录有错误信息的时间刚好是今天数据库连接不上的时间,不清楚错误代码代表什么错误,数据库要怎样调整.谢谢! (To:oprs,从论坛里搜到的关于db2diag的信息很少,所以能否告诉我这些信息是怎样看的?谢谢.我的QQ:31696393,E-Mail:kingking945@yahoo.com.cn.) 2004-11-03-08.52.57.500000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1672 Appid:D3984109.EA0B.041102122833 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 113784, 56892 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 113781, S -- Result (0 = success): 0 2004-11-03-08.53.27.578000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1672 Appid:D3984109.EA0B.041102122833 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 113783, 56891 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 113780, S -- Result (0 = success): 0 2004-11-03-08.53.50.343000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1672 Appid:D3984109.EA0B.041102122833 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 113785, 56892 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 113782, S -- Result (0 = success): 0 2004-11-03-08.54.11.343000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:852 Appid:D3984109.EC0B.041102122835 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 113785, 56892 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 113782, S -- Result (0 = success): 0 2004-11-03-10.20.13.640000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:948 Appid:D3984109.CE05.041103022020 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.20.15.125000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1132 Appid:D3984109.6511.041102102534 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=15, tbspaceID=2, objType=1, parentObjID=15 parentTbspaceID=2. 2004-11-03-10.20.15.687000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1228 Appid:none buffer_pool_services sqlbFreeUpSlot Probe:122 All pages in buffer pool 1 are in use. 2004-11-03-10.20.16.328000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:948 Appid:D3984109.CE05.041103022020 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.20.16.828000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:292 Appid:D3984109.CF05.041103022021 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=10, tbspaceID=2, objType=0, parentObjID=10 parentTbspaceID=2. 2004-11-03-10.20.17.187000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:292 Appid:D3984109.CF05.041103022021 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=21, tbspaceID=2, objType=0, parentObjID=21 parentTbspaceID=2. 2004-11-03-10.20.17.828000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1132 Appid:D3984109.6511.041102102534 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.20.18.515000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1228 Appid:none buffer_pool_services sqlbGetVictimSlot Probe:727 DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.20.18.828000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1228 Appid:none buffer_pool_services sqlbErrorHandler Probe:0 DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.20.18.953000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1228 Appid:none buffer_pool_services sqlbErrorHandler Probe:0 Obj={pool:2;obj:21;type:0} State=x27 Prefetcher Error, in sqlbServiceListRequest Data Title:SQLB_OBJECT_DESC PID:616 TID:1228 Node:000 0200 1500 0200 1500 0000 0000 0002 5991 ..............Y? 60d2 0000 0000 0000 0000 0000 0000 0000 `?............. 0000 0000 0101 0000 2700 0000 0000 0000 ........'....... 0010 0000 2000 0000 0100 0000 0200 1500 .... ........... 8874 0201 f022 5f7e 坱..?_~ 2004-11-03-10.20.20.453000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1228 Appid:none buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0 Prefetcher Error rc = -11988 IGNORED ... err loc 0 . Request follows... 2004-11-03-10.20.21.484000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1228 Appid:none buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0 type = LIST numpages = 1 SQLB_OBJECT_DESC: objID: 21 PlId: 2 objTyp: 0 Ext Anch: 0 plFlgs: 257 start index: 0 The pages: 30 2004-11-03-10.20.22.875000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:292 Appid:D3984109.CF05.041103022021 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.20.24.140000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:292 Appid:D3984109.CF05.041103022021 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.13.640000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1388 Appid:D3984109.9F10.041103024729 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.14.718000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1388 Appid:D3984109.9F10.041103024729 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.14.906000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1860 Appid:D3984109.270C.041102113144 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=4, tbspaceID=3, objType=128, parentObjID=4 parentTbspaceID=3. 2004-11-03-10.54.15.875000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1860 Appid:D3984109.270C.041102113144 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.15.984000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1800 Appid:D3984109.F50B.041102122844 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=12, tbspaceID=2, objType=0, parentObjID=12 parentTbspaceID=2. 2004-11-03-10.54.17.062000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1208 Appid:D3984109.EF10.041103024803 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.18.765000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1860 Appid:D3984109.270C.041102113144 sort/list_services sqlsSpillASORT Probe:10 Database:JINGMEI ibuff 3040 e906 0100 0000 ec00 0000 00c0 0e00 0@?....?...?. 5111 0000 1c11 0000 04bf 0e00 0000 0000 Q........?..... 0000 0000 0cfe f706 5c34 f306 ....../4? 2004-11-03-10.54.22.109001 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1960 Appid:D3984109.DC10.041102130017 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.24.140000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1512 Appid:D3984109.0A04.041102093435 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.26.500000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:984 Appid:D3984109.FA0B.041102122848 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.28.468000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1020 Appid:D3984109.BB12.041103025500 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.30.296000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:756 Appid:D3984109.040C.041102122857 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.31.921000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1860 Appid:D3984109.270C.041102113144 sort/list_services sqlsSpillASORT Probe:15 Database:JINGMEI recptr 5c34 f306 /4? String Title: PID:616 Node:000 Could not fix page for objID=12, tbspaceID=2, objType=0, parentObjID=12 parentTbspaceID=2. 2004-11-03-10.54.34.250000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1052 Appid:D3984109.D110.041102130010 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=2, tbspaceID=1, objType=128, parentObjID=2 parentTbspaceID=1. 2004-11-03-10.54.37.187000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2032 Appid:D3984109.D310.041102130012 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.38.281000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2064 Appid:D3984109.D010.041102130009 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.39.593000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1816 Appid:D3984109.010C.041102122854 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.40.390000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:864 Appid:D3984109.F40B.041102122843 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=12, tbspaceID=2, objType=0, parentObjID=12 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.41.218000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:756 Appid:D3984109.040C.041102122857 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.41.515000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1052 Appid:D3984109.D110.041102130010 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.41.703000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2128 Appid:D3984109.F90B.041102122847 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.42.015000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:604 Appid:D3984109.D210.041102130011 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.42.218000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1800 Appid:D3984109.F50B.041102122844 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=12, tbspaceID=2, objType=0, parentObjID=12 parentTbspaceID=2. 2004-11-03-10.54.42.406000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2064 Appid:D3984109.D010.041102130009 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.42.484000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1064 Appid:D3984109.8411.041103025001 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.42.796000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1960 Appid:D3984109.DC10.041102130017 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.42.953000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2032 Appid:D3984109.D310.041102130012 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.43.031000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:604 Appid:D3984109.D210.041102130011 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.43.093000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1708 Appid:D3984109.ED0B.041102122836 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.44.109000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1708 Appid:D3984109.ED0B.041102122836 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.44.234000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1388 Appid:D3984109.9F10.041103024729 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.44.750000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1816 Appid:D3984109.010C.041102122854 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.44.921000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:600 Appid:D3984109.E710.041102130024 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.45.343000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1388 Appid:D3984109.9F10.041103024729 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.45.515000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:808 Appid:D3984109.080B.041102112658 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.45.734000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:808 Appid:D3984109.080B.041102112658 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.45.859000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:600 Appid:D3984109.E710.041102130024 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=12, tbspaceID=2, objType=0, parentObjID=12 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.46.187000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:984 Appid:D3984109.FA0B.041102122848 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.46.234000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:984 Appid:D3984109.FA0B.041102122848 sort/list_services sqlsSpillASORT Probe:10 Database:JINGMEI ibuff 3040 6306 0100 0000 ec00 0000 00c0 0e00 0@c.....?...?. 950d 0000 870d 0000 30be 0e00 0000 0000 ?..?..0?..... 0000 0000 b4fd 7106 649c 6306 ....待q.d渃. 2004-11-03-10.54.46.390000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:984 Appid:D3984109.FA0B.041102122848 sort/list_services sqlsSpillASORT Probe:15 Database:JINGMEI recptr 649c 6306 d渃. 2004-11-03-10.54.46.671000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1512 Appid:D3984109.0A04.041102093435 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=12, tbspaceID=2, objType=0, parentObjID=12 parentTbspaceID=2. 2004-11-03-10.54.46.781000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:864 Appid:D3984109.F40B.041102122843 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=10, tbspaceID=2, objType=0, parentObjID=10 parentTbspaceID=2. 2004-11-03-10.54.47.687000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1076 Appid:D3984109.BD12.041103025501 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-10.54.48.375000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1020 Appid:D3984109.BB12.041103025500 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=3, tbspaceID=1, objType=128, parentObjID=3 parentTbspaceID=1. 2004-11-03-10.54.49.562000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2128 Appid:D3984109.F90B.041102122847 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.49.937000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1208 Appid:D3984109.EF10.041103024803 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.50.187000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1092 Appid:D3984109.070C.041102122858 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-10.54.51.265000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1920 Appid:D3984109.D810.041102130014 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=6, tbspaceID=3, objType=128, parentObjID=6 parentTbspaceID=3. 2004-11-03-10.54.52.875000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1092 Appid:D3984109.070C.041102122858 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=6, tbspaceID=1, objType=128, parentObjID=6 parentTbspaceID=1. 2004-11-03-10.54.53.406000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1920 Appid:D3984109.D810.041102130014 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.53.843000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1076 Appid:D3984109.BD12.041103025501 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.55.000000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1064 Appid:D3984109.8411.041103025001 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-10.54.55.906000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1092 Appid:D3984109.070C.041102122858 sort/list_services sqlsSpillASORT Probe:10 Database:JINGMEI ibuff 3040 5807 0100 0000 ec00 0000 00c0 0e00 0@X.....?...?. bb0c 0000 b40c 0000 b0be 0e00 0000 0000 ?..?..熬...... 0000 0000 c0fd 6607 60a8 6507 ....例f.`╡. 2004-11-03-10.54.56.765000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1092 Appid:D3984109.070C.041102122858 sort/list_services sqlsSpillASORT Probe:15 Database:JINGMEI recptr 60a8 6507 `╡. 2004-11-03-11.29.19.125000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1876 Appid:D3984109.6511.041102102534 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=5, tbspaceID=3, objType=128, parentObjID=5 parentTbspaceID=3. 2004-11-03-11.29.19.625000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1876 Appid:D3984109.6511.041102102534 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-11.29.19.687000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1876 Appid:D3984109.6511.041102102534 sort/list_services sqlsSpillASORT Probe:10 Database:JINGMEI ibuff 3040 fa06 0100 0000 ec00 0000 00c0 0e00 0@?....?...?. 950d 0000 870d 0000 30be 0e00 0000 0000 ?..?..0?..... 0000 0000 b4fd 0807 5076 0807 ....待..Pv.. 2004-11-03-11.29.20.281000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1876 Appid:D3984109.6511.041102102534 sort/list_services sqlsSpillASORT Probe:15 Database:JINGMEI recptr 5076 0807 Pv.. 2004-11-03-12.00.49.703000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1908 Appid:D3984109.F60B.041102122845 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=2, tbspaceID=3, objType=128, parentObjID=2 parentTbspaceID=3. 2004-11-03-12.00.51.109000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1952 Appid:D3984109.F110.041102130034 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.00.52.140000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1908 Appid:D3984109.F60B.041102122845 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=2, tbspaceID=1, objType=128, parentObjID=2 parentTbspaceID=1. 2004-11-03-12.00.53.796000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1952 Appid:D3984109.F110.041102130034 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.15.156000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:580 Appid:D3984109.D705.041103022029 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. 2004-11-03-12.11.15.437000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:580 Appid:D3984109.D705.041103022029 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.15.593000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1796 Appid:D3984109.6407.041102094659 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.16.234000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1796 Appid:D3984109.6407.041102094659 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.16.359000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:580 Appid:D3984109.D705.041103022029 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. 2004-11-03-12.11.16.781000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:580 Appid:D3984109.D705.041103022029 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.17.156000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1460 Appid:D3984109.F90B.041102122847 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=59, tbspaceID=2, objType=0, parentObjID=59 parentTbspaceID=2. 2004-11-03-12.11.17.609000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1460 Appid:D3984109.F90B.041102122847 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.20.125000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1532 Appid:D3984109.D305.041103022025 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.21.140000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1532 Appid:D3984109.D305.041103022025 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.21.765000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1100 Appid:D3984109.EB05.041103022035 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.11.22.828000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:828 Appid:D3984109.F40B.041102122843 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.11.26.859000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:636 Appid:D3984109.6D04.041103041148 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.28.593000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:636 Appid:D3984109.6D04.041103041148 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.28.875000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2084 Appid:D3984109.270C.041102113144 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.30.640000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1672 Appid:D3984109.120A.041102095539 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.33.687000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1100 Appid:D3984109.EB05.041103022035 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.37.562000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:828 Appid:D3984109.F40B.041102122843 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.38.265000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:916 Appid:D3984109.D505.041103022027 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.11.39.562000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1848 Appid:D3984109.EE05.041103022038 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=2, tbspaceID=1, objType=128, parentObjID=2 parentTbspaceID=1. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=2, tbspaceID=3, objType=128, parentObjID=2 parentTbspaceID=3. 2004-11-03-12.11.42.562000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2084 Appid:D3984109.270C.041102113144 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.42.906000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2084 Appid:D3984109.270C.041102113144 sort/list_services sqlsSpillASORT Probe:10 Database:JINGMEI ibuff 3040 a306 0100 0000 ec00 0000 00c0 0e00 0@?....?...?. ff12 0000 d112 0000 b8d0 0d00 0000 0000 ...?..感...... 0000 0000 3810 b106 6c48 a606 ....8.?lH? 2004-11-03-12.11.45.062000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2084 Appid:D3984109.270C.041102113144 sort/list_services sqlsSpillASORT Probe:15 Database:JINGMEI recptr 6c48 a606 lH? 2004-11-03-12.11.46.750000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:916 Appid:D3984109.D505.041103022027 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.47.750001 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1932 Appid:D3984109.7504.041103041156 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.11.49.546000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1848 Appid:D3984109.EE05.041103022038 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.50.859001 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1552 Appid:D3984109.7104.041103041152 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.11.52.937000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1752 Appid:D3984109.E905.041103022033 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.54.546000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1752 Appid:D3984109.E905.041103022033 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.54.656000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:944 Appid:D3984109.6F04.041103041150 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=7, tbspaceID=3, objType=128, parentObjID=7 parentTbspaceID=3. 2004-11-03-12.11.54.968000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1672 Appid:D3984109.120A.041102095539 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.55.109000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:944 Appid:D3984109.6F04.041103041150 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.55.468000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1068 Appid:D3984109.6804.041103041143 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.55.671000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1068 Appid:D3984109.6804.041103041143 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.56.046000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1032 Appid:D3984109.7204.041103041153 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=10, tbspaceID=2, objType=0, parentObjID=10 parentTbspaceID=2. 2004-11-03-12.11.56.187000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1032 Appid:D3984109.7204.041103041153 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.56.609000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1504 Appid:D3984109.ED05.041103022037 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.11.56.781000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1504 Appid:D3984109.ED05.041103022037 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.57.156000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1932 Appid:D3984109.7504.041103041156 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.11.57.218000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1812 Appid:D3984109.FA0B.041102122848 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=5, tbspaceID=1, objType=128, parentObjID=5 parentTbspaceID=1. 2004-11-03-12.11.57.343000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1812 Appid:D3984109.FA0B.041102122848 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=10, tbspaceID=2, objType=0, parentObjID=10 parentTbspaceID=2. 2004-11-03-12.11.57.781000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1552 Appid:D3984109.7104.041103041152 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.15.22.828000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:936 Appid:D3984109.8404.041103041210 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.15.23.656000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:936 Appid:D3984109.8404.041103041210 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.15.25.062000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:848 Appid:D3984109.7C04.041103041203 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.15.26.359000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:848 Appid:D3984109.7C04.041103041203 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.15.38.703000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:916 Appid:D3984109.D505.041103022027 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.15.39.796000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2084 Appid:D3984109.270C.041102113144 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=5, tbspaceID=3, objType=128, parentObjID=5 parentTbspaceID=3. 2004-11-03-12.15.41.187000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:916 Appid:D3984109.D505.041103022027 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=5, tbspaceID=1, objType=128, parentObjID=5 parentTbspaceID=1. 2004-11-03-12.15.41.843000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2084 Appid:D3984109.270C.041102113144 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.09.203000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1504 Appid:D3984109.ED05.041103022037 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=10, tbspaceID=2, objType=0, parentObjID=10 parentTbspaceID=2. 2004-11-03-12.21.09.406001 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1504 Appid:D3984109.ED05.041103022037 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.09.468000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1244 Appid:D3984109.7704.041103041158 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=67, tbspaceID=2, objType=0, parentObjID=67 parentTbspaceID=2. 2004-11-03-12.21.09.968000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1244 Appid:D3984109.7704.041103041158 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.10.156000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1552 Appid:D3984109.7104.041103041152 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.21.10.312000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2024 Appid:D3984109.EF10.041103024803 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=67, tbspaceID=2, objType=0, parentObjID=67 parentTbspaceID=2. 2004-11-03-12.21.10.531000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2024 Appid:D3984109.EF10.041103024803 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.10.656000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:916 Appid:D3984109.D505.041103022027 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=67, tbspaceID=2, objType=0, parentObjID=67 parentTbspaceID=2. 2004-11-03-12.21.11.015000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:916 Appid:D3984109.D505.041103022027 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.11.343000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:468 Appid:D3984109.8504.041103041211 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. 2004-11-03-12.21.11.578000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:468 Appid:D3984109.8504.041103041211 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.11.937000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2048 Appid:D3984109.7904.041103041200 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. 2004-11-03-12.21.12.281000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2048 Appid:D3984109.7904.041103041200 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.12.562000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1912 Appid:D3984109.7804.041103041159 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.21.13.609000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:900 Appid:D3984109.6A04.041103041145 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=67, tbspaceID=2, objType=0, parentObjID=67 parentTbspaceID=2. 2004-11-03-12.21.15.812000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:900 Appid:D3984109.6A04.041103041145 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.16.265000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1504 Appid:D3984109.ED05.041103022037 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-12.21.17.578000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:636 Appid:D3984109.6D04.041103041148 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=67, tbspaceID=2, objType=0, parentObjID=67 parentTbspaceID=2. 2004-11-03-12.21.18.781000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:636 Appid:D3984109.6D04.041103041148 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.19.125000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1912 Appid:D3984109.7804.041103041159 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.19.718000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1552 Appid:D3984109.7104.041103041152 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-12.21.20.062000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:944 Appid:D3984109.6F04.041103041150 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.21.21.093000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1504 Appid:D3984109.ED05.041103022037 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-12.21.21.750000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:944 Appid:D3984109.6F04.041103041150 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-13.36.53.515000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1160 Appid:D3984109.1E07.041103042209 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=12, tbspaceID=2, objType=0, parentObjID=12 parentTbspaceID=2. 2004-11-03-13.36.53.968000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1160 Appid:D3984109.1E07.041103042209 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-13.36.54.359000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2008 Appid:D3984109.4A08.041103053703 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-13.36.54.515000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:864 Appid:D3984109.5908.041103053717 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=44, tbspaceID=2, objType=0, parentObjID=44 parentTbspaceID=2. 2004-11-03-13.36.54.781000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:864 Appid:D3984109.5908.041103053717 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-13.36.54.968000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1708 Appid:D3984109.4E08.041103053707 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. 2004-11-03-13.36.55.406000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1708 Appid:D3984109.4E08.041103053707 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-13.36.55.765000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:828 Appid:D3984109.4C08.041103053705 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=59, tbspaceID=2, objType=0, parentObjID=59 parentTbspaceID=2. 2004-11-03-13.36.56.375000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:828 Appid:D3984109.4C08.041103053705 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-13.36.56.546000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1556 Appid:D3984109.4808.041103053701 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=44, tbspaceID=2, objType=0, parentObjID=44 parentTbspaceID=2. 2004-11-03-13.36.57.625000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:2008 Appid:D3984109.4A08.041103053703 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-13.36.57.875000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:412 Appid:D3984109.1807.041103042206 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=44, tbspaceID=2, objType=0, parentObjID=44 parentTbspaceID=2. 2004-11-03-13.36.58.703000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:412 Appid:D3984109.1807.041103042206 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-13.36.59.093000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:600 Appid:D3984109.5A0A.041103043737 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-13.36.59.609000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1456 Appid:D3984109.4607.041103042246 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-13.37.00.734000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1960 Appid:D3984109.5A08.041103053718 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-13.37.01.781000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:600 Appid:D3984109.5A0A.041103043737 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=2, tbspaceID=1, objType=128, parentObjID=2 parentTbspaceID=1. 2004-11-03-13.37.02.250000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1556 Appid:D3984109.4808.041103053701 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. 2004-11-03-13.37.02.906000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1960 Appid:D3984109.5A08.041103053718 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-13.37.03.078000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1456 Appid:D3984109.4607.041103042246 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-13.37.04.140000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1456 Appid:D3984109.4607.041103042246 sort/list_services sqlsSpillASORT Probe:10 Database:JINGMEI ibuff 3040 ff09 0100 0000 ec00 0000 00c0 0e00 0@ ....?...?. c511 0000 a011 0000 70be 0e00 0000 0000 ?..?..p?..... 0000 0000 d0fd 0d0a f4be 010a ....旋..艟.. 2004-11-03-13.37.06.562000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1456 Appid:D3984109.4607.041103042246 sort/list_services sqlsSpillASORT Probe:15 Database:JINGMEI recptr f4be 010a 艟.. 2004-11-03-14.07.50.421000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1208 Appid:D3984109.9A0E.041103060738 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 113786, 56893 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 113783, S -- Result (0 = success): 0 2004-11-03-14.22.41.218000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:936 Appid:D3984109.4A12.041103062041 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. 2004-11-03-14.22.42.046000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:936 Appid:D3984109.4A12.041103062041 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-14.23.18.468000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1736 Appid:D3984109.7C13.041103062314 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-14.23.19.296000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:872 Appid:D3984109.7413.041103062307 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-14.23.20.328000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1712 Appid:D3984109.7312.041103062124 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. 2004-11-03-14.23.21.625000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1848 Appid:D3984109.3E12.041103062024 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-14.23.22.421000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1848 Appid:D3984109.3E12.041103062024 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=13, tbspaceID=2, objType=0, parentObjID=13 parentTbspaceID=2. String Title: PID:616 Node:000 Could not fix page for objID=45, tbspaceID=2, objType=0, parentObjID=45 parentTbspaceID=2. 2004-11-03-14.23.23.234000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1712 Appid:D3984109.7312.041103062124 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-14.23.23.609000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1736 Appid:D3984109.7C13.041103062314 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-14.23.23.796000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:872 Appid:D3984109.7413.041103062307 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-14.23.25.609000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1972 Appid:D3984109.1010.041103061336 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 31868, 15934 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 31865, S -- Result (0 = success): 0 2004-11-03-14.23.26.296000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1972 Appid:D3984109.1010.041103061336 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 31824, 15912 -- Table (ID) Name : (2;13) DB2ADMIN.ORDERDETAIL -- Locks, Request Type : 23885, S -- Result (0 = success): 0 2004-11-03-14.23.26.437000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1312 Appid:D3984109.9C12.041103062207 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 111090, 55545 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 111046, S -- Result (0 = success): 0 2004-11-03-14.23.26.921000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:816 Appid:D3984109.1210.041103061338 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 87855, 43927 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 87852, S -- Result (0 = success): 0 2004-11-03-14.23.27.593000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1972 Appid:D3984109.1010.041103061336 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 31833, 15916 -- Table (ID) Name : (2;44) DB2ADMIN.CU_CUSTOMER -- Locks, Request Type : 31830, S -- Result (0 = success): 0 2004-11-03-14.23.28.546000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1848 Appid:D3984109.3E12.041103062024 data_management sqldEscalateLocks Probe:2 Database:JINGMEI -- Lock Count, Target : 80024, 40012 -- Table (ID) Name : (2;45) DB2ADMIN.PRO_PRODUCT -- Locks, Request Type : 74448, S -- Result (0 = success): 0 2004-11-03-14.41.56.921000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:584 Appid:D3984109.3507.041103063722 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=2, tbspaceID=1, objType=128, parentObjID=2 parentTbspaceID=1. 2004-11-03-14.41.58.062000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:584 Appid:D3984109.3507.041103063722 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-14.41.58.359000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:584 Appid:D3984109.3507.041103063722 sort/list_services sqlsSpillASORT Probe:10 Database:JINGMEI ibuff 3040 650c 0100 0000 ec00 0000 00c0 0e00 0@e.....?...?. ff12 0000 d512 0000 54e2 0c00 0000 0000 ...?..T?..... 0000 0000 dc21 720c c449 700c ....?r.腎p. 2004-11-03-14.41.59.859000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:584 Appid:D3984109.3507.041103063722 sort/list_services sqlsSpillASORT Probe:15 Database:JINGMEI recptr c449 700c 腎p. 2004-11-03-15.44.00.500000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1756 Appid:D3984109.D608.041103064439 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=4, tbspaceID=1, objType=128, parentObjID=4 parentTbspaceID=1. 2004-11-03-15.44.01.375000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1756 Appid:D3984109.D608.041103064439 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 2004-11-03-16.06.19.843001 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:1444 Appid:D3984109.7F0B oprs 回复于：2004-11-03 20:15:01 注意一下关键字呀，大部分都是All pages in buffer pool 1 are in use.，把你的bufferpool调大吧，机器是1g内存，如果只跑db2的话，调到500m左右吧 另外，sqldEscalateLocks 的信息明显减少了，不过还有一些，把locklist的值再增大一些看看吧， 那PRO_PRODUCT是个基础表吧，数据量不小，索引一定要确定没问题o joey945 回复于：2004-11-03 22:36:12 多谢oprs. pro_product表是比较大,有十二万的数据.它的访问量大是因为我们在前台提供产品搜索.昨天下午我已经把前台的产品搜索功能屏蔽了,但是昨天晚上22:00我去看的时候故障还在,有连数据库的页面就出不来.当时连到数据库的应用只有30个.而且二个月前该表的数据有17万多,也没有这种情况,后来整理过的,整理后也做了reorg和runstats.不知道是不是数据库有什么内部错误,我看到很多如下面的"0xFFFFD12C"错误,这个是什么错误呢? 2004-11-03-18.48.26.890000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:852 Appid:D3984109.5813.041103090310 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". 同时操作系统的日志查看器有如下错误: Event Type: Error Event Source: DB2 Event Category: None Event ID: 4 Date: 11/3/2004 Time: 6:48:26 PM User: N/A Computer: DBSERVER Description: An entry has been logged to the DB2 Diagnostic Log for instance DB2. Please refer to this instance's DB2 Diagnostic Log for additional information. 2004-11-03-18.48.26.890000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:852 Appid:D3984109.5813.041103090310 An error has occurred and diagnostic information has been written to db2diag.log. Please examine the entry and contact IBM Service if necessary. 后来,根据你说的,我把locklist调到6000,IBMDEFAULTBP调成400000,另外有一个自己创建的buffer pool是151517,今天早上又连不上,在服务器的命令行connect 到数据库时出现下面的消息,是不是其它地方的参数占用内存太多,buffer pool不够用了? SQL1478W The defined buffer pools could not be started. Instead, one small buffer pool for each page size supported by DB2 has been started. SQLSTATE=01626 然后就把自己创建的那个buffer pool卸掉了,只留IBMDEFAULTBP,本地连接依然很慢,只好又把IBMDRFAULT的size又改回151517,本地连接才可以连接.但是又回到了昨天的状态.该怎么调呢? 再次感谢,请继续不吝赐教和帮助,这个问题已经困扰我一段时间了,严重影响了正常业务运作. myuhan 回复于：2004-11-04 08:57:57 呵呵，还有好多参数要调，等会帮你看，现在忙 huyuhui001 回复于：2004-11-04 10:44:33 2004-11-03-10.20.17.187000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:292 Appid:D3984109.CF05.041103022021 buffer_pool_services sqlbGetVictimSlot Probe:727 Database:JINGMEI DIA9999E An internal error occurred. Report the following error code : "0xFFFFD12C". String Title: PID:616 Node:000 Could not fix page for objID=21, tbspaceID=2, objType=0, parentObjID=21 parentTbspaceID=2. "0xFFFFD12C"的意思是disk full，检查一下你的buffer pool，调大一些，另外，你的tempspace所在的分区是不是空间不够。还有编号是2的表空间是什么，检查一下了。 DB2在32位系统中是有内存限制的，你是把总量调的太高了。参考下面的公式计算一下： buffer pools + dbheap + util_heap_sz + pkgcachesz + aslheapsz + locklist + approx 10% overhead 计算出来的总量参考下面：（不能超过呀） AIX - 1.75 GB Linux - 1.75 GB Sun - 3.35 GB HP-UX - approximately 800 MB Windows - 2-3 GB （在 NT/2000 上的 boot.ini 中使用的是 ' 3GB' switch） 12万的数据量不算大，我这里实际应用中的很多表都至少有30多了columns，数据量都在亿以上，大的表有200GB。调整好索引和分配合理的表分布，重要的是检查sql是不是合理。很多问题不是数据库调整就能解决的，烂的sql能把你的DB跑死了。 oprs 回复于：2004-11-04 12:53:31 兄弟，调过头了，400000都1.6G了吧，现在是151517吗？ 除了满足楼上所说的容量限制外，那个容量总和也不应该超过你机器的物理内存数，不然反效果 db2 select * from syscat.bufferpools db2 list tablespaces show detail 把结果弄上来kk myuhan 回复于：2004-11-04 17:00:32 locktimeout 60 maxlocks 20 PCKCACHESZ 6000 sortheap 2000 dbheap 12000 locklist 10000 logfilsiz 2500 先调这些吧，不行的话在调，一张表有20几万条记录其实没什么。还有索引是不是合适。你可以用DB2ADVIS命令根据你的SQL语句来创建合适的索引。 joey945 回复于：2004-11-04 18:43:21 首先感谢三位救星,多谢! db2 select * from syscat.bufferpools的结果如下: BPNAME BUFFERPOOLID NGNAME NPAGES PAGESIZE ESTORE ------------------ ------------ ------------------ ----------- ----------- ------ IBMDEFAULTBP 1 - 151517 4096 N db2 list tablespaces show detail的结果如下:(只有一个硬盘,分了四个区,C装OS,D装DB2,E放数据库备份,F放一些安装程序.三个tablespace都是安装时默认的,都在D上.目前D区已用1.81G,剩余2.42G,应该有空间啊,怎么报disk full呢?) Tablespaces for Current Database Tablespace ID = 0 Name = SYSCATSPACE Type = System managed space Contents = Any data State = 0x0000 Detailed explanation: Normal Total pages = 2887 Useable pages = 2887 Used pages = 2887 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 16 Number of containers = 1 Minimum recovery time = 2004-11-04-00.36.57.000000 Tablespace ID = 1 Name = TEMPSPACE1 Type = System managed space Contents = System Temporary data State = 0x0000 Detailed explanation: Normal Total pages = 1 Useable pages = 1 Used pages = 1 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 16 Number of containers = 1 Tablespace ID = 2 Name = USERSPACE1 Type = System managed space Contents = Any data State = 0x0000 Detailed explanation: Normal Total pages = 207706 Useable pages = 207706 Used pages = 207706 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 16 Number of containers = 1 Minimum recovery time = 2004-08-12-06.24.07.000000 目前参数: BUFFPAGE - 151517 DBHEAP - 1621 UTIL_HEAP_SZ - 50505 PCKCACHESZ - 4000 LOCKLIST - 6000 ASLHEAPSZ - 15 approx 10% overhead 约占1G内存的10% - 100M LOCKTIMEOUT - 60 MAXLOCKS - 20 SORTHEAD - 256 LOGFILSIZ - 250 按上面的公式算起来,其它参数不变的话,BUFFPAGE应该是128000,目前是151517,不能再大了啊.myuhan兄提供的参数中,PCKCACHESZ 6000 dbheap 12000 locklist 10000和其它的几个加起来也超过了啊.怎么办? oprs和huyuhui001对myuhan提供的参数有何高见吗? 另外,有些表是有好几个索引,进行增删改操作并reorg后,runstats只能按照其中一个索引来做或者都不做,那些索引我以前看到过不少是指示需要重组的,但runstats不能做,要怎么做才是合适的索引呢?把旧的索引删掉重建可以吗? 急盼大家的帮助!TKS! mymm 回复于：2004-11-05 01:32:58 1、楼主用的是SMS，db2empfa是个不错的方案，不过改后就改不回来了！ 2、楼主又加了个BUFFERPOOL？能把： select a.tbspace,b.bpname,b.npages,b.pagesize from syscat.tablespaces a ,syscat.bufferpools b where a.bufferpoolid=b.bufferpoolid 列出来看看吗？楼主会明白，一个Tbs只能使用一个BufferPool，而一个BufferPool可用于多个Tbs吧！ 3、运行重整的有效方法是：runstats =>; reorg =>; rebind 4、151517的bufferpool对你1G的MEM来说该是太大了，调小一些，过大的BufferPool会使性能很低！ 5、为什么不打开监视开关看看呢？ 顺便贴一个关于BufferPool的不错的文章！ 摘自《DB2 Magazine》By Roger Sanders 引用：Buffer Pools If you have any experience with DB2 UDB, you probably know that a buffer pool is an area of memory allocated to the DB2 Database Manager solely for caching data pages either as new data is added to a database or as data is retrieved from disk in response to a query. Buffer pools improve overall database performance by reducing disk input/output operations because data can be accessed much faster from memory than from disk. In fact, analyzing how buffer pools are created and used is the most important step when tuning a database for optimum performance. Given the importance of buffer pools, every DBA should understand how DB2 UDB uses them. Here's a quick refresher course. When new data is added to a database, it's added to a new page in the buffer pool first. Eventually, that page is externalized to database storage. On the other hand, when data is retrieved from a database in response to a query, the DB2 Database Manager places the page (or pages) that contain the requested data into a buffer pool before passing the data itself onto the application or user that requested it. Each time a new query is processed, every available buffer pool is searched to see if the page that contains the data needed already resides in memory. If so, it's immediately passed on to the appropriate application or user. However, if the data requested can't be found in any of the available buffer pools, the DB2 Database Manager retrieves it from storage and copies it to a buffer pool before passing it on. Once a page has been copied to a buffer pool, that page stays in the buffer pool until the database is shut down or until the space it occupies is needed to store another page. (Because all data additions and modifications take place in the buffer pool first — modified pages are eventually flushed to disk — data stored in a buffer pool is always up-to-date.) When a buffer pool becomes full, the DB2 Database Manager selects pages to remove by examining when a page was last referenced, the likelihood that the page will be referenced again, the page type, and whether or not the page has been altered without externalizing the changes to disk. For example, a page that was retrieved in response to a query that was run 30 minutes ago would more likely be overwritten than a page that contains data for an update operation that hasn't yet been committed. By default, DB2 UDB creates one buffer pool (named IBMDEFAULTBP) as part of the database creation process. On Linux and Unix platforms, this buffer pool is allocated 1,000 4KB pages of memory; on Windows platforms, this buffer pool is allocated 250 4KB pages. You can increase or decrease the number of 4KB pages this buffer pool can hold by selecting the appropriate action from the Buffer Pools menu found in the Control Center or by executing the ALTER BUFFERPOOL SQL statement. You can also create additional buffer pools using the Buffer Pools menu in the Control Center or by executing the CREATE BUFFERPOOL SQL statement. Because buffer pools are so important, you should carefully consider how many buffer pools your implementation needs, how big each buffer pool should be, and how each buffer pool available should be used. In most environments, the number of buffer pools that can be used effectively depends on the amount of system memory available. If the total amount of memory available can hold only 10,000 4k pages (or less), it's often better to use a single large buffer pool than several small buffer pools. Using several small buffer pools can cause frequently accessed pages to be swapped in and out of memory more often, which, in turn, can lead to I/O contention for storage objects such as system catalog tables or repeatedly accessed user tables and indexes. However, if more memory is available, consider creating individual buffer pools for the following: * Each temporary tablespace defined * Tablespaces that contain tables that are accessed consistently and repeatedly by many short-duration update transactions * Tablespaces that contain tables and indexes that are updated frequently * Tablespaces that contain tables and indexes that are queried frequently but are updated infrequently * Tablespaces that contain tables that are queried frequently in a random manner * Tablespaces that contain data that is accessed by infrequently used applications * Any tablespace that contains data and indexes you want to favor. In most cases, larger buffer pools are better than smaller buffer pools. However, take into account the total amount of memory available as well as how the buffer pools will be used. If you have an application that performs many random access operations against a very large table, you should create and use a small buffer pool for that particular table. In such a situation, there's no need to keep data pages in buffer pool memory once they've been used to resolve a single query. On the other hand, if you have an application that frequently retrieves data from several small look-up tables, you should consider creating a buffer pool that's large enough to hold all of the data stored in these tables. With this design, the data can be loaded into memory once, allowing it to be accessed repeatedly without requiring additional disk I/O. oprs 回复于：2004-11-05 09:16:10 151517相对于你的内存都还是有点偏大了，120000差不多了，难道以现在这个值还会出现下面的类似这种错误？是数据库一被连接就会出现，还是使用一段时候后出现？ 2004-11-03-14.41.56.921000 Instance:DB2 Node:000 PID:616(db2syscs.exe) TID:584 Appid:D3984109.3507.041103063722 buffer_pool_services sqlbFreeUpSlot Probe:122 Database:JINGMEI All pages in buffer pool 1 are in use. String Title: PID:616 Node:000 Could not fix page for objID=2, tbspaceID=1, objType=128, parentObjID=2 parentTbspaceID=1. 另外那几个参数，像dbheap,sortheap等，适当的大些也是好的，你原先的值也确实小了点，但对你db2diag.log这些错误不会有什么影响 joey945 回复于：2004-11-05 09:57:20 monitor switches我打开了table,lock,bufferpool,但terminate后再get dbm cfg显示6个monitor依然是OFF呢? select a.tbspace,b.bpname,b.npages,b.pagesize from syscat.tablespaces a ,syscat.bufferpools b where a.bufferpoolid=b.bufferpoolid的结果如下: TBSPACE BPNAME NPAGES PAGESIZE ------------------ ------------------ ----------- ----------- SYSCATSPACE IBMDEFAULTBP 151517 4096 TEMPSPACE1 IBMDEFAULTBP 151517 4096 USERSPACE1 IBMDEFAULTBP 151517 4096 db2empfa我运行过两三次,db2 disconnect db_name,db2 force applicaton all,db2 terminate,db2stop,db2start后运行但过了一段时间提示数据库有对象正在用,我就没再试了.要怎么办才可以运行成功呢? 连接数据库不是一开始就不行,每次不行的时候我就去重启一下appserver,然后能用一段时间,用一段时间之后连接数据库的页面就出不来了,这种状态持续一段时间不重启appserver就会所有的页面都出不来了. 我注意到当连接数据库的页面出不来的时候,我去执行db2 disconnect db_name,db2 force applicaton all,db2 terminate,db2stop,db2start后,那些页面依然是连不上,必须要在WebSphere的控制台重启appserver才可以,而且我们5:30PM下班后没什么人用了,前台搜索也屏蔽了,晚上我去看的时候也是跟白天一样上不去,所以我怀疑是不是WebSphere有什么问题?我去看了WebSphere/AppServer/logs下的一些日志文件,没发现什么有用的信息,不知道要怎样获得WebSphere的诊断日志信息? 我想干脆把DB2升级到8.1,WAS升级到5.x,但网上没找到这些软件下载,在该论坛搜到一个DB2 8.1的下载地,下下来后安装发现许可证只能有5个connect,也不能用.大家有什么好建议? 希望大家能继续帮我,解决问题,谢谢了! oprs 回复于：2004-11-05 12:35:26 joey945, 我感觉你的系统的问题不是单一的，而是有很多，这点不知道你意识到没有，不要搅在一起了 照你说的情况，那连接不上的问题肯定主要是websphere服务器上的问题了，参考我前面的回帖 而db2diag.log里的信息反映了你数据库上的问题，基本上，这是不相关的问题 现在的话， 1。你调整了db2的lock和bufferpool的一些值，那么db2diag.log的出错信息还会出现么？ 2。把SystemOut.log, SystemErr.log贴出来kk吧 joey945 回复于：2004-11-05 13:10:45 出问题前WebSphere的connection pool是500,servlet engine的并发连接数是500.后来我调小了好几个值的组合都没有用.现在是前者是500,后者是450. oprn兄,我没有找到SystemOut.log和SystemErr.log,是不是要打开什么选项才能生成这两个日志文件? oprs 回复于：2004-11-08 09:56:40 晕，这两个日志文件都没有？总有类似的输出系统的出错信息的日志巴，3。5太老了，不熟悉 不过我感觉你的连接数设得太大了，你是什么性质的系统？一般业务系统，设个50，60足够了，运行一段时间连接不上，多半是连接资源没有释放，你用性能跟踪工具跟踪过没？ joey945 回复于：2004-11-10 08:33:17 这个系统每天都要用的,后台有订单、进销存及财务等,前台有搜索、目录树及文章系统等.以前曾因为数据库连接池不够连接不上我才把数量加大的,用500很长时间都没有问题啊. 系统有default_server_stdout.log和default_server_stderr.log及tracefile,我看过,但没有什么有用的信息. 我找了一个resource analyzer 3.5,能看到一些数据,但不熟悉,不知道能否由它找出问题.我今天11:00上去看了数据,这个时段几个参数都没什么明显的增加. 我发现基本上上午11:00左右都会上不去,下午1:00左右或2:00左右及下午4:00左右也会上不去.可能是这个时段用的人比较多.但是下班后后台没有人用的,前台应该也没多少人浏览,晚上10:00左右我去看也会连不上(连数据库的页面出不来,但用CLP的CONNECT命令是可以连上的).搞不懂是什么原因. 有文章说网络访问数量的关系应该是(见图):网络->;Web服务器Web容器->;EJB容器->;数据库,有效的配置方式就是使得队列成为一个"漏斗",也就是说，越靠近客户端的队列，其容量越大，而后面的队列，其容量要略小于或等于前面的队列. 在WebSphere3.5中,没有地方可以配置WebContainer的Thead Pools和ORB Services的Thread Pools,IBM HTTP SERVER的配置文件httpd.conf里的ThreadsPerChild就是上图WebServer,Servlet Engine并发连接数就是WebContainer,数据源Connection Pools就是DataSource,对么?我现在设置的ThreadsPerChild是250,Servlet Engine的大并发连接数是200,数据库的Connection Pools是150.这些值及其它如connection timeout,idle timeout和orghan timeout应该设什么值比较好? 哪位大虾熟悉WebSphere3.5及其故障诊断方法,请指点一二.
| ||||