IBM Netezza System Administrator’s Guide Administrator
User Manual:
Open the PDF directly: View PDF
Page Count: 550 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Preface
- Administration Overview
- Installing the Netezza Client Software
- Using the Netezza Administration Interfaces
- Netezza CLI Overview
- SQL Command Overview
- NzAdmin Tool Overview
- Client Compatibility
- Starting the NzAdmin Tool
- Logging In to NzAdmin
- Connecting to the Netezza System
- Displaying System Components
- Interpreting the Color Status Indicators
- Main Menu Commands
- Using the NzAdmin Tool Hyperlinks
- Administration Commands
- Setting Automatic Refresh
- Controlling NzAdmin Session Termination
- Web Admin Overview
- Managing Netezza HA Systems
- Linux-HA and DRBD Overview
- Differences with the Previous Netezza HA Solution
- Linux-HA Administration
- Heartbeat Configuration
- CIB
- Important Information about Host 1 and Host 2
- Managing Failover Timers
- Netezza Cluster Management Scripts
- Identifying the Active and Standby Nodes
- Monitoring the Cluster and Resource Group Status
- nps Resource Group
- Failover Criteria
- Relocate to the Standby Node
- Safe Manual Control of the Hosts (And Heartbeat)
- Transition to Maintenance (Non-Heartbeat) Mode
- Transitioning from Maintenance to Clustering Mode
- Cluster Manager Events
- Logging and Messages
- DRBD Administration
- Administration Reference and Troubleshooting
- IP Address Requirements
- Forcing Heartbeat to Shutdown
- Shutting Down Heartbeat on Both Nodes without Causing Relocate
- Restarting Heartbeat after Maintenance Network Issues
- Resolving Configuration Problems
- Fixed a Problem, but crm_mon Still Shows Failed Items
- Output From crm_mon Does Not Show the nps Resource Group
- Linux Users and Groups Required for HA
- Checking for User Sessions and Activity
- Managing the Netezza Hardware
- Netezza Hardware Components
- Hardware Management Tasks
- Managing Data Slices
- Automatic Query and Load Continuation
- Power Procedures
- PDU and Circuit Breakers Overview
- Powering On the IBM Netezza 1000 and IBM PureData System for Analytics N1001
- Powering Off the IBM Netezza 1000 or IBM PureData System for Analytics N1001
- Powering on an IBM Netezza C1000 System
- Powering off an IBM Netezza C1000 System
- NEC InfoFrame DWH PDU and Circuit Breakers Overview
- Powering On the NEC InfoFrame DWH Appliance
- Powering Off an NEC InfoFrame DWH Appliance
- Managing the Netezza Server
- Software Revision Levels
- System States
- Managing the System State
- System Errors
- System Logs
- System Configuration
- Managing Event Rules
- Template Event Rules
- Managing Event Rules
- Copying a Template Event to Create an Event Rule
- Copying and Modifying a User-Defined Event Rule
- Generating an Event
- Deleting an Event Rule
- Disabling an Event Rule
- Adding an Event Rule
- Specifying the Event Match Criteria
- Specifying the Event Rule Attributes
- Specifying the Notification
- The sendMail.cfg File
- Aggregating Event E-mail Messages
- Creating a Custom Event Rule
- Template Event Reference
- Specifying System State Changes
- Hardware Service Requested
- Hardware Needs Attention
- Hardware Path Down
- Hardware Restarted
- Specifying Disk Space Threshold Notification
- Specifying Runaway Query Notification
- Monitoring the System State
- Monitoring for Disk Predictive Failure Errors
- Monitoring for ECC Errors
- Monitoring Regeneration Errors
- Monitoring Disk Errors
- Monitoring Hardware Temperature
- Monitoring System Temperature
- Query History Events
- Monitoring SPU Cores
- Monitoring Voltage Faults
- Monitoring Transaction Limits
- Switch Port Events
- Reachability and Availability Events
- Event Types Reference
- Displaying Alerts
- Establishing Security and Access Control
- Netezza Database Users and Groups
- Develop an Access Model
- Default Netezza Groups and Users
- Choosing a User Authentication Method
- Configuring Password Content Controls and Expiration
- Creating Netezza Database Users
- Altering Netezza Database Users
- Deleting Netezza Database Users
- Creating Netezza Database Groups
- Altering Netezza Database Groups
- Deleting Netezza Database Groups
- Security Model
- Logon Authentication
- Netezza Client Encryption and Security
- Setting User and Group Limits
- Logging Netezza SQL Information
- Group Public Views
- Netezza Database Users and Groups
- Managing User Content on the Netezza Appliance
- Creating Databases and User Tables
- Creating Distribution Keys
- Avoiding Data Skew
- Using Clustered Base Tables
- Updating Database Statistics
- Grooming Tables
- Managing Sessions
- Running Transactions
- Netezza Optimizer and Query Plans
- Viewing Query Status and History
- Backing Up and Restoring Databases
- General Information on Backup and Restore Methods
- Overview
- Database Completeness
- Portability
- Compression in Backups and Restores
- Multi-Stream Backup
- Special Columns
- Upgrade/Downgrade Concerns
- Compressed Unload and Reload
- Encryption Key Management in Backup and Restore
- Filesystem Connector for Backup and Recovery
- Third-Party Backup and Recovery Solutions Support
- Host Backup and Restore
- Using the nzbackup Command
- Using the nzrestore Command
- Using the Symantec NetBackup Connector
- Using the IBM Tivoli Storage Manager Connector
- About the Tivoli Backup Integration
- Configuring the Netezza Host
- Configuring the Tivoli Storage Manager Server
- Special Considerations for Large Databases
- Running nzbackup and nzrestore with the TSM Connector
- Host Backup and Restore to the TSM Server
- Backing up and Restoring Data Using the TSM Interfaces
- Troubleshooting
- Using the EMC NetWorker Connector
- NetWorker Troubleshooting
- General Information on Backup and Restore Methods
- Query History Collection and Reporting
- Query History Concepts
- Query History Loading Process
- Disabling History Collection
- Changing the Owner of a History Database
- Changing Query History Configuration Settings
- Displaying Query History Configuration Settings
- Dropping History Configurations
- Query History Event Notifications
- Managing History Configurations Using NzAdmin
- Query History Views and User Tables
- Query History and Audit History Views
- _v_querystatus
- _v_planstatus
- $v_hist_queries
- $v_hist_successful_queries and $v_hist_unsuccessful_queries
- $v_hist_incomplete_queries
- $v_hist_table_access_stats
- $v_hist_column_access_stats
- $v_hist_log_events
- $hist_version
- $hist_nps_$SCHEMA_VERSION
- $hist_log_entry_$SCHEMA_VERSION
- $hist_failed_authentication_$SCHEMA_VERSION
- $hist_session_prolog_$SCHEMA_VERSION
- $hist_session_epilog_$SCHEMA_VERSION
- $hist_query_prolog_$SCHEMA_VERSION
- $hist_query_epilog_$SCHEMA_VERSION
- $hist_query_overflow_$SCHEMA_VERSION
- $hist_service_$SCHEMA_VERSION
- $hist_state_change_$SCHEMA_VERSION
- $hist_table_access_$SCHEMA_VERSION
- $hist_column_access_$SCHEMA_VERSION
- $hist_plan_prolog_$SCHEMA_VERSION
- $hist_plan_epilog_$SCHEMA_VERSION
- History Table Helper Functions
- Managing Workloads on the Netezza Appliance
- Overview
- Managing Short Query Bias
- Managing GRA
- Resource Percentages and System Resources
- Assigning Users to Resource Groups
- Resource Groups Example
- GRA Allocations Example
- Resource Allocations for the Admin User
- Allocations for Multiple Jobs in the Same Group
- Priority and GRA Resource Sharing
- Guaranteed Resource Allocation Settings
- Tracking GRA Compliance
- Monitoring Resource Utilization and Compliance
- Managing PQE
- Managing the Gate Keeper
- Displaying Netezza Statistics
- Managing the MantraVM Service
- Mantra Information
- Starting and Stopping the MantraVM Service
- Managing the MantraVM Service
- Displaying the MantraVM Service Configuration
- Displaying the MantraVM Service Version
- Enabling the MantraVM Service
- Disabling the MantraVM Service
- Setting the MantraVM IP Address
- Reconfiguring the MantraVM IP Addresses
- Configuring the MantraVM Monitoring Interfaces
- Displaying the MantraVM Monitoring Interfaces
- Accessing the Mantra Web Interface
- Troubleshooting
- Netezza CLI
- Linux Host Administration Reference
- Netezza User and System Views
- System Configuration File Settings
- Notices and Trademarks
- Glossary of Database and System Terms
- Index