You can use the Control Center tool to choose any db and from the drop down,
choose tablespaces.
Start to create one (You will not keep it, you will cancel it) with fake
container. When you put the container in, the option for Drive Speed on the
left will highlight.
Go there and look at the options to define your disks. As you do so, note
the values for overhead/transferate change. Pick the one you want and use
that for all tablespaces.
The following link in the DB2 V9.5 Information Center will let you be very
precise:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp
Regards, Pierre.
-----Message d'origine-----
De : Dominello B. (Beldon)
[mailto:db2udbdba-ezmlmshield-x2003656.[Email address protected]
Envoyé : 28 avril 2008 12:22
À : LazyDBA Discussion
Objet : Question on TRANSFERRATE and OVERHEAD
Is there a reasonably reliable way to determine the values to put in the
tablespace parameters TRANSFERRATE and OVERHEAD by running iostat (on a
Solaris box, with or without VCS) or something similar?
Alternately, would it be just as well not to even put these parameters in?
I've been searching for references online and in manuals and there is
nothing for determining these values.
Thanks, in advance.
¯
Beldon Dominello
Sr. Database Administrator
CITS, Shared Services, EIM, Database Services
ING
One Orange Way, A2N
Windsor, CT 06095-4774
ING. Your future. Made easier.SM
---------------------------------------------------------
NOTICE: The information contained in this electronic mail message is
confidential and intended only for certain recipients. If you are not an
intended recipient, you are hereby notified that any disclosure,
reproduction, distribution or other use of this communication and any
attachments is strictly prohibited. If you have received this communication
in error, please notify the sender by reply transmission and delete the
message without copying or disclosing it.
============================================================================
================
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page