dbsize

rajesh_1972 · #1 (**permalink**) 02-19-07, 11:53

What is the command to find out dbsize of a database. Please throw your ideas. Your ideas are appreciated.

koganti · #2 (**permalink**) 02-19-07, 12:00

db2 list utilities show details will show the size of the database while the backup is running.

or

db2 list tablespaces show detail and calculate the size of each tablespace

guyprzytula · #3 (**permalink**) 02-20-07, 03:19

or if using v9 get_dbsize_info procedure wil tell this

rahul_s80 · #4 (**permalink**) 02-20-07, 04:06

Quote:

Originally Posted by guyprzytula

or if using v9 get_dbsize_info procedure wil tell this

even v 8.2.0 LUW supports sysproc.get_dbsize_info

sansaniwal · #5 (**permalink**) 02-20-07, 06:01

Also through control center you can get the db size after clicking on connect on bottom right corner of control center.
but for the version should be v 8.2.0 with fix pack 12 or lower fix pack.

Thanks & Regards,
deepak Sansaniwal
DBA

meehange · #6 (**permalink**) 02-21-07, 19:42

Hey,

I've been trying to get

Code:

db2 "call GET_DBSIZE_INFO(?,?,?,-1)"

to work but I keep getting

Code:

SQL0443N  Routine "*IZE_INFO" (specific name "") has returned an error
SQLSTATE with diagnostic text "SQL0204  Reason code or token: SYSTOOLSPACE
".  SQLSTATE=38553

I believe it has something to do with the OUT params but all the examples say to use a '?'.

I'm following this:
http://www-1.ibm.com/support/docview...id=swg21231144

I'm using v8 FP9 on AIX

EDIT: Nevermind.... I was bein stupid... I just created the systoolspace and all is well ...DUHHHH! :P

stolze · #7 (**permalink**) 02-26-07, 13:14

Have you run the "db2updv8" on your database? I guess not because the error message means that some routine named SYSTOOLSPACE is not available:

Code:

$ db2 "? sql204"

SQL0204N "<name>" is an undefined name.

Internet Services

Web Development

Digital Marketing

Consumer Tech