Author Archives: James Gill

Quick Tip – DB2 Diagnosis Guide

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

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

Five Days in the labs – Part 2. DB2 pureScale Coupling Facility

By James Gill We were lucky enough to get an opportunity to spend a week in the IBM Boeblingen Labs in Germany, to get some hands on experience with DB2 9.8 – pureScale – or Data Sharing on mid-range.  The … Continue reading

Posted in Availability & disaster recovery, DB2, Five days in the labs, James Gill, capacity planning, db2 pureScale, pureScale | Tagged , , , , , , | 2 Comments

Coupling Facility Sizing Tool

Just a short blog entry this week: If you find yourself trying to build a parallel sysplex, one of the things you’ll need to do is establish how big your coupling facility (CF) needs to be. IBM provide a handy … Continue reading

Posted in DB2, IBM, Information Management, James Gill, System Z | Tagged , , | Leave a comment

TWS – Export and Import

I had to set up 10 TWS batch schedules this week, and baulked a bit at the idea of going through the admin tool and clicking them all in. Following a discusion with a colleague, I came across a TWS … Continue reading

Posted in DB2, DB2 Tools, James Gill | Tagged , | Leave a comment

RESTORE.EXE Updated – 64-bit DB2 Support

As the title says, restore.exe (automated redirected restore with TSM support) has been tested against DB2 UDB V8.2 on Windows 2003 Server 64-bit (64-bit instance) and works. Next port will be to Linux 32-bit. Porting to 64-bit will be problematic … Continue reading

Posted in DB2, IBM, Information Management, James Gill, Linux, Techie Tips, Uncategorized | Tagged , , , , , , | Leave a comment

Snapshot Monitoring Tool Progress

Updates have been applied to snapper (data collector), snapsave (recorder) and snapmon (web based front end) to allow snapsave and snapmon to support multiple collectors.   New test data was generated, and it is now apparent that some summarisation of … Continue reading

Posted in DB2, DB2 Monitoring, DB2 Tools, IBM, Information Management, James Gill | Tagged , , , | Leave a comment

Progress on the snapshot monitoring tool

The front end has been modified to include updates to the report presentation: Colour coding of the grid report to show which columns are chartable. Charting support using Dojo.  The charts are presented in a “dialog box” (another Dojo widget). … Continue reading

Posted in DB2, DB2 Monitoring, DB2 Tools, IBM, Information Management, James Gill | Tagged , , , | Leave a comment

Snapshot Monitoring Tool – Latest

The snapshot monitoring tool now has a data recording component for DBM snapshots that records the event and all of the details into a DB2 UDB database.   Work has started on a web-based front end (Apache / PHP / … Continue reading

Posted in DB2, DB2 Monitoring, DB2 Tools, Information Management, James Gill | Tagged , , , , , | Leave a comment

Snapshot Monitoring Tool – Latest

The data capture aspects (“snapper”) of the snapshot monitoring tool are now complete. Thread scheduling has been verified, along with the timer thread operation and the communications thread.   A small command line utility has also been written to tell snapper to shutdown. … Continue reading

Posted in DB2, DB2 Monitoring, DB2 Tools, Information Management, James Gill | Tagged , , , , , , , , , | Leave a comment

Snapshot Monitoring Tool

The snapshot server / daemon is just about finished – I need to build in some way of driving the shutdown event (already built into all of the threads) and put some additional events in to make sure that all … Continue reading

Posted in DB2, DB2 Monitoring, DB2 Tools, James Gill | Tagged , , | Leave a comment