Managing your IBM Netezza®️ appliances just got a whole lot easier!
Smart Management Frameworks (SMF) automates processes to improve the performance, availability, recoverability, and security of IBM Pure Data for Analytics/Netezza Performance Server systems - whether on premise or in the cloud.
Works with any kind of storage media (including NFS, Spectrum Scale, SAN/NAS, etc.) across multiple sites
Bi-directional, multi-master in nature (from anywhere to anywhere, including multiple targets replicated from the same backup source, or the restoration target being on the same physical appliance as the backup source itself)
Backup/restore increments can be as frequent as you like (from minutes to days). Multiple different concurrent backup sets supported per appliance
Can backup/restore subsets of tables within a database (and even subsets of rows within a table)
Ideal for Disaster Recovery, as well as Development/Test database population using sampled referentially intact subsets of production data
Active Directory/LDAP Synchronisation Features
Dynamic creation/dropping of database users and groups based on synchronised Active Directory/LDAP master data
Automatic addition/removal of users to/from groups, as well as granting/revoking of permissions to/from groups
Performance Tuning Features
Automatically and regularly identifies relatively poorly performing query workloads based on configurable settings such as query frequency, queue time, latency, and throughput
Extracts and parses execution plans of problem queries to identify underlying causes of poor performance
Provides recommendations on how to resolve performance issues
Dynamically generates code to implement accepted recommendations
Advanced Security Features
Provides row and column-level access control security model for both users and groups
Dynamically creates views that automatically either reveal or obscure secure row/column values when queried, depending on the user performing the query, the permission groups they belong to, and the contents of the column-level access control security model
Automatically rebuilds or drops views when the underlying base table’s schema changes or is dropped
Automatically re-synchronises column-level user/group permissions with LDAP master
Assists with the management and application of security levels, categories, and cohort security labels
Dynamically builds row secure tables, and applies security labels to their contents, based on parameter settings and configurable matching rules
Dynamically generates, schedules, executes, and logs a variety of system management tasks essential for consistently optimal query performance
GROOMS versions of altered tables, as well as changed/deleted rows in the most performant way. Automatically detects when RECORDS ALL is needed e.g. as a result of a changed ORGANIZE ON setting
Generates statistics for only the tables whose contents have changed since the last time it was run
Disconnects idle sessions outside of permitted hours of service and performs online vacuums against the system catalog host database. Can optionally schedule a service window for periodic ‘manual’ vacuums also
If you would like more information, contact us here and we'll get in touch.
To download the Smart Management Frameworks brochure, click here. To see the Active Directory Synchronisation Intro Video, click here.