Shows information about space available and space used in the IQ store, IQ temporary store, RLV store, and IQ global and local shared temporary stores.
sp_iqspaceused(out mainKB unsigned bigint,
out mainKBUsed unsigned bigint,
out tempKB unsigned bigint,
out tempKBUsed unsigned bigint,
out shTempTotalKB unsigned bigint,
out shTempTotalKBUsed unsigned bigint,
out shTempLocalKB unsigned bigint,
out shTempLocalKBUsed unsigned bigint,
out rlvLogKB unsigned bigint,
out rlvLogKBUsed unsigned bigint)
Simplex and multiplex.
Requires the ALTER DATABASE, MANAGE ANY DBSPACE, or MONITOR system privileges. Users without one of these system privileges must be granted EXECUTE permission.
sp_iqspaceused returns several values as unsigned bigint out parameters. This system stored procedure can be called by user-defined stored procedures to determine the amount of main, temporary, and RLV store space in use.
sp_iqspaceused returns a subset of the information provided by sp_iqstatus, but allows the user to return the information in SQL variables to be used in calculations.
If run on a multiplex database, this procedure applies to the server on which it runs. Also returns space used on IQ_SHARED_TEMP.
Column Name |
Description |
|---|---|
mainKB |
The total IQ main store space, in kilobytes. |
mainKBUsed |
The number of kilobytes of IQ main store space used by the database. Secondary multiplex nodes return '(Null)'. |
tempKB |
The total IQ temporary store space, in kilobytes. |
tempKBUsed |
The number of kilobytes of total IQ temporary store space in use by the database. |
shTempTotalKB |
The total IQ global shared temporary store space, in kilobytes. |
shTempLocalKB |
The total IQ local shared temporary store space, in kilobytes. |
shTempLocalKBUsed |
The number of kilobytes of IQ local shared temporary store space in use by the database. |
|
rlvLogKB |
The total RLV store space, in kilobytes. |
|
rlvLogKBUsed |
The number of kilobytes of RLV store space in use by the database. |
create or replace procedure dbo.myspace()
begin
declare mt unsigned bigint;
declare mu unsigned bigint;
declare tt unsigned bigint;
declare tu unsigned bigint;
declare gt unsigned bigint;
declare gu unsigned bigint;
declare lt unsigned bigint;
declare lu unsigned bigint;
declare rvlt unsigned bigint;
declare rvlu unsigned bigint;
call sp_iqspaceused(mt,mu,tt,tu,gt,gu,lt,lu, rvlt, rvlu);
select cast(mt/1024 as unsigned bigint) as mainMB,
cast(mu/1024 as unsigned bigint) as mainusedMB,
mu*100/mt as mainPerCent,
cast(tt/1024 as unsigned bigint) as tempMB,
cast(tu/1024 as unsigned bigint) as tempusedMB,
tu*100/tt as tempPerCent,
cast(gt/1024 as unsigned bigint) as shTempTotalKB,
if gu=0 then 0 else gu*100/gt endif as globalshtempPerCent,
cast(lt/1024 as unsigned bigint) as shTempLocalMB,
cast(lu/1024 as unsigned bigint) as shTempLocalKBUsed,
if lt=0 then 0 else lu*100/lt endif as localshtempPerCent,
cast(rvlt/1024 as unsigned bigint) as rlvLogKB,
cast(rvlu/1024 as unsigned bigint) as rlvLogKBUsed;
end
myspace