Category Archives: James Gill

“If you’re a retailer with a high volume online transaction environment then DB2 pureScale is going to be absolutely ideal for you”

In our first Confessions of a DB2 Geek podcast we chat to two of our DB2 experts about pureScale and what this important new release means for organisations running DB2 on midrange platforms. An ideal fit for the retail sector, … Continue reading

Posted in DB2, DB2 Geek, DB2 LUW, James Gill, pureScale | Tagged , , | Leave a comment

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

DB2 UDB Monitoring

I’ve started work on a UDB snapshot monitoring tool to gather and retain information from database servers. Only minimal thought has gone into reporting at the moment, but this will probably be web based. The current proof of concept code … Continue reading

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