#################################################################################
Check Resource utilization on IBM Netezza system
#################################################################################
[nz@XXXXXXX]$ nzsqa schedqueues -sys
SCHED TIME: 2016-03-08 11:46:27.801 PST
SCHEDULER POLICY:
Gatekeeper Disabled max slots = 2048
GRA Enabled max slots = 48 SQB slots = 10
Snippet Enabled max slots = 40 SQB slots = 6
SQB (< 2s) Enabled
SN Limiting Enabled baseline = 8
GRALoad Enabled
Null I/O -> Ceilings:on Available:on Expected:on SNLimit:on
##### Defined utilization will be here
KNOWN GROUPS:
GROUP --OID= 4901 RSG Min 20% Max 100% JobMax 0 (off) "PUBLIC"
GROUP --OID= 4900 RSG Min 100% Max 100% JobMax 0 (off) "ADMIN"
GROUP --OID=170526524 RSG Min 10% Max 100% JobMax 0 (off) "ADM_GRP"
GROUP --OID=144910001 RSG Min 50% Max 100% JobMax 0 (off) "RSG_PERFTEST"
GATEKEEPER:
Gatekeeper 0 [normal], up to 0 sec, queued 0, running 0 (max 2048)
GRA SCHED:
##### Current utilization will be here
SNIPPET SCHED: Avail Avail
Short Long InUse Max Delta Reserved
Host Memory 16384 15872 0 16384 0 512
Blade Memory 18499 16499 0 18499 0 2000
Channels 100 100 0 100
Distributes 50 49 0 50 0 1
Spu2Hosts 100 100 0 100 0 0
Broadcasts 100 100 0 100 0 0
###########checck Running process utilization
[nz@XXXX]$ nz_responders
Cur Time Plan # Snippet Time S/P State Busy Dataslices ... SQL Username/Database
======== ======= ========= ========= ======= ==== ==================== ======================================== ====================
11:46:45
11:46:55
11:47:05
11:47:15
Check Resource utilization on IBM Netezza system
#################################################################################
[nz@XXXXXXX]$ nzsqa schedqueues -sys
SCHED TIME: 2016-03-08 11:46:27.801 PST
SCHEDULER POLICY:
Gatekeeper Disabled max slots = 2048
GRA Enabled max slots = 48 SQB slots = 10
Snippet Enabled max slots = 40 SQB slots = 6
SQB (< 2s) Enabled
SN Limiting Enabled baseline = 8
GRALoad Enabled
Null I/O -> Ceilings:on Available:on Expected:on SNLimit:on
##### Defined utilization will be here
KNOWN GROUPS:
GROUP --OID= 4901 RSG Min 20% Max 100% JobMax 0 (off) "PUBLIC"
GROUP --OID= 4900 RSG Min 100% Max 100% JobMax 0 (off) "ADMIN"
GROUP --OID=170526524 RSG Min 10% Max 100% JobMax 0 (off) "ADM_GRP"
GROUP --OID=144910001 RSG Min 50% Max 100% JobMax 0 (off) "RSG_PERFTEST"
GATEKEEPER:
Gatekeeper 0 [normal], up to 0 sec, queued 0, running 0 (max 2048)
GRA SCHED:
##### Current utilization will be here
SNIPPET SCHED: Avail Avail
Short Long InUse Max Delta Reserved
Host Memory 16384 15872 0 16384 0 512
Blade Memory 18499 16499 0 18499 0 2000
Channels 100 100 0 100
Distributes 50 49 0 50 0 1
Spu2Hosts 100 100 0 100 0 0
Broadcasts 100 100 0 100 0 0
###########checck Running process utilization
[nz@XXXX]$ nz_responders
Cur Time Plan # Snippet Time S/P State Busy Dataslices ... SQL Username/Database
======== ======= ========= ========= ======= ==== ==================== ======================================== ====================
11:46:45
11:46:55
11:47:05
11:47:15
No comments:
Post a Comment