AMP Usage Via SQL 1

[terminalclick]

Please could someone point me in the direction of some DBC sql which I can run while a query is running to see what AMPs it is using?

(I am having an issue with SPOOL space running out, and I think it's because I have skewed data, where the query is only using one or two of the full amount of AMPs, but need to see if this is the case. I don't have access to any graphical tools.)

Thanks for your help.

 

[Liam1]

Hello,

Basically if you are trying to "whatch" yourself on the box try
Select
Databasename
,vproc as Amp_No
,MaxSpool(dec(18,0)) as Max_Allowed_Spool
,CurrentSpool(dec(18,0)) as Current_Usage
,PeakSpool(Dec(18,0)) as Peak_So_Far
,MaxTemp(dec(18,0))
,CurrentTemp(dec(18,0))
,PeakTemp(Dec(18,0))

From dbc.diskspace
Where databasename = 'UserId'
;

Your Peak spool will actualy get cleared down at some point. ours is cleared down at midnight.

Hope this helps,

Liam.

 

[terminalclick]

That's great, seems to be what I wanted! Thanks!