The nzspupart command

Use the nzspupart command to display information about the SPU partitions on a system, including status information and the disks that support the partition.

Syntax

The nzspupart command has the following syntax:

nzspupart [-h|-rev] [-hc] subcmd [subcmd options]

Inputs

The nzspupart command takes the following inputs:

Table 1. The nzspupart input options
Input	Description
nzspupart show [options]	Displays information about the specified partitions. If you do not specify any options, the command displays a list of all partition and their ID, type, status, size, percent that is used, and supporting disks. You can specify one or more options to show specific output.
nzspupart regen [options] [-force]	Starts regeneration for SPU partitions. Starting from version 11.0.3.0, the `nzspupart` command is enabled to `regen` only specified data partitions. If you do not specify any options, the command searches for degraded partitions and starts regeneration processes to the available spare disks. Optionally, you can use the options -spu spuId, -part partId, and -dest diskHwId to specify source and target information for a specific regeneration. Include the -force option to start the regen without prompting you for a confirmation.
nzspupart listTypes	Displays a list of the valid hardware types that you can input for the nzspupart show -type `spuPartitionType` command.

Options

The nzspupart command takes the following options:

Table 2. The nzspupart options
Option	Description
-u `user`	Specifies the database user name [NZ_USER].
-pw `password`	Specifies the user password [NZ_PASSWORD].
-host `hostname`	Specifies the host name or IP address of the Netezza Performance Server system.
-caCertFile `path`	Specifies the path name of the root CA certificate file on the client system. This argument is used by Netezza Performance Server clients who use peer authentication to verify the Netezza Performance Server host system. The default value is NULL, which skips the peer authentication process.
-securityLevel `level`	Specifies the security level that you want to use for the session. This option does not apply when you are logged in to the Netezza Performance Server system and running the command. The argument has four values: preferredUnSecured This value is the default value. Specify this option when you would prefer an unsecured connection, but you accept a secured connection if the Netezza Performance Server system requires one. preferredSecured Specify this option when you want a secured connection to the Netezza Performance Server system, but you accept an unsecured connection if the Netezza Performance Server system is configured to use only unsecured connections. onlyUnSecured Specify this option when you want an unsecured connection to the Netezza Performance Server system. If the Netezza Performance Server system requires a secured connection, the connection is rejected. onlySecured Specify this option when you want a secured connection to the Netezza Performance Server system. If the Netezza Performance Server system accepts only unsecured connections, or if you are attempting to connect to a Netezza Performance Server system that is running a release before 4.5, the connection is rejected.
-timeout `seconds`	Specifies the amount of time in seconds to wait for the command to complete before it exits with a timeout error. Default is 300.
-id `hwId`	Displays information about the partitions that are supported by a SPU or disk with the specified hardware ID.
-spa `id`	Displays information about the hardware components in the SPA with the specified ID.
-detail	Displays more information about the partitions.
-issues	Displays information about partitions that have issues.
-type `spuPartitionType`	Displays information about specific types of partitions. The types include data, nzlocal, swap, and log.
-regenStatus	Displays information about regenerations that are in progress.
-spare	Displays list of available spare partitions.

Description

The nzspupart command has the following description.

Privileges required: You must specify a database user account that has Manage Hardware privilege.
Common tasks: Use the nzspupart command to display information about the SPU partitions of a Netezza Performance Server system, or to perform a partition regeneration when th partition is degraded. You can use the command to obtain status about the partitions and the space that is used within them, whether regenerations are in progress, or if there are issues that require your attention.

Related Commands: Use with other system commands, such as the nzhw and nzds commands.

Usage

The following provides some sample usage:

To display information about the SPU partitions, enter:

nzspupart
SPU  Partition Id Partition Type Status  Size (GiB) % Used Supporting Disks
---- ------------ -------------- ------- ---------- ------ -------------------------------
1021 0            Data           Healthy 178        4.68   1068,1098
1021 1            Data           Healthy 178        4.67   1068,1099
1021 2            Data           Healthy 178        4.70   1073,1100
1021 3            Data           Healthy 178        4.69   1084,1098
1021 4            Data           Healthy 178        4.68   1063,1099
1021 5            Data           Healthy 178        4.67   1094,1100
1021 6            Data           Healthy 178        4.67   1069,1098
1021 7            Data           Healthy 178        4.67   1074,1099
1021 8            Data           Healthy 178        4.67   1080,1100
1021 9            Data           Healthy 178        4.66   1085,1098
1021 10           Data           Healthy 178        4.67   1084,1098
1021 11           Data           Healthy 178        4.66   1069,1099
1021 12           Data           Healthy 178        4.72   1065,1100
1021 13           Data           Healthy 178        4.67   1075,1098
1021 14           Data           Healthy 178        4.67   1081,1099
1021 15           Data           Healthy 178        4.67   1086,1100
1021 16           Data           Healthy 178        4.68   1096,1098
1021 17           Data           Healthy 178        4.71   1066,1099
1021 18           Data           Healthy 178        4.67   1071,1100
1021 19           Data           Healthy 178        4.68   1076,1100
1021 20           Data           Healthy 178        5.56   1063,1098
1021 21           Data           Healthy 178        4.66   1063,1099
1021 22           Data           Healthy 178        4.68   1085,1100
1021 100          NzLocal        Healthy 4292       0.00   1098,1099,1100,1101

To display a list of available spare partitions, enter:

nzspupart -spare
SPA SPU Id SPU Name  Disk Id Disk Role Disk Serial        PartitionID Role
--- ------ --------- ------- --------- ------------------ ----------- -----
1   1005   spa1.spu1 1013    Active    PHLE8221017L3P2EGN 14          SPARE
1   1005   spa1.spu1 1013    Active    PHLE8221017L3P2EGN 15          SPARE
1   1005   spa1.spu1 1014    Active    PHLE822100H53P2EGN 14          SPARE
1   1005   spa1.spu1 1014    Active    PHLE822100H53P2EGN 15          SPARE
1   1005   spa1.spu1 1015    Active    PHLE822100XB3P2EGN 14          SPARE
1   1005   spa1.spu1 1015    Active    PHLE822100XB3P2EGN 15          SPARE
1   1005   spa1.spu1 1016    Active    PHLE833500KV3P2EGN 14          SPARE
1   1005   spa1.spu1 1016    Active    PHLE833500KV3P2EGN 15          SPARE
1   1006   spa1.spu2 1018    Active    PHLE833500KC3P2EGN 14          SPARE
1   1006   spa1.spu2 1018    Active    PHLE833500KC3P2EGN 15          SPARE
1   1006   spa1.spu2 1019    Active    PHLE833500GB3P2EGN 14          SPARE
1   1006   spa1.spu2 1019    Active    PHLE833500GB3P2EGN 15          SPARE
1   1006   spa1.spu2 1020    Active    PHLE833500K33P2EGN 14          SPARE
1   1006   spa1.spu2 1020    Active    PHLE833500K33P2EGN 15          SPARE
1   1006   spa1.spu2 1021    Active    PHLE822100XG3P2EGN 15          SPARE
1   1007   spa1.spu3 1023    Active    PHLE822100R33P2EGN 14          SPARE
1   1007   spa1.spu3 1023    Active    PHLE822100R33P2EGN 15          SPARE
1   1007   spa1.spu3 1024    Active    PHLE822100SN3P2EGN 14          SPARE
1   1007   spa1.spu3 1024    Active    PHLE822100SN3P2EGN 15          SPARE
1   1007   spa1.spu3 1025    Active    PHLE822100UK3P2EGN 14          SPARE
1   1007   spa1.spu3 1025    Active    PHLE822100UK3P2EGN 15          SPARE
1   1007   spa1.spu3 1026    Active    PHLE822102203P2EGN 15          SPARE
1   1008   spa1.spu4 1028    Active    PHLE822102843P2EGN 14          SPARE
1   1008   spa1.spu4 1028    Active    PHLE822102843P2EGN 15          SPARE
1   1008   spa1.spu4 1029    Active    PHLE822100YH3P2EGN 14          SPARE
1   1008   spa1.spu4 1029    Active    PHLE822100YH3P2EGN 15          SPARE
1   1008   spa1.spu4 1030    Active    PHLE8221027G3P2EGN 14          SPARE
1   1008   spa1.spu4 1030    Active    PHLE8221027G3P2EGN 15          SPARE
1   1008   spa1.spu4 1031    Active    PHLE8221022J3P2EGN 15          SPARE
1   1009   spa1.spu5 1033    Active    PHLE822100XF3P2EGN 14          SPARE
1   1009   spa1.spu5 1033    Active    PHLE822100XF3P2EGN 15          SPARE
1   1009   spa1.spu5 1034    Active    PHLE8221017P3P2EGN 14          SPARE
1   1009   spa1.spu5 1034    Active    PHLE8221017P3P2EGN 15          SPARE
1   1009   spa1.spu5 1035    Active    PHLE833500F43P2EGN 14          SPARE
1   1009   spa1.spu5 1035    Active    PHLE833500F43P2EGN 15          SPARE
1   1009   spa1.spu5 1036    Active    PHLE833500L03P2EGN 15          SPARE
1   1010   spa1.spu6 1038    Active    PHLE822100Z23P2EGN 14          SPARE
1   1010   spa1.spu6 1038    Active    PHLE822100Z23P2EGN 15          SPARE
1   1010   spa1.spu6 1039    Active    PHLE822100GF3P2EGN 14          SPARE
1   1010   spa1.spu6 1039    Active    PHLE822100GF3P2EGN 15          SPARE
1   1010   spa1.spu6 1040    Active    PHLE822102233P2EGN 14          SPARE
1   1010   spa1.spu6 1040    Active    PHLE822102233P2EGN 15          SPARE
1   1010   spa1.spu6 1041    Active    PHLE822101AS3P2EGN 15          SPARE
1   1011   spa1.spu7 1043    Active    PHLE822100QG3P2EGN 14          SPARE
1   1011   spa1.spu7 1043    Active    PHLE822100QG3P2EGN 15          SPARE
1   1011   spa1.spu7 1044    Active    PHLE8221017J3P2EGN 14          SPARE
1   1011   spa1.spu7 1044    Active    PHLE8221017J3P2EGN 15          SPARE
1   1011   spa1.spu7 1045    Active    PHLE822100QZ3P2EGN 14          SPARE
1   1011   spa1.spu7 1045    Active    PHLE822100QZ3P2EGN 15          SPARE
1   1011   spa1.spu7 1046    Active    PHLE822100FR3P2EGN 15          SPARE