IBM Support

Direction of IBM i Navigator, Navigator for IBM i and IBM i Access Client Solutions

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


Document information

More support for: IBM i
DB2 for IBM i

Software version: Version Independent

Operating system(s): IBM i

Reference #: N1019797

Modified date: 31 July 2017