Category Archives: Techie Tips

Make sure your tools are up to the job

Posted on February 16, 2011 by laura

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 →

Share/Bookmark
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

Posted on January 31, 2011 by laura

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 →

Share/Bookmark
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

Posted on January 26, 2011 by laura

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 →

Share/Bookmark
Posted in DB2, DB2 Support, Julian Stuhler, Remote DBA, Techie Tips | Tagged , , , , | 1 Comment

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

Posted on January 20, 2011 by laura

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 →

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

Beware of “over-federating”

Posted on January 12, 2011 by Iqbal

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 →

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

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

Posted on September 2, 2009 by Iqbal

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 →

Share/Bookmark
Posted in Techie Tips | Tagged , , , | Leave a comment

Enabling Applications from Oracle to DB2 the Easy Way

Posted on August 6, 2009 by Administrator

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 →

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

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

Posted on August 3, 2009 by Administrator

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 →

Share/Bookmark
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

Posted on May 8, 2009 by Administrator

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 →

Share/Bookmark
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

Posted on April 14, 2009 by Iqbal

1.      During a recent migration exercise at a customer site the following error was encountered whilst migrating one of the databases: 2009-04-08-14.21.06.625141+060 E61438A838         LEVEL: Error (OS) PID     : 18892                TID  : 164         PROC : db2sysc 0 INSTANCE: db2inst1             NODE : 000 … Continue reading →

Share/Bookmark
Posted in DB2, DB2 8, DB2 9.5, Iqbal Goralwalla, Techie Tips | Tagged , , , , | Leave a comment