Re: UDB - Estimate Size Tool in Control Center

James Campbell

Re: UDB - Estimate Size Tool in Control Center
(in response to JOHN KRUGER)
Let's do a reasonableness calculation:
1822 B (avg row size) * 2,128,266 (number of rows) = 3877700652
B = 3698 MB.

Anything more need to be said?

James Campbell

On 6 Dec 2005 at 15:30, [login to unmask email] wrote:

> Help!
>
> I've been using the "Estimate Size" tool in Control Center to estimate
> storage requirements for a database and application that is in development.
> I had been using the v7.2 DB2 Client (fixpak 7) until recently, when I
> upgraded to v8.2 DB2 Client (fixpak 10). I'm getting vastly different
> results.
>
> For instance: I have a table that is defined in a tablespace with an 8k
> pagesize. Runstats shows that there are currently 45,238 rows loaded into
> the table, and the table has an average row size of 1,822 bytes. When I
> change the "New total number of rows" to 2,128,266 and select "Display size
> in units of Pages", the tool comes back with an estimated size of 532,325
> pages. This is consistent for both the v7.2 Client and the v8.2 Client.
>
> Here's the interesting part: when I choose "Display size in units of MB",
> the v7.2 Client comes back with an estimated size of 2,079.39mb. The v8.2
> Client comes back with an estimated size of 4,158.79mb (which is exactly
> double). This disturbs be greatly because I'm dealing with what I thought
> was a 700gb database, but now may have just become a 1.4tb database this
> afternoon.
>
> So my question is: which one is correct? The v7.2 client, or the v8.2
> client?
>
> -------------------------------------------------------
> Bill Gallagher
> Database Administrator
> IT / Common Services
> Phoenix Life Insurance Company
> 860-403-6327
> [login to unmask email]
>
>
> *********************************************************************************** CONFIDENTIAL: This communication, including attachments, is intended only for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, you are hereby notified that you have received this document in error, and any use, review, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this communication and destroy any and all copies of this communication.
>
> ***********************************************************************************
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bill Gallagher

UDB - Estimate Size Tool in Control Center
Help!

I've been using the "Estimate Size" tool in Control Center to estimate
storage requirements for a database and application that is in development.
I had been using the v7.2 DB2 Client (fixpak 7) until recently, when I
upgraded to v8.2 DB2 Client (fixpak 10). I'm getting vastly different
results.

For instance: I have a table that is defined in a tablespace with an 8k
pagesize. Runstats shows that there are currently 45,238 rows loaded into
the table, and the table has an average row size of 1,822 bytes. When I
change the "New total number of rows" to 2,128,266 and select "Display size
in units of Pages", the tool comes back with an estimated size of 532,325
pages. This is consistent for both the v7.2 Client and the v8.2 Client.

Here's the interesting part: when I choose "Display size in units of MB",
the v7.2 Client comes back with an estimated size of 2,079.39mb. The v8.2
Client comes back with an estimated size of 4,158.79mb (which is exactly
double). This disturbs be greatly because I'm dealing with what I thought
was a 700gb database, but now may have just become a 1.4tb database this
afternoon.

So my question is: which one is correct? The v7.2 client, or the v8.2
client?

-------------------------------------------------------
Bill Gallagher
Database Administrator
IT / Common Services
Phoenix Life Insurance Company
860-403-6327
[login to unmask email]


*********************************************************************************** CONFIDENTIAL: This communication, including attachments, is intended only for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, you are hereby notified that you have received this document in error, and any use, review, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy any and all copies of this communication.

***********************************************************************************

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: UDB - Estimate Size Tool in Control Center
(in response to Bill Gallagher)
simple math says 500K pages of 8K size = 4GB. I would suspect that somewhere
a bit of code forgot to include 8K vs 4K pages in it's calculation.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of [login to unmask email]
Sent: Tuesday, December 06, 2005 2:31 PM
To: [login to unmask email]
Subject: [DB2-L] UDB - Estimate Size Tool in Control Center

Help!

I've been using the "Estimate Size" tool in Control Center to estimate
storage requirements for a database and application that is in development.
I had been using the v7.2 DB2 Client (fixpak 7) until recently, when I
upgraded to v8.2 DB2 Client (fixpak 10). I'm getting vastly different
results.

For instance: I have a table that is defined in a tablespace with an 8k
pagesize. Runstats shows that there are currently 45,238 rows loaded into
the table, and the table has an average row size of 1,822 bytes. When I
change the "New total number of rows" to 2,128,266 and select "Display size
in units of Pages", the tool comes back with an estimated size of 532,325
pages. This is consistent for both the v7.2 Client and the v8.2 Client.

Here's the interesting part: when I choose "Display size in units of MB",
the v7.2 Client comes back with an estimated size of 2,079.39mb. The v8.2
Client comes back with an estimated size of 4,158.79mb (which is exactly
double). This disturbs be greatly because I'm dealing with what I thought
was a 700gb database, but now may have just become a 1.4tb database this
afternoon.

So my question is: which one is correct? The v7.2 client, or the v8.2
client?

-------------------------------------------------------
Bill Gallagher
Database Administrator
IT / Common Services
Phoenix Life Insurance Company
860-403-6327
[login to unmask email]


****************************************************************************
******* CONFIDENTIAL: This communication, including attachments, is intended
only for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the intended
recipient, you are hereby notified that you have received this document in
error, and any use, review, copying, disclosure, dissemination or
distribution is strictly prohibited. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
communication and destroy any and all copies of this communication.

****************************************************************************
*******

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

JOHN KRUGER

Re: UDB - Estimate Size Tool in Control Center
(in response to Mike Bell)



IBM realiazed they can use their own tools to sell more storage
devices.
Version 7.2 is correct.

Thanks,
John Kruger







John P. Kruger
Database Administrator
Management Information Systems
IL Department of Human Services
(217) 557-9720
FAX (217) 782-6089


>>> [login to unmask email] 12/06/05 3:10 PM >>>
simple math says 500K pages of 8K size = 4GB. I would suspect that
somewhere
a bit of code forgot to include 8K vs 4K pages in it's calculation.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf
Of [login to unmask email]
Sent: Tuesday, December 06, 2005 2:31 PM
To: [login to unmask email]
Subject: [DB2-L] UDB - Estimate Size Tool in Control Center

Help!

I've been using the "Estimate Size" tool in Control Center to estimate
storage requirements for a database and application that is in
development.
I had been using the v7.2 DB2 Client (fixpak 7) until recently, when I
upgraded to v8.2 DB2 Client (fixpak 10). I'm getting vastly different
results.

For instance: I have a table that is defined in a tablespace with an
8k
pagesize. Runstats shows that there are currently 45,238 rows loaded
into
the table, and the table has an average row size of 1,822 bytes. When
I
change the "New total number of rows" to 2,128,266 and select "Display
size
in units of Pages", the tool comes back with an estimated size of
532,325
pages. This is consistent for both the v7.2 Client and the v8.2
Client.

Here's the interesting part: when I choose "Display size in units of
MB",
the v7.2 Client comes back with an estimated size of 2,079.39mb. The
v8.2
Client comes back with an estimated size of 4,158.79mb (which is
exactly
double). This disturbs be greatly because I'm dealing with what I
thought
was a 700gb database, but now may have just become a 1.4tb database
this
afternoon.

So my question is: which one is correct? The v7.2 client, or the v8.2
client?

-------------------------------------------------------
Bill Gallagher
Database Administrator
IT / Common Services
Phoenix Life Insurance Company
860-403-6327
[login to unmask email]


****************************************************************************
******* CONFIDENTIAL: This communication, including attachments, is
intended
only for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the
intended
recipient, you are hereby notified that you have received this document
in
error, and any use, review, copying, disclosure, dissemination or
distribution is strictly prohibited. If you are not the intended
recipient,
please notify the sender immediately by return e-mail, delete this
communication and destroy any and all copies of this communication.

****************************************************************************
*******

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
"Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email]
Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG
conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

JOHN KRUGER

Re: UDB - Estimate Size Tool in Control Center
(in response to JOHN KRUGER)



IBM realiazed they can use their own tools to sell more storage
devices.
Version 7.2 is correct.

Thanks,
John Kruger







John P. Kruger
Database Administrator
Management Information Systems
IL Department of Human Services
(217) 557-9720
FAX (217) 782-6089


>>> [login to unmask email] 12/06/05 3:10 PM >>>
simple math says 500K pages of 8K size = 4GB. I would suspect that
somewhere
a bit of code forgot to include 8K vs 4K pages in it's calculation.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf
Of [login to unmask email]
Sent: Tuesday, December 06, 2005 2:31 PM
To: [login to unmask email]
Subject: [DB2-L] UDB - Estimate Size Tool in Control Center

Help!

I've been using the "Estimate Size" tool in Control Center to estimate
storage requirements for a database and application that is in
development.
I had been using the v7.2 DB2 Client (fixpak 7) until recently, when I
upgraded to v8.2 DB2 Client (fixpak 10). I'm getting vastly different
results.

For instance: I have a table that is defined in a tablespace with an
8k
pagesize. Runstats shows that there are currently 45,238 rows loaded
into
the table, and the table has an average row size of 1,822 bytes. When
I
change the "New total number of rows" to 2,128,266 and select "Display
size
in units of Pages", the tool comes back with an estimated size of
532,325
pages. This is consistent for both the v7.2 Client and the v8.2
Client.

Here's the interesting part: when I choose "Display size in units of
MB",
the v7.2 Client comes back with an estimated size of 2,079.39mb. The
v8.2
Client comes back with an estimated size of 4,158.79mb (which is
exactly
double). This disturbs be greatly because I'm dealing with what I
thought
was a 700gb database, but now may have just become a 1.4tb database
this
afternoon.

So my question is: which one is correct? The v7.2 client, or the v8.2
client?

-------------------------------------------------------
Bill Gallagher
Database Administrator
IT / Common Services
Phoenix Life Insurance Company
860-403-6327
[login to unmask email]


****************************************************************************
******* CONFIDENTIAL: This communication, including attachments, is
intended
only for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the
intended
recipient, you are hereby notified that you have received this document
in
error, and any use, review, copying, disclosure, dissemination or
distribution is strictly prohibited. If you are not the intended
recipient,
please notify the sender immediately by return e-mail, delete this
communication and destroy any and all copies of this communication.

****************************************************************************
*******

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
"Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email]
Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG
conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bill Gallagher

Re: UDB - Estimate Size Tool in Control Center
(in response to James Campbell)
Duh!

Good point. I guess I was in too much shell-shock about the possibility
in being off in my storage calculation by 700gb to do the simple math.
Looks like we'll need more storage.

At least I can blame the v7.2 Client for this one!

Thanks,

-------------------------------------------------------
Bill Gallagher
Database Administrator
IT / Common Services
Phoenix Life Insurance Company
860-403-6327
[login to unmask email]





"James Campbell" <[login to unmask email]>
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>
12/06/2005 07:59 AM
Please respond to "DB2 Database Discussion list at IDUG"


To: [login to unmask email]
cc:
Subject: Re: [DB2-L] UDB - Estimate Size Tool in Control Center


<?xml version="1.0" ?>
Let's do a reasonableness calculation:
1822 B (avg row size) * 2,128,266 (number of rows) = 3877700652 B = 3698 MB.
Anything more need to be said?
James Campbell
On 6 Dec 2005 at 15:30, [login to unmask email] wrote:
> Help!
>
> I've been using the "Estimate Size" tool in Control Center to estimate
> storage requirements for a database and application that is in
development.
> I had been using the v7.2 DB2 Client (fixpak 7) until recently, when I
> upgraded to v8.2 DB2 Client (fixpak 10). I'm getting vastly different
> results.
>
> For instance: I have a table that is defined in a tablespace with an 8k
> pagesize. Runstats shows that there are currently 45,238 rows loaded
into
> the table, and the table has an average row size of 1,822 bytes. When I
> change the "New total number of rows" to 2,128,266 and select "Display
size
> in units of Pages", the tool comes back with an estimated size of
532,325
> pages. This is consistent for both the v7.2 Client and the v8.2 Client.
>
> Here's the interesting part: when I choose "Display size in units of
MB",
> the v7.2 Client comes back with an estimated size of 2,079.39mb. The
v8.2
> Client comes back with an estimated size of 4,158.79mb (which is exactly
> double). This disturbs be greatly because I'm dealing with what I
thought
> was a 700gb database, but now may have just become a 1.4tb database this
> afternoon.
>
> So my question is: which one is correct? The v7.2 client, or the v8.2
> client?
>
> -------------------------------------------------------
> Bill Gallagher
> Database Administrator
> IT / Common Services
> Phoenix Life Insurance Company
> 860-403-6327
> [login to unmask email]
>
>
>
***********************************************************************************
CONFIDENTIAL: This communication, including attachments, is intended only
for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the intended
recipient, you are hereby notified that you have received this document in
error, and any use, review, copying, disclosure, dissemination or
distribution is strictly prohibited. If you are not the intended
recipient, please notify the sender immediately by return e-mail, delete
this communication and destroy any and all copies of this communication.
>
>
***********************************************************************************
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm