Delayed Block Cleanout is not happening

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 30 Aug 2000 03:07:32 -0700 (PDT)
Message-Id: <10604.115829@fatcity.com>

Hi All...

I have created a table and inserted one row. Now I have dumped the datablock and here is the ITL Entry

 Itl           Xid                  Uba         Flag 
Lck        Scn/Fsc

0x01 0x0002.012.00000012 0x00c00b8f.0037.01 ----  1 fsc 0x0000.00000000

Now I have updated a row in that table..(but didn't commmit..) Here is that ITL entry

 Itl           Xid                  Uba         Flag 
Lck        Scn/Fsc

0x01 0x0002.012.00000012 0x00c00b8f.0037.01 --U-  1 fsc 0x0000.00009131

Here the flag is --U- As expected...And i did a commit.
And the ITL falg has not changed..

I forced a block cleanout by doing a full table scan of that table. But still the ITL flag is --U-

My question is WHEN EXACTLY the block clean out is done and how do i trace that?

The version is 8.0.3 and NT 4.0 (SP5) If that matters.

---

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! Received on Wed Aug 30 2000 - 05:07:32 CDT