The IBM Database Assistant just got more powerful: database administrators can now use natural language to retrieve key performance insights, including database statistics, query response times and query throughput. Additionally, the assistant can identify tables or views with updated or outdated statistics, helping you maintain optimal database performance with minimal effort.
A new set of built-in skills makes navigation even easier. Just ask the assistant to take you directly to specific pages within the Db2 web console, saving you time and clicks. For example, jump straight to the SQL Editor by saying, "Take me to the SQL Editor page."
New capabilities in IBM Database Assistant
Action: Get database performance statistics
Example prompt phases:
- How is my database performing today?
- Show me database performance stats for the past week
- db performance from 2nd January 2025 to 7 January 2025
Action: Navigate directly to a specific page within the Db2 web console
Example prompt phases:
- Take me to the monitoring profile settings
- Open my authorization settings
- Show me the locking event monitor page
- Navigate to SQL editor page
Action: Get information about query processing rates and throughput
Example prompt phases:
- Get query throughput
- How many rows have been read in the last hour?
- What is the query processing rate from the last 2 hours?
- What is the query throughput of the system from 2am to 4am?
Action: Get information about query response times
Example prompt phases:
- Tell me how the overall query responsiveness is at the system level.
- Query response time from 1pm to 4pm
- Give me a summary of Query response times
- Show me query response times
Action: Get information about tables or schemas that have updated statistics
Example prompt phases:
- Get updated statistics
- Show me updated stats for the schema schema-name-1 with at least 30% row changes
- Get updated stats for the schema schema-name-1 with row changes of 20% or more in the last 5 hours
Action: Get information about tables or schemas that have outdated statistics
Example prompt phases:
- Get a list of tables in the schema schema-name-1 that have outdated stats
- Get the outdated stats for the schema schema-name-1 with at least 30% row changes
- Give me list of tables that have outdated stats in the last 2 hours
Further enhancements
In addition to the above new capabilities, a new set of built-in enhancements make it even more user-friendly.
- Export Capability: Each query in the tabular list under Show me running queries can now be exported.
- Embedded Chat Interface: The assistant is now fully integrated into the console for a smoother user experience, replacing the previous pop-up chat window.
IBM Database Assistant is available on Db2 on Cloud and Db2 Warehouse on Cloud. Try the Database Assistant today: IBM Database Assistant. For full details on capabilities, refer to the IBM Db2 Warehouse on Cloud documentation.
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online