dba-db2.com - db2 performance tuning, DB2 tuning,db2 performance,sql tuning db2, DBA in DB2, DBA Scripts,DB2,DB2 consulting,DB2 consultant,DB2 architecture,DB2 training

Database size in DB2

23 June,2011 by Tom Collins

How can I calculate the Database size in DB2?

Database size in DB2 - Find 3 methods I use to find the database size in DB2

METHOD 1 - GET_DBSIZE_INFO
============================
db2 connect to 
db2 "CALL GET_DBSIZE_INFO (?, ?, ?, -1)"

METHOD 2a (in MB) snapshot_tbs_cfg
===============================
db2 connect to 
db2 "select (sum(total_pages)* 4096)/(1024*1024) Tot_allocat_spceinMB from table(snapshot_tbs_cfg(' ',-1)) TBS_SPCE"

METHOD 2b (in GB)snapshot_tbs_cfg
==================================
db2 "select (SUM(total_pages)*4)/(1024.0*1024) TOTAL_ALLOCATED_SPACE_IN_GB from table (snapshot_tbs_cfg('',-1)) TBS_SPCE"
db2 connect reset

METHOD 3 systools.stmg_dbsize_info

================================
SELECT db_size, db_capacity FROM systools.stmg_dbsize_info;

 

Read More

DB2 table size shell script - DBA DB2

Database will come up with hidden buffer pools - DBA DB2

Database Tuning overview –Storage Tuning - DBA DB2

Author: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 9:00 AM in DBA Scripts | Permalink | Comments (2) | TrackBack (0)

Searches: , , , ,

Hi,

Please let me know how to find the previous database growth from Db level in Db2 database.


Thanks,
Praveen.

Posted by: Praveen | Jul 9, 2013 12:32:33 AM

Hi Praveen , One method I use is to utilise SYSIBMADM.ADMINTABINFO or ADMIN_GET_TAB_INFO_V97 . Typically, I will save the output at a regular period - usually once a day. Then I will run a script and create some trend graph

Posted by: Tom Collins | Jul 9, 2013 12:56:21 PM

Verify your Comment

Previewing your Comment

Posted by: |

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Database size in DB2

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright