Solved

Db size for DB2 v7

Posted on 2009-07-09
1
657 Views
Last Modified: 2012-05-07
Hi,

What is the command to find the database size in db2 V7
0
Comment
Question by:jsaravana
1 Comment
 
LVL 17

Accepted Solution

by:
k_murli_krishna earned 500 total points
ID: 24821223
There is no command as such. You maybe able to obtain control center. Else, estimate table and index sizes and add a buffer of 5 MB to this for rest of object definitions. The size of database folder on hard disk is one way to measure.

Size of table and index, you can get from GUI via average row/key size and then multiplying by number of rows for each table/index. Sum total of all this can get you close to actaul database size.
You can also calculate using formulas:
Size of table = (Average row size + 8) * 1.5
Size of index = (Average key size + 8) * 2
Size of temporary tablespace size = (Average total sort size + 8) * 3.2
Sort size implies aggregate functions MAX, MIN, GROUP BY and ORDER BY columns.

You can also estimate taking sum of data type sizes for all columns in a table/index while taking 70 % size for VARCHAR columns.
You can also query data dictionary i.e. SYSIBM and SYSCAT tables/views and count the total number of pages used * page size after connecting to database.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AS400 Single Sign On 3 1,341
AS400 Forms 9 134
DB2 LUW V9.7 on Windows Change a column from NOT NULL to allow NULLS 3 74
iSeries DB2 SQL - Request user input 12 60
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question