RE: SQL function/procedure to know used/free space

RE: SQL function/procedure to know used/free space

 

  

CALL GET_DBSIZE_INFO(?, ?, ?, 0)

________________________________

From: Prabhakaran Venu [mailto:db2udbdba-ezmlmshield-x63864933.[Email address protected]
Sent: Wed 9/27/2006 10:18 PM
To: LazyDBA Discussion
Subject: SQL function/procedure to know used/free space




Hi DB2 Gurus,

Is there a command/function/procedure in DB2 to find the free and used
space in the database to do some capacity planning?

Thanks in advance
Venu

**********************************************************************
IMPORTANT NOTICE
This e-mail message (including its attachments) is private,
is intended for the recipient named in it and may contain
material which is confidential and privileged. No-one
other than the named recipient may read, copy, rely on,
redirect, save or alter the message or any part of it or
any attachment to it in any way. The Travelex Group does
not accept legal responsibility for the contents of this
message. Any views or opinions presented are solely those
of the author and do not represent those of the Travelex
Group unless otherwise specifically stated. While reasonable
effort has been made to ensure this message is free of
viruses, opening and using this message is at the risk of
the recipient.
Travelex can be found on the World Wide Web at
http://www.travelex.com.
**********************************************************************



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page