RE: IBM i Access for Web - Not yet a replacement for Navigator

Years back, 2006, (before SSD arrived and I had some serious disk issues)
With guidance from IBM performance support
Using OpsNav Management Central, I setup a Disk Response monitor,
Collection interval of 30 seconds,
Threshold 1 with a trigger
Operating system command - Call STRPEXCL parm('&VAL')

PENCOR05 Monitor Pencor05 Disk exceeded threshold 50 for 1 interval(s); current value is 71 at 082409 - 153700

This was awesome.
Gathered perf data automatically and alerted me that the disks were busy.

One of the recent OS upgrades may have changed something.
The monitor is still there, but Threshold 1 is greyed out.


STRPEXCL

0045.00 CRTLIB LIB(&LIB) TEXT(&LIBDESC)
0046.00 CRTSAVF FILE(QGPL/&LIB) TEXT(&LIBDESC)
0047.00
0048.00 SNDMSG MSG('Monitor Pencor05 Disk exceeded +
0049.00 threshold for 1 interval(s); current value is ' +
0050.00 *CAT &VAL *TCAT ' at ' *CAT &DATE *TCAT ' - ' *CAT &TIME ) +
0051.00 MSGTYPE(*INFO) TOMSGQ(QSYSOPR)
0052.00
0053.00 /* QIDRPA/STRPACOL COLLECTION(BUSYDRIVES) +
0054.00 PROBLEM(*PDIO_TIME) DURATION(1) +
0055.00 MAXDATA(4000000) DATALIB(&LIB) +
0056.00 CPUSAMPLE(200) JOBQ(QCTL) JOBQLIB(*LIBL) +
0057.00 CVTPEX(Y) NBRTHD(*CALC) ENDPEXPTY(51) +
0058.00 PEXFTR(*NONE) WRAPTRC(*STOPTRC) TEXT('') +
0059.00 ADDEVTS(*SAREVTS) /* test */
0060.00 /* MONMSG MSGID(CPF0000) /* t */

Paul



-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Matt Olson
Sent: Wednesday, August 19, 2015 10:36 AM
To: Midrange Systems Technical Discussion
Subject: RE: IBM i Access for Web - Not yet a replacement for Navigator

Some, but not all. Need my visual explain so I can analyze poorly performing querys!


-----Original Message-----
From: Keith McCully [mailto:keithmccully@xxxxxxxxx]
Sent: Tuesday, August 18, 2015 12:24 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: IBM i Access for Web - Not yet a replacement for Navigator

Some of the SQL facilities mentioned are covered by RDi SQL plug in assuming that's supported by Windows 10.
On 18 Aug 2015 18:02, "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx> wrote:

1) Drag and drop spoolfiles.
2) Specific object BRMS omits

Two items that can't be done in green screen.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
rob@xxxxxxxxx
Sent: Tuesday, August 18, 2015 12:42 PM
To: Midrange Systems Technical Discussion
Subject: Re: IBM i Access for Web - Not yet a replacement for
Navigator

The main thing I use iNav for is Management Central, to view
performance on multiple systems.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Matt Olson <Matt.Olson@xxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 08/14/2015 10:55 AM
Subject: IBM i Access for Web - Not yet a replacement for Navigator
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Since iSeries Navigator is no longer supported on Windows 10 or above
(it is discontinued) IBM is now touting IBM I Access for Web as the
replacement.

However there seems to be many deficiencies in the product such as:


1. Database Interaction

a. How to list "All Objects" in the database

b. How to view and create constraints using a GUI

c. How to view and create functions using a GUI

d. How to view and create Indexes using a GUI

e. Viewing journal recievers in a library and viewing the entries and
other management functions of journal receivers

f. Viewing stored procedures, editing stored procedure definitions
within a GUI

g. Viewing / creating SQL Packages

h. Viewing / Creating triggers

i. Viewing / Creating SQL Types

j. Viewing / Creating Views

2. Users and Groups

a. No Group or all users viewing

3. No Visual Explain

4. No index tuning


Anyone able to get rid of navigator yet?

Matt
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.