Category Archives: System Z

Quick Tip – DB2 Diagnosis Guide

Posted on March 16, 2011 by James Gill

Did you know that as from February 2007 (with UK21798 for DB2 z/OS V8) the Diagnosis Guide ships as part of SDSNIVPD – member DSNDR? Do a binary download of this to get the version that applies to your current … Continue reading →

Share/Bookmark
Posted in DB2, DB2 10, DB2 8, DB2 9, System Z | Leave a comment

APAR UPDATE – INSERT performance in critical DB2 9 for z/OS tables

Posted on February 8, 2011 by Julian

Are you trying to improve INSERT performance in your critical DB2 9 for z/OS tables? Many DB2 experts have given excellent presentations on this important subject, and there are several good techniques you can use to reduce the elapsed time for … Continue reading →

Share/Bookmark
Posted in DB2, DB2 9, System Z | Tagged , , , | 1 Comment

Ultimate protection for your business data – IBM information protection solutions for System z

Posted on June 23, 2010 by Administrator

Latest Webcast from IBM This session will cover the end-to-end monitoring, alerting and protection of information that’s stored on or managed by System z. You’ll see how it can help: Ensure compliance by properly controlling who sees, uses and accesses your … Continue reading →

Share/Bookmark
Posted in DB2, System Z | Tagged , , , , , | Leave a comment

Justifying the Upgrade to IBM DB2 10 for z/OS

Posted on May 17, 2010 by Julian

In his column for Database Journal Julian Stuhler looks at how an upgrade to DB2 10 can be justified. Under current economic conditions IT professionals are being asked to give short-term business benefit cases before any major infrastructure upgrade is agreed. … Continue reading →

Share/Bookmark
Posted in CIO, DB2, DB2 10, Julian Stuhler, System Z | Leave a comment

How many DB2 for z/OS Stored Procedures?

Posted on May 6, 2010 by Julian

As always, the answer to this is “it depends”! However, here are some basic rules of thumb that you may find useful: • Define an application environment specifically for your Java stored procedures. This should have NUMTCB set to a … Continue reading →

Share/Bookmark
Posted in DB2, DB2 Support, Julian Stuhler, System Z | Tagged , , , , | Leave a comment

Improving your life as a DBA in today’s turbulent environment

Posted on April 16, 2010 by Administrator

Webcast from IBM. April 20, 2010, 11 a.m., Eastern Daylight Time, 3:00 p.m. UTC The life of a database administrator (DBA) is not easy these days. Database performance issues, worries about data corruption and loss, expanding business requirements, and rising chargeback … Continue reading →

Share/Bookmark
Posted in DB2, IBM, System Z | Tagged , , | 1 Comment

Julian Stuhler’s Guest Blog on “Getting the Most out of DB2 for z/OS and System z”

Posted on April 14, 2010 by Julian

I’d like to follow up on a topic last mentioned in this very column last November, on the subject of “Not Accounted” time (link here ). The list of possible explanations for not accounted time that Willie referred to was … Continue reading →

Share/Bookmark
Posted in DB2, System Z | Tagged , , , | Leave a comment

DB2 Geek Confession of the Month

Posted on March 9, 2010 by Administrator

March 2010- Unintended Consequences We’ve all done it.  You see a great new feature in DB2 and jump headling into using it without fully appreciating all of the implications.  Here’s a case in point: One of our clients is a … Continue reading →

Share/Bookmark
Posted in DB2, DB2 9, DB2 Geek, Julian Stuhler, System Z | Tagged , , , , | Leave a comment

Techie Tip – Real Time Statistics (RTS) feature

Posted on March 1, 2010 by Julian

If you make use of RTS and DEFINE NO, you might want to review your processes to ensure that you’re picking up all of the tablespaces you should be…… Since V7 of DB2 for z/OS, IBM has provided a Real … Continue reading →

Share/Bookmark
Posted in DB2, DB2 9, DB2 Support, IBM, System Z | Tagged , , , , , , , | Leave a comment

Arcati Mainframe Yearbook 2010

Posted on February 16, 2010 by Administrator

The 2010 Arcati mainframe yearbook is now available to download here. This year’s topics include: Mainframe continuity planning Leveraging existing mainframe investmentsin modernisation projects Lowering mainframe TCO through zIIP speciality engine exploitation SNA mainframe security TurboHercules and disaster recovery – … Continue reading →

Share/Bookmark
Posted in System Z | Tagged , , | Leave a comment