Re: iNav

[Jim Oberholtzer <midrangel@xxxxxxxxxx>]

David,

As Pete suggested there is Systems Director Navigator to use and that is 
a great tool, but unfortunately that does not include one of the most 
important tools (nor will it due to the reliance on the Windows OS to do 
the graphics) the Database tools.  SQL scripts are but a very minor 
component of those tools that allow you to design, create, and manage 
DB/2 in a graphical environment.  A short list of the things you can do 
is mange constraints, check pending constraints, manage index rebuilds, 
SQL performance Monitors, SQL Plan cache tools and more.  Much of this 
can be done from a green screen but even for a command line zealot like 
myself, I find using the graphical tools much easier.  One of my more 
favorite parts is the ability to create a UML like database map that 
shows all the relationships between the database objects.  I hesitate to 
call it a Data flow Diagram but that is really what it is meant to 
mimic.    You can maintain that in other tools, (I use Enterprise 
Architect) but this one is included with the system.

If V6R1 is on your system, you already have the code needed, (it's 
stuffed into the IFS "/QIBM/ProdData/Access/Windows")  Run the 
cwblaunch.exe and it will take it from there.  If the PTFs on the system 
are current then the fix packs will already be installed, otherwise it's 
easy to get them from the internet.  both the 32bit and 64bit versions 
are there.

Jim Oberholtzer
CEO/Chief Technical Architect
Agile Technology Architects, LLC


On 12/6/2010 5:30 AM, David FOXWELL wrote:
> I can no longer execute sql scripts with iNav. I'm presuming that this is because of missing PTF or the wrong version of iNav. About iSeries Navigator shows Version 5 release 4 modification level 0. Our OS is V6R1. Is this compatible?
>
> As developers, we had to battle to get the right to use iNav as it was considered a tool for the system people only. Now, I find I'm only using it for working with spool files as little else works.
>
> I want to make a list to argue my case for upgrading this tool. What features of iNav would you consider most useful from a DEVELOPER's point of view?