“Foglight Skills 101” Alarms
Foglight fires alarms when something being monitored is experiencing a lower- or higher-than-desired level, or “abnormal” behavior. You can help Foglight understand what “reasonable” levels of perfor...
5 fitness tips for PL/SQL code
5 fitness tips for PL/SQL code
How much time per day, week, or month do you spend on physical fitness training? I’m talking about strength training, functional training, cardio training, sports training, walking, taking the stairs ...
DBA heroics subdue DB2 performance problems
DBA heroics subdue DB2 performance problems
DB2 LUW DBAs are no different than DBAs who manage other types of databases—they are constantly pulled in many directions at once, and they are asked to keep databases and applications that use those ...
Five ways to be more proactive about DB2 performance problems
Before application users are affected! That’s when everyone would like to see database performance problems addressed. However, if you’re like many of the DB2 LUW customers I work with, and how I fu...
Improve your DB2 workload investigations with the new Foglight DB2 SQL Performance dashboard
Hello all. I am a sales engineer at Quest, so I assist customers with Foglight for DB2 installations and evaluations. People who manage performance of DB2 databases need a view in Foglight listing ...
Compare DB2 z/OS and LUW schemas? Yes, you can!
Compare DB2 z/OS and LUW schemas? Yes, you can!
Comparing schemas across database platforms, like DB2 LUW and DB2 z/OS, is sometimes necessary and often puzzling. No matter your motivation for comparing them, this can be a daunting task. Maybe you’...
Take Your Monitoring Insights to another Level Using New Analytic Views
Foglight 5.9.3 (core Foglight release) includes among its features new components for building dashboards called “analytic views”. The new view types are: Scatter Plot Chart, Bubble Chart and Tree M...
Track Down Useless Indexes Effortlessly with Toad for DB2 LUW
Track Down Useless Indexes Effortlessly with Toad for DB2 LUW
DB2 LUW indexes, like any database indexes, can be extremely helpful for queries that need data that’s scattered in the database. They act, of course, like a book’s index – rather than methodically ...
Be Doubly Selective with Two Foglight Report Parameterized Inputs: SQL Server Instance and Databases
Foglight reports can be extremely useful in broadening the reach of whatever monitoring you’ve got set up. Reports can be the mechanism for delivering PDF or Excel summaries of important information...
Minimize Risk by Simplifying and Automating Oracle Code Testing
Minimize Risk by Simplifying and Automating Oracle Code Testing
As I work with database management and application development pros at all types and sizes of organizations, I’ve been looking for trends in database code testing – unit testing of PL/SQL functions an...
Squash Your Mainframe SQL Tuning Anxiety With Toad™ for DB2 z/OS
Squash Your Mainframe SQL Tuning Anxiety With Toad™ for DB2 z/OS
Fear and confusion: two emotions you probably don’t like associated with your job. I see it often in my line of work, and have seen it for many years since I started working with mainframe files and ...
Run Oracle Scripts (Even against Multiple Databases) in the Toad Script Manager
Run Oracle Scripts (Even against Multiple Databases) in the Toad Script Manager
If your IT department or development team is like a lot of those I talk with (and have worked in), you have a lot of scripts that do all sorts of things. They are important to you, and that’s why yo...