when i execute get_dbsize_info to find the size of a database it is
giving output as -1. Can anyone, please help me out how to resolve
this issue?

On 2011-02-02 15:56, kavin wrote:
What version of db2, how did you call the procedure and what is the output?


/Lennart

On Feb 2, 9:37*pm, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com>
wrote:
i had used 2 commands
1) db2 "call get_dbsize_info (?,?,?,-1)"
output is
Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2011-02-02-08.16.04.580034

Parameter Name : DATABASESIZE
Parameter Value : -1

Parameter Name : DATABASECAPACITY
Parameter Value : -1

Return Status = 0

2) db2 "select * from SYSTOOLS.STMG_DBSIZE_INFO"
output is
SNAPSHOT_TIMESTAMP DB_SIZE DB_CAPACITY
-------------------------- -------------------- --------------------
2011-02-02-08.16.04.580034 -1 -1

db2 version is DB2 v9.1.0.9

Manual states: To ensure that the data is returned by all partitions
for a global table space snapshot, the database must be activated.

So, is the database activated ?

yes the database is Active

Have you tried taking a manual snapshot from the control center ?
Check to make sure tablespaces SYSTOOLSPACE and SYSTOOLSTMPSPACE have
been created correctly. If the DB2 registry variable DB2_WORKLOAD is
set to SAP, neither the SYSTOOLSPACE nor the SYSTOOLSTMPSPACE will be
created automatically.

You will need statistics to be collected for db objects. You might need a runstat on all tables.

Submitted via EggHeadCafe
WCF Generic DataContract object Serializer
http://www.eggheadcafe.com/tutorials...erializer.aspx