Ask the Experts

Ask the Experts

iSeries systems management

• 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

• 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

• 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

• Recovering from DST QSECOFR password disablement on V5R4

  If the DST QSECOFR and QSECOFR passwords have been disabled from multiple attempts at user login, the OS may need to be reinstalled on IBM i to recover function.  Continue Reading

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

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

• How to resolve a CPI93B8 error message: LIC problem data has been logged for #MSTRTNS

  Use WRKPRB command to determine meaning of CPI93B8 error message  Continue Reading

• Detecting copied files on the AS/400 using audit journals

  Want to know if a user has copied a file from the AS/400? Use QUADJRN and look at ZC and ZR to detect changes and reads of the files.  Continue Reading

• How database views get deleted from AS/400 libraries

  Audit journals on the AS/400 can help track down file deletions from Libraries on the system, including view files for databases.  Continue Reading

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

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

• Changing system CCSID

  If done without attention to detail, changing the CCSID on the AS/400 can lead to very messy database files.  Continue Reading

• Error: CWBC01049

  If you get the error CWBC01049, it can often mean that the Client Access servers haven't been started.  Continue Reading

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

• Changing BRMS configurations for new naming conventions for i5

  Use BRMMED to adapt the i5 to new location names for relocated machines.  Continue Reading