Using the Netezza database assistant
Chat with the IBM Netezza database assistant to help you complete tasks, find out about your system status and statistics, or ask general questions about Netezza.
Open the database assistant from the Netezza web console, and then ask it to help you with a range of Netezza tasks, including:
- Answering your questions about Netezza
- Monitoring your Netezza instance, including getting information about:
- Active connections
- SQL activity
- Resource usage
- Schemas, databases, and tables in the system
- Users
- Backups
- Compute scaling
- Storage scaling
The database assistant uses built-in skills and is trained on the official IBM Netezza documentation so that it can provide you with the most accurate responses.
Starting the database assistant
To get started with the database assistant:
-
Open the Netezza web console.
-
Click the database assistant chat icon.
If the chatbot is not visible, go to Settings > Additional features and enable the Database assistant option.
- Type your questions and requests in the chat.
What can the database assistant do?
You can ask the database assistant to complete the actions listed in the following table.
Depending on the database workload, the database assistant might take some time to respond to certain prompts, such as requesting a database summary or getting details about the largest tables by storage size.
| No | Action | Example prompts |
|---|---|---|
| 1 | Show Instance Summary | Show me instance summary. What is the instance uptime? |
| 2 | List Tables | List tables for TESTDB11.SCH2. |
| 3 | List Views | List views for TESTDB11.SCH2 |
| 4 | List Schemas | List schemas in TESTDB11 |
| 5 | List Databases | List databases, Show databases |
| 6 | Show Backups | Show my backups, List backups |
| 7 | Total Storage Utilization | What is my storage utilization? Provide details on my storage usage |
| 8 | Show Instance State | Show instance status, Get status |
| 9 | Show CPU Usage | What is the host cpu usage in the last 4 hours. Get cpu usage from last Monday till last Wednesday |
| 10 | Show Memory Usage | Find out memory usage in the last 5 hours. Show memory usage in the last week |
| 11 | Show I/O Usage | Display I/O usage for the past 12 hours. What is the IO utilization over the last two weeks |
| 12 | Show Connections | List connections. Show connections |
| 13 | Show Active Queries | Show inflight sql queries. List running queries |
| 14 | Top N largest tables by storage | List top 10 tables largest tables. Provide list of largest tables by storage size |
| 15 | Get CRN | CRN? Get CRN |
| 16 | Get NPS hostname | What is my NPS hostname? Hostname? |
| 17 | Show Pause/Resume History | Show pause/resume history. Fetch pause-resume history |
| 18 | Show Scaling History | Show scaling history. Retrieve scaling history |
| 19 | Show Smart Scaling | Retrieve scaling demand growth. Provide me scaling prediction |
| 20 | Get System Version | What is current Netezza software version? Get my system version |
Troubleshooting the Netezza database assistant
If you find that you are not getting the answers and results that you expect from the Netezza database assistant, try one or more of the following troubleshooting strategies:
- Rephrase the question. The assistant might not understand your phrasing. Try using different wording, if possible.
- Restart the conversation. The assistant might be getting confused by other things you have discussed with it.
- Ensure that you are asking about Netezza. If you are asking about something else, it might be outside of the assistant's capabilities.
- Try asking about something specific. If your question is too broad, the assistant is more likely to return results that aren't relevant to your request.
Data privacy and opting out
When you interact with the Netezza database assistant, your questions and requests are processed by IBM watsonx Orchestrate, which is outside of your Netezza instance. All communications between IBM watsonx Orchestrate and your Netezza instance are encrypted.
To opt out of the Netezza database assistant, contact IBM Support.