I have a stored procedure for finding the disk size used by a DB, in SYBASE. Now trying to port to DB2. Anyone have got examples for storedprocedures in DB2? Iam attaching the Sybase stored procedure here..


create procedure sp_myspaceused
@used_size float OUTPUT
as
declare @dbase_size float
declare @unused_size float
select @dbase_size = 10
select @unused_size = 10
select @unused_size = sum( curunreservedpgs( db_id('ipms'), lstart, unreservedpgs)) * ( @@pagesize/1024 ) from master..sysusages where dbid = db_id('ipms')
select @unused_size = convert( float, @unused_size )/1024.0
select @dbase_size = sum(size) * ( @@pagesize/1024 ) from master..sysusages where dbid = db_id('ipms')
select @dbase_size = convert( float, @dbase_size)/1024.0
select @used_size = ( @dbase_size - @unused_size )
return
go