Getting the following error for a db , for rest all dbs under the same instance  it's working fine , any ideas anyone ?


gb02qap050arcx7.warwick.mebs.ihost.com[/home/db2comm]$ db2 'call get_dbsize_info(?,?,?,-1)'
SQL0443N  Routine "*IZE_INFO" (specific name "") has returned an error
SQLSTATE with diagnostic text "SQL0444  Reason code or token: *TAMPDIFF,
TIMESTAMPDIFF,.../".  SQLSTATE=38553

Regards

kanak

Hi Kanakarajuy,

You have another option to discover the size of database when this routine doesn't work. Execute the script in the below:

http://www.dbatodba.com/db2/scripts-db2/shell-scripts-to-db2/database-size-script/

Previously wrote:

Hi Kanakarajuy,

You have another option to discover the size of database when this routine doesn't work. Execute the script in the below:

http://www.dbatodba.com/db2/scripts-db2/shell-scripts-to-db2/database-size-script/

HI Perallis,

THanks for your input.do i need to change any parmeters in that script or straight away can i exexute this script??

Hello Kanakarajuy,

You don't need to set any parameters to execute this script, but If want, you can set some parameters to extra functions, example: to send an e-mail to your personal e-mail box, to change the threshold values, to change the report file name

Regards,