Re: iSeries Navigator SQL Perf

[CRPence <CRPbottle@xxxxxxxxx>]

ibm wrote:
> In my Navigator I do not see "SQL Performance Monitors" per
> http://www.redbooks.ibm.com/redbooks/pdfs/sg246654.pdf
>
> I can "create a new SQL perf mon" but I can not view it.
>
> Any ideas?

  What VRM [version, release, modification] of the OpsNav and 
server are being used might be relevant.  The monitor was created 
using that OpNav client?

  What does "can not view it" mean?  Is there a particular diagram 
[number & page] in the referenced Redbooks document, and perhaps a 
particular line of text\graphic in that diagram that can be 
described as missing?

  Was security auditing turned on and the audit log information 
reviewed for any /authority failure/ logged violations?  I seem to 
recall there was a defect whereby a super-user needs to be the first 
to use the feature... Or that may have been for a different feature, 
but the symptom of not seeing an expected as available function is 
very likely to have origin as an authority issue.

  Probably good to review the joblog of the server job for the 
/create/ if the created monitor is not available to right-click and 
analyze.  There are some [mostly older] APARs and KB items for "SQL 
Performance monitor" on www-01.ibm.com that may be relevant.  For 
example:
http://www-01.ibm.com/support/docview.wss?uid=nas23c9501203e841ea186257157003ca32c
http://www-01.ibm.com/support/docview.wss?uid=nas1a908513fb84f345786257459006691ba

Regards, Chuck