syslogs中OP代表的类型

----------------------------------------------------------------------------

---- 本文为andkylee个人原创，请在尊重作者劳动成果的前提下进行转载；

---- 转载务必注明原始出处 : http://blog.youkuaiyun.com/andkylee

---- 关键字： sybase log operation type  日志分析 类型

----------------------------------------------------------------------------

 

 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.)