OS/400

Iam unable to view graph details of Performance data for more than one day.

I use GO PERFORM to view by graph of the cpu usage etc during the day.  Though i have configured the retention period for 15 days, i am able to view graph for data of the previous day only. Iam unable to view graph details of Performance data for data older than the previous days data. What do i...

9117-MMA Performance

WE have recently installed a 9117 MMA p570 which has 11 partitions, 3 of which are iSeries. All disk is on DS6800. Our performance has gone backwards on the Production iSeries partition, runtimes blown out excessively though I have seen some batch jobs running faster. We  have heard thru the...

AS/400 QUERY ; how can I calculate the month and year of 3 months ago in define result fields?

I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...

Damaged Object unable to remove

Hi anyone else come across this problem. I have a damaged object which is causing the full system save backup to skip whe whole library with the damaged object in. The library is a user one with a object type of DSPF  Normaly a delete and create a damaged object fixes all, but I can not...

System Upgrade Path Software and Hardware

We have a 170 box running V5R1.  Which upgrade path is doable and or the best. Upgrade 170 with V5R1 to 270 running V5R2 Upgrade 170 with V5R1 to 270 running V5R4 Upgrade 170 with V5R1 to 525 LPAR running V5R4     

Want to know the OS Installation date & Last OS Upgrade date..?

How can i trace the date when OS installed on my iSeries Server & When it is Last upgraded to newer version....? Software/Hardware used: IBM iSeries MMA (Power6)

Access paths

What are Access paths/Recovery access paths in AS/400? Thanks in Advance.

File Level Identifiers

If we save and restore SQL generated files which were created under an old OS/400 system software will the Format Level Identifier be changed and how does this affect the file?

We are runing V5R1 OS400, how do I write to CSV file

We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.

Use of Function Keys on OS/400 Command line

Can I set up a function key to enable a command to be run from the AS400 command line

QAOSSS14B damaged object

During a recent full save prior to an OS upgrade, I noticed the object QAOSSS14B in QUSRSYS is damaged. Recovery is to delete and restore from backup. Problem, couldn't find it on a backup. Any other recovery? Thanks in advance. Sam Kentopian

Program to process command

Is there a way to tell what program is processing a compiled command?

Java on AS/400

Hi All,I want to know what is the best configuration of i5 system to run JAVA application such as M3 ERP.

JAVA and i5

Hi All, I want to know what is the best configuration of i5 system to run JAVA application such as M3 ERP.

Display Query for OS/400 SQL script

Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.

AS400 Disk space

AS400 Disk space I’ve just inherited the responsibility for a couple of old AS400 (model 510, OS V4R5) which are out of support and although I spent many years supporting AS400 I’ve not touched them in the last 6 years and I have a little problem with them. The problem is the system ASP...

AS400 FOLDERS

I Would like to know the phisical stores of as400 folders, I thougth folders were found on QDLS library on previous OS400

Create text file to OS400 folder by using Microsoft SQL Server 2005

Hi All, Do u have any idea to create text file to the OS400 folder by using MS SQL Server 2005? currently i had map drive with OS400 folder in server. i only can create text file at local server by using Ms SQL Server 2005. No idea to create text file at OS400 folder. But allow use dos command...

OS 400 upgradation steps

Can anyone refer me a book where I will be able to read about PTFs and OS upgradation steps.It is just for learning purpose.

Delete files from an IFS folder using a Windows account

I would like to delete files from an ifs-folder (OS400 V5R4) using a windows-account. The folder is shared so I can access it via a vista-workstation. Is it possible to set 'full right' permissions on a windows-account ?