Netezza Performance Server

Netezza Performance Server

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Disk issues check

    Posted 01/08/24 10:25 AM
    Edited by Andres Parada 01/08/24 10:55 AM

    Hi all,

    is there a way to forecast eventual disks issues/failures on NPS?

    The query I has on disk defetct are no longer working on this version,,is there a way also from the bare metal to foresee potential disk failures?
    a predict to understand.

    Thanks a lot in advance.

    Bye 
    Andrea



    ------------------------------
    Andrea Ceccotti
    ------------------------------



  • 2.  RE: Disk issues check

    Posted 01/14/24 05:37 AM

    Hi All,

    I kindly ask again if there is some way to predict any eventual/potential disk issues on NPS, some command/query performed from container node or phisical server to monitor the disk situation. Before once we had Mako we used this query but now is no more working ........

    Any suggestion/support wil be apprecieted

    Thanks in advamce.


    select
    hwid,rack,spuid,spa,encl,slot,
    grown_defects,
    uncor_read,uncor_write,uncor_verify,
    cor_write_delayed,cor_read_delayed,cor_verify_delayed,
    non_medium
    from v_scsi_disk
    where
    grown_defects > 1000
    or uncor_write > 1000
    or uncor_read > 1000
    or uncor_verify > 1000
    or cor_write_delayed > 50000
    or cor_read_delayed > 50000
    or cor_verify_delayed > 50000
    or non_medium > 50000
    order by
    rack, spa, encl, slot;



    ------------------------------
    Andrea Ceccotti
    ------------------------------