Category Archives: Information Management

A Hawk-Eye View

Our Brothers across the pond, DBI, have launched their new generation of performance monitoring software.  Brother-Hawk sends automated, customised alerts based on the characteristics of real-time and recently computed data.  Specifically for DB2 LUW databases it gives lights-out alerting of potential … Continue reading

Share
Posted in database auditing, DB2, DB2 LUW, DB2 Monitoring, Information Management | Tagged , , , , , , | Comments Off on A Hawk-Eye View

DB2 for z/OS Plan Stability

One of the major headaches all DB2 users face when upgrading to a new release is the possibility of access path regression. In order to benefit from enhancements to the optimiser, plans and packages need to be rebound under the … Continue reading

Share
Posted in DB2, IBM, Information Management, Julian Stuhler, System Z, Techie Tips | Tagged , , , , , , | Comments Off on DB2 for z/OS Plan Stability

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

Share
Posted in DB2, IBM, Information Management, James Gill, System Z | Tagged , , | Comments Off on Coupling Facility Sizing Tool

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

Share
Posted in DB2, IBM, Information Management, James Gill, Linux, Techie Tips, Uncategorized | Tagged , , , , , , | Comments Off on RESTORE.EXE Updated – 64-bit DB2 Support

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

Share
Posted in DB2, DB2 Monitoring, DB2 Tools, IBM, Information Management, James Gill | Tagged , , , | Comments Off on Snapshot Monitoring Tool Progress

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

Share
Posted in DB2, DB2 Monitoring, DB2 Tools, IBM, Information Management, James Gill | Tagged , , , | Comments Off on Progress on the snapshot monitoring tool

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

Share
Posted in DB2, DB2 Monitoring, DB2 Tools, Information Management, James Gill | Tagged , , , , , | Comments Off on Snapshot Monitoring Tool – Latest

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

Share
Posted in DB2, DB2 Monitoring, DB2 Tools, Information Management, James Gill | Tagged , , , , , , , , , | Comments Off on Snapshot Monitoring Tool – Latest