-
Omitting processes during a save while active backup?
I've written a full system backup program in CL that takes advantage of the save while active functionality to decrease our downtime window. Although it has to be started in a restricted state to ...
-
Good strategies for iSeries backup
IBM's iSeries Backup and Recovery manual answers many questions related to system backup and disaster recovery.
-
Bundling multiple one-page reports from IBM i into single document
To print a single document with all of the one page reports generated by the iSeries you need to first create a program that bundles all the individual spool files into a single spool file.
-
How to migrate old *ALLUSR data using BRMS to V6R1
When upgrading from an older I5/OS release to V6R1 using BRMS use the detailed instructions provided by IBM to help using BRMS to restore *ALLUSR data.
-
Parallel backups using save option 21
If you are using a save option 21 for parallel backups on the AS/400, learn how to use BRMS.
-
How to save HMC critical data through the console
On the AS/400 the HMC console backup is initiated from the HMC console, not via save option 21. These instructions will show you how to save HMC critical data.
-
Will overloaded discs impact iSeries performance?
With the AS/400, use the performance tools to collect data during a busy part of the day and then analyze it to see if your disk performance is impacting overall system performance.
-
How to print RPG output using iSeries Access
Use work station customize object or printer type in iSeries Access to print the output of an RPG file from the AS/400 to an HP printer.
-
How to use an API for adding users to EIM SSO implemenation
Searching for the right API to add users to an EIM SSO implementation? The IBM site includes sample APIs based on C.
-
Incorrect CCSID on FTP connection from AS/400 to Windows
Sending the file binary to the AS/400 after defining the destination file tagged with CCSID of 1200 may solve the problem of incorrect CCSID numbers on FTP transfers.
-
How to view source files in the library
On the AS/400 library, source files are multi-member. View source files using GET QCLSRC.membername or MGET QRPGSRC.*
-
Blocking AS/400 DB2 users
To block DB2 users from altering data using WinSQL tool, a security software tool may be the best bet for true protection.
-
User being locked out by Windows share on iSeries
Use the the iSeries QSYSOPR message to look for any errors in passwords when running a program on the iSeries that transfers data to a spreadsheet on a Windows share.
-
Error CWBCO1049 on AS/400
Connecting the iSeries in AS/400, issue STRHOSTSVR *ALL. Make sure the as-signon port is in listen state and check the firewall settings.
-
Trouble accessing IFS path from Win2k3 server
What to do when an application is published in IFS from Win2k3 server, and users are unable to access the shared folder on AS/400.
-
SQL server error message -321
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor using dynamic SQL.
-
Choose which column names are returned via ODBC when working with DB2 files
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC because SQL-based interfaces use the long column nam...
-
Developing tables in a parent-child relationship in DB2
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to maintain over time.
-
When is the YES option for 'reuse deleted files' function the best choice?
IBM did not change the default of the reuse deleted files function to YES for physical files in order to minimize the impact on any existing applications that may have dependencies on deleted recor...
-
Monitoring members 'stuck' within a physical file on an EDI system
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output file that can be analyzed, or occasionally run q...
-
Running AS/400 query to find records based on date
Learn about a quick way of running an AS/400 query to select records based on current sysdate.
-
Consolidation across multiple LPARs using BRMS
The BRMS Network feature allows a BRMS system to connect to other BRMS systems via a network, and enables a user to consolidate media such as backu...
-
Options other than RCLSTG to enable file journaling?
The only option to correct damage preventing file journaling is to use the RCLSTG command.
Submit a question to our experts