Does sFTP works for SNDDST command
Currently our business is modifying all existing interface (From IBM V5R4M0) with Windows server to replace FTP by sftp. Our Question is — whether SNDDST works even after we covert from FTP to sFTP, if there exists any issue what would be the alternate IBM command which works along with sFTP

Answer Question   |  March 31, 2012  3:33 PM
AS/400 SFTP, SFTP, SNDDST, V5R4M0

Upgrading from V5R3M0 to V5R4M0 Using HMC on P-570
I’m at the planning stage of this upgrade and it’s the first upgrade with a HMC attached. There’s no twinaxial console, so my question is , Can the HMC perform the upgrade? Do I need to attach a console, to carry out the upgrade.

Answer Question   |  April 13, 2011  10:06 AM
HMC, HMC updates, OS/400 Upgrades, V5R3M0, V5R4M0

AS400 Printing Trouble
Hello. My company upgraded our AS400 from v5r4m0 to v6r1m0 about a year ago. Ever since we’ve had issues with printers going into *END status randomly. The printers are two IBM InfoPrint 6400′s. We never had this issue on our old AS400. During the day when we see it happen we just WRKWTR and use [...]

Answer Question   |  May 26, 2011  6:42 PM
AS/400, IBM AS/400, iSeries printing, iSeries Upgrades, iSeries V6R1, V5R4, V5R4M0

PM400 screen to print
PM400 option Print performance report displays the screen (below) to allow the user to drill down.  This screen is a summary with interval of 15 minutes for a 24 hour period.  I would like to copy the data lines (all entries for 24 hour period) data down to an Excel file (or .csv).   Unfortunaltely, [...]

Answer Question   |  February 11, 2011  2:04 PM
CSV, iSeries, iSeries printing, PM/400, V5R4M0

APPN session initiation attempt has failed
I get this message when someone or something is trying to connect to a system that has since long been Obsolete. My question is : is there a way to get to the job that is trying to get a connection to that location?

Answer Question   |  January 25, 2011  9:26 AM
APPN, AS400 APPN Location, OS/400, V5R4M0

AS/400 Error: RRN() does not start from 1, but starts from number of rows deleted + 1 db2, v5r4m0
i’m trying to populate a field in A table with the row number using rrn(tablename). the first time if i insert 4 rows then the id is 1,2,3,4 as required. if i delete the rows and try the insert again the rrn() does not return the same so 1,2,3,4 but returns 5,6,7,8 (that is the [...]

Answer Question   |  November 23, 2010  2:37 PM
AS/400, AS/400 DB2, RRN, V5R4M0

Testing RPGSQL for the number of records.
I need to update file A if I can match a record in file B using an SQL statement. (IE: is Work Order # 5 in file B.) Im looking for something similar to a SETLL. When I OPEN the cursor, will the SQLCA give me some specific answer? Or do I have to actually FETCH [...]

Answer Question   |  September 20, 2010  5:03 PM
RPGSQL, SQL, SQL statement, V5R4M0

Version of DB2 running on AS/400
I need to know the version of DB2 runing on AS400, do you know how can I to get it?

Answer Question   |  September 14, 2010  5:06 PM
AS/400, AS/400 DB2, V5R4M0

Query Manager Error
Type SQL Statement ************************** Beginning of Data ************************* 0001.00 SET MISC :MISC6 0002.00 SELECT bcbgcd COLHDG(“MISC” “CODE”), 0008.00 &MISC LEN(4,0) COLHDG(“SHARED CONTAINER” “CODE”) NAME(MISC) 0009.00 FROM lmbcrela 0012.00 WHERE bcbgcd=&MISC In checking the SQL syntax it errors: Token MISC was not valid. Valid tokens: :.

Answer Question   |  September 16, 2010  4:42 PM
AS/400, SQL Query, SQL Server, V5R4M0

Passing parameter to Query Manager
I have the following query manager that errors with the following statement that is being placed in the CLP program: Type a value for variable “SELECT” and press Enter. This value should have been passed by the CLP program: *************** Beginning of data ************************************ PGM DCL VAR(&SELEC) TYPE(*CHAR) LEN(5) CHGVAR VAR(&SELEC) VALUE(’54310′) STRQMQRY QMQRY(AXMTESTLIB/TESTQM) QMFORM(*SYSDFT) [...]

Answer Question   |  September 7, 2010  12:57 PM
AS/400, CLP, CLPROGRAM, Query Manager, V5R4, V5R4M0

client access from p/c to AS400 signon screen
Since we have changed our password to disable the persons user ID for invalid attempts instaed of varying the seesion off. We now have aproblem where user get thier user ID diabled when really doing nothing. They have already gain access and are doing their work and may be inactive for a few moments, it [...]

Answer Question   |  August 19, 2010  7:26 PM
AS/400 passwords, AS/400 security, iSeries passwords, V5R4M0

i5 FTP over SSL
I have a message: FTP Unsuccesful. See the FTP log in CPSSRC,OUTPUT …. Stupid question: how do I view the log ?

Answer Question   |  July 21, 2010  6:13 PM
FTP Error Codes, i5/OS, iSeries error messages, V5R4M0

MQ software upgrade
I am going to upgrade MQseries to latest version. I don’t know anything about MQ. Can somebody tell me what are the basic steps I need to follow?   My machine is 9406-825 and os is V5R4M0

Answer Question   |  July 23, 2010  12:08 PM
MQ for iSeries, OS upgrade, Software upgrades, V5R4M0

How can I see when a user signs onto iSeries to check their profile?
I need to know a user signs on the iSeries so I can check the profile aganist a file to disable the profile or not. How can I get this information??

Answer Question   |  June 22, 2010  5:30 PM
iSeries, iseries v5r4, V5R4M0

Iseries Netserver fails to start
We are doing a full system save of our system (model 520, v5r4m0). When the full system save completes and the system restarts iseries netserver fails to start because the subsystem qserver is not active at the time. This seems to be a timing issue. Not sure how i can get the subsystem started prior [...]

Answer Question   |  April 19, 2010  8:23 AM
iSeries 520 9406, iSeries netsetver, V5R4M0

Restore iSeries tape
Can I restore data on the tape ULTRIUM3 after I run INZTAP comand with CLEAR(*NO)?[Br _extended=”true” />[Br _extended=”true” />

Answer Question   |  December 10, 2010  12:02 PM
iSeries tape drives, OS/400, Tape drives, Ultrium, Ultrium 3, V5R4M0

Display Performance Data in AS/400
I have several LPAR’s that collect peerformance data. In one LPAR I can see all Performance Collections with DSPPFRDTA *SELECT in QMPGDATA. On the others only the current collection is shown although the *MGTCOL objects are in QMPGDTA. How can I force these to be shown on the other LPARs as well ? iSeries V5R4M0 [...]

Answer Question   |  June 7, 2011  10:23 AM
AS/400 performance, V5R4, V5R4M0

Require the method and steps to decrease ASP and DASD utilization.
Hi, I am new to AS400 Admin. And one of the AS400 box has high ASP utilization. The Disk space report shows the user libraries and user directories occupy maximum space. Can anyone please elaborate the steps I need to perform inorder to reduce the ASP utilization of the system.Specifically for purging by using RCLSTG [...]

Answer Question   |  February 1, 2010  7:51 AM
AS/400 performance, ASP, ASP Utilization, DASD, V5R4M0

How to run CHGPRTF on QSYSPRT in V6R1M0
In V5R4M0, we are able run CHGPRTF on Qsysprt. In V6R1M0, this file is always unavailable, it is use by QSYS in SCPF. Any way to run CHGPRTF on Qsysprt?

Answer Question   |  January 4, 2010  5:12 PM
V5R4, V5R4M0

SQLCODE = 1077952576
All- I’m getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors. I should be getting a small subset. I get 0 records. Any Ideas?  It’s not in the SQLCODE finder. Phil

Answer Question   |  November 28, 2009  11:02 PM
RPGLE, RPGSQL, V5R4, V5R4M0