- 论坛徽章:
- 0
|
为什么使用命令db2 "select * from table(snapshot_lock('hbtst', -1)) as snapshot_lock"取出来有的项为空值-?所有的快照开关也都打开了啊!
SNAPSHOT_TIMESTAMP AGENT_ID TABLE_FILE_ID LOCK_OBJECT_TYPE LOCK_MODE LOCK_STAT
US LOCK_OBJECT_NAME PARTITION_NUMBER LOCK_ESCALATION TABLE_NAME
TABLE_SCHEMA
TABLESPACE_NAME
-------------------------- -------------------- -------------------- -------------------- -------------------- ---------
----------- -------------------- ---------------- --------------- ------------------------------------------------------
-------------------------------------------------------------------------- ---------------------------------------------
----------------------------------------------------------------------------------- ------------------------------------
--------------------------------------------------------------------------------------------
2009-04-15-11.38.34.039300 435 0 9 3
1 0 - 0 -
-
-
2009-04-15-11.38.34.039300 435 0 8 3
1 0 - 0 -
-
- |
|