IBM Support

Disk mpath issues reported on PureData System for Analytics

Troubleshooting


Problem

Resolving mpath issues present in nzhealthcheck report.

Symptom

Health check contains entry similar to the following excerpt:

Rule            : SHC106
Issue Detected  : Disk path was not optimal
Severity        : Low
Components      : spa1.spu1.disk[enclosure7.slot9] (from nzmpath) - SPU was not using preferred path to disk on 2015-12-03 08:31:26
                 spa1.spu1.disk[enclosure10.slot9] (from nzmpath) - SPU was not using preferred path to disk on 2015-12-03 08:31:26


Expert's Advice :

Multipath allows SPU to access each disk using more than one path, so that when one path fails, the disk can still be used.
However, in some cases, the cost of using this additional (not preferred) path may be bigger, and therefore it may impact system performance.
Also, if some paths are not enabled (broken) then overall system fault tolerance is decreased, even if it does not impact its performance.

Report the issue to IBM Netezza Support.

 

Diagnosing The Problem

Run following command to confirm if there are any current mpath issues:

$ nzpush -a mpath -issues

Resolving The Problem


There are two kinds of mpath issues. An issue is reported when preferred path is not set or when path count is set to one.


If, PrefPath=No, then we can try the following workaround:

$ nzpush -a mpath dm -r
###wait 2-3 mins
$ nzpush -a mpath -issues

Otherwise if PrefCount=1, then you need to plan an outage to run the following:

$ nzhw -issues
###if no issues
$ nzstop

##Become root
#/nzlocal/scripts/rpc/spapwr.sh -off all
#/nzlocal/scripts/rpc/spapwr.sh -on all

# su - nz

$ nzstart

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2019

UID

swg21975671