IBM PureData System for Analytics, Version 7.1

The nzspupart command

Use the nzspupart command to display information about the SPU partitions on an IBM® Netezza® 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. 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. The regen option is not supported on Netezza C1000appliances because the hardware controls regenerations.
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 system.
-caCertFile `path`	Specifies the path name of the root CA certificate file on the client system. This argument is used by IBM Netezza clients who use peer authentication to verify the Netezza 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. 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 system requires one. preferredSecured Specify this option when you want a secured connection to the Netezza system, but you accept an unsecured connection if the Netezza system is configured to use only unsecured connections. onlyUnSecured Specify this option when you want an unsecured connection to the Netezza system. If the Netezza system requires a secured connection, the connection is rejected. onlySecured Specify this option when you want a secured connection to the Netezza system. If the Netezza system accepts only unsecured connections, or if you are attempting to connect to a Netezza 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 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.

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 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
---- ------------ -------------- ------- ---------- ------ -------------------------------
1255 0            Data           Healthy 3725       0.00   1129,1151,1167
1255 1            Data           Healthy 3725       0.00   1126,1148,1169
1255 2            Data           Healthy 3725       0.00   1133,1150,1171
1255 3            Data           Healthy 3725       0.00   1132,1145,1170
1255 4            Data           Healthy 3725       0.00   1136,1137,1166
1255 5            Data           Healthy 3725       0.00   1146,1149,1175
1255 6            Data           Healthy 3725       0.00   1130,1153,1165
1255 7            Data           Healthy 3725       0.00   1131,1155,1173
1255 8            Data           Healthy 3725       0.00   1127,1152,1164
1255 100          NzLocal        Healthy 11150      0.00   1134,1135,1147,1154,1168,1172,1174
1255 101          Swap           Healthy 24         0.00   1134,1135,1147,1154,1168,1172,1174
1255 110          Log            Healthy 1          0.00   1134,1135,1147,1154,1168,1172,1174

To list the SPU partition types, enter:

nzspupart listTypes
Description Type
----------- -------
Data        data
NzLocal     nzlocal
Swap        swap
Log         log

To start a partition regeneration:
```
nzspupart regen
Are you sure you want to proceed (y|n)? [n] y
Info: Regen Configuration - Regen configured on SPA:1 Data slice 2
and 1
```
If there are no degraded partitions, the command outputs the message No degraded partitions. If the regen cannot proceed because there are no spare disks on the system, the command outputs the message No spares disks available.