TechTips / Sys Admin

Partner TechTip: The Commercial Power of SQL-Based Monitoring PDF Print E-mail
Tips & Techniques - System Administration
Written by Kurt Thomas   
Friday, 16 May 2014 01:00

Discover how you can use the information from any classical iSeries physical or logical file from any application and apply real-time monitoring, alerts, and reports for better business performance.

kurt thomas.Written by Kurt Thomas

Organizations can now apply the valuable insights, analysis, and real-time notifications that they use for system information to information from broader business applications thanks to the SQL-based monitoring feature in QSystem Monitor. The implications could bring substantial benefits to the commercial bottom line and even provide businesses with new competitive advantage. The trick is knowing how and where to apply SQL-based monitoring in your IBM i environment.

Add a comment
Last Updated on Thursday, 15 May 2014 13:05
TechTip: Monitoring AIX with SNMP PDF Print E-mail
Tips & Techniques - System Administration
Written by David Tansley   
Friday, 18 April 2014 01:00

It's not hard to get SNMP v1 up and running. Just follow these simple steps.

david tansleyWritten by David Tansley

A few weeks ago, I received an email from a fellow AIX system administrator, who was having issues trying to get his SNMP v3 (Simple Network Management Protocol) client talking to the local SNMP monitor server. After a few email exchanges, I suggested he revert back to SNMP v1 to test the connectivity. I sent him a bare bones config file for SNMP v1 to test. The system admin was surprised by how small in size the config file was to get SNMP working. So let me share with you in this article how to mskr SNMP v1 communicate with an SNMP-aware monitor server. The standard configuration file AIX ships is over a 100 lines long. You don't need all those config entries to get SNMP up and running.

Add a comment
Last Updated on Friday, 18 April 2014 01:00
Partner TechTip: The Many Ways Robot Supports SNMP PDF Print E-mail
Tips & Techniques - System Administration
Written by Chuck Losinski   
Friday, 11 April 2014 01:00

Is your SNMP enterprise management solution busting your budget? Do you even have a trap-monitoring product in place? Learn how Robot products can double as an inexpensive solution for SNMP management.

chuck losinskiWritten by Chuck Losinski

SNMP (or simple network management protocol) is the network management and monitoring standard in the IT industry. Many devicessuch as switches, routers, printers, and servershave this protocol built in. SNMP is also used as one of the notification and escalation methodologies available in Robot products. Take as example a disk failure message or application message waiting and intercepted by Robot, or issues regarding a Robot-submitted job that ended abnormally. Typically, these events (SNMP traps) are directed to a central SNMP manager, which may be a central, corporate-wide, problem-ticketing system or management console. They can also be directed to Robot if you do not have a trap-monitoring product already in place (see Robot/TRAPPER below).

Add a comment
Last Updated on Friday, 11 April 2014 01:00
Partner TechTip: Reply Trace Is Like Analyze, "Premium Edition" PDF Print E-mail
Tips & Techniques - System Administration
Written by Kurt Thomas   
Friday, 28 March 2014 01:00

When you make changes to autoreplies in QMessage Monitor, Analyze is the must-use functionality. But what if new autoreplies don't work as intended? Meet Reply Trace, a powerful new feature that illuminates autoreply issues for fast investigations.

kurt thomas.Written by Kurt Thomas

Existing QMessage Monitor (QMM) users will know it is best practice to use the Analyze function after changing or adding autoreplies. Available in the PC module Maintenance by right-clicking an autoreply, the Analyze function checks which autoreplies share the same message ID with the currently selected autoreply. When matches are found, a list is generated that is split into two categories— "Affected" and "Affects"—as shown in figure 1 below.

Add a comment
Last Updated on Friday, 28 March 2014 01:00
Partner TechTip: What Makes the Good Morning Report So Good? PDF Print E-mail
Tips & Techniques - System Administration
Written by Chuck Losinski   
Friday, 21 March 2014 01:00

You're out of traffic, you've got your coffee—it's time for some news about your system, delivered hot off the press in your Good Morning report.

ChuckLosinski 116x116Written by Chuck Losinski

There's nothing like waking up to find the latest news delivered right to your doorstep, waiting for you on the printer, or sent to you electronically. For years, our customers have started their days reading the Good Morning report from Robot/SCHEDULE. But this report is more than just a good way to start your day. It's full of advantageous parameters and can be used for your other Robot tools, too!

Add a comment

Last Updated on Thursday, 20 March 2014 12:28
TechTip: Manage Processes and Revenue with SugarCRM's Community Edition PDF Print E-mail
Tips & Techniques - System Administration
Written by Martin Schneider   
Friday, 14 March 2014 01:00

Sugar CE is a great tool for developers and end users who understand the value of automation software but lack the resources to jump in whole hog on a large commercial project.

martin schneiderWritten by Martin Schneider

Many small and mid-sized businesses can benefit from customer relationship management (CRM) software. However, every business has unique processes and data points in their key sales, marketing, and support operations that make it difficult or expensive to purchase and deploy proprietary CRM tools.


 In addition, many proprietary or SaaS CRM systems lack the ability for internal developers to take the software and make deep customizations or integrationseither as a test of the system or for production usage. Or these systems require significant up-front investment to do so.

Add a comment
Last Updated on Thursday, 13 March 2014 12:45
TechTip: Dynamic Menu Using Tree Data Structure PDF Print E-mail
Tips & Techniques - System Administration
Written by George Karkavitsas   
Friday, 20 December 2013 01:00

This method for deploying menus uses only three objects to represent as many menus as needed. And menus can be changed by editing the file's records, instead of the code.

george karkavitsasWritten by George Karkavitsas

A menu is a list of options from which the user makes a selection. Each option is a brief description of the job that will be run when the user makes that selection. An option can lead to a program or to another menu of options. In IBM i, a menu consists of one display file, one message file, and one *MENU object [1]. In the IBM i environment, the display file contains the menu image, the message file contains the commands, and the *MENU object contains the name of the display file and the message file. In order to create one menu, we have to create a source file for the specified menu, define prompts for the menu image, define the command source for the menu, and finally save and compile the menu and command sources. If we want to change the menu, we have to reedit the code and recompile objects. This method is inconvenient if there's a large amount of menus, if we need to change options, or even if we want to avoid editing code.

Add a comment
Last Updated on Thursday, 19 December 2013 17:30
User Rating: / 6
TechTip: Try LPAR2RRD for Automatic CPU Monitoring PDF Print E-mail
Tips & Techniques - System Administration
Written by Pavel Hampl   
Friday, 22 November 2013 01:00

It's super easy, and even better, it's free!

pavel hamplWritten by Pavel Hampl

Here's the challenge: How do you monitor your IBM Power Systems' CPU usage without using commercial tools, operating system agents, or SNMP?

The answer is the free, open-source LPAR2RRD package. It does exactly that and offers a lot of additional unique features as well.

Add a comment
Last Updated on Thursday, 21 November 2013 11:53
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 3 of 47



See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:


  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.