Wednesday, September 14, 2016

Check Resource utilization on IBM Netezza system

#################################################################################
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

3 comments:

  1. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor led live training in IBM Netezza, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on IBM Netezza. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/


    ReplyDelete
  2. The content is good and very informative and I personally thank you for sharing article on IBM Netezza DBA.

    ReplyDelete
  3. Thank you so much for sharing about Resource Utilization. It is such a nice blog to read. Keep sharing it.

    ReplyDelete