SQL to find all Resource groups in Netezza

Reading Time: < 1 minute

You can run below query to find all the resource groups in a Netezza system. The output of this query will also give us the maximum and minimum resource allocation values in percentage.
To get these details we will query system view _v_group in system database.

select GROUPNAME as "Resource Group",GRORSGPERCENT as "Min Resource",RSGMAXPERCENT as "Max Resource"
from _v_group where grorsgpercent<>0