Sybase系统表syslogs中OP代表的类型

sybase的syslogs(id=8)表中仅有两个字段:xactid:事务ID和op:更新操作的次数(sybase中文文档中的翻译)!
我觉得op应该理解为日志操作的类型。每个OP代表什么含义呢?常用的日志类型有:更新、插入、删除,对应的OP分别为:9,4,5。
下面列出OP值及其对象的操作类型。

Values:meanings

0: Transaction begin 
 
4: Data page insert 
 
5: Data page delete 
 
6: Indirect insert (from deferred insert/update) 
 
7: Index page insert 
 
8: Index page delete 
 
9: Direct replace/update 
 
10: No Op (skipped in recovery) 
 
11: Logged in first phase of deferred insert/update 
 
12: Logged in first phase of deferred delete/update 
 
13: Page allocation 
 
14: Next available object id for a creation 
 
15: Generated by 4801 (?) 
 
16: Page split 
 
17: Checkpoint 
 
18: Transaction save 
 
19: Logged when any "update" begins 
 
20: Sort page deallocations 
 
21: Page deallocation 
 
22: Delete all extents on allocation page 
 
23: Allocate extent - mark all pages used 
 
24: Allocation for new page of a split 
 
25: Direct sysindexes change 
 
26: Compensation log record 
 
27: Sort record 
 
28: SODEALLOC record 
 
30: Transaction end 
 
31: Sort timestamp record 
 
32: Text insert - direct 
 
33: Text insert - deferred 
 
34: Text delete - deferred 
 
35: Indirect insert (log record) 
 
36: Text delete - log record 
 
37: OAM page allocation 
 
38: OAM page deallocation 
 
39: OAM entry insertion 
 
40: OAM entry deletion 
 
41: OAM allocation during create/sort 
 
42: No Op cmd record 
 
43: Record for stored proc begin exec 
 
44: Record for stored proc complete 
 
45: Dump database sync 
 
46: Truncation point save 
 
47: Load database sync 
 
48: Load transaction sync 
 
49: Before/after image for replication 
 
50: Reserved for Replication Server 
 
51: Move OAM entries between OAM pages 
 
52: Record attribute data on OAM 
 
53: Deleted a column from a row 
 
54: Deallocate a run of log pages 
 
55: Data slice control page 
 
56: Deferred insert of an index row 
 
58: Table/procedure schema versioning (replication support) 
 
59: Column/parameter schema versioning (replication support) 
 
60: Prepare to commit 
 
61: Start of a top action 
 
62: End of a top action 
 
63: Insert log record for data row of data-only locked table 
 
64: Counterpart of XREC_INSIND for DOL table 
 
65: Update log record for DOL table 
 
66: Delete log record for data row of data-only locked table 
 
67: Garbage collection log record for DOL table 
 
68: Deferred update log record for DOL table 
 
69: Page alloc without links to neighbors 
 
70: Counterpart of XREC_DNOOP for DOL tables 
 
71: Btree leaf/nonleaf insert 
 
72: Btree leaf/nonleaf delete 
 
73: Btree leaf/nonleaf split 
 
74: Btree garbage collect leaf 
 
75: System catalog rows for the source table of create index 
 
76: End of sort log record 
 
77: New log record from dropextents 
 
82: dbtable structure change (X-DB commit dbcc pfts etc.)
  • 本文链接地址:https://www.dbainfo.net/syslogs-operation-types.htm
  • 本文为dbainfo个人原创,请在尊重作者劳动成果的前提下进行转载;
  • 转载务必注明原始出处 : Sybase数据库技术,数据库恢复专家
  • 对《Sybase系统表syslogs中OP代表的类型》有何疑问或见解,请在本文下方发表;
  • 对网站还有其他问题或建议,请提交在留言板,谢谢!
  • 目前还没有任何评论.
    :wink: :twisted: :roll: :oops: :mrgreen: :lol: :idea: :evil: :cry: :arrow: :?: :-| :-x :-o :-P :-D :-? :) :( :!: 8-O 8)