The summary of note worthy features of new Netezza NPS Release 7.2.1.3 (as of Feb 2017)
Refer do IBM Release notes:
New feature
|
Why it's good ?
|
Examples
|
| In-memory external tables | Reduced catalog growth and contention. | |
| Table-oriented zone maps | Improved incremental loads to a table | |
| New nzload -merge option | Less steps in ETL | |
New SQL commands:
| More tools in developers toolkit | |
| Reduced time requirements for major upgrades | Shorter system downtime |
New features in General Purpose Scripts Toolkit Version: 7.2 (2016-07-04) in /nz/support/bin/***
| Script Name | New Option(s) | Comments |
| nz_csv | New script to dump out tables in in CSV format | |
| nz_ddl_all_grants | New script to dump out all GRANT statements across all databases | |
| nz_ddl_diff | -ignoreQuotes | Ignore quotes and case in object names/DDL |
| nz_genstats | -default | Have the system decide the default type of statistics to be generated |
| nz_groom | -scan+records -brief | Perform a table scan + record level groom of the table (if needed) |
| Limit the output to only tables that are considered "groom worthy" | ||
| nz_health | Includes output from the nznpssysrevs command | |
| Includes output about the frequency/usage of the nz_*** scripts | ||
| nz_migrate | -fillRecord -truncString | Treat missing trailing input fields as null |
| Truncate any string value that exceeds its declared storage | ||
| nz_plan | After each table ScanNode, show what is done with that data set | |
| nz_rerandomize | New script to re-randomize the rows in a randomly distributed table | |
| nz_scan_table_extents | New script to scan 1 table ... 1 dataslice ... 1 extent at a time | |
| nz_zonemap | Include additional information with the existing "-info" option |
No comments:
Post a Comment