Fw: change in pagesize calculation by oncheck - an
Hi all,
This is a changed o/p issue I am facing in oncheck -pS, oncheck
-cS & oncheck -pe commands for blob spaces.
I am adding a smart large object sblobsp and inserting 1 file st-louis.jpg
which is of size 103670 bytes.
IDS version : 10.00.UC4
The o/p's(partial) of oncheck -cS oncheck-pS & oncheck -pe are as
follows(This o/p is for 2k platforms)
oncheck -cS
Large Objects
ID Ref Size Allocced Creat Last
Sbs# Chk# Seq# Cnt (Bytes) Pages Extns Flags Modified
---- ---- ----- ---- ---------- -------- ----- -----
------------------------
2 2 1 1 486 1 1 N-N-H Mon Feb 13 04:17:32
2006
2 2 2 1 103670 54 1 N-N-H Mon Feb 13 04:17:32
2006
oncheck-pS
Space Chunk Page = [2,2,2] Object ID = 1139825832
LO SW Version 4
LO Object Version 1
Created by Txid 13
Flags 0x32 LO_NOLOG
LO_NOKEEP_LASTACCESS_TIME LO_HIGH_INTEG
Data Type 0
Extent Size -1
IO Size 0
Created Mon Feb 13 04:17:32 2006
Last Time Modified Mon Feb 13 04:17:32 2006
Last Time Accessed Mon Feb 13 04:17:32 2006
Last Time Attributes Modified Mon Feb 13 04:17:32 2006
Ref Count 1
Create Flags 0x32 LO_NOLOG
LO_NOKEEP_LASTACCESS_TIME LO_HIGH_INTEG
Status Flags 0x400 LO_FROM_SERVER
Size (Bytes) 103670
Size Limit -1
Total Estimated Size -1
Deleting TxId -1
LO Map Size 200
LO Map Last Row -1
LO Map Extents 2
LO Map User Pages 54
oncheck-pe
Description Offset(p)
Size(p)
------------------------------------------------------------- --------
--------
RESERVED PAGES 0
2
CHUNK FREELIST PAGE 2
1
sblobsp:'informix'.TBLSpace 3
50
SBLOBSpace LO [2,2,1] 53
1
SBLOBSpace LO [2,2,2] 54
54
SBLOBSpace FREE USER DATA (AREA 1) 108
59338
SBLOBSpace RESERVED USER DATA (AREA 1) 59446
49988
sblobsp:'informix'.sbspace_desc 109434
4
sblobsp:'informix'.chunk_adjunc 109438
4
sblobsp:'informix'.LO_ud_free 109442
608
sblobsp:'informix'.LO_hdr_partn 110050
6481
SBLOBSpace FREE META DATA 116531
24087
SBLOBSpace RESERVED USER DATA (AREA 2) 140618
49988
SBLOBSpace FREE USER DATA (AREA 2) 190606
59394
The text in above o/p marked in RED(& italic) is coming as 52 in
10.00.UC4 whereas its 54 in earlier versions of server(family 10)
if we calculate the pagesize from the file size it should come to 103670/
2048 = 50.62 ~ 51 pages.
My question is why its coming as 52 in UC4 and 54 in earlier versions of
server whereas it should come as 51!
Regards
Manoj Ghogale
I
On 2/13/06, Manoj Ghogale <mghogale@in.ibm.com> wrote:
> This is a changed o/p issue I am facing in oncheck -pS, oncheck
> -cS & oncheck -pe commands for blob spaces.
> I am adding a smart large object sblobsp and inserting 1 file st-louis.jpg
> which is of size 103670 bytes.
>
> IDS version : 10.00.UC4
>
> The o/p's(partial) of oncheck -cS oncheck-pS & oncheck -pe are as
> follows(This o/p is for 2k platforms)
>
> oncheck -cS>
[...]
>
> The text in above o/p marked in RED(& italic) is coming as 52 in
> 10.00.UC4 whereas its 54 in earlier versions of server(family 10)
> if we calculate the pagesize from the file size it should come to 103670/
> 2048 = 50.62 ~ 51 pages.
> My question is why its coming as 52 in UC4 and 54 in earlier versions of
> server whereas it should come as 51!
Page overhead?
103670 / (2048 - 28) = 51.32 => 52
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/