Another day, another DB2 quiz. Below is the partial output produced by a DB2 tool. Which tool is it? It is part of every DB2 LUW installation.
COLUMN NAME : ID
Length of column name : 2
Column id : 0
Col type {hex, type} : 0x0001 , INTEGER
Col dist. type {hex, type}: 0x0018 , INTEGER
Column length : 4
Blob length : 4
Statistic offset : 480
Column String Units : N
Flags : 0x20000090
- SQLRG_MIXED
- SQLRG_NULLIND
Flags2 : 0x00000000
Codepage : 0
Collation name : NOT_APPLICABLE
Collation ID in hex : B'FF FF FF FF FF FF FF FF
Length of user default : 0
Logged : 0
Compact : 0
Inline Length : 0
Datalink Features : 000000
Ref. row type desc. offset: 0
No. unique values in col. : 2
Average column length : 5
Expected Change Rate : 0.000781
Percentage Encoded : -1
Page Variance Ratio : -1
Source column ID : 0
High2key and Low2key len. : 8
Avg column length in chars: -1
Delimiter length : -1
Number of Subelements : -1
Number of nulls : 0
High2key : 2
Low2key : 1
Statistic Descriptor :
colid : 0
fd offset : 16
hd offset : 64
nmostfreq : 2
mtiles : 4
Histogram Descriptor : Count Distcount Value_len Value
---------------------------------------------
0 0 4 1
1280 0 4 1
1280 0 4 2
2560 0 4 2
Frequency Descriptor : Count Value_len Value
---------------------------------
1280 4 1
1280 4 2
Security Label ID : 0
COLUMN NAME : S
Length of column name : 1
Column id : 1
Col type {hex, type} : 0x0101 , VARCHAR
Col dist. type {hex, type}: 0x0038 , VARCHAR
Column length : 2000
Blob length : 2000
Statistic offset : 504
Column String Units : S
Flags : 0x20000090
- SQLRG_MIXED
- SQLRG_NULLIND
Flags2 : 0x00000000
Codepage : 1208
Collation name : IDENTITY
Collation ID in hex : B'00 00 00 02 FF 00 FF FF
Length of user default : 0
Logged : 0
Compact : 0
Inline Length : 0
Datalink Features : 000000
Ref. row type desc. offset: 0
No. unique values in col. : 2
Average column length : 86
Expected Change Rate : 0.000781
Percentage Encoded : -1
Page Variance Ratio : -1
Source column ID : 0
High2key and Low2key len. : 66
Avg column length in chars: 81
Delimiter length : -1
Number of Subelements : -1
Number of nulls : 0
High2key : {'This is a long teeeeeeeeeeeeeeee}
High2key in Hex Format : 27546869732069732061206c6f6e67207465656565656565656565656565656565
Low2key : {'Another }
Low2key in Hex Format : 27416e6f7468657220202020202020202020202020202020202020202020202020
Statistic Descriptor :
colid : 1
fd offset : 16
hd offset : 96
nmostfreq : 2
mtiles : 4
Histogram Descriptor : Count Distcount Value_len Value Hex(value)
---------------------------------------------
0 0 8 {'Another} 27416e6f74686572
1280 0 8 {'Another} 27416e6f74686572
1280 0 33 {'This is a long teeeeeeeeeeeeeeee} 27546869732069732061206c6f6e67207465656565656565656565656565656565
2560 0 33 {'This is a long teeeeeeeeeeeeeeee} 27546869732069732061206c6f6e67207465656565656565656565656565656565
Frequency Descriptor : Count Value_len Value Hex(value)
---------------------------------
1280 8 {'Another} 27416e6f74686572
1280 33 {'This is a long teeeeeeeeeeeeeeee} 27546869732069732061206c6f6e67207465656565656565656565656565656565
Security Label ID : 0