News
Abstract
This document will summarize the available DBA tools supported by IBM.
Content
This matrices have caveats:
- All future plans are subject to change, without notice.
- We appreciate hearing feedback directly from clients.
Database Navigator Product Overview:
| Products | IBM i Access for Windows | IBM i Access Client Solutions | IBM Navigator for i |
| Aliases | System i Navigator or IBM i Navigator | ACS | Navigator for i |
| Where does it run? | Windows PC Install | Anywhere Java can be used | Browser Served from IBM i 7.3, 7.2, & 7.1 |
| Recent service level? | IBM i Access Windows Service Pack 7.1 – SI62603 | Version 1.1.7.0 | IBM HTTP SERVER FOR i PTF Group: 7.3 - SF99722 Level 6 7.2 - SF99713 Level 19 7.1 - SF99368 Level 45 |
| Best of breed features | Schema folders and object actions Index Advisor, and more | Run SQL Scripts SQL Performance Center Visual Explain and more | PDI Perspectives Batch Modeling Historical Collection Services Data |
| Webpage to watch | www-03.ibm.com/systems/power/software/i/access/windows_sp.html | http://www-03.ibm.com/systems/power/software/i/access/solutions_support.html | http://www-01.ibm.com/support/docview.wss?uid=nas4SF99722 http://www-01.ibm.com/support/docview.wss?uid=nas4SF99713 http://www-01.ibm.com/support/docview.wss?uid=nas4SF99368 |
| Next (planned) Update | June, 2017 | July, 2017 -> Version 1.1.7.1 | New PTF Group every 2-3 months |
Database Navigator Feature Breakdown:
| Navigator Feature | IBM i ACS Version 1.1.5.0 (December/2015) | IBM i ACS Version 1.1.6.0 (August/2016) | IBM i ACS Version 1.1.7.0 (March/2017) / 1.1.7.1 (July 2017) |
| Run SQL Scripts | Initial/Partial support | Statement formatter, JDBC connection manager, and others | Add CL Prompter |
| Analyze | Initial/Full support | No changes needed | No changes needed |
| Graphical Debugger | Initial/Full support | No changes needed | No changes needed |
| Visual Explain | Not supported | Initial/Full support | No cross launch to Navigator for i |
| Show Statements | Not supported | Initial/Full support | No changes needed |
| Compare Monitors | Not supported | Initial/Full support | No changes needed |
| Schema Folders (and object actions) | Not supported | Not supported | Initial/Partial support |
| Table Action - View Content | Not supported | Not supported | Initial/Full support |
| Index Advisor | Not supported | Not supported | Initial/Partial support |
| DB2 Health Center | Not supported | Not supported | Initial/Full support (1.1.7.1) |
| View Journal Entries | Not supported | Not supported | Initial/Full support (1.1.7.1) |
| Below this line are those features that only exist within Navigator for i (browser) | |||
| Database Maintenance | Use Navigator for i | Use Navigator for i | Use Navigator for i |
| Transactions | Use Navigator for i | Use Navigator for i | Use Navigator for i |
| OmniFind Text Search | Use Navigator for i | Use Navigator for i | Use Navigator for i |
| Below this line are those database features that only exist within IBM i Access for Windows | |||
| Database Navigator Maps | Not supported | Not supported | Not supported |
| Table Actions - Edit Contents | Not supported | Not supported | Not supported |
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 for IBM i","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Document Information
Modified date:
18 December 2019
UID
nas8N1019797