TechTips / Sys Admin


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 
Partner TechTip: Why Did Our Cross-Platform Process Run So Long? PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 18 November 2011 00:00

Is your data warehouse out of date again, or did a Windows job run late?

tom_huntingtonWritten by Tom Huntington

I'm convinced that sometimes the only reason a Windows or UNIX server is alongside an IBM i server is for better data reporting or a data warehouse.

 

For example, at your site, a process periodically sends data from the IBM i server to the other server. Usually, the IBM i process that builds the data starts at 7:00 p.m. and the Windows process grabs the data at 8:00 p.m. Over the years, you've never had a problem because the IBM i process started one hour before the Windows process. But your business has grown and so has your data processing. The result is that the IBM i process runs longer each day.

Add a comment
Last Updated on Friday, 18 November 2011 00:00
Read more...
 
User Rating: / 1
PoorBest 
Partner TechTip: IFS Directory Backups Used to Be So Difficult PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 21 October 2011 00:00

Enjoy flexible IFS backups with Robot/SAVE.

tom_huntingtonWritten by Tom Huntington

On the IBM i server, we all store data that needs to be backed up in the Integrated File System (IFS). Are you struggling with a lack of flexibility for IFS backups because you have to back up the entire IFS? Would you like a more selective approach that allows you to save certain directories and files? How easy is it to restore specific IFS directories?

Add a comment
Last Updated on Friday, 21 October 2011 00:00
Read more...
 
Partner TechTip: Solve Business Issues with an Easy-to-Use BI and Enterprise Reporting Solution PDF Print E-mail
Tips & Techniques - System Administration
Written by Floyd Del Muro   
Friday, 07 October 2011 00:00

Is your business intelligence solution difficult to implement and use?

floyd_delmuroWritten by Floyd Del Muro

Are your reports out of date, and is your report request backlog growing? Do your business intelligence (BI) people spend most of their time redefining data to make your solution work? Does your technical team spend hours installing program fixes? Does your BI solution work with only one database? Is it too complicated for end users to write inquiries? Do you have to pay more to do more? Is your BI solution meeting your needs?

Add a comment
Last Updated on Thursday, 06 October 2011 11:56
Read more...
 
Partner TechTip: Automate Your IBM TS3500 Tape Library with Robot/SAVE PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 09 September 2011 00:00

Manage unattended backups using Robot/SAVE and your AML.

tom_huntingtonWritten by Tom Huntington

The IBM TS3500 can automatically load, unload, and eject tape volumes to provide an automated backup solution for IBM i servers. Yet, how many people can actually run this hardware unattended? Do your operators still start the process manually? Do they have to manually determine how to eject tapes and which tapes are available for daily backups?

Add a comment
Last Updated on Friday, 09 September 2011 00:00
Read more...
 
TechTip: Gather Linux Performance Data with nmon PDF Print E-mail
Tips & Techniques - System Administration
Written by Max Hetrick   
Friday, 19 August 2011 00:00

Use this open-source tool to view from one screen all the stats about CPU utilization, disk and network I/O, kernel performance, and more!

max_hetrickWritten by Max Hetrick

The very handy nmon utility measures live system-performance statistics on Linux, as well as gathers system information and details. The nmon project was originally an internal IBM project for monitoring AIX systems but has since been released under the GPL open-source license. The tool's original project page can be browsed from IBM's Web site. This tip looks at nmon from the Linux angle.

Add a comment
Last Updated on Monday, 29 August 2011 12:59
Read more...
 
Partner TechTip: Are You Happy with Your Disk Space Collection Utilities? PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 29 July 2011 00:00

How many different collections do you run?

tom_huntingtonWritten by Tom Huntington

One of my favorite parts of visiting with customers for Help/Systems is asking them what tools they're using and what they would like to have. When I ask people what they use for collecting disk space information, I get several answers.

Add a comment
Last Updated on Friday, 29 July 2011 00:00
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 7 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