- Change Management
- Debugging
- iSeries Applications
- Multi-platform Integration
- Performance
- iSeries compliance and regulation
- Server Consolidation
- Server Installation
- Server Pricing
- i5-OS -- OS-400
- iSeries service and support issues
- iSeries system performance and monitoring
- Systems Management Tools
Email Alerts
-
Auditing: RPG with embedded SQL showing up as a changed object
DB2 stores access plans inside the SQLRPG program object for each SQL statement embedded within the program. When DB2 updates these access plans because of a system environment change, the change date of the program object will be updated at the same time.Ask the Expert
-
Changing system CCSID
If done without attention to detail, changing the CCSID on the AS/400 can lead to very messy database files.Ask the Expert
-
Changing BRMS configurations for new naming conventions for i5
Use BRMMED to adapt the i5 to new location names for relocated machines.Ask the Expert
-
Why can't we change the system value?
One Search400.com member wrote, "We recently upgraded to V5R3, and we're no longer able to change system value QUTCOFFSET. Do you know what the problem is?" Systems management expert Dan Reusche explains what is going on.Ask the Expert
-
Technical documentation: Pictures worth a thousand words
Andrew Borts takes a look at how you can use screen shots to improve your technical documentation after you modify a program.Tip
-
Evaluating change management software
An ITKnowledge Exchange member recently inquired about solutions for iSeries, WDSC & WebSphere running on Linux on PCs. Other techies jumped in to offer some advice.Tip
-
Manage WebSmart development with TURNOVER Change Management
Manage WebSmart development with TURNOVER Change ManagementArticle | 20 May 2004
-
How to resolve a CPI93B8 error message: LIC problem data has been logged for #MSTRTNS
Use WRKPRB command to determine meaning of CPI93B8 error messageAsk the Expert
-
Error: CWBC01049
If you get the error CWBC01049, it can often mean that the Client Access servers haven't been started.Ask the Expert
-
Space offset X'0015FF00' or X'0000000000000000' is outside current limit for object QIGC2424C
When AS/400 running STOP gives the error message 'Space offset X'0015FF00' or X'0000000000000000' is outside current limit for object QIGC2424C', the value being given to the space pointer is greater than the size of the object, and system stops the program. Contact IBM for a PTF to fix it.Ask the Expert
-
Determining why a job ran unscheduled
ISeries backup and recovery expert Ken Graap explains how to use the IJS Log to determine why a job ran unscheduled.Ask the Expert
-
What's happening to my subfile?
Search400.com development expert John Blenkinsop helps an iSeries user out with a subfile problem.Ask the Expert
-
What happening to my subfile?
I am writing a program using subfiles. My subfile is doing something strange. When I call the program it displays on the last page of records in the subfile. I need it to display from the first record it finds down. I assume this can be corrected easily, but I can't find the answer.Ask the Expert
-
Debugging a Web page
Programming expert Andrew Borts goes into detail about the debugging of the Web page and the internal elements of the Web page -- the JavaScript.Tip
-
Error message not displaying correctly when user has not established a 5250 connection
We've created our own program to do additional password validation, but we're running into problems displaying the error message. We used the sample program from the iSeries Security Reference Manual as a template. Messages are sent using the SNDPGMMSG command. The message displays correctly when the user has already established a 5250 session. However, if the user is going through iSeries Access and is prompted (by a pop up window that displays: Password will expire in XX days or password expired) for the user ID/password, the message is not displayed. I suspect it is because the 5250 session is not established. Any thoughts?Ask the Expert
-
Why am I receiving the error SQL7008?
This user is receiving the error SQL7008 message. Site expert Kent Milligan offers some advice.Ask the Expert
-
Error occurs during debugging
Ask the Expert
- VIEW MORE ON : Debugging
-
How to: Code the parameters for API QUSRSPLA
A user is trying to get the last print file generated from a job that was created on the AS/400 after the program producing the print file ran. He is attempting to use CL to code the parameters for QUSRSPLA, but is having difficulties.News | 11 Feb 2010
-
Modern System i reports using Client Access
Creating reports on the IBM System i no longer has to be a headache. You can use the CPYTOIMPF command and then open the file into a spreadsheet or use Client Access. Computer-savvy users can then manipulate the reports to their liking, taking the formerly tedious work on an AS/400 green-screen out of your hands. In addition, some vendors offer automated methods to generate reports and email them to end-users.Tip
-
Tips for installing Lotus Domino server on a System i partition
What AS/400 admins thinking about installing Lotus Domino server on their system should consider prior to installation and during intial phases of set-up and administration. These include disk space, mailbox size limits and base memory as prerequisite considerations, and naming conventions and upgrading for Lotus Domino servers within the System i.Tip
-
Documenting nested program structures on the AS/400
Documenting nested program structures on AS/400 is a complex task and is sometimes overlooked or not updated. The XPGMSTR command automates documentation in a structured and reliable way, eliminating the human-error (or lazyness) involved in the usual nested program structure documentation mishaps.Tip
-
System i no longer the stepchild of IBM's world
Learn about PHP, VoIP and server consolidation with iSeries in this tip from System i programming expert Andrew Borts as he explains how iSeries is the gift that keeps on giving.Tip
-
Storing XML data in a CLOB field
Ask the Expert
-
IBM System i gets VoIP via Nortel
IBM and Nortel are collaborating on IP telephony software and hardware that competes with the System i package 3Com announced last year.Article | 13 Jun 2007
-
Fast Guide to System i/iSeries book excerpts
Find IBM System i (AS400, iSeries) related book excerpts and chapter downloads in this guide. Topics range from iSeries books on Java programming, iSeries web development, RPG legacy applications and more.Learning Guide
-
System i shop retires legacy app, starts fresh
Farm Mutual Reinsurance Plan enlists the help of Magic Software to build new software to replace its outdated insurance administration application.Article | 10 Jan 2007
-
Status messages with the CEEMOUT API -- part 2
In a recent tip, System i administrative expert Ron Turull discussed the fundamental use of the Dispatch Message (CEEMOUT) API. He also discussed its parameters and basic operations. In this tip, Ron covers the details of the API and takes a look at it in action.Tip
- VIEW MORE ON : iSeries Applications
-
Microsoft's HPC server hybrid option for Linux
Microsoft is trying to push into the supercomputing market with the Windows HPC Server 2008 R2 Beta 2's hybrid option for Linux, but will that be enough to lure Linux faithful?News | 13 Apr 2010
-
OpenOffice: What to know before making the transition from Microsoft Office
Learn how OpenOffice Write compares to Word, as well as how OpenBase compares to Access. Get advice on how to work with departments in your company to make the switch from Microsoft Office to OpenOffice. Helpful tips are offered, like letting the administrative assistant to the President keep PowerPoint and Word to reduce friction.Tip
-
OpenOffice: An enterprise open source solution
As more companies look to save money in their IT operations, Sun's OpenOffice may be more attractive. Key features of the multi-platform supported open source software are described. The software can be used in Windows or Linux environments with connection to an AS/400 database.Tip
-
How to: Transfer unlimited data to Excel from AS/400
Using the data transfer from iSeries utility in Client Access allows you to transfer data from the AS/400 to Excel. By setting up the worksheet type and optional setting for Excel to start a new worksheet you can avoid running out of room on a single Excel worksheet.News | 11 Sep 2008
-
Viewing AS/400 directories and folders in Windows
Expert Shahar Mor explains how to access AS/400 folders though Windows.Ask the Expert
-
ISCSI integration available on System i, plus new Lotus discount
New integration capabilities that allow IBM System i servers to manage IBM's x86 machines became generally available this week. Customers can also get a hardware discount for buying Lotus products.Article | 10 May 2006
-
IBM launches Workplace Collaboration Services 2.5
Big Blue responded to iSeries customers seeking an integrated tool set for Workplace by launching WCS 2.5 last week for the iSeries.Article | 26 May 2005
-
Linux For Dummies, 6th Edition -- Chapter 1
This sample chapter introduces you to the world of Linux, discussing such things as the differences between Linux and other operating systems and the distribution of Linux.Tip
-
Integration specialists ride mainframe migration wave
As you map out your strategy, make sure you know the latest in integration and migration tools.Tip
-
RJS Software to launch cross-platform line
IBM software partner RJS announced this week it plans to offer cross-platform solutions to help customers operating heterogeneous data center systems.Article | 17 Mar 2005
- VIEW MORE ON : Multi-platform Integration
-
Extend storage capacity on an IBM i without negatively effecting system performance
After extending storage capacity on an IBM 520, the system performance depends on the workload amount and should not be affected negatively as long as the system has a good controller with lots of free space.Ask the Expert
-
Database drivers on the i: MySQL vs. IBM Toolbox
Which reads data from i faster: MySQL or IBM Toolbox drivers? Joe Pluta put the drivers to the test in both an AS/400 and a Windows environment. The conclusion: MySQL over its own database performs roughly as well as IBM's Java Toolbox over DB2 data, with the caveat that they both can handle hundreds ot thousands of records well, but you may not want to push then into the millions.Tip
-
Performance tuning for IBM i: The basics and beyond
Raymond Johnson answers five reader-submitted questions about performance tuning on the AS/400. Some quick tips and tricks for performance tuning are provided.Tip
-
Dynamic memory in V5: Harness the power -- part 5: New built-in function simplifies dynamic array ha
According to iSeries (AS/400) systems management expert Ron Turull, a new built-in function (BIF) added to Integrated Language Environment (ILE) RPG in V5R3 is essential when using dynamic arrays. The new built-in function is %SubArr (sub-array) and it allows you to extract or set> a portion of an array, much the same as the %SubSt (sub-string) BIF allows you to extract or set a portion of a string.Tip
-
Clean up programs and procedures to increase data and application integrity -- part 3
Here's the information you should know before employing clean-up procedures in your applications.Tip
-
Catholic Charities keeps track of homeless with iSeries
The Twin Cities' chapter of Catholic Charities runs its IT department with a handful of iSeries servers that helps it feed the hungry and provide shelter for the homeless.Article | 27 Jun 2006
-
Clean up programs and procedures to increase data and application integrity -- part 2
In part 1 we discussed some differences between ILE and OPM in the way programs can be cleaned up. We also were introduced to the CEERTX API (Register Call Stack Entry Termination User Exit Procedure). In this installment, we'll see this API in action, and we'll discuss a couple of example cleanup procedures that you will be able to use as generic templates.Tip
-
Expiration of disk controller card batteries in V5R3
Expiration of disk controller card batteries in V5R3Tip
-
i5 error messages: What you need to know
We've compiled a list of resources for iSeries error messages that you can browse through quickly to find a possible solution to your error. If you've come across an error message that is not listed, we have iSeries experts on hand to help you tackle even the toughest errors out there.
Fast Lookup
-
IBM races for clock speed
IBM offered a sneak peak of its server Power6 chips, slated for release in 2007. IBM is touting gains in clock speed, but experts question whether clock speed matters.Article | 23 Feb 2006
- VIEW MORE ON : Performance
-
Healthcare users struggle with HIPAA
Healthcare providers, especially small and midsized companies, say HIPAA has made them rethink their approach to storage.Article | 05 Jan 2006
-
Go beyond SOX for business continuity
Achieving SOX compliance does not ensure business resilience or continuity. There are extra steps you should take to make sure that your business is protected.Tip
-
Complying with multiple regulations and contending with conflicts
This tip reviews how to comply with multiple regulations and what to do when they conflict.Tip
-
SOX 404 compliance: Efficiency is key
Gain a better understanding of SOX Section 404 and learn how to improve your compliance efficiency.Tip
-
Strategic Storage: Storage takes center stage in compliance efforts
If you haven't followed compliance as it applies to storage very closely, read on. Learn about the current guidelines and what's coming up on the horizon.Article | 13 Jun 2005
-
SOX-in-a-box: One size does not fit all when it comes to compliance
A Burton Group analyst explains why SOX-in-a-box is a fallacy and offers five steps for SOX compliance.Tip
-
Four ways to measure security success
Improve your ability to assess the effectiveness of security programs using these four measures.Tip
-
Watch those iSeries system values
Security expert Rich Loeber recently installed a new i5 System i server in his office. Rich explains that this is always an exciting time and he normally rushes to get the system set up so he can move operations onto the new hardware as soon as possible. But as usual, there are always steps that need to be taken to make the transition smooth.Tip
-
Server consolidation, virtualization give U.S. Open the advantage
IBM runs the USOpen.org Web site with a combination of System p and System i servers.Article | 06 Sep 2006
-
Server management costs soar, says IDC
According to IDC's latest report, server revenues are down while shipments are up. But IT shops are picking up the cost of managing more machines.Article | 28 Feb 2006
-
Cleaning up IFS files
Search400.com member Stacey Thompson writes, "Although there are many ways to clean up IFS files it seems that the easiest was is to use QShell. " Click over to view the complete tip.Tip
-
Cool Blue: How IBM beats the heat
After three years of development, IBM released a water-based technology to help servers win the war on heat. The verdict is still out on whether this will solve the issue.Article | 14 Jul 2005
-
Look before you leap into consolidation
Saving space, saving money, and maximizing utilization--what's not to love about server consolidation and virtualization? But experts agree it's not the right move for everybody.Article | 10 May 2005
-
Look before you leap into consolidation
Saving space, saving money, and maximizing utilization – what's not to love about server consolidation and virtualization? But experts agree it's not the right move for everybody.Tip
-
iSeries fights server sprawl
Server consolidation is a hot issue. People are consolidating server farms to address maintenance concerns. But what about heating issues and power loads?Article | 12 Apr 2005
-
Life after migration
Two years after San Francisco's Asian Art Museum migrated to new iSeries servers, life is good for the museum's IT staff these days -- both for the present and the near future.Article | 29 Mar 2005
-
i5 iSeries capacity planning
An ITKnowledge Exchange member asked about replacing his existing iSeries with i5 servers, and fellow techies jumped in on the conversation.Tip
- VIEW MORE ON : Server Consolidation
-
System i blades not selling yet, it seems
Interest in the System i blade has been high since its release in April 2008, but sales are low. Users can get IBM i (formerly i5/OS) on the JS12 blade, which has a single dual-core Power chip, or the JS22 blade, which has two dual-core Power chips. Although, there is some confusion regarding support for the JS22, which could be leading to some hesistancy in uptake.News | 12 Jun 2008
-
MQ Series Client installation
Ask the Expert
-
Mississippi Sportswear's joyride
When Mississippi Sportswear, a uniform manufacturing company, scored a major deal with Adidas, the company decided to upgrade its IT system to an iSeries i5 520 box to support its growing business.Article | 28 Apr 2005
-
Powering up a model 720 iSeries
Ask the Expert
-
InfiniBand finally ready to leap in commercial market
Despite this, experts still agree that the interconnect architecture is fairly high-end for many traditional IT shops.Tip
-
i5 iSeries capacity planning
An ITKnowledge Exchange member asked about replacing his existing iSeries with i5 servers, and fellow techies jumped in on the conversation.Tip
-
If at first you don't succeed, read the documentation
A lot of the problems users had with installing the i5 had to do with the fact that they didn't read the documentation. So how do the guys who write the documentation get customers to notice it? It's all in the packaging.News | 09 Dec 2004
-
First i5 users recount 'nightmare' installs
Early customers of IBM's new Power5 server encountered numerous quirks during installation that frustrated experienced integrators. While some problems have been addressed by IBM, users will just have to adjust to the rest.Article | 19 Oct 2004
-
Domino and the AS/400; Installation and Configuration
Get all the details for implementing Lotus Domino on the AS/400.Tip
-
Implementing Windows NT on the AS/400: Installing, Configuring, and Troubleshooting
Get advice on planning and installing NT on the AS/400.Tip
- VIEW MORE ON : Server Installation
-
Q&A: IBM System i Business Systems' Marc Dupaquier
@46007 In July 2007, IBM Corp. split its System i division into two parts: the higher-end Power Systems unit, and the lower-end Business Systems unit. It soon became clear that the Business Systems unit would be crucial in the survival of the System i platform, with the unit generating 95% of System i volume and 70% of its revenue.
Marc Dupaquier, a relatively unknown figure in the System i world, is head of the Business Systems unit. Search400.com spoke with Dupaquier recently about how he got his start at IBM, the difference between big and small System i customers, and when the i5/OS is coming out.
Interview | 18 Dec 2007 -
i5 pricing option mirrors IBM on-demand strategy
Users looking to run multiple operating systems on their i5 server now have greater flexibility in purchasing. But will it end up costing them more in the long run?Article | 22 Jul 2004
-
IBM changes the rules, levels playing field for iSeries
By drastically changing how the iSeries is priced and marketed, IBM has eliminated a number of obstacles to future platform growth.Article | 13 May 2004
-
IBM forges new ground with next gen iSeries, V5R3
The wait is over. The first Power5 iSeries servers make their debut along with a new version of OS/400 – and they both get new names.Article | 02 May 2004
-
Update on "Can you still afford 5250?"
Questions still remain about what IBM will do to improve the value of an iSeries running 5250 applications.Tip
-
Can you still afford 5250?
Looking at the iSeries today, it's not clear how much longer companies can afford to run 5250 applications if they invest in new iSeries computers announced in 2003.Tip
-
Pricing on the AS/400
Ask the Expert
-
The long-term costs of the AS/400 versus Unix?
Ask the Expert
-
Computing hardware winners
For the purposes of this year’s awards, the computing hardware category includes all server-class computer hardware in any configuration and delivered in any form factor including rack and blade. This category also includes related computing hardware such as networking and storage systems as well as integrated infrastructure suites.Products of the Year
-
IBM puts Power systems in the cloud: News in brief
IBM will now offer a CloudBurst appliance based on Power systems.News | 14 Oct 2010
-
Enrolling a user profile in the i5/OS system distribution directory
Use the WRKDIRE command to access the system distribution directory and enroll a user profile.Ask the Expert
-
OS/400
OS/400 is IBM's operating system for its AS/400 and AS/400e line of business computers. (Continued...)Definition
-
AS/400 (IBM iSeries, AS/400e, eServer iSeries/400)
The AS/400 - formally renamed the 'eServer iSeries/400,' but still commonly known as AS/400 - is a middle-size server designed for small businesses and departments in large enterprises and now redesigned so that it will work well in distributed networks.Definition
-
System i users: Power Systems merger good, OS name change mixed
System i users are happy with the System p/System i merger, saying Power Systems could bring more visibility to System i. Not everyone's thrilled about the name change, though.Article | 16 Apr 2008
-
System i5/OS operating system due out in March
Big Blue has announced the new i5/OS V6R1 and its various features, including the ability to run on blade servers.Article | 31 Jan 2008
-
The top 10 iSeries events of 2004
Since the announcement of i5 and i5/OS spanned a six-month time frame, the new i5 models and enhancements to the iSeries operating system generated excitement all through 2004. In addition to these important events out of Rochester, the year was also filled with acquisitions, revenue dips, and a rejuvenation of iSeries marketing.News | 21 Dec 2004
-
What's in a name change? Plenty
Was changing the name of the AS/400 again a dumb idea? Users certainly think so, but experts say with a company the size of IBM, a product name change is almost irrelevant.Article | 17 May 2004
-
System i users: Power Systems merger good, OS name change mixed
System i users are happy with the System p/System i merger, saying Power Systems could bring more visibility to System i. Not everyone's thrilled about the name change, though.Article | 16 Apr 2008
-
Supporting an iSeries empire
You're on a date with your significant other and your operator calls "The SO AND SO is down!" It is a 45-minute drive home to drop off your grumbling date. Wouldn't it be nice if you had a way to help your operator out for the five minutes of keystrokes you need to enter into your iSeries?Tip
-
Personalize your iSeries
With iSeries systems now being more cost effective, a lot of users have more of them under one roof. It's becoming more important to personalize how they look and run to match your needs.Tip
-
Modifying the sign-on screen
Search400.com member Madhavi explains how to modify the sign-on screen.Tip
-
iSeries customers rather fight than switch
Members of Quest and the J.D. Edwards/PeopleSoft user group said they would rather dump Oracle than get rid of their iSeries. Only 20.1% of members said they would consider moving to Fusion if it did not support the platform.Article | 21 Dec 2005
-
Cleaning up the QSYS library
One Search400.com member writes, "How can I clean up the QSYS library? Currently my system's ASP is nearing its threshold value (75%) and upon checking, I found out that the QSYS library has consumed 50% of the storage used. How can I free it up? Before my system ASP was only running at an average of 40%." Systems management expert Rich Belles warnes against removing anything from the QSYS library.Ask the Expert
-
authorized program analysis report (APAR)
An APAR (authorized program analysis report) is a term used in IBM for a description of a problem with an IBM program that is formally tracked until a solution is provided.Definition
-
UCCnet
UCCnet is a standards organization that provides an Internet-based supply chain management (SCM) data registry service for e-commerce companies and companies that have an e-commerce component.Definition
-
Email to pager over iSeries
This user would like to send an e-mail to the person's pager via their iSeries that is on call if a job produces an error that requires a response.Ask the Expert
-
The straight story on PTF installs
Ask the Expert
- VIEW MORE ON : iSeries service and support issues
-
Automated IBM i monitoring options
An AS/400 user wants to know how to set up alerts from V5R4 and V6R1 version machines.How To
-
Translating Linux for IBM i admins: Working with jobs and networking
Learn the Linux equivalent to WRKACTJOB and how NETSTAT works on in Linux. This tip continues to translate Linux commands for AS/400 adminstrators who are not familiar with the complexities of the language.Tip
-
Database performance comparisons on IBM i
Testing performance of RLA in the IBM Java Toolbox against JDBC and native I/O for the AS/400 revealed that RPG on System i is the most efficient language, and DB2 is taken for granted. Joe Pluta built some benchmarks to compare different aspects of database performance to one another and he provides the results of his testing. Although MySQL is popular and provides an option for prepackaged applications with less stringent database requirements, it won't likely replace DB2 anytime soon.Tip
-
Performance tuning for IBM i: The basics and beyond
Raymond Johnson answers five reader-submitted questions about performance tuning on the AS/400. Some quick tips and tricks for performance tuning are provided.Tip
-
i5/OS
i5/OS is the name IBM has given to its newest release of OS/400 V5R3. i5/OS runs on IBM's i5 servers, which are based on IBM's Power5 microprocessors.Definition
-
Detecting system changes made by outside IP address
If you suspect that changes are being made by an external source, you can use an exit point program to monitor the activity and trace the IP address.Ask the Expert
-
AS/400 system values quiz
Think you know your AS/400 system values? Put your knowledge to the test!Quiz
-
Checking on System i disk space requires creating a new command: XRTVSYSSTS
Monitoring System i disk space is imperative to keeping your system up and running. If a process begins to loop endlessly without notice, it can fill up a working file and bring everything to a halt. XRTVSYSSTS can save the day.Tip
-
Drive space management commands
Helpful commands to manage drive space and view disk status.Ask the Expert
-
Viewing netstat information
Though the netstat command line tool is no substitute for full-blown systems monitoring software, it provides good, quick network information on demand.Tip
- VIEW MORE ON : iSeries system performance and monitoring
-
Automated IBM i monitoring options
An AS/400 user wants to know how to set up alerts from V5R4 and V6R1 version machines.How To
-
Strategies for securing IBM i production files
This tip offers an overview of the process for securing production files on IBM i. Learn how to best secure native objects, including data files, on the AS/400. Walk through the steps from setting system security, access strategy, object level security and libraries.Tip
-
Translating Linux for IBM i admins: User profile commands
Linux can run on an AS/400 partition, but without understanding the commands, an IBM i admin may give up. Learn about user profile commands on Linux from an IBM i admin, including how to change passwords and assign users to groups and subgroups.Tip
-
AS/400 lessons from the past, present, and future: A holiday tale
An AS/400 admin with any experience has surely learned lessons about best practices. Andrew Borts shares some lessons from his past, the present, and speculates about what he needs to know in his future work on the IBM i.Tip
-
Checking if a local port is used by another job on AS/400
A command called NETSTAT shows who is using local ports on AS/400 but it can only be used interactively to create spooled output.Ask the Expert
-
Changing BRMS configurations for new naming conventions for i5
Use BRMMED to adapt the i5 to new location names for relocated machines.Ask the Expert
-
AS/400 system values quiz
Think you know your AS/400 system values? Put your knowledge to the test!Quiz
-
DAYSPAST CLLE program for AS/400: Compares object creation date with today's date
A CLLE program for AS/400 to determine the number of days that have passed since an object was created.Tip
-
Checking on System i disk space requires creating a new command: XRTVSYSSTS
Monitoring System i disk space is imperative to keeping your system up and running. If a process begins to loop endlessly without notice, it can fill up a working file and bring everything to a halt. XRTVSYSSTS can save the day.Tip
-
Setting up an automatic reply in the system reply list
AS/400 systems can use the system reply list to automatically reply, but only if the inquiry message reply attribute is specified as INQMSGRPY(*SYSRPYL).Ask the Expert
- VIEW MORE ON : Systems Management Tools