IBM PureData System for Analytics (Netezza) and Db2 CLI command compatibility
Most PureData® System for Analytics (Netezza®) CLI commands (nz* commands) do not have corresponding Db2® commands. In some cases, there's a different mechanism. In other cases, no equivalent is necessary.
| Netezza CLI command | Db2 support |
|---|---|
| nzbackup | In the Db2 managed service environment, backups are managed for you. |
| nzcontents | There is no Db2 equivalent. |
| nzconvert | For information about how to load data in a Db2 environment, see Loading your data. |
| nzds | The Db2 environment does not use data slices. |
| nzevent | Use a Db2 web console. |
| nzhistcleanupdb | The Db2 environment does not use a history database. To collect and view historical data about database usage, use the Db2 monitoring capabilities. |
| nzhistcreatedb | The Db2 environment does not use a history database. To collect and view historical data about database usage, use the Db2 monitoring capabilities. |
| nzhostbackup | In the Db2 managed service environment, backups are managed for you. |
| nzhostrestore | In the Db2 managed service environment, backups are managed for you. |
| nzhw | There is no Db2 equivalent. In the Db2 managed service environment, hardware is managed for you. |
| nzload | For information about how to load data in a Db2 environment, see Loading your data. |
| nzodbcsql | For information about defining and testing ODBC connections, see Connecting programmatically with ODBC or CLI. |
| nzpassword | Use a Db2 web console. |
| nzreclaim | For column-organized tables, reorganization is done automatically. For row-organized tables, use the REORG TABLE statement. |
| nzrestore | In the Db2 managed service environment, backups are managed for you. |
| nzrev | Use a Db2 web console or CLPPlus. |
| nzsession | Use a Db2 web console to obtain a list of connected applications. |
| nzspupart | The Db2 environment does not use SPUs. |
| nzsql | Use the dbsql command. For more information, see Overview of the support tools. |
| nzstart | The Db2 managed service is started automatically. |
| nzstate | Use a Db2 web console. |
| nzstats | Use a Db2 web console. |
| nzstop | It is not necessary to stop the Db2 managed service. |
| nzsystem | Use a Db2 web console. |