TechTips / Sys Admin


Partner TechTip: Manage by Exception! Get Rid of the Noise! PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 27 April 2012 00:00

Automate by eliminating the unnecessary messages.

tom_huntingtonWritten by Tom Huntington

Does your Operations team complain that many of the events they look at aren't important? Does your Operations team miss important events because they are hidden within the "noise" of the other messages (like a needle in a haystack)? Do you need a separate console for each partition or server they manage?

Add a comment
Last Updated on Friday, 27 April 2012 00:00
Read more...
 
Partner TechTip: Combine and Automate MS SQL Server and IBM i Processes PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 16 March 2012 00:00

Robot/SCHEDULE Enterprise runs your SSIS packages automatically.

tom_huntingtonWritten by Tom Huntington

More than 90 percent of the servers running next to IBM i servers are running Windows. And more than 50 percent of these Windows servers run MS SQL Server to perform some form of reporting against data that was stored on the IBM i system. This reporting process uses SQL Server Integration Services (SSIS) packages to bundle data and generate business reports.

Add a comment
Last Updated on Friday, 16 March 2012 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Analyze Your Programs and Applications, Part II PDF Print E-mail
Tips & Techniques - System Administration
Written by Jean-Paul Lamontre   
Friday, 03 February 2012 00:00

The first part of this article series showed how DSPOBJD can easily provide statistics to manage a general recompilation project. But it only touched the surface of all the things you get with the DSPxxx commands.

jean-paul_lamontreWritten by Jean-Paul Lamontre

Let's start with a review of the information we gathered in Part I by just using DSPOBJD.

Objects by Type and Year

This data is concerned with counting objects by type and by year of source update (for those that have a source, of course).

 

If we had used ODCCEN plus ODCDAT (i.e., the object creation date) instead of ODSRCC plus ODSRCD, we'd have gotten a report on recompilation instead of a report on source update.

Add a comment
Last Updated on Friday, 03 February 2012 00:00
Read more...
 
User Rating: / 5
PoorBest 
Partner TechTip: Old Reports Sitting on an Output Queue? PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 03 February 2012 00:00

Not a good idea!

tom_huntingtonWritten by Tom Huntington

Several months ago, I was visiting customers and reviewing their computer operations. A question that comes up more than I can believe is, "What do we do with all of the reports that are sitting on output queues?" This question always amazes me. There are companies with reports that have been sitting on output queues for five years or more!

Add a comment
Last Updated on Friday, 03 February 2012 00:00
Read more...
 
User Rating: / 1
PoorBest 
QuickLook: Rocket Software Servergraph Professional V6.2 PDF Print E-mail
Tips & Techniques - System Administration
Written by Rocket Software   
Friday, 06 January 2012 00:00

For anyone whose backed up data couldn't be restored when needed, Servergraph Professional offers assurance that you will not suffer that experience—ever again.

Written by Rocket Software, Inc.

Servergraph Professional is an agentless Web-based backup reporting, alerting, and monitoring tool that identifies—and even prevents—missed backups while it finds wasted space, boosts performance, and improves the reliability of backup servers. It also can create compliance reports and, optionally, charge-back reports showing the relative costs of storage and data protection services. Servergraph identifies storage and backup problems before they affect operations.

Add a comment
Last Updated on Wednesday, 04 January 2012 18:29
Read more...
 
User Rating: / 1
PoorBest 
Partner TechTip: Coordinate Business Processes Across Windows, Linux, UNIX, and IBM i Servers PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 06 January 2012 00:00

Monitor and control your data warehouse processes.

tom_huntingtonWritten by Tom Huntington

One great thing about my job is that I get to speak to thousands of customers each year and discuss the issues they encounter automating, monitoring, and managing their servers. Often people are unaware they even have an issue because they don't know that anything better is available.

Add a comment
Last Updated on Thursday, 05 January 2012 15:52
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Remove Column Separators in iSeries Access PDF Print E-mail
Tips & Techniques - System Administration
Written by Sam Lennon   
Friday, 16 December 2011 00:00

Don't like column separators in iSeries Access when you use yellow or turquoise? Here's how to easily remove them.

sam_lennonWritten by Sam Lennon

Column Separators occur automatically when you use yellow or turquoise on a 5250 color terminal. (When was the last time you saw one of those?) iSeries Access faithfully reproduces this behavior, as in Figure 1.

 

Column Separators have always mildly annoyed me, and I avoided using yellow and turquoise. They annoy me a more now, because I'm maintaining code in which the original developer liked to use yellow. There is no way to change the 5250 data stream, but iSeries Access gives you a preference setting where it is very easy to turn off column separators in a session so that Figure 1 turns into Figure 2.

Add a comment
Last Updated on Friday, 16 December 2011 00:00
Read more...
 
User Rating: / 7
PoorBest 
TechTip: Analyze Your Programs and Applications, Part I PDF Print E-mail
Tips & Techniques - System Administration
Written by Jean-Paul Lamontre   
Friday, 09 December 2011 00:00

In the first of this series of TechTips, find information about each object in each library.

jean-paul_lamontreWritten by Jean-Paul Lamontre

Recently, a friend called me for help. His boss asked him two questions:

 

 

  • How much lost or forgotten old RPG or CL do we have?
  • What is the status of the "general review of all the ILE programs" project?

 

He added, "I don't want a bullet-point listing. If you can give me a report in Excel in a normal table with normal filters, such as used by normal users every day, that would be better."

Add a comment
Last Updated on Wednesday, 07 December 2011 12:26
Read more...
 
User Rating: / 2
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 6 of 45

WEBCAST

MC Webcast CenterFEATURED WEBCAST

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!

 

TRIAL SOFTWARE

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.


   MC-STORE.COM