Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


IBM System i





IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

Share tech news, updates, or what's on your mind.

Sign up to Post

Does anyone know if IBM has come out with a statement of impact or remediation for the IBM i platform - in regards to the Spectre/Meltdown vulnerabilities?
Free Tool: Port Scanner
LVL 11
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Does anyone have a SQL statement that will list all libraries on my IBM i server and the number of objects in each of the libraries?

So my output would have just 2 columns. Table Name and Number of Objects.

I appreciate any help...
I've been tasked with updating remote MS SQL database tables. I'd like best ideas for utilizing our IBM i to do this. I'm primarily and ILE-RPG, RPG Freeform programmer, but have worked using RPG-XML (which we have) and consuming  web services via a local MS SQL database. I'm also familiar with SQLLERPG to a degree.    

I have access to 'data source', 'Initial Catalog', 'User ID', and 'password' for the remote database tables.

All ideas are welcome and will rewards points accordingly.


Phil Knox
Ok i'm stumped and google/youtube are no help in this case

how exactly do i remove the processor heat sink on this server?
Hi experts,

Is there a way to use Certificates with Secure FTP on the iSeries (AS/400)?
(If Yes, How?)
Hi All,
The below is the requirement.
I have multiple queues  as below and i want to retrieve only specific output queues . These specific queue represent each day e.g
MON1,TUE1,WED1,THU1,FRI1 .These output queues are placed in random order and are in 'RDY' status in the queue.
Every day when the spool file comes into a specific queue , it should be copied into a physical file.
For Eg. On Monday, once the spool file SPOOLF1 is present in the output queue MON1, it should be immediately written to the physical file even if it is empty.There are many  other spool files present in MON1, however, the copy should be performed only to the specific file SPOOLF1 for MON1.

On similar lines, once the spool file SPOOLF1 comes to TUE1 queue , it should immediately be copied to another physical file and so on and so forth for queues WED1,THU1 and FRI1.

Work with all output queues:

Queue          Library
A                    XYZ
MON1           XYZ
C                    XYZ
D                   XYZ
TUE1             XYZ
F                    XYZ
WED1          XYZ
THU1           XYZ
FRI1                XYZ

After selecting output queue TUE1, i am in the below screen:
Work with output queue:
File                 User                    User Data       Sts
SPOOLX        user1                    ud1                 RDY
SPOOLY        user1                     ud2                RDY
SPOOLZ        user1                     ud3         …

I am having issues restoring a library or objects using RSTOBJ or RSTLIB commands. The restore normally takes 13-17 minutes, however, its taking 8-12 hours.  The save includes ACCPTH(*YES) so it shouldn't take too long to restore. Ironically, whenever, I save the same library using the SAVLIB command, it takes 13-20 minutes. But to restore is a nightmare.

Please help me with this. I have checked sysval (System Values) for access path and other sysval for restoring objects like verify objects with digital signatures, converting objects etc. All those sysval based on my research seem to be correct.

I have a feeling it has to do with journaling. However, I am not sure. The message I got from the log were:
1. New format X was created for the file because sharing of fomat X with file X in Library Y could not be established again. It could be dependencies (logical files).
2. We encountered an error message CPF3281
3. File X in library Y using format X with a correct format level identifier does not exist.  

Please in whatever way you can HELP!

Greetings iSeries Gurus,

I just successfully set up SSL for an iSeries Access 5250 Emulation connection...
I need to know what port is used by the System i Navigator when it connects to the iSeries...

I know that Telnet uses port 23, FTP uses port 21, and SSL uses port 992 for their connections...
(Curious to note that port 992 is not showing as open on the iSeries...)


I have a problem via SQL and into RPG too when I type SUBSTR(xxxx,1,6)
from some reason on my iSeries it requesting to be one space between comma and lengths e.g. substr(xxx, 1, 6).
I know that on other iSeries it's not a problem and on more examples it is not written with these spaces...

This is the error message when I check

Select * from ztrans0p                    
 where substr(trcrd#,1,6) = '516971'        
 Token ,1 was not valid. Valid tokens: ) ,.

Message ID . . . . . . :   SQL0104                                            
Message . . . . :   Token ,1 was not valid. Valid tokens: ) ,.                
Cause . . . . . :   A syntax error was detected at token ,1.  Token ,1 is not  
  a valid token.  A partial list of valid tokens is ) ,.  This list assumes    
  that the statement is correct up to the token.  The error may be earlier in  
  the statement, but the syntax of the statement appears to be valid up to    
  this point.                                                                  
Recovery  . . . :   Do one or more of the following and try the request again:
    -- Verify the SQL statement in the area of the token ,1. Correct the      
  statement.  The error could be a …
Hi Experts.
I am doing work for a manufacturer.  They have email that is hosted by the ISP, so it is not in house.
I have a legacy system (AS400/iseries) that is in-house that I am sending emails out to vendors for Purchase orders.  The system creates PDF's then creates the email and sends out.  So it does not go thru the regular email system.    
So, we have had some emails not get delivered and some bounce back.  I have gone thru the option to tell Office 365 to whitelist the ip address we are sending from.    
The question is, Can we tell the world that our IP is safe via DNS in some way?   Otherwise, we are going to have to send emails to companies that we get kickbacks from and request that they white list us.  Issue is small now, but I am getting ready to add customer service to emailing invoices, etc too and it is only going to get bigger.
Keep up with what's happening at Experts Exchange!
LVL 11
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

One of our developers has asked that we run a script that they wrote every 3-5 minutes on our iSeries.  The script is set up to see if a particular port is open - and if it isn't, then to start their application.

The script is a .sh (monitor.sh) file located in the IFS.

Is there any easy way to do this?
What is the difference between SAVLIB for *NONSYS, *IBM and *ALLUSR?
How do we do complete disaster recovery test? Just need sample example with steps
Why should we need to run UPTPTDINF during a complete system recovery after library QGPL has been restored
Why do we install PTF? What are the difference between cummulative, group and Hyper PTF
Hello Team,

Could you please tell me the difference between IPL Type A and IPL Type B? IPL B is used for routine work like ...PTF , LICPGM installation , Post monthly backups and for free up some space .... so what is the purpose of IPL A ?

on what scenarios we use IPL Type C?

Avinash Chandra
Hello Team,

Request you to answer the below questions

1.) What is Save while act in AS400 and How does it works?
2.) TEST LPAR was unfortunately shutdown and need to restart the LPAR with Restricted state? Does it possible ? i think we should remove the QSTRUPPGM value to *NONE and then restart the system to bring it in Restricted state , but that is not possible when LPAR is in inactive state
3.)what do you mean by Audits in MIMIX
4.) How do we check the Boot Load is TAP01 or not before initiating the IPL : Manual, D for recovery the system from bull backup tape
5.) on what scenarios we use End batch restricted state option in DST?
Avinash Chandra
I have a number of database files on our IBM i that I need to update the authority on for our developers to *USE. Unfortunately these files are pretty much in use 100% of the time.

Is there ANY way that authority can be updated on a file without having an exclusive lock on the file? I am not aware of any - but thought I would check with others to make sure I wasn't overlooking something.

Thanks in advance
We have a AS400 server which is running v5r4 of the OS. It has an integrated windows 2003 server. To get antivirus installed in the windows 2003 server we had to make some registry modifications. The original registry settings were backed up. When the windows 2003 starts it blue screens and says the windows session manager cant start. We have already tried "Last know good configuration" and "Safe mode". Both of these yield the same blue screen. If we could only boot from a CD and run windows restore or some utility to re import the registry settings. But there seems to be no way to tell the AS400 to boot the integrated server from the CD instead of the hard drive.  Please HELP.
We have a AS400 server which is running v5r4 of the OS. It has an integrated windows 2003 server. The windows server install got corrupted and is down.  We would like to pull the data of of the windows install without the windows 2003 server running.  Is it possible? Since the disks are integrated between the AS400 and windows I thought it might be possible since the Windows drive are showing up as AS400 virtual disks with the integrated server being off.
We have a AS400 server which is running v5r4 of the OS. It has an integrated windows 2003 server. The windows server install got corrupted and is down.  Is it required for QNTC to work on the AS400?
Hi Team,

I would like to know the difference between Virtual Printer vs. Remote Printer vs. LAN Printer and in what scenario we use these printers and how do we configure Virtual Printer and Remote printer in AS400 . Please help me with commands.

Avinash Chandra
Get quick recovery of individual SharePoint items
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.


I have a disk full condition which caused a V7R1 Power5 to shut down...
Need to know the procedure for IPLing to delete some stuff...

Someone said to IPL from the A side...
Is that true...?
Is that A Normal or A Manual...
We are FINALLY looking to retire our 'Office Vision' email. I'm looking for a way to dump the email detail for every email we currently have. The intent would be parse this information into a database for historical purposes.  

I've used QRYDST to dump header information, but I need all details.

Can anyone provide direction on this? Is it possible?

Thank You!!!
Error details : CWBLM0031 - failure, a data conversion error was returned by the host server. rc1=2 rc2=21,I am using PC EMULATOR 5250 PERSONAL COMMUNICATION ,I am accessing it via remote ,Now whenever I am logging in to it ,I am having this error.I amnot able to log in.
Please help.

I have taken on the management of a system that runs on an as400 and was looking to get some training online. Can someone recommend a training course?


iSeries is successfully sending out emails, but spam filtering rules prevent the receipt of mail issued from the iSeries bearing the same domain name.  The only solution would be to route the outbound mail through the local exchange server.
What settings need to be altered on the iSeries to point the outbound SMTP traffic to the local Exchange Server?

I am trying to configure a Xerox Phaser 6180 MFP to work on an IBM AS400. the configuration is accepted but I keep getting the message "remote device rejected an attempt by the writer to open a connection"
I have it configured as a
Device Type:  3812
Model: 1
Port: 9100
Manufacturer Type and Model:   *HP5SI
Remote Location:
System Driver Program:  *HPPJLDRV

Can anyone advise.


IBM System i





IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

Top Experts In
IBM System i