免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
123下一页
最近访问板块 发新帖
查看: 11522 | 回复: 27

DB2性能调整优化问题,请高手指点,急... [复制链接]

论坛徽章:
0
发表于 2004-10-28 12:45 |显示全部楼层
服务器是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)

论坛徽章:
0
发表于 2004-10-29 15:50 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

光看参数没用的,几个问题
1.你的websphere和db2是在一台服务器上,还是分开的?
2.速度变慢的时候察看资源,cpu,内存占用情况如何?
3。事务操作进行得比较多,那么reorg, runstats有没有做过?
4。看下你的db2diag.log里,有锁升级的信息么?

论坛徽章:
0
发表于 2004-10-29 16:19 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

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语句。
以上是我个人的观点,仅供参考。

论坛徽章:
0
发表于 2004-10-29 23:04 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

首先要向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页面没问题,连接数据库的就慢慢的很久出不来,最后显示"找不到服务器",如果再持续一段时间就连不连接数据库的页面都出不来了.

急盼大家的帮助!

论坛徽章:
0
发表于 2004-10-31 10:17 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

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以上的版本要稳定很多,最好还是升级把

希望对你有帮助    

论坛徽章:
0
发表于 2004-10-31 23:22 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

以下是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   InstanceB2   Node:000
PID:1060(db2syscs.exe)   TID:988   Appid3984109.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   InstanceB2   Node:000
PID:1060(db2syscs.exe)   TID:1448   Appid3984109.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   InstanceB2   Node:000
PID:1060(db2syscs.exe)   TID:1448   Appid3984109.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   InstanceB2   Node:000
PID:1060(db2syscs.exe)   TID:1448   Appid3984109.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   InstanceB2   Node:000
PID:1060(db2syscs.exe)   TID:1448   Appid3984109.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

论坛徽章:
0
发表于 2004-11-01 08:45 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

统统都是sqldEscalateLocks ,参考我前面说的第一条,调大locklist和maxlocks的值,直到不会出现sqldEscalateLocks的信息为止
db2diag.log的资料不是太多,你看下置顶帖和搜索一下这个论坛的db2diag,有几个帖子有介绍
你的情况,我觉得迁移表空间不会有什么明显的效果

论坛徽章:
0
发表于 2004-11-03 17:35 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

请大家帮我看看这个日志,因为记录有错误信息的时间刚好是今天数据库连接不上的时间,不清楚错误代码代表什么错误,数据库要怎样调整.谢谢!

(Toprs,从论坛里搜到的关于db2diag的信息很少,所以能否告诉我这些信息是怎样看的?谢谢.我的QQ:31696393,E-Mail:kingking945@yahoo.com.cn.)

2004-11-03-08.52.57.500000   InstanceB2   Node:000
PID:616(db2syscs.exe)   TID:1672   Appid3984109.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   InstanceB2   Node:000
PID:616(db2syscs.exe)   TID:1672   Appid3984109.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   InstanceB2   Node:000
PID:616(db2syscs.exe)   TID:1672   Appid3984109.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   InstanceB2   Node:000
PID:616(db2syscs.exe)   TID:852   Appid3984109.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   InstanceB2   Node:000
PID:616(db2syscs.exe)   TID:948   Appid3984109.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      

论坛徽章:
0
发表于 2004-11-03 20:15 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

注意一下关键字呀,大部分都是All pages in buffer pool 1 are in use.,把你的bufferpool调大吧,机器是1g内存,如果只跑db2的话,调到500m左右吧
另外,sqldEscalateLocks 的信息明显减少了,不过还有一些,把locklist的值再增大一些看看吧,
那PRO_PRODUCT是个基础表吧,数据量不小,索引一定要确定没问题o

论坛徽章:
0
发表于 2004-11-03 22:36 |显示全部楼层

DB2性能调整优化问题,请高手指点,急...

多谢oprs.
pro_product表是比较大,有十二万的数据.它的访问量大是因为我们在前台提供产品搜索.昨天下午我已经把前台的产品搜索功能屏蔽了,但是昨天晚上22:00我去看的时候故障还在,有连数据库的页面就出不来.当时连到数据库的应用只有30个.而且二个月前该表的数据有17万多,也没有这种情况,后来整理过的,整理后也做了reorg和runstats.不知道是不是数据库有什么内部错误,我看到很多如下面的"0xFFFFD12C"错误,这个是什么错误呢?
2004-11-03-18.48.26.890000   InstanceB2   Node:000
PID:616(db2syscs.exe)   TID:852   Appid3984109.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   InstanceB2   Node:000
PID:616(db2syscs.exe)   TID:852   Appid3984109.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,本地连接才可以连接.但是又回到了昨天的状态.该怎么调呢?

再次感谢,请继续不吝赐教和帮助,这个问题已经困扰我一段时间了,严重影响了正常业务运作.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

SACC2021中国系统架构师大会

【数字转型 架构重塑】2021年5月20日-22日第十三届中国系统架构师大会将在云端进行网络直播。

大会为期3天的议程,涉及20+专场,近120个主题,完整迁移到线上进行网络直播对会议组织来说绝非易事;但考虑到云端会议的直播形式可以实现全国各地技术爱好者的参与,也使ITPUB作为技术共享交流平台得到更好的普及,我们决定迎难而上。
http://sacc.it168.com/


大会官网>>
  

北京盛拓优讯信息技术有限公司. 版权所有 16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP