[精华] DB2性能调整优化问题,请高手指点,急... |
|---|
|
| 来源 chinaunix.net 酷勤网整理 |
服务器是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): |
| |
