469,927 Members | 1,672 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Query in Reorgchk

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

Dec 6 '06 #1
4 2967
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
Dec 6 '06 #2
"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.
Dec 6 '06 #3
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
Dec 6 '06 #4
"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.
Dec 6 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jeff | last post: by
5 posts views Thread by Jari Korkiakoski | last post: by
1 post views Thread by hikums | last post: by
2 posts views Thread by EpsilonAurigae | last post: by
6 posts views Thread by Hemant Shah | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.