Re: Object Size confusion. -- MIDRANGE-L

Subject: Re: Object Size confusion.
From: Mark Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>
Date: Wed, 30 Jun 2021 15:31:49 +0000 (UTC)
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

Kerwin,

I am pretty sure that ...

"Data_Size" is what you see when you issue:

DSPFD ... TYPE(*MBR)

Look for "Data space size in bytes" ...

"ObjSize" is what you see when you issue:

DSPOBJD OBJ(lib/name) OBJTYPE(*FILE) DETAIL(*FULL)

Look for "Storage information" ... "Size"

Hope that helps,

Mark S. Waterbury

On Wednesday, June 30, 2021, 10:31:51 AM EDT, K Crawford <kscx3ksc@xxxxxxxxx> wrote:

What is the difference between Data_Size in SysTableStat and ObjSize in
Object_Statistics table function?

I am trying to get an accurate size of some tables.

Even on tables with no deleted rows they are different.

KCrawford

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.