Query to find all the resource groups in a Netezza system
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