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

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