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
-
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
-
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
-
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
-
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
-
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
-
HIPER PTF installation and cover letters for SF99097
Should HIPER PTF be installed without Group PTF on an AS/400? Also, how to locate PSP documents including cover letters. Continue Reading
-
Library QUSRSYS not completely installed
If you receive an error following a QUSRSYS install on AS/400, you may need to reinstall while keeping a backup of the previous library because it contains user data. Continue Reading
-
Print private authorities (PRTPVTAUT) command for user objects in a library with *public exclude
On i5/OS, the print private authority (PRTPVTAUT) command allows you to print a report of all the private authorities for objects of a specified type in a specified library, folder or directory. Continue Reading
-
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). Continue Reading
-
Clearing physical member file records
If you are trying to clear a physical member file, but get a message that says: FILE *** in LIBRARY *** is in use, what do you do? Scott Ingvaldson provides a quick fix. Continue Reading
-
Drive space management commands
Helpful commands to manage drive space and view disk status. Continue Reading
-
Group PTFs
Do you want to know what group PTFs are? Better yet, do you want to know which ones may be installed on your AS/400? Scott Ingvaldson explains what they are and why they exist, and best of all, where to find out which ones you have installed in your... Continue Reading
-
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... Continue Reading
-
Identifying users' system authority
How do users get the authority to run certain commands? How do you identify those users? System i security expert Carol Woodbury has the answers. Continue Reading
-
Run a stored procedure in AS/400 with limited profile access
ISeries security expert Carol Woodbury explains how to run a stored procedure in AS/400 while restricting the access of the profile that makes the call. Continue Reading
-
Viewing the job log of an *ALLOBJ user
ISeries security expert Carol Woodbury explains how a non-*ALLOBJ user can view the job log of a user with *ALLOBJ access. Continue Reading
-
Using the notification function of Advanced Job Scheduler
ISeries backup and recovery expert Ken Graap explains how to use job scheduler to send notifications using the Change Notification Command. Continue Reading
-
Viewing AS/400 directories and folders in Windows
Expert Shahar Mor explains how to access AS/400 folders though Windows. Continue Reading
-
i5/OS defect when submitting a CHGPF command to an existing physical file
-
Storing XML data in a CLOB field
-
Gaining control over use of SST profiles
Expert Carol Woodbury explains the only way to extract SST profile information on iSeries servers. Continue Reading
-
Is there a way to get and modify the source for QDSIGNON2?
iSeries systems management expert offers help on how to personalize the initial sign-on screen. Continue Reading
-
What's happening to my subfile?
Search400.com development expert John Blenkinsop helps an iSeries user out with a subfile problem. Continue Reading
-
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 ... Continue Reading
-
Why are the locked objects shown as addresses only
One Search400.com member writes, "Why are the locked objects shown as addresses only and not by name, library and type?" Continue Reading
-
What does the QDBSRVnn job do?
One Search400.com member writes, "What does the QDBSRVnn job do?" Continue Reading
-
Finding the value for the 'message key' parameter
One Search400.com member writes, "I am trying to set up a reply to a message that I am monitoring for. How do I find the value for the 'message key' parameter for the sndrpy command?" Continue Reading
-
Performance degradation
One Search400.com member writes, "If the cache battery failed for the iSeries system (RAID5), is the system performance degraded?" Systems management expert Rich Belles says yes. Continue Reading
-
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. Continue Reading
-
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? ... Continue Reading
-
TCP/IP connection between the two iSeries
One Search400.com member wrote, "I have two iSeries servers with the same configuration, V5R3M0. Both servers are in one city, and I'd like to establish remote journaling between the two. What is the best way to establish a TCP/IP connection between... Continue Reading
-
How to permanently apply PTFs
One Search400.com member writes, "I have an iSeries 620 box running V5R1. I temporarily applied PTF (TL03175) on this box and then IPL it on the B side. The next day I did an IPL on A side and still find that the PTL is temporarily applied. I again ... Continue Reading
-
Determining the speed of an Ethernet card
One Search400.com user writes, "How can I determine the speed of an Ethernet card on the iSeries?" Systems management expert Rich Belles shares his method. Continue Reading
-
Getting authority for STRDBG
One user writes, "What is the command to get authority for STRDBG?" Systems management expert Scott Ingvaldson was on hand to offer some advice. Continue Reading
-
Setting the font size for reports
I need to set the font size to Arial 13 in my reports (PRTF). How can I do this? Continue Reading
-
WRKENVVAR character limit
I use the WRKENVVAR to set the variable CLASSPATH. The issue is that the CLASSPATH has already been filled up. How can I increase the length of the Value Field? Continue Reading
-
Changing default message replies
One user writes, "I've changed the default answer (C) from cpf4101 to (D) with CHGMSGD MSGID (CPf4101) MSGF(QCPFMSG) DFT('D'). I've also put an entry in the SYSRPLY: ADDRPYLE SEQNBR (12) MSGID(CPF4101) with reply *dft (which is now actually D, so ... Continue Reading
-
Why am I receiving the error SQL7008?
This user is receiving the error SQL7008 message. Site expert Kent Milligan offers some advice. Continue Reading
-
Understanding the user class of a profile
Security expert Carol Woodbury tries to clarify user's confusion on the user class of a profile. Continue Reading
-
Monitoring QSECOFR
Security expert Carol Woodbury explains the best method for tracking activity QSECOFR has on V4 OS/400s. Continue Reading
-
Enable the QSECOFR user profile
This user has questions about enabling the QSECOFR user profile. Continue Reading
-
The straight story on PTF installs
-
Using subsystems to run job queues
-
Error occurs during debugging
-
How to remedy spike in CPU percentage
-
Using NetServer without entering a password
-
Making sense of temporary addresses usage
-
How to log use of STRSQL
-
What PTFs do I need?
-
Connections to clocks from AS/400 drop intermittently
-
How to audit addlible/rmvlible/chglibl actions
-
How to detect or log all commands typed
-
What is eating up my CPU?
-
Setting up journals
-
Limiting the number of sessions
-
How often are message queues cleared?
-
Good descriptions of field names
-
Error message within the printer file
-
MQ Series Client installation
-
Copy WRKOUTQ to a "speed key" for a specific Outq
-
Powering up a model 720 iSeries
-
Creating a library with a *test vs. *prod parameters
-
Should I worry about AF audit journal entries?
-
Cleaning up journal entries
-
Granting OS/400 users special authorities
-
Using the SPLF0200 format in QUSLSPL API
-
What can we do to improve our system performance?
-
Locating user profiles with the WRKUSRJOB command
-
Should we do the CUM first or last?
-
Embedding SQL into RPG LE programs
-
New option within the WRKSYSACT command
-
Ways to improve response times
-
See the users with *change or *all authority
-
Copy a spoolfile (report) into the IFS as a .txt file
-
CPF error message - CPF6708
-
User space objects in Library QDIRSRV2
-
Limit command line access
-
Set up journals
-
Restrict access to file transfers
-
Which API could be used to write data into a user space?
-
Determine which memory slots and disk drive slots are empty
-
Creating new user profiles on the iSeries
-
Finding CPF messages for a particular topic
-
Can an IPL start on its own?
-
Euro symbol on an iSeries
-
Command to find out who locked the file
-
Reading NETSTAT information
-
CPD0162 parameters don't match
-
iSeries MAC address
-
Installing CUM fixes
-
Reseting passwords
-
QUSRWRK cannot start QZDASOINIT job
-
Analyzing job run information