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