Netezza Performance Server

 View Only
  • 1.  Disk issues check

    Posted Mon January 08, 2024 10:25 AM
    Edited by Andres Parada Mon January 08, 2024 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 Sun January 14, 2024 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
    ------------------------------