Hello all,

I have an issue on one database DB2v8.2 on AIX 5.3 - that call to get_dbsize_info(?,?,?,0) function hangs.

I have waited for 15 minutes only. Then I pressed Ctrl-C.

What should I look for to investigate the cause ? I mean if I monitor via db2mon tool while executing it.

Can it help me (db2mon) or suggest any other tool to find cause of long running query ? I understand that I have db2top available, but not used it much.

Thanks,

DBFinder

ps: same thing with get_dbsize_info(?,?,?,-1)

have you checked the status of the agent - maybe lockwait ??

Actually, not checked.

I will check it today, I assumed that this function queries only catalog tables.

Correct me if I am wrong, it calculates the size by summing all used pages (tablespace) multiplied by page size.

I will investigate today and let you know.

Regards

Yes, I think it looks at the tablespaces's used pages when it calculates the databasesize (this info is stored in the tablespace's control files). So, you can use list tablespaces or db2pd instead.

Found,
One agent querying dbsize info was hanging around for 6 days. My call was waiting for that agent to finish.

When first agent was forced off, it returned db size promptly.

Thanks for your support.

DBFinder