Problem solve

Systems Management Tools

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

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

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

• 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

• 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

• System i modularization -- part 1

  Modularization is the key to reaping the benefits of Integrated Language Environment (ILE). It is the major factor in cutting development time and increasing programmer productivity -- the more effective the modularization, the more productive the ...Continue Reading

• Automatic software key installation

  Instead of manually typing your i5/OS software license keys into the system, you can download and install them automatically using the IBM Entitled Software Support Web site.Continue Reading

• Redirect ODBC to a separate subsystem

  We had ODBC connections that we wanted to isolate to its own subsystem to increase performance. You may have the same need. We are going to create a new subsystem, isolate the ODBC connections from the other ODBC traffic and create a filter on ...Continue Reading

• Creating LF over flat files

  Learn how to create to create logical files over flat ones with this step-by-step tip from Search400.com member Pankaj Jain.Continue Reading

• Change the IPL mode remotely

  This command will change the IPL mode remotely from the green screen.Continue Reading

• Fundamentals of Technology Project Management -- Chapter 3

  Fundamentals of Technology Project Management written by Colleen Garton and Erika McCulloch will help you to becoming a more effective, more efficient IT project manager.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

• Know what user pressed what from any system command screen

  In any application, you are surely using one of the iSeries system functions or commands (i.e. WRKSPLF, etc). And in some cases you want to easily track down programmatically what user pressed when they left a system command screen, so that you can ...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

• 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

• Enable the QSECOFR user profile

  This user has questions about enabling the QSECOFR user profile.Continue Reading

• Using subsystems to run job queues

  Continue Reading

• Using NetServer without entering a password

  Continue Reading

• Limiting the number of sessions

  Continue Reading

• Good descriptions of field names

  Continue Reading

• Delete members based on numbers of days old

  Don't waste your time searching, call this utility program to remove file members based on numbers of days old.Continue Reading

• Learn which JobQ an active job is running from

  Here's a simple command that helps you determine which JobQ an active job is running from?Continue Reading

• Delaying a job by less than a second

  Learn an easy way to poll a file.Continue Reading

• Check objects in directories other than QDLS

  Here's an alternative method to check for objects.Continue Reading

• Tapping WRKSYSACT to collect performance data

  What you may not know about WRKSYSACT is that you can run the command in batch to collect data about how well your system is performing.Continue Reading

• Should we do the CUM first or last?

  Continue Reading

• How to encapsulate SNA over TCP

  Learn how to encapsulate SNA over TCP so you can use the old SNA commands such as SAVRST*.Continue Reading

• Utility helps you determine the status of PTFs on your system quickly

  Ron Turull has created a utility that eases the task of determining if a particular PTF has been applied.Continue Reading

• Security Tools can help manage your system security

  You don't need to look far for tools to manage your system's security. Included in your iSeries is a generous set of utilities that can help you.Continue Reading

• Setting up a paging system from the AS/400

  Continue Reading

• Figuring out the metrics of 'five-nines'

  How much is enough? TechTarget spoke with analyst Aaron Goldberg about his recent research on Web site availability to help answer this question.Continue Reading

• Logging into QCTL and not in QINTER using Client Access

  Continue Reading

• The process of importing data into a spreadsheet

  Continue Reading

• Time to change the time on the AS/400

  Continue Reading