• CPU Utilization

    How do We Segregate CPU utilization report based on Interactive(Avg,MIN,MAX) and Batch(AVG,INT,MAX) Utilization report..? Is it Possible with iSeries Navigaor? Based on the results i've to do Capacity Management ? Please suggest me if we have any third party tool for that ? 

    qmaster1,675 pointsBadges:
  • Add multiple connection’s in iSeries Navigator in single attempt.

    I need to add 90 iSeries Server connection's in iSeries Navigator ...How can i add multiple connections to iSeries navigator in single attempt...?  I have IP address for all boxes...!

    Harish.kuolkhere190 pointsBadges:
  • Complete installation of Function Availability in iSeries Navigator

    Sir :        How do i complete the installation of additional FUNCTION AVAILABILITY under MANAGEMENT CENTRAL in iSeries Navigator since the function i need like MONITORS (i need this for the statistics) is labeled as NOT INSTALLED. This is also noticeable in My Connections where under a...

    danmd5systemad370 pointsBadges:
  • ISeries Navigator

    Hi, I am a DB2 DBA coming from zSeries to iseries. I have iSeries Navigator , when I click on "Database task"  "Map the database"nothing happens. Is there somewhere I can check for an error message or do I have to load an addon?     Regards   Wendy

    WendyB95 pointsBadges:
  • Access to iSeries server using iSeries Navigator.

    Getting error while accessing iSeries server using iSeries Navigator. Error Details: "system i Navigator was unable to determine which new components 00.00.00.00 is capable of supporting. Refer to the system i Access History Log for more Information." (Where 00.00.00.00 is the IP address of...

    Harish.kuolkhere190 pointsBadges:
  • ISERIES navigator

    How do I create an automated process to take a spool file and convert to PDF and email out?

    GeekComputer5 pointsBadges:
  • I-series Navigator Database access

    I have Client access loaded on my Laptop and have recently loaded the Database facility into Navigator. It loaded okay with no errors, Client Access is V5R4M0 and the I-series is V5R4M5. My Problem is that when I go into Navigator and connect to the I-series and try to expand the database tree it...

    RobertHart225 pointsBadges:
  • iSeries SQL ISNULL Equivalent

    What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

    Jaggerdude60 pointsBadges:
  • Create trigger using iSeries Navigator

    I am trying to ceate a simple trigger to a table to update a history file with the old rate when the rate changes in the master table. I have gone as far as creating the sql statement, but I am not able to make it to work (my sql is very limitted). Would it be possible to have some example that I...

    Myhandle5405 pointsBadges:
  • Database Issues – Trying to prove that something has to be done

    Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major...

    Dcantwell470 pointsBadges:
  • iSeries Navigator SQL Script Output

    I'm not familiar with CL but is there an easy way to direct the output of an adhoc SQL query in iSeries Navigator into a CSV file in my local Windows drive? Thanks in advance.

    Jaggerdude60 pointsBadges:
  • iSeries Navigator viewing AFP files

    I've been using iSeries navigator for some time now to view AFP files - click on the spool file, get to see the spool file and it's overlay together, works great, saves lots of printing. Of a sudden, about a week ago - it stopped working. Now when I double click on a spool file, all I get is a...

    Renojim145 pointsBadges:
  • Monitor When QINTER is inactive

    What is a good way to moniter when QINTER is inactive? So if QINTER isn't up I need to know, since no one can log in at that point. I am using iSeries Navigator  VR5.4.0 THANKS

    Jaymz69765 pointsBadges:
  • Iseries navigator

    I am recieving a cwbunnav.exe error when i attempt to logon to navigator. I have ver5 rel3.

    Diego20 pointsBadges:
  • unable to start management central

    I was trying to start management central using the command STRTCPSVR *MGTC as the job QYPSSRV under QSYSWRK was not running which is supposed to be the job for management central. But when I tried that, I got the error TCP1A10. however, when I start it using iseries navigator it shows as started,...

    Srinivas naikk115 pointsBadges:
  • Is it possible for the monitor jobs to start automatically

    Is it possible for the monitor jobs to start automatically after ipl. We need to manually start the monitor jobs after every IPL. We have setup few monitor jobs under iseries navigator.  

    JohnsonMumbai1,160 pointsBadges:
  • Query Calculation Part of Select Criteria

    This query works great except I need to add one thing. There are two district codes that need to be included in the query. These codes just need the MC_Tax_Amount field totaled - no dividing by two. How do I add this to my query? Thank you, SELECT "T16.CPRP".CP_DISTRICT_CODE,...

    lorit365 pointsBadges:
  • Token Error in iSeries Navigator

    Help - what's wrong with my query: (Getting Token Error, From Into Clause) SELECT DISTINCT "T16.CPRP".CP_TOWNSHIP, "T16.CBL".CB_INTEREST_CITY MINUS ("T16.CBL".CB_TAXCOLL * .03) AS Interest, SUM ("T16.CTDT".TD_DETAIL_AMT_01) as Payments FROM QS36F."T16.CPRP" AS "T16.CPRP", QS36F."T16.CBL" AS...

    lorit365 pointsBadges:
  • iSeries Token Error

    Need help with this query - it will not run token error.  Here is the query: SELECT   SUM  ("T16.CTDT".TD_DETAIL_AMT_01 * .10) AS TOTAL, "T16.CPRP".CP_DISTRICT_CODE

    lorit365 pointsBadges:
  • iSeries Navigator Tool

    Hi, I am new to i Series Navigator Tool. Please can anyone suggest me a Video/WBT for for this. Many Thanks  

    Hugheswilliams345 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following