By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

estimate table size not working?

P: n/a
hi, i am using db2 udb v8.1 on windows, i try to use control center to
estimate table size, but some of them showing 0 rows even though there
are 6000 rows in the table, some of them showing correctly, so why is
that?
Nov 12 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
aka
perhaps a runstats missing?

aka
"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0**************************@posting.google.c om...
hi, i am using db2 udb v8.1 on windows, i try to use control center to
estimate table size, but some of them showing 0 rows even though there
are 6000 rows in the table, some of them showing correctly, so why is
that?

Nov 12 '05 #2

P: n/a
aka
perhaps a runstats missing?

aka
"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0**************************@posting.google.c om...
hi, i am using db2 udb v8.1 on windows, i try to use control center to
estimate table size, but some of them showing 0 rows even though there
are 6000 rows in the table, some of them showing correctly, so why is
that?

Nov 12 '05 #3

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
hi, i am using db2 udb v8.1 on windows, i try to use control center to
estimate table size, but some of them showing 0 rows even though there
are 6000 rows in the table, some of them showing correctly, so why is
that?


SQL666 - You have exceeded the number of allowed questions on this
newsgroup.
Nov 12 '05 #4

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
hi, i am using db2 udb v8.1 on windows, i try to use control center to
estimate table size, but some of them showing 0 rows even though there
are 6000 rows in the table, some of them showing correctly, so why is
that?


SQL666 - You have exceeded the number of allowed questions on this
newsgroup.
Nov 12 '05 #5

P: n/a
Mark A wrote:
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
hi, i am using db2 udb v8.1 on windows, i try to use control center to
estimate table size, but some of them showing 0 rows even though there
are 6000 rows in the table, some of them showing correctly, so why is
that?

SQL666 - You have exceeded the number of allowed questions on this
newsgroup.

You missed also paragraph titled:

Possible actions:

Read documentation available online at:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Jan M. Nelken
Nov 12 '05 #6

P: n/a
Mark A wrote:
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
hi, i am using db2 udb v8.1 on windows, i try to use control center to
estimate table size, but some of them showing 0 rows even though there
are 6000 rows in the table, some of them showing correctly, so why is
that?

SQL666 - You have exceeded the number of allowed questions on this
newsgroup.

You missed also paragraph titled:

Possible actions:

Read documentation available online at:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Jan M. Nelken
Nov 12 '05 #7

P: n/a
what do i missing?
Nov 12 '05 #8

P: n/a
what do i missing?
Nov 12 '05 #9

P: n/a
aka
> You missed also paragraph titled:

Possible actions:

Read documentation available online at:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Jan M. Nelken


BTW does someone know how to access the above link in english language
rather than my national translation?

aka
Nov 12 '05 #10

P: n/a
aka
> You missed also paragraph titled:

Possible actions:

Read documentation available online at:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Jan M. Nelken


BTW does someone know how to access the above link in english language
rather than my national translation?

aka
Nov 12 '05 #11

P: n/a
aka,

in the Microsoft Internet Explorer in German:

Extras->Internetoptionen->Allgemein Sprachen... (Button).

regards,
Joachim Müller
"aka" <ak*@aka-soft.de> schrieb im Newsbeitrag
news:c7**********@online.de...
You missed also paragraph titled:

Possible actions:

Read documentation available online at:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Jan M. Nelken


BTW does someone know how to access the above link in english language
rather than my national translation?

aka

Nov 12 '05 #12

P: n/a
aka,

in the Microsoft Internet Explorer in German:

Extras->Internetoptionen->Allgemein Sprachen... (Button).

regards,
Joachim Müller
"aka" <ak*@aka-soft.de> schrieb im Newsbeitrag
news:c7**********@online.de...
You missed also paragraph titled:

Possible actions:

Read documentation available online at:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Jan M. Nelken


BTW does someone know how to access the above link in english language
rather than my national translation?

aka

Nov 12 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.