Chinaunix首页 | 论坛 | 博客
  • 博客访问: 103126462
  • 博文数量: 19283
  • 博客积分: 9968
  • 博客等级: 上将
  • 技术积分: 196062
  • 用 户 组: 普通用户
  • 注册时间: 2007-02-07 14:28
文章分类

全部博文(19283)

文章存档

2011年(1)

2009年(125)

2008年(19094)

2007年(63)

分类:

2008-05-08 08:13:29

    来源:赛迪网    作者:Alizze

现在我们来看看EOS.RPT

_____________ DART _______

D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o o l

IBM DB2 6000

_________________________________________________

DART (V8.1.0) Report:

2007-11-24-20.59.51.355893

Database Name: EOS

Report name: EOS.RPT

Old report back-up: EOS.BAK

Database Subdirectory: /opt/db2/db2inst1/NODE0000/SQL00001

Operational Mode: Database Inspection Only (INSPECT)

_____________________________________________

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

Action option: DD

Table-object-ID: 1560; Tablespace-ID: 2; First-page: 157312p; Number-pages: 1; Verbose: y

Warning: The database state is not consistent.

Warning: Reorg rows MAY be due to the inconsistent state of the database.

Connecting to Buffer Pool Services...

Table object report phase start.

Dump format is verbose.

_____________________________________

Page 0 of object 1560 from table space 2.

BPS Page Header:

Page Data Offset = 48

Page Data Length = 4048

Page LSN = 0000 AE97 AE41

Object Page Number = 0

Pool Page Number = 157312

Object ID = 1560

Object Type = Data Object

Data Page Header:

Slot Count = 8

Total Free Space = 2784

Total Reserve Space = 0

Youngest Reserve Space = n/a

Youngest TID = n/a

Free Space Offset = 2799

Maximum Record Size = 23

Data Records:

Slot 0:

Offset Location = 3996 (xF9C)

Record Length = 32 (x20)

Record Type = Data Object Header Control Record

Page count = 1

Object Creation LSN = 0000 AE97 800C

Object State = x0000

UDI Since Runstats = 0

DART Field = x00000000

Slot 1:

Offset Location = 2992 (xBB0)

Record Length = 1004 (x3EC)

Record Type = Free Space Control Record

Free space entries:

0: 2884 (x0B44), 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC)

4: 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC)

8: 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC)

省略...

492: 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC)

496: 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC), 4028 (x0FBC)

Slot 2:

Offset Location = 2916 (xB64)

Record Length = 76 (x4C)

Record Type = Table Directory Record

MetaIndex Root Page = 157377

Index Type = 2

Table Descriptor Pointer -- Page 157312 Slot 3

Max Insert Search = 0

Flags = x02000200

bit representation = 00000010 00000000 00000010 00000000

Check pending info:

Constraint status = x00

Constraint RID = Page 0 Slot 0

last BID = x00000000

Slot 3:

Offset Location = 2892 (xB4C)

Record Length = 24 (x18)

Record Type = Table Description Record

Number of Columns = 2

Column 1:

Type is Long Integer

Length = 4

Prohibits NULLs

Prohibits Default

Fixed offset: 0

Column 2:

Type is Fixed Length Character String

Length = 10

Allows NULLs

Prohibits Default

Fixed offset: 4

Slot 4:

Offset Location = 2869 (xB35)

Record Length = 23 (x17)

Record Type = Table Data Record (FIXEDVAR)

Fixed part length value = 15

Column 1:

Fixed offset: 0

Type is Long Integer

Value = 1

Column 2:

Fixed offset: 4

Type is Fixed Length Character String

61202020 20202020 2020 a

Slot 5:

Offset Location = 2846 (xB1E)

Record Length = 23 (x17)

Record Type = Table Data Record (FIXEDVAR)

Fixed part length value = 15

Column 1:

Fixed offset: 0

Type is Long Integer

Value = 2

Column 2:

Fixed offset: 4

Type is Fixed Length Character String

61202020 20202020 2020 a

Slot 6:

Offset Location = 2823 (xB07)

Record Length = 23 (x17)

Record Type = Table Data Record (FIXEDVAR)

Fixed part length value = 15

Column 1:

Fixed offset: 0

Type is Long Integer

Value = 3

Column 2:

Fixed offset: 4

Type is Fixed Length Character String

61202020 20202020 2020 a

Slot 7:

Offset Location = 2800 (xAF0)

Record Length = 23 (x17)

Record Type = Table Data Record (FIXEDVAR)

Fixed part length value = 15

Column 1:

Fixed offset: 0

Type is Long Integer

Value = 4

Column 2:

Fixed offset: 4

Type is Fixed Length Character String

61202020 20202020 2020 a

Slots Summary: Total=8, In-use=8, Deleted=0.

Table object report phase end.

______________________________________

DB2DART Processing completed with warning(s)!

Warning(s) detected during processing.

______________________________________

Complete DB2DART report found in:

/home/db2inst1/sqllib/db2dump/DART0000/EOS.RPT

__ D A R T P R O C E S S I N G C O M P L E T E____

最后找到Solt 7 (0x07),至此,我们就可以清楚地知道应用等待的Row为(4,a)

阅读(882) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~