ISeries Navigator

iSeries Navigator message monitor failing on endpoint system

After years of working very well, iSeries Nagivator (Ops Nav) refuses to monitor messags on an endpoint iSeries.  This is a recent development.  Its been working just fine on the endpoint in question for the last 3+ years.  The QYPSJSVR job log shows CPFB904 and CPFB905.  Both are running V5R4...

missing Host Application

I am manage several LPAR under OS/400 V5R4M0, at least three of them were created with restore from other one. In those LPARs I can see QIBM_EJB_PRODUCT tree into Host Applications option of Application Administration in iSeries Navigator. The original LPAR have it. The question is, how can I...

Convert to PDF

Please guide on how do we use Convert to PDF from i series navigator. We are on V5R4. Need the steps to be followed in order to convert a spool file to a pdf. What needs to be done in order to save it to a location on the PC.      

iSeries Navigator printed output

I can view my spool files on the iSeries using the wrksplf command, but not thru iSeriece Navigator. When I click on Printed Output the panel is blank. When I right-click on Printed Output and select Customize this view, all options except Auto Refresh are grayed-out.

UPDATE a year from an ISO date field using SQL

Dear Sir/Madam, How can I update the year from a date field. For example the date file contains '2008-12-31' and I would like to use I-Series navigator's SQL to update the date field above with '2007-11-31'.But my intention for the update here is to decrease/deduct the year by 1 year and the month...

Printer output not coming in iSeries Navigator

My Spools files generates by BPCS not showing in Printer Outputs of I-series Navigator. Plesae tell me the reason of this problem and give the solution how to resolve it. Software/Hardware used: AS/400 -BPCS

Difference between RMTCMD and REXEC

What are the major difference between RMTCMD and REXEC? I installed iSeries navigator in my PC and I am able to access both these commands.

Many jobs created with iSeries Nav collects inventory

Recently I installed iSeries Access service pak SI32972 on my PC. This includes updates to Navigator. Since the install, every time we collect inventory (fixes, users, etc) about 400 jobs are added to our iSeries. These jobs remain until we ENDTCPSVR *MGTC. These jobs also consume disk space...

ISeries Navigator - changing installation language Spanish -to- English

iSeries Navigator v5r3 Installed and set up using spanish language. Needs to be switched to have user interface in English. How can one possibly do it without uninstalling it ?

iSeries Navigator V5R3M0

Hi all, I have a DDS from a logical file on my system: A R I55120 PFILE(F55120) A K ICBOX A S ICSTAT COMP(EQ 'I') A ICTIPC COMP(EQ '1') How can I make this index...

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

TABLE type not detecting in AS/400 Green Screen

hi, I created a table from i series navigator of type TABLE in lib XYZ. Now i want to see the object in AS/400 green screen. How do i see that Thanks Siddharth

iSeries Navigator

how can i find how many and who are using the iSeries Navigator. can I use any exit program.

Printer Output via iSeries Navigator

how can I know who use printer output via iSeries Nvigator. or can I play with wrkreginf.

iNavigator hangs on SMTP properties

We have an iSeries running v5r2 and the latest release of client access. I need to change the binding of SMTP and this appears to only be available by Navigator. However Navigator hangs when I click the properties on SMTP. Any other way that I can change this binding to a new ip address?

Message Monitoring

Is there a way through Iseries Navigator to setup monitoring for messages from Qsysopr. I do not sit at the console so I would need my monitor at my desk to do a break message when a message appears in Qsysopr queue. I have tried to setup the monitor view but it does not do a break message.

DB2/400 to Oracle 10g

I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle...

SQL script output to a file

I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

mapping a drive to the As400

We currently map drives to the as400, is anyone using a different and maybe easier method? I Series Navigator?

iSeries Navigator V5.4 automatically reset monitor triggers

I have created a message monitor in ISeries Navigator V5.4 and I want to trigger a command whenever a message appears on the QSYSOPR log. The trigger command is working properly; however, the "Automatically reset after trigger command has run" does not work. How do I get the trigger to reset so...