Popular Posts
For when a first initial is all you can remember
Why you should program to interfaces in SQL
With DB2 9.7′s introduction of modules and the ability to create an alias on a module, you now have the ability to program to a function or procedure’s interface rather than its implementation. Why would you want to do this? In today’s post, I will go over reasons to program to an interface and show [...]
db2top: How to change column order and preserve it in the next session
Over the next few db2top-related blog posts, I am planning to post some videos that demonstrate some of the features I wrote about in earlier posts. First up is the Change Columns Order screen and a video to demonstrate how to change the column order and keep it changed for the next time you launch [...]
db2top Performance Report
Up to now, we have been looking mostly at db2top as a tool for observing the behavior of your system in real-time, but background mode and recording and playback has shown us that db2top can produce and examine historical data as well. The db2top tool can also be used to perform an analysis on such [...]
db2top Display Settings
When a monitoring or reporting tool reaches a certain level of sophistication, it needs to be able to report on itself as well. The db2top tool has a large number of configurable options, so it is fortunate that there is a screen that lets us see the present value of each such option. In today’s [...]
New in DB2 for LUW 9.7.2: UDF default parameters
IBM released DB2 for LUW 9.7.2 recently and, along with numerous quality improvements, there were a number of interesting new features. In today’s post, I will talk about the “default parameters in UDFs” feature and how that helped me shrink the amount of code I needed to write for one of my UDFs.
db2top Change Columns Order
What good is a tool if you can’t customize it to your liking? Fortunately, db2top is quite customizable. In today’s post, we will look at how you can customize the order in which columns are presented for the majority of those screens in db2top that present their information in a table.
Histograms
In Curt Cotner’s recent blog post, What’s new in statement-level performance metrics, he wrote about the popularity among customers of Optim Performance Manager (OPM)’s ability to create and visualize histograms of statement costs. In this post, I’m going to take a look at histograms in general, examine some histograms that are new in DB2 for [...]
Posted in db2, workload manager
db2top Sort
The db2top tool is all about showing the top sessions, bufferpools, tablespaces, etc. by some criteria. It wouldn’t be very useful if it didn’t let you choose these criteria. Fortunately, db2top lets you quickly base the order in which the data is presented on the criteria of your choice. In today’s post, we’ll see how.
Do your uninstall scripts leave something behind?
Have you ever needed to write a pair of scripts: one to create some tables, data types, or user-defined functions and a second to uninstall the same? How do you test that the uninstall script did its job and didn’t leave any database objects behind? Today, using a tool that comes with DB2, I’ll show [...]
Categories
-
