Query in Reorgchk

[santhosh.david]

Hi,

I have a query in reorgchk. When I was examining the output of reorgchk
I found a column TSIZE in Table Statistics & ISIZE in Index Statistics.
Can any one let me know the formula for TSIZE & ISIZE? How to calculate
the size?

Thanks & Regards,
Santhosh

[Knut Stolze]

sa************@in.standardchartered.com wrote:

Hi,

I have a query in reorgchk. When I was examining the output of reorgchk
I found a column TSIZE in Table Statistics & ISIZE in Index Statistics.
Can any one let me know the formula for TSIZE & ISIZE? How to calculate
the size?

What do you mean with "query in reorgchk"? You can't do a reorgchk on
queries - just on tables.

The description of TSIZE and ISIZE can be found here:
http://publib.boulder.ibm.com/infoce...e/r0001971.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Mark A]

"Knut Stolze" <st****@de.ibm.comwrote in message
news:el**********@lc03.rz.uni-jena.de...

What do you mean with "query in reorgchk"? You can't do a reorgchk on
queries - just on tables.

He means he has a "question" about reorgchk.

Doubt = Query = Question to some non-native speakers of English.

[Knut Stolze]

Mark A wrote:

"Knut Stolze" <st****@de.ibm.comwrote in message
news:el**********@lc03.rz.uni-jena.de...

>What do you mean with "query in reorgchk"? You can't do a reorgchk on
queries - just on tables.

He means he has a "question" about reorgchk.

Doubt = Query = Question to some non-native speakers of English.

Thanks, that makes sense. When I hear "query", my first association is
SELECT ... ;-)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Mark A]

"Knut Stolze" <st****@de.ibm.comwrote in message
news:el**********@lc03.rz.uni-jena.de...

Thanks, that makes sense. When I hear "query", my first association is
SELECT ... ;-)

Knut Stolze
DB2 Information Integration Development
IBM Germany

I think some of it comes from translation websites.