I don’t know about you, but I’m pretty addicted to db2top. I started using it way back when it was a download from Alphaworks. It is simply unparalleled for free real-time monitoring for DB2. No, it’s not full enough of a feature set to be your only monitoring tool, but I can barely troubleshoot a locking issue any more without it. I tried last night, and it took me four times as long, at least.
Why did I even try to troubleshoot an occurring issue without db2top? Well, I have these nifty new AIX servers that were allocated by someone in another country. And every time I try db2top on them, I got something that looked like this:
I can see a few parts that look like db2top there, but nothing readable, and it doesn’t get better if I change the screen size or if I hit a key to get to a different type of screen.
Searching the web brought me to this APAR:
http://www-01.ibm.com/support/docview.wss?uid=swg1IC73092
That is for 9.5. I am most certainly not using 9.5. These servers are 10.5, Fixpack 3. I had the same exact problem on 14 servers and 16 instances. My LANG variable was already correct. The ultimate resolution was to add these lines to my instance owner’s .profile:
LC_COLLATE="C" LC_CTYPE="C" LC_MONETARY="C" LC_NUMERIC="C" LC_TIME="C" LC_MESSAGES="C" LC_ALL= export LC_COLLATE export LC_CTYPE export LC_MONETARY export LC_NUMERIC export LC_TIME export LC_MESSAGES export LC_ALL
[…] Scrambled Output from db2top […]
So was it some form of code page conversion then?
Yes. I’m a tad worried about how these settings will affect me doing updates and such with non-ASCII characters, so we’ll see how that goes.
I had this issue, and your post helped me resolve it.. we are running on 9.7 fp5 Thanks for the post ember.
http://www.dbforums.com/db2/1690752-db2top-presentation-aix-putty-s-kcs.html
That leads to some interesting colors when working with a white background in iterm2. Not sure if I care enough about the colors to go back to working on a black background.
You can easily run db2top remote. Just install express-C on a linux PC (or linux virtual machine inside your windows desktop) and catalog all your remote databases there. Just start db2top on linux passing the required parameters and you get the best presentation.
This way you also monitor the DB2 databases running on windows, which do not have db2top (then again you have the good-old db2mon over there).
Combined with a nice desktop or tmux you can monitor many databases simultaneously.
Nice one Dick 😉