Category Archives: Techie Tips

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

Don’t Miss The DB2Night Show Episode #39 – Top DB2 Support Issues and Solutions with Julian Stuhler

If you haven’t already marked your diary then grab a pen and make a note!  This Friday our very own Julian Stuhler will be a guest on The DB2Night Show™, the ever popular show from DBI Software.  Join in to hear him share his views … Continue reading

Posted in DB2, DB2 Support, 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 azithromycin order generic cialis pill security exposure. Using any DB2 client tool, it was possible to connect to the database as any user without having to … Continue reading

Posted in Techie Tips | Tagged , , , , | 1 Comment

Append only DB2 diagnostic log and administration notification log files? No more in DB2 9.7!

How many times have I asked customers for the DB2 diagnostic log file (db2diag.log) only to be told “it’s too large to send” or “it’s taking too long to open.” This is because the DB2 diagnostic files have been append … Continue reading

Posted in Techie Tips | Tagged , , , | Leave a comment

Enabling Applications from Oracle to DB2 the Easy Way

A recording of the live DB2 chat with the lab webinar held in July. DB2 9.7 for Linux, Unix, and Windows has out-of-the-box support for Oracle’s SQL and PL/SQL dialects. This allows many applications written for Oracle to execute virtually … Continue reading

Posted in DB2 9.7, Techie Tips | Tagged , , , , | Leave a comment

DB2 9.7 – Minimize planned outages when making changes to your database objects

IBM DB2 9.7 introduces enhancements that allow you to make changes to the database objects while keeping these objects fully accessible to the database users during the modification. These enhancements allow database administrators to make vital changes to the database … Continue reading

Posted in DB2 9.7, Techie Tips | Tagged , , | Leave a comment

Top 6 tips for a successful DB2 Performance Expert Deployment for DB2 for Linux, UNIX & Windows

Part 1 – Modifying settings, setting up alerts and using System Health data views Performance monitoring and tuning are critical tasks for a database administrator (DBA). DB2® Performance Expert helps DBAs tackle immediate performance problems, as well as avoid problems … Continue reading

Posted in DB2, DB2 LUW, IBM, Information Management, Techie Tips | Tagged , , , , | Leave a comment

Migration issues from DB2 V8.2 to DB2 9.5 on Sun Solaris 64-bit

1.      During a recent migration exercise at a customer site the following error was encountered whilst migrating one of the databases: canadian healthcare pharmacy 2009-04-08-14.21.06.625141+060 E61438A838         LEVEL: Error (OS) PID     : genuine viagra online without prescription 18892                TID  : 164         PROC … Continue reading

Posted in Techie Tips | Tagged , , , , | Leave a comment