Category Archives: DB2 Tools

DB2DART – Hints & Tips for the DBA

In his recent presentation on the DB2Night Show, Iqbal Goralwalla shared with attendees hints and tips on using DB2DART to achieve storage reclamation, address index corruption, extract data and remove backup pending status.  100% of attendees at the live show said … Continue reading

Posted in DB2, DB2 LUW, DB2 Monitoring, DB2 Support, DB2 Tools | Tagged , , , | Leave a comment

DB2 Support Video – Monitoring transaction times

In our latest video demo our Remote DBA team show how they use Brother-Thoroughbred® from DBI Software to measure customer’s transaction times, time distributions and service level attainments.   Tweet// < ![CDATA[ // < ![CDATA[ // < ![CDATA[

Posted in DB2, DB2 LUW, DB2 Monitoring, DB2 Support, DB2 Tools | Tagged , , , | Leave a comment

Triton Expert Headlining the DB2Night Show™ – All About DB2DART

We’re excited that one of our top DB2 Geeks, Iqbal Goralwalla will be presenting on next weeks’ DB2Night Show.  His specialist subject will be DB2DART. There are several powerful and important commands in DB2 LUW and “db2dart” is among the … Continue reading

Posted in DB2, DB2 Geek, DB2 LUW, DB2 Monitoring, DB2 Support, DB2 Tools, IDUG EMEA 2011, Iqbal Goralwalla | Tagged , , , | Leave a comment

Make sure your tools are up to the job

We had a customer who had a COGNOS 8/BI development environment running against DB2 AIX V9.5.  They were having issues with extremely long elapsed times for COGNOS-generated queries (over 30 minutes!).  Temp space was being exceeded and users were increasing … Continue reading

Posted in DB2, DB2 Monitoring, DB2 Support, DB2 Tools, Remote DBA, Techie Tips | Tagged , , , , | 1 Comment

The DB2Night Show sets new records with TOP DB2 LUW Support Issues

Last week Triton’s Julian Stuhler appeared on the ever popular DB2Night Show run by DBI software.  We’re delighted to report that this issue on “Top DB2 LUW Support Issues” set a new record for audience registrations.  Julian shared an assortment … Continue reading

Posted in DB2, DB2 Administration, DB2 Support, DB2 Tools, Julian Stuhler, Remote DBA, Techie Tips | Tagged , , , , , | 1 Comment

Latest from the DB2 Geeks – 5 Clicks to DB2 Success!

Have you heard the latest from the DB2 Geek?!  If not then take a look http://www.triton.co.uk/confessions-of-a-db2-geek/article/38/5-Clicks-to-DB2-Success! We chat to Scott Hayes to get the inside info on his “5 clicks to success” methodology.  Being a fellow DB2 Geek, Scott was … Continue reading

Posted in DB2, DB2 Geek, DB2 LUW, DB2 Monitoring, DB2 Support, DB2 Tools, Remote DBA, Techie Tips | Tagged , , , , , , | 1 Comment

Beware of “over-federating”

During a recent DB2-LDAP configuration at a client site, I stumbled upon a bizarre security exposure. Using any DB2 client tool, it was possible to connect to the database as any user without having to get the password right! Once … Continue reading

Posted in DB2, DB2 Administration, DB2 Geek, DB2 Support, DB2 Tools, Iqbal Goralwalla, Techie Tips | Tagged , , , , | 1 Comment

DB2 Cloning Tool for z/OS

Fast, automated DB2 cloning and refresh operations to boost results 17th November 4pm UTC There are many reasons to clone DB2 systems and refresh table spaces; create test environments, stage data-warehouse loads and offload business processed from production to other … Continue reading

Posted in DB2, DB2 Tools, System Z | Tagged , , , , | Leave a comment

Database performance monitoring & tuning for real business benefits

In their latest video, DBI Software demonstrate the importance of effective database performance monitoring and tuning to: Lower energy costs Improve ability to optimize existing IT assets Avoid or defer hardware upgrades  Dramatically cust software licensing costs Improve productivity and … Continue reading

Posted in DB2, DB2 Monitoring, DB2 Tools | 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