Ask the Experts

Ask the Experts

• 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.  Continue Reading

• 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 backup tapes.  Continue Reading

• Options other than RCLSTG to enable file journaling?

  The only option to correct damage preventing file journaling is to use the RCLSTG command.  Continue Reading

• Good strategies for iSeries backup

  IBM's iSeries Backup and Recovery manual answers many questions related to system backup and disaster recovery.  Continue Reading

• Omitting processes during a save while active backup?

  Find out if log files can be omitted during a save without causing problems in a full restore.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading

• 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.  Continue Reading