Author Archives: James Gill

IDUG EMEA 2016 – Day 1

IDUG EMEA 2016 is taking place in Brussels, so travel options were a bit more flexible this year. Having decided not to spend most of the day in the queue for security in Stansted airport, we opted to go via … Continue reading

Posted in DB2, IDUG EMEA 2016, James Gill, Uncategorized | Tagged | Leave a comment

IDUG EMEA 2015 Day 1

Arriving at lunchtime in Dublin the Sunday before the IDUG EMEA 2015 conference kicks off does leave one with half a day to kill. The half day in question was blustery with the threat of rain and so we elected … Continue reading

Posted in DB2, DB2 11, DB2 Geek, DBI, IDUG, IDUG EMEA 2015, James Gill, Julian Stuhler, mainframe, Paul Stoker, z/OS | Tagged , , , , , , | Comments Off on IDUG EMEA 2015 Day 1

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, capacity planning, DB2, db2 pureScale, Five days in the labs, James Gill, 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