MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

September 3, 2010 | Volume 7 Issue 35


TOP STORY: TechTip: Simplify Your Development with DB2 Automatic Timestamp Support
FEATURED ARTICLE: QuickLook: S4i Systems DASD-Plus
ADVERTORIAL: Partner TechTip: Save-While-Active for Backups Can Be Handy
NEWS HIGHLIGHT: QSystem Monitor Now Flags I/O Hungry Jobs
FORUM: Using Common Table Expressions with UPDATE?
TRIAL SOFTWARE: Try S4i Disk Space Management for 30-days. When you buy, get FREE SUPPORT!
BLOG:System i Management Tips

Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
T.L. Ashford is “The Labeling Answer”® for the System i.

Ashford's Barcode400 has been the dependable choice for the industry since 1983. With Barcode400's newly enhanced Graphic Designer no “green screen” interaction is needed for label design. New features include: AFP/HP-compatible printing, easy-to-use graphics import tool, test print to desktop printer, simple font download tool, updated drivers and format listing reports. Even compliance labeling is made easy with design templates. Call 800-541-4893 to order your Fully-Functional, FREE Trial Software or visit us at T.L. Ashford & Associates.

Also, be sure to download the new white paper: Bar Code / RFID Label Printing, Don't get caught in the integration trap.



Feature Article - TechTip
TechTip: Simplify Your Development with DB2 Automatic Timestamp Support

Minimize your application development costs by moving your timestamp logic into the DB2 for i database engine.

kent_milligan_117x117Written by Kent Milligan

Many applications have logic to capture and record a timestamp that indicates when certain business events occurred, such as when an order was placed or changed. While this application logic is fairly simple, there is still a cost to coding, testing, and maintaining this code. You can reduce these application development costs by instead moving this timestamp logic into your DB2 table definitions and relying on DB2's "automatic" timestamp support.


Feature Article - System Administration
QuickLook: S4i Systems DASD-Plus

The native IBM i utility provides for running numerous automated disk cleanup jobs to help improve system performance.

Written by S4i Systems

Editor's Note: To download and try DASD-Plus at no obligation, visit the MC Software Center.


DASD-Plus is a utility that allows iSeries/System i administrators to schedule more than 27 automated cleanup jobs. These jobs can be run either in a "what-if" scenario to check out what will be cleaned up if the process is actually run or in a "commit" mode to clean up history logs, alerts, message queues, spool files, etc. Administrators can run surveys to monitor changes in libraries, objects, directories, and entries as well as monitor for spikes in disk utilization.


Advertorial - Help/Systems
Partner TechTip: Save-While-Active for Backups Can Be Handy

Automate your backups with save-while-active.

tom_huntingtonWritten by Tom Huntington

Although the save-while-active feature for backups has been around for many years, a lot of customers are afraid to use this parameter in their save commands. They may have heard something bad about the process at a conference, or they may have tried it and it didn't work. I've found the parameter to be very helpful, but you have to understand how best to use it.


In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor





MC Industry Blogs

BLOG: System i Management Tips from Vision Solutions, Inc.


Latest Posting: 3/26/10 Additional ways to see the contents of a user space (*USRSPC)


01/29/10 How to determine the jobs or objects responsible for generating journal entries in a journal receiver?

12/17/09 How to search for text in a file at the member level

11/20/09 Simplify replication of devices between two systems by matching hardware resource names

10/21/09 Know the impact of using the ENDJOBABN command

10/2/09 How to rapidly set up a network printer using IBM Personal Communications