sybase中给表增加和删除字段时内部处理过程分析

分析一下给表增加字段时sybase数据库的内部处理过程。

表原来的结构:

create table t(id int, col1 varchar(30))

向表中插入数据:

insert into t
select 1,'a'
go
insert into t
select 1,'a'
go
insert into t
select 2,'b'
go
insert into t
select 3,'c'
go

测试表t的object_id是:

1> select object_id('t')
2> go

 -----------
   608002166

利用dbcc log分析数据库的日志,可以看出上面的四条insert语句对应了四个单独的事务。因为sybase中默认是隐式提交的。

四条记录的页号和偏移分别是:

row1.  pageno=801 offset=32

row2.  pageno=801 offset=44

row3.  pageno=801 offset=56

row4.  pageno=801 offset=68

        BEGINXACT                (256007,32)    sessionid=256007,32
        attcnt=1 rno=32 op=0 padlen=2 sessionid=256007,32 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        masterxsid=(invalid sessionid)
        xstat=XBEG_ENDXACT,
        spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
        name=$ins   time=Apr  7 2010 10:21:49:756AM
        INSERT                   (256007,33)    sessionid=256007,32
        attcnt=1 rno=33 op=4 padlen=0 sessionid=256007,32 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=608002166  ptnid=608002166 pageno=801 offset=32 status=0x800 (0x08
00
(XSTAT_EXPAGE))
        cid=0 indid=0
        old ts=0x0000 0x000017d3  new ts=0x0000 0x000017e1
        xrow:
10003620d3c (     0):  01000000 0001000c 61020908           ........a...
        ENDXACT                  (256007,34)    sessionid=256007,32
        attcnt=1 rno=34 op=30 padlen=4 sessionid=256007,32 len=32
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        endstat=COMMIT time=Apr  7 2010 10:21:49:756AM
        xstat=0x0 []
        BEGINXACT                (256007,35)    sessionid=256007,35
        attcnt=1 rno=35 op=0 padlen=2 sessionid=256007,35 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        masterxsid=(invalid sessionid)
        xstat=XBEG_ENDXACT,
        spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
        name=$ins   time=Apr  7 2010 10:21:55:756AM
        INSERT                   (256007,36)    sessionid=256007,35
        attcnt=1 rno=36 op=4 padlen=0 sessionid=256007,35 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=608002166  ptnid=608002166 pageno=801 offset=44 status=0x800 (0x08
00
(XSTAT_EXPAGE))
        cid=0 indid=0
        old ts=0x0000 0x000017e1  new ts=0x0000 0x000017e3
        xrow:
10003620ddc (     0):  01010000 0001000c 61020908           ........a...
        ENDXACT                  (256007,37)    sessionid=256007,35
        attcnt=1 rno=37 op=30 padlen=4 sessionid=256007,35 len=32
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        endstat=COMMIT time=Apr  7 2010 10:21:55:756AM
        xstat=0x0 []
        BEGINXACT                (256007,38)    sessionid=256007,38
        attcnt=1 rno=38 op=0 padlen=2 sessionid=256007,38 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        masterxsid=(invalid sessionid)
        xstat=XBEG_ENDXACT,
        spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
        name=$ins   time=Apr  7 2010 10:22:03:756AM
        INSERT                   (256007,39)    sessionid=256007,38
        attcnt=1 rno=39 op=4 padlen=0 sessionid=256007,38 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=608002166  ptnid=608002166 pageno=801 offset=56 status=0x800 (0x08
00
(XSTAT_EXPAGE))
        cid=0 indid=0
        old ts=0x0000 0x000017e3  new ts=0x0000 0x000017e5
        xrow:
10003620e7c (     0):  01020000 0002000c 62020908           ........b...
        ENDXACT                  (256007,40)    sessionid=256007,38
        attcnt=1 rno=40 op=30 padlen=4 sessionid=256007,38 len=32
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        endstat=COMMIT time=Apr  7 2010 10:22:03:756AM
        xstat=0x0 []
        BEGINXACT                (256007,41)    sessionid=256007,41
        attcnt=1 rno=41 op=0 padlen=2 sessionid=256007,41 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        masterxsid=(invalid sessionid)
        xstat=XBEG_ENDXACT,
        spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
        name=$ins   time=Apr  7 2010 10:22:07:756AM
        INSERT                   (256007,42)    sessionid=256007,41
        attcnt=1 rno=42 op=4 padlen=0 sessionid=256007,41 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=608002166  ptnid=608002166 pageno=801 offset=68 status=0x800 (0x08
00
(XSTAT_EXPAGE))
        cid=0 indid=0
        old ts=0x0000 0x000017e5  new ts=0x0000 0x000017e7
        xrow:
10003620f1c (     0):  01030000 0003000c 63020908           ........c...
        ENDXACT                  (256007,43)    sessionid=256007,41
        attcnt=1 rno=43 op=30 padlen=4 sessionid=256007,41 len=32
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        endstat=COMMIT time=Apr  7 2010 10:22:07:756AM
        xstat=0x0 []

接着,向表中添加一个identity字段。

alter table t add col2 int identity not null
go

再利用dbcc log分析日志,我们可以看出在这四行数据上面发生了延迟更新(op=6,INSID在日志类型中是延迟更新的意思!)。

每行数据的页号和偏移变成了:

row1. pageno=801 offset=32

row2. pageno=801 offset=49

row3. pageno=801 offset=66

row4. pageno=801 offset=83

        INSIND                   (256008,24)    sessionid=256008,2
        attcnt=1 rno=24 op=6 padlen=2 sessionid=256008,2 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=608002166  ptnid=608002166 pageno=801 offset=32 status=0x2000 (0x2
000
(XSTAT_EXTABLE))
        cid=0 indid=0
        old ts=0x0000 0x000017f8  new ts=0x0000 0x000017f9
        data rnum 0 ptr=(256008,13)
        INSIND                   (256008,25)    sessionid=256008,2
        attcnt=1 rno=25 op=6 padlen=2 sessionid=256008,2 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=608002166  ptnid=608002166 pageno=801 offset=49 status=0x2000 (0x2
000
(XSTAT_EXTABLE))
        cid=0 indid=0
        old ts=0x0000 0x000017f9  new ts=0x0000 0x000017fa
        data rnum 1 ptr=(256008,15)
        INSIND                   (256008,26)    sessionid=256008,2
        attcnt=1 rno=26 op=6 padlen=2 sessionid=256008,2 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=608002166  ptnid=608002166 pageno=801 offset=66 status=0x2000 (0x2
000
(XSTAT_EXTABLE))
        cid=0 indid=0
        old ts=0x0000 0x000017fa  new ts=0x0000 0x000017fb
        data rnum 2 ptr=(256008,17)
        INSIND                   (256008,27)    sessionid=256008,2
        attcnt=1 rno=27 op=6 padlen=2 sessionid=256008,2 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=608002166  ptnid=608002166 pageno=801 offset=83 status=0x2000 (0x2
000
(XSTAT_EXTABLE))
        cid=0 indid=0
        old ts=0x0000 0x000017fb  new ts=0x0000 0x000017fc
        data rnum 3 ptr=(256008,19)

比较一下前后的各行的偏移量。我们发现:第一行没有移动,第二行向下移动了5(49-44)字节,第三行向下移动了10字节,第四行向下移动了15字节(83-68)。也就是说,每行增加了5个字节的数据。5个字节是因为:int类型占用4个字节再加一个字节的长度。


关于alter table add语法方面的

在向表添加列时是不能够添加not null 列的。错误如下所示:

1> alter table t add col4 char(30) not null
2> go
Msg 4997, Level 16, State 1:
Server 'SYB_NFJD_TEST', Line 1:
ALTER TABLE 't' failed. Default clause is required in order to add non-NULL
column 'col4'.
1> alter table t add col4 int not null
2> go
Msg 4997, Level 16, State 1:
Server 'SYB_NFJD_TEST', Line 1:
ALTER TABLE 't' failed. Default clause is required in order to add non-NULL
column 'col4'.
1>

1. 只能添加为空的字段。

2. 但是,本文前面的向表添加identity类型的int 非空字段却可以。alter table t add col2 int identity not null却可以。

3. 这似乎和SQL标准中的不太一致。

4. 分析page:801页面上的数据。发现最后添加的identity列居然是作为可变长字段进行存储的。字段col即使被定义为非空,但是物理存储上却是作为可变长存储的。因为是varchar类型。

注意: 后来我通过试验发现有一种例外情况。就是新增一个非空列的时候对这列指定默认值,就可以成功增加这列。

比如:alter table test add COLC char(1) default "0" not null

这条语句就能够成功执行!

删除表上的字段的时候报错:

1> alter table t drop col2
2> go
Msg 11052, Level 16, State 1:
Server 'SYB_NFJD_TEST', Line 1:
The 'select into' database option is not enabled for database 'testdb'. ALTER
TABLE with data copy cannot be done. Set the 'select into' database option and
re-run.
1>

报错的原因是表t所在的数据库testdb没有打开select into buklcopy选项。

打开testdb的select into/bulkcopy/pllsort 选项

1> use master
2> go
1> sp_dboption testdb,'select into',true
2> go
Database option 'select into/bulkcopy/pllsort' turned ON for database 'testdb'.
Running CHECKPOINT on database 'testdb' for option 'select
into/bulkcopy/pllsort' to take effect.
(return status = 0)

再次执行删除列的操作,可以执行成功!

1> use testdb
2> go
1> alter table t drop col2
2> go
(4 rows affected)

删除完col2之后,再次分析一下dbcc log的结果。

发现背后进行的操作有三步:

第一:删除表t在systabstats上的统计信息并重建;

第二:删除在系统表sysstatistics,sysobjects,syscolumns,sysindexes,syspartitions上对应记录的索引然后重建;

第三:更新在系统表sysstatistics,sysobjects,syscolumns,sysindexes,syspartitions上对应记录的信息。

删除表上的列的过程的日志信息,如下:

        BEGINXACT                (256038,36)    sessionid=256038,36
        attcnt=1 rno=36 op=0 padlen=2 sessionid=256038,36 len=104
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        masterxsid=(invalid sessionid)
        xstat=XBEG_ENDXACT,
        spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
        name=$ALTER TABLE ADM t ID=880003135 dbid=4 fid=1   time=Apr  7 2010
12:43:21:076PM
        BT_DELETE                (256038,37)    sessionid=256038,36
        attcnt=1 rno=37 op=72 padlen=7 sessionid=256038,36 len=88
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=23 systabstats indid=2 ptnid=23 pageno=209 level=0 root=208 cid=0
status=0x00 (0x0000)
        slot=90 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c54 new ts=0x0000 0x00001c86
        B-tree key:
10003624c20 (     0):  003473c8 3f000034 73c83f00 0000c400  .4s.?..4s.?.....
10003624c30 (    16):  00                                   .
        DOL_DELETE               (256038,38)    sessionid=256038,36
        attcnt=1 rno=38 op=66 padlen=6 sessionid=256038,36 len=224
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=23 systabstats ptnid=23 pageno=196 rowno=0 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c7d new ts=0x0000 0x00001c87
        xdol_row:
10003624c6a (     0):  00000000 00000000 3473c83f 00000000  ........4s.?....
10003624c7a (    16):  00000000 00000001 00000006 00000001  ................
10003624c8a (    32):  40100000 00000000 00000000 00000000  @...............
10003624c9a (    48):  00000000 00000000 00000000 00000000  ................
10003624caa (    64):  00000000 00000000 00000000 00000000  ................
10003624cba (    80):  00000000 00000000 40378000 00000000  ........@7......
10003624cca (    96):  00000000 00000000 00000000 00000000  ................
10003624cda (   112):  3f800000 3f800000 00000000 00000000  ?...?...........
10003624cea (   128):  00000000 00000000 00000000 00000000  ................
10003624cfa (   144):  3f800000 3f800000 3473c83f 00000000  ?...?...4s.?....
10003624d0a (   160):  00009d51 00bf1c77                    ...Q...w
        DOL_INSERT               (256038,39)    sessionid=256038,36
        attcnt=1 rno=39 op=63 padlen=6 sessionid=256038,36 len=224
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=23 systabstats ptnid=23 pageno=196 rowno=7 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c87 new ts=0x0000 0x00001c88
        xdol_row:
10003624d4a (     0):  00070004 00000000 3473c83f 00000000  ........4s.?....
10003624d5a (    16):  00000000 00000001 00000006 00000001  ................
10003624d6a (    32):  40100000 00000000 00000000 00000000  @...............
10003624d7a (    48):  00000000 00000000 00000000 00000000  ................
10003624d8a (    64):  00000000 00000000 00000000 00000000  ................
10003624d9a (    80):  00000000 00000000 40378000 00000000  ........@7......
10003624daa (    96):  00000000 00000000 00000000 00000000  ................
10003624dba (   112):  3f800000 3f800000 00000000 00000000  ?...?...........
10003624dca (   128):  00000000 00000000 00000000 00000000  ................
10003624dda (   144):  3f800000 3f800000 3473c83f 00000000  ?...?...4s.?....
10003624dea (   160):  00009d51 00d1a923                    ...Q...#
        BT_INSERT                (256038,40)    sessionid=256038,36
        attcnt=1 rno=40 op=71 padlen=7 sessionid=256038,36 len=88
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=23 systabstats indid=2 ptnid=23 pageno=209 level=0 root=208 cid=0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
        slot=90 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c86 new ts=0x0000 0x00001c89
        B-tree key:
10003624e38 (     0):  003473c8 3f000034 73c83f00 0000c420  .4s.?..4s.?....
10003624e48 (    16):  07                                   .
        OAMCREATE                (256038,41)    sessionid=256038,36
        attcnt=1 rno=41 op=41 padlen=4 sessionid=256038,36 len=128
        odc_stat=0x0040 (0x0040 (LHSX_SLRXACT))
        loh_status: 0x40 (0x00000040 (LHSX_SLRXACT))
        xpostcommit_scan_nextpg=3
Page header for page 0x10003624e64
pageno=888 nextpg=888 prevpg=888 ptnid=880003135  timestamp=0000 00001c8a
oampgcount=0 attrcount=0 indid=0 totalentries_lo=0 entrycount=0
page status bits: 0x8004 (0x8000 (PG_OAMPG), 0x0004 (PG_OAMSORT))
        old next ts=0x0000 0x00000000  new next ts=0x0000 0x00000000
        old prev ts=0x0000 0x00000000  new prev ts=0x0000 0x00000000
        oampg=0 cid=0 objid=880003135
        extent oampage=0 extptnid=880003135 pgl_status=0x808 (XPG_SET_SORT)
        OAMINSERT                (256038,42)    sessionid=256038,36
        attcnt=1 rno=42 op=39 padlen=0 sessionid=256038,36 len=72
        odc_stat=0x0140 (0x0100 (LHSR_DO_NOT_UNDO), 0x0040 (LHSX_SLRXACT))
        loh_status: 0x140 (0x00000100 (LHSR_DO_NOT_UNDO), 0x00000040 (LHSX_SLRXA
CT))
        oampg=888, allocpg=768, xinspg=888
        xobjid=880003135 , xindid=0, xptnid=880003135
        prev ts=0x0000 0x00001c8a  new ts=0x0000 0x00001c8b
        hdr prev ts=0x0000 0x00001c8a hdr new ts=0x0000 0x00001c8b
        ALLOC                    (256038,43)    sessionid=256038,36
        attcnt=1 rno=43 op=13 padlen=4 sessionid=256038,36 len=128
        odc_stat=0x0200 (0x0200 (LHSX_POSTCOMMIT_SCAN))
        loh_status: 0x200 (0x00000200 (LHSX_POSTCOMMIT_SCAN))
        xpostcommit_scan_nextpg=0
Page header for page 0x10003624f2c
pageno=889 nextpg=0 prevpg=0 ptnid=880003135  timestamp=0000 00001c8c
nextrno=0 level=0 indid=0 freeoff=32 minlen=6
page status bits: 0x1 (0x0001 (PG_DATA))
        old next ts=0x0000 0x00000000  new next ts=0x0000 0x00000000
        old prev ts=0x0000 0x00000000  new prev ts=0x0000 0x00000000
        oampg=888 cid=0 objid=880003135
        extent oampage=888 extptnid=880003135 pgl_status=0x808 (XPG_SET_SORT)
        OAMENTRYMOVE             (256039,0)     sessionid=256038,36
        attcnt=1 rno=0 op=51 padlen=0 sessionid=256038,36 len=144
        odc_stat=0x0040 (0x0040 (LHSX_SLRXACT))
        loh_status: 0x40 (0x00000040 (LHSX_SLRXACT))
        xobjid=880003135  xindid=0 xsrc_ptnid=880003135 xdst_ptnid=0
        entries_moved=0, xsrc_cacheid=0 xdst_cacheid=0
        xsrc_1st_oampgno=0 xsrc_oampgno=888
        xdst_1st_oampgno=0 xdst_oampgno=0
        xsrc_1st_oam_oldts=0x0000 0x00000000    xsrc_oam_oldts=0x0000 0x00001c8b
        xsrc_1st_oam_newts=0x0000 0x00000000    xsrc_oam_newts=0x0000 0x00001c8d
        xdst_1st_oam_oldts=0x0000 0x00000000    xdst_oam_oldts=0x0000 0x00000000
        xdst_1st_oam_newts=0x0000 0x00000000    xdst_oam_newts=0x0000 0x00000000
        oamentry: allocpg=0  used=0  unused=0
        deleted_index=0 reserved=10 xoamvstat=0x0 (0x00)
        OAMATPUT                 (256039,1)     sessionid=256038,36
        attcnt=1 rno=1 op=52 padlen=0 sessionid=256038,36 len=120
        odc_stat=0x0040 (0x0040 (LHSX_SLRXACT))
        loh_status: 0x40 (0x00000040 (LHSX_SLRXACT))
        objid=880003135  ptnid=880003135 pageno=888 offset=10 status=0x00 (0x000
0)
        cid=0 indid=0
        old ts=0x0000 0x00001c8d  new ts=0x0000 0x00001c8f
        xvallen=64
        newval:
100032660e8 (     0):  00000000 00000000 00000000 00000000  ................
100032660f8 (    16):  00000000 00000000 00000000 00000000  ................
10003266108 (    32):  00000000 00000000 00000000 00000000  ................
10003266118 (    48):  00000000 00000000 00000000 00000000  ................
10003266128 (    64):
        DROPEXTSMAP              (256039,2)     sessionid=256038,36
        attcnt=1 rno=2 op=77 padlen=4 sessionid=256038,36 len=152
        odc_stat=0x0200 (0x0200 (LHSX_POSTCOMMIT_SCAN))
        loh_status: 0x200 (0x00000200 (LHSX_POSTCOMMIT_SCAN))
        xpostcommit_scan_nextpg=256039
        objid=880003135 , indid=0 ptnid=880003135 de_status=0x00 (0x0000)
        de_allocpg=768, de_oamretainpg (saved oam pg)=0, de_retainpg (saved pg)=
0,
de_cid (cache ID)=0
        Extent map: 0x08000000
        Extents in use:
            Extid: 800
                Alloc   : 0x03 ( 800 801 )
                Dealloc : 0x00 ( )
        DOL_UPDATE               (256039,3)     sessionid=256038,36
        attcnt=1 rno=3 op=65 padlen=0 sessionid=256038,36 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=2 sysindexes ptnid=2 pageno=19 rowno=18 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c6c new ts=0x0000 0x00001c90
        xfirstoff=0, xoldvlen=0, xnewvlen=0
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image:
10003266200 (     0):
        new image:
10003266200 (     0):
        DOL_UPDATE               (256039,4)     sessionid=256038,36
        attcnt=1 rno=4 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=2 sysindexes ptnid=2 pageno=19 rowno=18 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c90 new ts=0x0000 0x00001c91
        xfirstoff=57, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 46
10003266240 (     0):  2e                                   .
        new image: 41
10003266241 (     0):  29                                   )
        DOL_UPDATE               (256039,5)     sessionid=256038,36
        attcnt=1 rno=5 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c50 new ts=0x0000 0x00001c92
        xfirstoff=35, xoldvlen=1, xnewvlen=1
        xoldstatus=0x08: (0x0008 (DOL_ROW_UPDATED))
        xnewstatus=0x08: (0x0008 (DOL_ROW_UPDATED))
        old image: 33
10003266288 (     0):  21                                   !
        new image: 121
10003266289 (     0):  79                                   y
        DOL_UPDATE               (256039,6)     sessionid=256038,36
        attcnt=1 rno=6 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c92 new ts=0x0000 0x00001c93
        xfirstoff=39, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 33
100032662d0 (     0):  21                                   !
        new image: 121
100032662d1 (     0):  79                                   y
        DOL_UPDATE               (256039,7)     sessionid=256038,36
        attcnt=1 rno=7 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c93 new ts=0x0000 0x00001c94
        xfirstoff=27, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 32
10003266318 (     0):  20
        new image: 120
10003266319 (     0):  78                                   x
        DOL_UPDATE               (256039,8)     sessionid=256038,36
        attcnt=1 rno=8 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c94 new ts=0x0000 0x00001c95
        xfirstoff=23, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 0
10003266360 (     0):  00                                   .
        new image: 2
10003266361 (     0):  02                                   .
        DOL_UPDATE               (256039,9)     sessionid=256038,36
        attcnt=1 rno=9 op=65 padlen=2 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=2 sysindexes ptnid=2 pageno=19 rowno=18 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c91 new ts=0x0000 0x00001c96
        xfirstoff=80, xoldvlen=3, xnewvlen=3
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image:
100032663a8 (     0):  beb176                               ..v
        new image:
100032663ab (     0):  d1a923                               ..#
        BT_DELETE                (256039,10)    sessionid=256038,36
        attcnt=1 rno=10 op=72 padlen=1 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x00
(0x0000)
        slot=14 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c6b new ts=0x0000 0x00001c97
        B-tree key:
100032663f0 (     0):  003473c8 3f000000 01000000 2e0035    .4s.?.........5
        DOL_DELETE               (256039,11)    sessionid=256038,36
        attcnt=1 rno=11 op=66 padlen=4 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=3 syscolumns ptnid=3 pageno=46 rowno=53 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c6a new ts=0x0000 0x00001c98
        xdol_row:
10003266432 (     0):  00350000 00010000 3473c83f 00010038  .5......4s.?...8
10003266442 (    16):  00000004 00020000 00000007 00000000  ................
10003266452 (    32):  00000000 002a6964 0026               .....*id.&
        BT_DELETE                (256039,12)    sessionid=256038,36
        attcnt=1 rno=12 op=72 padlen=1 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x00
(0x0000)
        slot=15 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c97 new ts=0x0000 0x00001c99
        B-tree key:
100032664a0 (     0):  003473c8 3f000000 02000000 2e0036    .4s.?.........6
        DOL_DELETE               (256039,13)    sessionid=256038,36
        attcnt=1 rno=13 op=66 padlen=2 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=3 syscolumns ptnid=3 pageno=46 rowno=54 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c98 new ts=0x0000 0x00001c9a
        xdol_row:
100032664e2 (     0):  00360000 00010000 3473c83f 00020027  .6......4s.?...'
100032664f2 (    16):  0000001e ffff0000 00000002 00000000  ................
10003266502 (    32):  00000000 002c6e61 6d650026           .....,name.&
        BT_DELETE                (256039,14)    sessionid=256038,36
        attcnt=1 rno=14 op=72 padlen=1 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x00
(0x0000)
        slot=16 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c99 new ts=0x0000 0x00001c9b
        B-tree key:
10003266550 (     0):  003473c8 3f000000 03000000 2e0037    .4s.?.........7
        DOL_DELETE               (256039,15)    sessionid=256038,36
        attcnt=1 rno=15 op=66 padlen=2 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=3 syscolumns ptnid=3 pageno=46 rowno=55 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c9a new ts=0x0000 0x00001c9c
        xdol_row:
10003266592 (     0):  00370000 00010000 3473c83f 00038026  .7......4s.?...&
100032665a2 (    16):  00000004 fffe0000 00000007 00000000  ................
100032665b2 (    32):  00000000 002c636f 6c320026           .....,col2.&
        DOL_INSERT               (256039,16)    sessionid=256038,36
        attcnt=1 rno=16 op=63 padlen=4 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=3 syscolumns ptnid=3 pageno=46 rowno=78 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c9c new ts=0x0000 0x00001c9d
        xdol_row:
100032665f2 (     0):  004e0004 00010000 3473c83f 00010038  .N......4s.?...8
10003266602 (    16):  00000004 00020000 00000007 00000000  ................
10003266612 (    32):  00000000 002a6964 0026               .....*id.&
        BT_INSERT                (256039,17)    sessionid=256038,36
        attcnt=1 rno=17 op=71 padlen=1 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x220
(0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020 (XSTAT_BT_CHANGE_REPLACERID))
        slot=14 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c9b new ts=0x0000 0x00001c9e
        B-tree key:
10003266660 (     0):  003473c8 3f000000 01000000 2e204e    .4s.?........ N
        DOL_INSERT               (256039,18)    sessionid=256038,36
        attcnt=1 rno=18 op=63 padlen=2 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=3 syscolumns ptnid=3 pageno=46 rowno=79 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c9d new ts=0x0000 0x00001c9f
        xdol_row:
100032666a2 (     0):  004f0004 00010000 3473c83f 00020027  .O......4s.?...'
100032666b2 (    16):  0000001e ffff0000 00000002 00000000  ................
100032666c2 (    32):  00000000 002c6e61 6d650026           .....,name.&
        BT_INSERT                (256039,19)    sessionid=256038,36
        attcnt=1 rno=19 op=71 padlen=1 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x220
(0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020 (XSTAT_BT_CHANGE_REPLACERID))
        slot=15 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c9e new ts=0x0000 0x00001ca0
        B-tree key:
10003266710 (     0):  003473c8 3f000000 02000000 2e204f    .4s.?........ O
        DOL_UPDATE               (256039,20)    sessionid=256038,36
        attcnt=1 rno=20 op=65 padlen=0 sessionid=256038,36 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c95 new ts=0x0000 0x00001ca1
        xfirstoff=0, xoldvlen=0, xnewvlen=0
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image:
10003266760 (     0):
        new image:
10003266760 (     0):
        DOL_UPDATE               (256039,21)    sessionid=256038,36
        attcnt=1 rno=21 op=65 padlen=0 sessionid=256038,36 len=64
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001c77 new ts=0x0000 0x00001ca2
        xfirstoff=0, xoldvlen=0, xnewvlen=0
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image:
100032667a0 (     0):
        new image:
100032667a0 (     0):
        DOL_UPDATE               (256039,22)    sessionid=256038,36
        attcnt=1 rno=22 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001ca2 new ts=0x0000 0x00001ca3
        xfirstoff=23, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 64
100032667e0 (     0):  40                                   @
        new image: 0
100032667e1 (     0):  00                                   .
        DOL_UPDATE               (256039,23)    sessionid=256038,36
        attcnt=1 rno=23 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001ca3 new ts=0x0000 0x00001ca4
        xfirstoff=25, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 0
10003266828 (     0):  00                                   .
        new image: 1
10003266829 (     0):  01                                   .
        DOL_UPDATE               (256039,24)    sessionid=256038,36
        attcnt=1 rno=24 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001ca4 new ts=0x0000 0x00001ca5
        xfirstoff=17, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 0
10003266870 (     0):  00                                   .
        new image: 1
10003266871 (     0):  01                                   .
        DOL_UPDATE               (256039,25)    sessionid=256038,36
        attcnt=1 rno=25 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
        status (xstat)=0x00 (0x0000)
        status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
        old ts=0x0000 0x00001ca5 new ts=0x0000 0x00001ca6
        xfirstoff=19, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 1
100032668b8 (     0):  01                                   .
        new image: 2
100032668b9 (     0):  02                                   .
        DOL_UPDATE               (256039,26)    sessionid=256038,36
        attcnt=1 rno=26 op=65 padlen=6 sessionid=256038,36 len=224
        odc_stat=0x0100 (0x0100 (LHSR_DO_NOT_UNDO))
        loh_status: 0x100 (0x00000100 (LHSR_DO_NOT_UNDO))
        objectid=23 systabstats ptnid=23 pageno=196 rowno=7 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        status2 (xstat2)=0x10 (0x0010 (XSTAT2_DOLUPD_ROW_IMAGE))
        old ts=0x0000 0x00001c88 new ts=0x0000 0x00001ca7
        Redo-only log record
100032668f4 (     0):  00040000 00003473 c83f0000 00000000  ......4s.?......
10003266904 (    16):  00000000 00010000 00060000 00014010  ..............@.
10003266914 (    32):  00000000 00000000 00000000 00000000  ................
10003266924 (    48):  00000000 00000000 00000000 00000000  ................
10003266934 (    64):  00000000 00000000 00000000 00000000  ................
10003266944 (    80):  00020000 00004037 80000000 00000000  ......@7........
10003266954 (    96):  00000000 00000000 00000000 00003f80  ..............?.
10003266964 (   112):  00003f80 00000000 00000000 00000000  ..?.............
10003266974 (   128):  00000000 00000000 00000000 00003f80  ..............?.
10003266984 (   144):  00003f80 00003473 c83f0000 00000000  ..?...4s.?......
10003266994 (   160):  9d5100d1 a923                        .Q...#
        BT_DELETE                (256039,27)    sessionid=256038,36
        attcnt=1 rno=27 op=72 padlen=7 sessionid=256038,36 len=88
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=23 systabstats indid=2 ptnid=23 pageno=209 level=0 root=208 cid=0
status=0x00 (0x0000)
        slot=90 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c89 new ts=0x0000 0x00001ca8
        B-tree key:
100032669e0 (     0):  003473c8 3f000034 73c83f00 0000c420  .4s.?..4s.?....
100032669f0 (    16):  07                                   .
        DOL_UPDATE               (256039,28)    sessionid=256038,36
        attcnt=1 rno=28 op=65 padlen=4 sessionid=256038,36 len=256
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=23 systabstats ptnid=23 pageno=196 rowno=7 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        status2 (xstat2)=0x00 (0x0000)
        old ts=0x0000 0x00001ca7 new ts=0x0000 0x00001ca9
        xfirstoff=56, xoldvlen=94, xnewvlen=94
        xoldstatus=0x04: (0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image:
10003266a38 (     0):  00000000 00000000 00000000 00000000  ................
10003266a48 (    16):  00000000 00000000 00000002 00000000  ................
10003266a58 (    32):  40378000 00000000 00000000 00000000  @7..............
10003266a68 (    48):  00000000 00000000 3f800000 3f800000  ........?...?...
10003266a78 (    64):  00000000 00000000 00000000 00000000  ................
10003266a88 (    80):  00000000 00000000 3f800000 3f80      ........?...?.
        new image:
10003266a96 (     0):  3ff00000 00000000 00000000 00000000  ?...............
10003266aa6 (    16):  00000000 00000000 00000002 00000000  ................
10003266ab6 (    32):  40378000 00000000 00000000 00000000  @7..............
10003266ac6 (    48):  00000000 00000000 00000000 00000000  ................
10003266ad6 (    64):  00000000 00000000 00000000 00000000  ................
10003266ae6 (    80):  00000000 00000000 00000000 0000      ..............
        BT_INSERT                (256039,29)    sessionid=256038,36
        attcnt=1 rno=29 op=71 padlen=7 sessionid=256038,36 len=88
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=23 systabstats indid=2 ptnid=23 pageno=209 level=0 root=208 cid=0
status=0x20 (0x0020 (XSTAT_BT_CHANGE_REPLACERID))
        slot=90 ridposn=0 oldposn=0
        old ts=0x0000 0x00001ca8 new ts=0x0000 0x00001caa
        B-tree key:
10003266b38 (     0):  003473c8 3f000034 73c83f00 0000c420  .4s.?..4s.?....
10003266b48 (    16):  07                                   .
        BT_DELETE                (256039,30)    sessionid=256038,36
        attcnt=1 rno=30 op=72 padlen=3 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=2 sysindexes indid=2 ptnid=2 pageno=34 level=0 root=33 cid=0 statu
s=0x00
(0x0000)
        slot=93 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c49 new ts=0x0000 0x00001cab
        B-tree key:
10003266b90 (     0):  003473c8 3f000000 00001300 12        .4s.?........
        DOL_DELETE               (256039,31)    sessionid=256038,36
        attcnt=1 rno=31 op=66 padlen=5 sessionid=256038,36 len=168
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=2 sysindexes ptnid=2 pageno=19 rowno=18 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c96 new ts=0x0000 0x00001cac
        xdol_row:
10003266bd2 (     0):  0012000c 000c0000 3473c83f 00000000  ........4s.?....
10003266be2 (    16):  00000000 00000000 00000000 00000000  ................
10003266bf2 (    32):  00000000 00000000 00000000 32010000  ............2...
10003266c02 (    48):  00010000 00000006 00290000 00000071  .........).....q
10003266c12 (    64):  74000000 00000000 00000000 009d5100  t.............Q.
10003266c22 (    80):  d1a92300 03000000 00005500 53004b00  ..#.......U.S.K.
10003266c32 (    96):  47204700 45004300 41204100 40204020  G G.E.C.A A.@ @
10003266c42 (   112):  40                                   @
        DOL_INSERT               (256039,32)    sessionid=256038,36
        attcnt=1 rno=32 op=63 padlen=1 sessionid=256038,36 len=160
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=2 sysindexes ptnid=2 pageno=19 rowno=25 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001cac new ts=0x0000 0x00001cad
        xdol_row:
10003266c7a (     0):  00190004 000c0000 3473c83f 00000000  ........4s.?....
10003266c8a (    16):  00000000 00000000 00000000 00000000  ................
10003266c9a (    32):  00000000 00000000 00000000 32010000  ............2...
10003266caa (    48):  00010000 00000006 00290000 0000006d  .........).....m
10003266cba (    64):  74000000 00000000 009d5100 d1a92300  t.........Q...#.
10003266cca (    80):  03000000 00005100 4f004720 47204700  ......Q.O.G G G.
10003266cda (    96):  45004300 41204100 40204020 40        E.C.A A.@ @ @
        BT_INSERT                (256039,33)    sessionid=256038,36
        attcnt=1 rno=33 op=71 padlen=3 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=2 sysindexes indid=2 ptnid=2 pageno=34 level=0 root=33 cid=0 statu
s=0x220
(0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020 (XSTAT_BT_CHANGE_REPLACERID))
        slot=93 ridposn=0 oldposn=0
        old ts=0x0000 0x00001cab new ts=0x0000 0x00001cae
        B-tree key:
10003266d28 (     0):  003473c8 3f000000 00001320 19        .4s.?...... .
        BT_DELETE                (256039,34)    sessionid=256038,36
        attcnt=1 rno=34 op=72 padlen=7 sessionid=256038,36 len=88
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=28 syspartitions indid=2 ptnid=28 pageno=90 level=0 root=89 cid=0
status=0x00 (0x0000)
        slot=93 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c45 new ts=0x0000 0x00001caf
        B-tree key:
10003266d78 (     0):  003473c8 3f000034 73c83f00 00005200  .4s.?..4s.?...R.
10003266d88 (    16):  10                                   .
        BT_DELETE                (256039,35)    sessionid=256038,36
        attcnt=1 rno=35 op=72 padlen=3 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=28 syspartitions indid=3 ptnid=28 pageno=113 level=0 root=112 cid=
0
status=0x00 (0x0000)
        slot=93 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c46 new ts=0x0000 0x00001cb0
        B-tree key:
10003266dd0 (     0):  003473c8 3f000000 00005220 10        .4s.?.....R .
        BT_DELETE                (256039,36)    sessionid=256038,36
        attcnt=1 rno=36 op=72 padlen=7 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=28 syspartitions indid=4 ptnid=28 pageno=129 level=0 root=128 cid=
0
status=0x00 (0x0000)
        slot=93 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c47 new ts=0x0000 0x00001cb1
        B-tree key:
10003266e20 (     0):  013473c8 3f000000 00005220 100b745f  .4s.?.....R ..t_
10003266e30 (    16):  38383030 30333133 35                 880003135
        DOL_DELETE               (256039,37)    sessionid=256038,36
        attcnt=1 rno=37 op=66 padlen=1 sessionid=256038,36 len=120
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001ca1 new ts=0x0000 0x00001cb2
        xdol_row:
10003266e72 (     0):  0010000c 00010000 3473c83f 3473c83f  ........4s.?4s.?
10003266e82 (    16):  00010000 00000002 00000378 00000000  ...........x....
10003266e92 (    32):  00000379 00000379 00000000 00009d51  ...y...y.......Q
10003266ea2 (    48):  00beb176 00000045 745f3838 30303033  ...v...Et_880003
10003266eb2 (    64):  31333500 38                          135.8
        DOL_INSERT               (256039,38)    sessionid=256038,36
        attcnt=1 rno=38 op=63 padlen=1 sessionid=256038,36 len=120
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=28 syspartitions ptnid=28 pageno=82 rowno=23 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001cb2 new ts=0x0000 0x00001cb3
        xdol_row:
10003266eea (     0):  00170004 00010000 3473c83f 3473c83f  ........4s.?4s.?
10003266efa (    16):  00010000 00000002 00000378 00000000  ...........x....
10003266f0a (    32):  00000379 00000379 00000000 00009d51  ...y...y.......Q
10003266f1a (    48):  00d1a923 00000045 745f3838 30303033  ...#...Et_880003
10003266f2a (    64):  31333500 38                          135.8
        BT_INSERT                (256039,39)    sessionid=256038,36
        attcnt=1 rno=39 op=71 padlen=7 sessionid=256038,36 len=88
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=28 syspartitions indid=2 ptnid=28 pageno=90 level=0 root=89 cid=0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
        slot=93 ridposn=0 oldposn=0
        old ts=0x0000 0x00001caf new ts=0x0000 0x00001cb4
        B-tree key:
10003266f70 (     0):  003473c8 3f000034 73c83f00 00005220  .4s.?..4s.?...R
10003266f80 (    16):  17                                   .
        BT_INSERT                (256040,0)     sessionid=256038,36
        attcnt=1 rno=0 op=71 padlen=3 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=28 syspartitions indid=3 ptnid=28 pageno=113 level=0 root=112 cid=
0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
        slot=93 ridposn=0 oldposn=0
        old ts=0x0000 0x00001cb0 new ts=0x0000 0x00001cb5
        B-tree key:
1000325c060 (     0):  003473c8 3f000000 00005220 17        .4s.?.....R .
        BT_INSERT                (256040,1)     sessionid=256038,36
        attcnt=1 rno=1 op=71 padlen=7 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=28 syspartitions indid=4 ptnid=28 pageno=129 level=0 root=128 cid=
0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
        slot=93 ridposn=0 oldposn=0
        old ts=0x0000 0x00001cb1 new ts=0x0000 0x00001cb6
        B-tree key:
1000325c0b0 (     0):  013473c8 3f000000 00005220 170b745f  .4s.?.....R ..t_
1000325c0c0 (    16):  38383030 30333133 35                 880003135
        BT_DELETE                (256040,2)     sessionid=256038,36
        attcnt=1 rno=2 op=72 padlen=7 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=24 sysstatistics indid=2 ptnid=24 pageno=625 level=0 root=624 cid=
0
status=0x00 (0x0000)
        slot=8 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c84 new ts=0x0000 0x00001cb7
        B-tree key:
1000325c110 (     0):  013473c8 3f000034 73c83f00 006c0000  .4s.?..4s.?..l..
1000325c120 (    16):  00010000 01f10001 ff                 .........
        DOL_DELETE               (256040,3)     sessionid=256038,36
        attcnt=1 rno=3 op=66 padlen=4 sessionid=256038,36 len=160
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=24 sysstatistics ptnid=24 pageno=497 rowno=1 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001c83 new ts=0x0000 0x00001cb8
        xdol_row:
1000325c162 (     0):  00010000 00070000 00000000 3473c83f  ............4s.?
1000325c172 (    16):  3473c83f 00000000 00000000 00000001  4s.?............
1000325c182 (    32):  00009d51 00d1a923 6c06006a 00000000  ...Q...#l..j....
1000325c192 (    48):  00000000 00000000 00000000 40080000  ............@...
1000325c1a2 (    64):  00000000 40000000 00000000 40000000  ....@.......@...
1000325c1b2 (    80):  00000000 00000000 00000000 0054004c  .............T.L
1000325c1c2 (    96):  0044003c 0034002c 202c               .D.<.4., ,
        DOL_INSERT               (256040,4)     sessionid=256038,36
        attcnt=1 rno=4 op=63 padlen=6 sessionid=256038,36 len=152
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=24 sysstatistics ptnid=24 pageno=497 rowno=6 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        old ts=0x0000 0x00001cb8 new ts=0x0000 0x00001cb9
        xdol_row:
1000325c202 (     0):  00060004 00060000 00000000 3473c83f  ............4s.?
1000325c212 (    16):  3473c83f 00000000 00000000 00000001  4s.?............
1000325c222 (    32):  00009d51 00d1a923 6c050060 00000000  ...Q...#l..`....
1000325c232 (    48):  00000000 00000000 00000000 40000000  ............@...
1000325c242 (    64):  00000000 40000000 00000000 40000000  ....@.......@...
1000325c252 (    80):  00000000 004c0044 003c0034 002c202c  .....L.D.<.4., ,
1000325c262 (    96):
        BT_INSERT                (256040,5)     sessionid=256038,36
        attcnt=1 rno=5 op=71 padlen=7 sessionid=256038,36 len=96
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=24 sysstatistics indid=2 ptnid=24 pageno=625 level=0 root=624 cid=
0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
        slot=8 ridposn=0 oldposn=0
        old ts=0x0000 0x00001cb7 new ts=0x0000 0x00001cba
        B-tree key:
1000325c2a8 (     0):  013473c8 3f000034 73c83f00 006c0000  .4s.?..4s.?..l..
1000325c2b8 (    16):  00010000 01f12006 ff                 ...... ..
        BT_DELETE                (256040,6)     sessionid=256038,36
        attcnt=1 rno=6 op=72 padlen=3 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=1 sysobjects indid=2 ptnid=1 pageno=161 level=0 root=160 cid=0
status=0x00 (0x0000)
        slot=35 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c68 new ts=0x0000 0x00001cbb
        B-tree key:
1000325c308 (     0):  01000000 01000000 01201e01 74        ......... ..t
        BT_DELETE                (256040,7)     sessionid=256038,36
        attcnt=1 rno=7 op=72 padlen=5 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=1 sysobjects indid=3 ptnid=1 pageno=10 level=0 root=9 cid=0 status
=0x00
(0x0000)
        slot=48 ridposn=0 oldposn=0
        old ts=0x0000 0x00001c69 new ts=0x0000 0x00001cbd
        B-tree key:
1000325c358 (     0):  003473c8 3f000000 01001e             .4s.?......
        DOL_UPDATE               (256040,8)     sessionid=256038,36
        attcnt=1 rno=8 op=65 padlen=6 sessionid=256038,36 len=72
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
        status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
        status2 (xstat2)=0x00 (0x0000)
        old ts=0x0000 0x00001ca6 new ts=0x0000 0x00001cbe
        xfirstoff=82, xoldvlen=1, xnewvlen=1
        xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
        old image: 4
1000325c3a8 (     0):  04                                   .
        new image: 0
1000325c3a9 (     0):  00                                   .
        BT_INSERT                (256040,9)     sessionid=256038,36
        attcnt=1 rno=9 op=71 padlen=3 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=1 sysobjects indid=2 ptnid=1 pageno=161 level=0 root=160 cid=0
status=0x20 (0x0020 (XSTAT_BT_CHANGE_REPLACERID))
        slot=35 ridposn=0 oldposn=0
        old ts=0x0000 0x00001cbb new ts=0x0000 0x00001cbf
        B-tree key:
1000325c3f0 (     0):  01000000 01000000 01201e01 74        ......... ..t
        BT_INSERT                (256040,10)    sessionid=256038,36
        attcnt=1 rno=10 op=71 padlen=5 sessionid=256038,36 len=80
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        objid=1 sysobjects indid=3 ptnid=1 pageno=10 level=0 root=9 cid=0 status
=0x20
(0x0020 (XSTAT_BT_CHANGE_REPLACERID))
        slot=48 ridposn=0 oldposn=0
        old ts=0x0000 0x00001cbd new ts=0x0000 0x00001cc0
        B-tree key:
1000325c440 (     0):  003473c8 3f000000 01201e             .4s.?.... .
        ENDXACT                  (256040,11)    sessionid=256038,36
        attcnt=1 rno=11 op=30 padlen=4 sessionid=256038,36 len=32
        odc_stat=0x0000 (0x0000)
        loh_status: 0x0 (0x00000000)
        endstat=COMMIT time=Apr  7 2010 12:43:21:076PM
        xstat=0x0 []
Total number of log records 301
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
 

有兴趣的可以自己分析一下。

自己先补充一下。

如果数据库没有打开select into选项的时候,drop column都会报错误:

Msg 11052, Level 16, State 1: Server 'TEST', Line 1: The 'select into' database option is not enabled for database 'escourt5'. ALTER TABLE with data copy cannot be done. Set the 'select into' database option and re-run 。

注意:不能添加非空列(除了第一个identity列)。 添加一列的时候,指定为非空并且有默认值的话,也报错:

1> alter table test add COLE char(1) default "0"

2> go

Msg 11052, Level 16, State 1: Server 'TEST', Line 1: The 'select into' database option is not enabled for database 'escourt5'. ALTER TABLE with data copy cannot be done. Set the 'select into' database option and re-run.

有空总结一下。 为什么会进行data copy。

————————————————————————————————-
—- 本文为andkylee个人原创,请在尊重作者劳动成果的前提下进行转载;
—- 转载务必注明原始出处 : http://www.dbainfo.net
—- 关键字: 字段 增加 删除 日志 内部 internals
————————————————————————————————-

  • 本文链接地址:http://www.dbainfo.net/sybase-table-add-drop-column-physical-storage-processing.htm
  • 本文为dbainfo个人原创,请在尊重作者劳动成果的前提下进行转载;
  • 转载务必注明原始出处 : Sybase数据库技术,数据库恢复专家
  • 对《sybase中给表增加和删除字段时内部处理过程分析》有何疑问或见解,请在本文下方发表;
  • 对网站还有其他问题或建议,请提交在留言板,谢谢!
  • 目前还没有任何评论.
    :wink: :twisted: :roll: :oops: :mrgreen: :lol: :idea: :evil: :cry: :arrow: :?: :-| :-x :-o :-P :-D :-? :) :( :!: 8-O 8)