TechTips / Sys Admin


Partner TechTip: Automate the Un-Automatable PDF Print E-mail
Tips & Techniques - System Administration
Written by Chuck Losinski   
Friday, 27 July 2012 00:00

Don't let operators or users waste valuable time and system resources by running reports and other processes with incorrect parameters or at the wrong time.

ChuckLosinski 116x116Written by Chuck Losinski

Do you still have people running reports repetitively at a certain time of day, week, or month? Maybe your ERP system has a series of demand reports, supplier order reports, or inventory reports that must be run, and you have an operator or clerk running those reports manually from a green-screen? Have these reports ever run with incorrect selection criteria? Maybe someone input an incorrect product line or date range? Or maybe someone took a vacation day and the reports didn't run at all?

Add a comment
Last Updated on Friday, 27 July 2012 00:00
Read more...
 
User Rating: / 1
PoorBest 
Partner TechTip: Avoid a System Crash! PDF Print E-mail
Tips & Techniques - System Administration
Written by Chuck Losinski   
Friday, 29 June 2012 00:00

Automate your storage analysis and cleanup.

chuck losinskiWritten by Chuck Losinski

In a recent Webinar, we highlighted the fact that if you max out your disk space on IBM i, the system will simply IPL and may delete all your spool files to make room. How inconvenient! Polling during the Webinar indicated that 10 percent of respondents had experienced an automatic IPL because their disk had become full.

Add a comment
Last Updated on Thursday, 28 June 2012 15:26
Read more...
 
User Rating: / 1
PoorBest 
Partner TechTip: Hit a Home Run with Your Financial Reporting PDF Print E-mail
Tips & Techniques - System Administration
Written by Mike Stegeman   
Friday, 01 June 2012 00:00

Want to streamline your budgeting and financial analysis?

mike_stegemanWritten by Mike Stegeman

When your general ledger and transaction files are on your IBM i system and your budget data is in Excel, comparing the two can be a real challenge. Does your team have the right equipment to stay in championship form so you can streamline your budgeting and financial analysis?

Add a comment
Last Updated on Friday, 01 June 2012 00:00
Read more...
 
Partner TechTip: How Can You Sleep at Night Without It? PDF Print E-mail
Tips & Techniques - System Administration
Written by Tom Huntington   
Friday, 25 May 2012 00:00

Automate your job scheduling and eliminate sleepless nights.

tom_huntingtonWritten by Tom Huntington

What keeps you up at night? Imagine being a data center manager and having to worry each night whether your team will run processes in the correct order, whether they might miss an event, or whether they'll forget that there is a special process to run.

Add a comment
Last Updated on Thursday, 24 May 2012 14:31
Read more...
 
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 
<< 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