ca.portal.admin

[DB2-L] UDB - Estimate Size Tool in Control Center

Discussion created by ca.portal.admin on Dec 6, 2005
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
bill.gallagher@phoenixwm.com


****************************************************************************
******* 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 DB2-L-REQUEST@www.idugdb2-l.org.
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
DB2-L-REQUEST@www.idugdb2-l.org. 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
DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
IDMS on a Z/SERIES Machine running in 64 bit mode
"Hello All:

Does anyone out there have older releases of IDMS, specifically release 12.1
running on a Z/SERIES Machine running Z/OS in 64 bit mode?

Bill Allen

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Release 16 program loads
"__________________

We think we've figured it out, so here's the follow up.

As we all know, there is not now nor has there ever been a need to include
CDMSLIB in any batch job that talks to IDMS, CV or local mode. What
appears to be happening is IDMS looking at the application program via a
BLDL so it can build the appropriate environment in the user address
space. If you include CDMSLIB, IDMS will look for your programs there. If
you leave out the CDMSLIB DD cards, he looks at STEPLIB/linklist just like
it's supposed to. When included with all the application libraries, stuff
works. When not included at all, stuff works. When included without all
of the application libraries, the job fails with the 4005.

As best I can tell, this is a change in behavior since R14.1. Back then,
the existence of CDMSLIB in the jobstream was irrelevant; it never got
used. In the R16.2 world, it appears to be functional. It would be nice
if the CA folks on the list could confirm or deny my rather heavy
suspicions.

Our final answer, of course, is to eliminate the CDMSLIB DD cards for all
batch jobstreams. In this case, I had an applications test jobstream
which (incorrectly) included the problematic DD cards and got caught with
the upgrade. Pull the DD cards from the test set and verify that the
production ones are all correct and all will be well.

Many thanks to all.

Alan ""getting loaded"" Fields

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [DB2-L] UDB - Estimate Size Tool in Control Center
"I guess I had a ""senior moment"". I subscribe to both lists, and, since I
get IDMS-L in digest mode, didn't realize I posted to the wrong one until
I saw your response this morning. Sorry for the cross-post and any
confusion it may have caused.

Dave Slocum
Consumers Energy


Joe Perkins wrote:
""Hi David,
It looks like you replied to a DB2-L thread in IDMS land. I just wanted to
make sure you are now aware of that.""

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [DB2-L] UDB - Estimate Size Tool in Control Center
"Hi David,
It looks like you replied to a DB2-L thread in IDMS land. I just wanted to
make sure you are now aware of that.

Happy Holidays,
Joe Perkins

Outcomes