How to find the average processor and Main Memory usage of iSeries?
For a report, how to find the average processor and Main Memory usage in iSeries. is it through Performance tools? If so which parm? or how. Thanks

Answer Question   |  November 17, 2010  10:28 AM
AS/400 performance, iSeries, iSeries management, iSeries performance

Terminate SQL exception, if it is running more than a specified time.
Whether we can forcefully terminate an sql statement during its execution if it is running for a long time or running more than a specified time?

Answer Question   |  November 15, 2010  10:03 AM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement

Reasons for a slow AS/400 console session
What could be the causes of a slow console session. a logmein session works fine. All clients in a domain , server 2003.

Answer Question   |  November 12, 2010  7:16 PM
AS/400 administration, AS/400 performance, AS400 Console, Windows Server 2003

How can we write an AS/400 subfile program without using any indicators?
How can we write a subfile program without using any indicators(Even no indicators for SFLDSP, SFLDSPCTL)?

Answer Question   |  August 25, 2011  10:06 AM
AS/400 Subfiles, RPG indicators, RPGLE

How to find the average processor and Main Memory usage of iSeries?
For a report, how to find the average processor and Main Memory usage in iSeries. is it through Performance tools? If so which parm? or how. Thanks

Answer Question   |  November 12, 2010  8:26 AM
AS/400 Parameters, AS/400 performance, AS/400 reporting, iSeries, iSeries performance

Creating script file to send AS/400 file to unix using SFTP
Hi, I’m using a script file in an AS400′s IFS to send a file to a Unix server.  lchdir /SFTP/RMDEDTRC                      cd /var/opt/apps/reporting/prod/dat/in/dvcs put RMDDWKP                                rename RMDDWKP RMDDKEP.TXT                     chmod 0766 RMDDKEP.TXT                     quit                                       RMDDWKP is the AS400 file.  I want to send it, then rename it.  It can’t find RMDDWKP.  Why not?  What is the correct code? [...]

Answer Question   |  November 16, 2010  7:30 PM
AS/400, AS/400 scripts, SFTP, Unix

Get AS/400 FTP session to echo back data and time
Frequently our AS/400 sends data to our bank via FTP. The bank returns a 220 welcome message in the FTP log which includes the time. We would like to also see the date from the bank’s UNIX computer recorded in our log. I’ve tried a couple of things in our FTP script but the commands [...]

Answer Question   |  November 15, 2010  6:42 PM
AS/400, AS/400 FTP, FTP, V5R4

Using SQL to insert records into a table
I have a table with a period in the table name, i.e. AB.CDE that I need to insert some records into. When I query the table (Select * from “AB.CDE”) it works fine. When I try to insert records (insert into “AB.CDE”), however, I get a file not found message. Does anybody know why this [...]

Answer Question   |  November 19, 2010  6:05 PM
AS/400, AS/400 Interactive Jobs, SQL, SQL Query

Embedded SQL number of days between dates
C/EXEC SQL                                C+ INSERT INTO SERIOVR60                  C+ SELECT HTSERN, HTPART, HTQTY, HTSTKL,  C+ HTSTS,  HTADAT,                        C+ substr(HTPART, 1, 11) AS HTMODEL,      C+ HTADAT – :CURDATE AS HTDAYS            C+ FROM SERI                              C+ WHERE HTADAT < :TESTDATE and           C+       HTADAT <> ’0001-01-01′ and       C+       HTSTS  = ‘A’                     C+ ORDER BY HTPART                        C/END-EXEC                                This returns;  Date     =    2010-05-12        Days [...]

Answer Question   |  November 13, 2010  5:07 PM
AS/400, Embedded SQL, SQL, SQLRPGLE

How can I tell if a file is ASCII or EBCDIC in iSeries?
Hi, I have to create a file to send to another location outside of our company. they ask if the file type is ASCII or EBCDIC. How do I tell what the file is on the iseries? Also when I transfer the file thru FTP do I need to define it in FTP. Thanks!

Answer Question   |  November 16, 2010  3:22 PM
ASCII, ASCII File, EBCDIC, File Types, iSeries, iSeries File Members

How to find RAM in iSeries?
RAM of an iSeries machine… command?

Answer Question   |  November 12, 2010  12:36 PM
AS/400, iSeries, iSeries Commands, Random Access

Tracking IPDS printing on AS400
How do I pass on user information to the printer from the AS/400? That is, if I wanted to embed user and job information on the IPDS job and send it to the printer, how would I go about it? 

Answer Question   |  November 12, 2010  12:27 PM
AS/400, IBM, IPDS, iSeries, V6R1

Moving a PDF file from the IFS directory to a Windows server
We are converting a spool file into a PDF report and storing it in the IFS directory. We are trying to MOV or CPY from the IFS directory (/POREPORTS/’) to the windows server. (‘/QNTC/SKYWALKER/POARCHIVE’)  I get the following error: The CCSID of the target file could not be set to match the CCSID of the Source file. [...]

Answer Question   |  November 10, 2010  9:29 PM
IFS, IFS Directory, IFS Folder, OS400 Upgrade, PDF conversion, Spool files, Windows Server

Using .net gridview control with AS/400
I am tiring to update a table in the as400 with the .net gridview control and I am having trouble binding the parameters to the sql query. My select query work if I use a liked server but it is slow. Next I tried the odbc driver but my select query is not working with [...]

Answer Question   |  November 15, 2010  7:01 PM
.NET 2.0, AS/400, AS/400 Parameters, GridView, GridView Control, SQL Query

What is the AS/400 configuration library?
I have been doing a *allusr restore from my live system i520 on operating system v5r3  to the test system and it keeps on overwriting the ip address from live to test. Please can someone tell me what library needs to be excluded to stop configuration overwriting

Answer Question   |  November 22, 2010  12:53 PM
AS/400, AS/400 Configuration, AS/400 Library, V5R3

AS/400 – Convert physical file with multi record to single record
This is AS/400 question, any idea to convert a multi-record physical file to a single record.  Example: [strong]FILE A[/strong] 000000     AAAAA 000000     BBBBB 000000     CCCCC 000000     DDDDD Convert to [strong]FILE B [/strong]000000    AAAAABBBBBCCCCCDDDDD Many thank ur idea.

Answer Question   |  November 11, 2010  2:38 AM
AS400 physical file, File conversion, Physical Files

Should HMC updates or I5/OS updates be done first?
Should HMC updates or I5/OS updates be done first? Where does firmware come in?

Answer Question   |  November 19, 2010  9:42 PM
Firmware, HMC updates, I5/OS updates, i520, IBM

iSeries TS3100 web interface ‘locked by another user or interface’ error message
Trying to use TS3100 web interface, get login screen and enter id/pw, get message that ‘Management Interface is locked by another user or interface’. This persists beyond several power cycles oif the library and a couple IPLs of the attached iSeries box as well. How to unlock/rectify? Thanks! Carter

Answer Question   |  November 10, 2010  7:38 PM
AS/400, AS/400 IPL, IBM TS3100, iSeries, TS3100

SSH shell error message
When trying to execute ssh within QP2TERM, I get the message You don’t exist, go away?” Any idea what needs to be setup

Answer Question   |  November 11, 2010  5:45 PM
Network protocols, qp2term, Secure Shell, SSH, SSH Configuration

AS400 RUNSQLSTM – Problem with CAST
I am using a RUNSQLSTM to insert records from file A into file B. One of the fiels in defined as 4S 0 in file A and as 4A in file B. If the value in file A is zero, not matter what I have tried file B gets populated with a 0 followed by [...]

Answer Question   |  November 9, 2010  4:27 PM
AS/400, DB2/400, RUNSQLSTM, SQL Server, V4R5