September 3, 2010 | Volume 7 Issue 35

ISSUE HIGHLIGHTS

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.

 


Read More >>

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.


Read More >>

Sponsor - The MC Press Bookstore
 
Learn to Use and Abuse PHP! Let PHP guru and co-author of The IBM i Programmer’s Guide to PHP unlock the hidden secrets of PHP. Discover highly practical, but atypical, ways of coding PHP that you’ll use on a weekly—if not daily—basis. Gain an insider’s knowledge of the incredibly dynamic language. Download a FREE chapter of this book. Just click now. >>
Read More >>

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.


Read More >>

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.


Read More >>

MC Software Center
 

Try S4i Disk Space Management for 30-days. When you buy, get FREE SUPPORT!

 

DASD-Plus, a Power tool offering disk diagnostics, analytics, reporting, management and unused space optimization can now be yours in one suite of three tools.

 

Clean your IFS. Reclaim your space. Mention code IBMSYS10 and receive your first year of support free when you buy DASD-Plus. Cannot be combined with another offer.

 

Request your no obligation free trial today!

The following trial software can also be found at the

Win an 3M Mini Projector! Visit the MC Webcast Center, the MC White Paper Center, MC Security Center or in the MC Disaster Recovery Center where you'll find the most comprehensive collection of IBM Power Systems solutions available. While there enter to win an iPod Touch…a $350 value! One lucky winner will receive one of their very own.

 

Have Trial Software you would like to list? Click here or call (208) 726-6822 for information.

 

 


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

 

Forums Sponsor

POPULAR FORUMS
  1. access Oracle, mySQl, MS SQL Server by embedded SQL in RPG (189 views)
  2. Common Table Expression (82 views)
  3. Official Review: The IBM i Programmer's Guide to PHP (66 views)
  4. IBMDA400 data connection hangs (28 views)
  5. TechTip: Simplify Your Development with DB2 Automatic Timestamp Support (11 views)
  6. Multi-core systems (7 views)
  7. Article Idea: What is the Extent of Outsourcing and H-1B Visas? (6 views)
  8. FIELDPROC for transparent column-level encryption (6 views)
  9. Cloud Computing (6 views)
  10. Mobile apps (6 views)

Forums

 

 

Search Sponsor

 

POPULAR SEARCHES
1. tom snyder
2. sql
3. PDF
4. xml
5. subfile
6. very best job
7. Wonderfull great site
8. this is be cool 8)
9. costagliola
10. vbscript

Search

 


Read More >>
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


Read More >>
   MC-STORE.COM