User prompted for AS/400 log on when using Excel Add-in to upload data.
I have users that are uploading data to the AS/400 (V6R1) using the Excel Add-in. One user gets a log on pop up window each time she initiates the data transfer. Others in her same group do not. Where would I go to turn this off? She is logged on an AS/400 session and it [...]

Answer Question   |  March 13, 2013  7:29 PM
AS/400, IBM Client Access, iSeries Navigator, Microsoft Excel

Uploading PTF file from local PC to AS/400
Hi, I do not have access to iSeries Navigtor to make this transfer. I need some ways to transfer a PTF from local PC to AS/400.

Answer Question   |  February 13, 2013  4:21 PM
AS/400, iSeries Navigator, PTF

Unreadable spool file
Hi all, after I restore some objects on our dev machine using the backup from our prd. I did try to have a copy of the spool file as a report. I use iSeries Navigator to get it from my users spool but when double checking its content its looks like some kind of an [...]

Answer Question   |  February 4, 2013  11:48 AM
AS/400, AS/400 Spool Files, iSeries Navigator

How to use ‘Create index’ statement in iSeries Navigator
Hi, I’m having trouble when I’m using the iSeries navigator to run statements for creating indexes on a table. The create table statements work fine but when I try to create an index for the same table, I get errors and can’t seem to find out why. However, if I paste the same command on [...]

Answer Question   |  January 9, 2013  2:11 PM
AS/400, iSeries Navigator

What special authority required to access collection services in iSeries Navigator
Kindly let me know what special authority required to access collection services in iSeries Navigator(To pull graphs using iSeries Navigator in Collection services + Graph data)?

Answer Question   |  November 23, 2012  3:55 PM
AS/400 administration, iSeries administration, iSeries Navigator

how to configure iseries navigator with Windows 7(32bit)
     I was just issued a new pc desktop with Windows 7 as OS and im having a problem using i-Series Navigator. The iseries access version i have is version 5 release 3 Modification level 0 Service Level SI30707.I’m prompted with the message “Unable to complete the connection to central system 192.xxx.xxx.xxx“. This is when [...]

Answer Question   |  June 23, 2012  2:26 PM
iSeries, iSeries Navigator, Management Central

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 ? 

Answer Question   |  May 16, 2012  3:36 AM
AS/400, CPU, iSeries Navigator, Utilization

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

Answer Question   |  March 26, 2012  9:36 AM
iSeries Navigator, OS/400

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 server.) Note: How can i check the ” System i Access [...]

Answer Question   |  March 19, 2012  12:58 PM
AS400 iseries, iSeries Navigator

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

Answer Question   |  March 17, 2012  4:18 PM
iSeries Navigator

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 specific IP Connection (e.g. 192.102.10.10), other FUNCTIONS like WORK [...]

Answer Question   |  March 31, 2012  1:42 PM
iSeries 820, iSeries Navigator, V5R3

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…!

Answer Question   |  March 31, 2012  1:43 PM
iSeries Navigator, iSeries Navigator Application Administration, Server configuration, Server connectivity

iSeries Navigator
I just installed Client Access 5.2 on a Win XP PC (I am successfully tunning this level on other PCs with the same OS) and whenever I try to print in Navigator, CWBUNNAV.EXE “encounters a problem” and brings down Navigator. I need help.

Answer Question   |  May 26, 2011  3:35 PM
Client Access, iNavigator, iSeries, iSeries Navigator, Windows XP

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?

Answer Question   |  January 27, 2011  10:28 PM
AS/400, iSeries Access, iSeries Navigator, iSeries SQL, T-SQL

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 [...]

Answer Question   |  December 2, 2010  2:28 AM
AS/400 triggers, iSeries Navigator, SQL, Triggers

iSeries Navigator
how i can find iSeries navigator users. is there any EXIT programe or can use any CL for this.

Answer Question   |  November 26, 2010  11:58 AM
AS400 iSeries Navigator, CL Program, CL programming, iSeries Navigator

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.

Answer Question   |  August 20, 2010  4:46 PM
Ad Hoc, iSeries Navigator, SQL Query, SQL Scripting

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

Answer Question   |  July 27, 2010  2:22 PM
AS400 QINTER, iSeries Navigator, QINTER, V5R4

Monitor the AS400
I just found on the iSeries Navigator a way to monitor my Qbatch and Qinter for MSGW. But how can I monitor for when the AS400 goes down? Or at least no one would be able to log in. The QINTER is down…

Answer Question   |  July 28, 2010  2:42 PM
AS/400, AS/400 Monitoring, iSeries Navigator, QINTER

System i Navigator connection error to Central Management System.
I am getting an error message in System i Navigator when I try to connect to Central Management System. “Unable to complete the connection to central system `system name`”. I am trying to retreive the System Operator Messages. Also under Basic Operations – Messages click on the bottom panel on View System Operator Messages, nothing [...]

Answer Question   |  June 16, 2010  4:44 PM
AS/400, i5, iNavigator, iSeries Navigator, iSeries Navigator Application Administration