Category: Posts-By-Category

Screenshot_072215_080015_PM 5

Calculating PVUs for IBM DB2 on Linux

DBAs do not have to calculate PVUs(Processor Value Units) often. Many times there is a system administrator or someone else who might do this for us. Or if you’re buying everything from IBM, then they’re likely to calculate it. You may also easily be able to get the information you need from your hardware vendor and skip right to the...

1

Analyzing Package Cache Size

Note: updated 7/21 to reflect location of the package cache high water mark in the MON_GET* table functions I have long been a fan of a smaller package cache size, particularly for transaction processing databases. I have seen STMM choose a very large size for the package cache, and this presents several problems: Memory used for the package cache might...

5

Architecting High-Availability and Disaster Recovery Solutions with DB2

NOTE: Please do not attempt to architect a high-availability solution without a DB2 expert involved. There are many questions and answers needed beyond those here to make the best decision and ask all the tough questions. High Availability vs. Disaster Recovery High Availability and Disaster Recovery often have different goals and priorities. High Availability can be considered the ability to...

1

DB2 Basics: Filesystems for DB2 on Unix and Linux Systems

DB2 doesn’t have any defaults for filesystems because that is an OS-level thing. However, there are a few sanity checks and some recommeded separation when installing DB2 on Linux and UNIX operating systems. These are my best practices for installations, in general terms. Software Location The default location for installing the DB2 code in /opt/ibm/db2/V10.5 (replacing V10.5 with whatever version)....

file0002050295530 5

Multiple Index Regression Analysis

I actually had a blog entry started on this topic before IDUG. I knew this was possible, but not exactly how to do it. Then I sat in Scott Hayes’ session – D04 – More Sage Advice: Invaluable DB2 LUW Performance Insights from Around the Globe, and he had all the details I needed to really get rolling on trying...

3

A Couple of db2look Problems

I recently ran into a couple of db2look problems for different clients, and thought I’d share them in case someone else runs into them. db2look is a tool used to mimic databases, objects, or statistics. If you are not familiar with it, check out my post on DB2 Basics: db2look. db2look Problem with Packages Bound This problem occurred when I...

3

Happy 5th Blogiversary to db2commerce.com!

This week marks the 5th blogiversary of db2commerce.com! Wow, 5 years! A few statistics: Total posts published (including guest bloggers): 384 Years of averaging one or more posts per week: 3.5 (started in 2012) Total words published (including guest bloggers): 401,245 Longest post: 13,043 words (HADR Tools: HADR Calculator) Shortest post: 27 words (DB2 Haiku – Building Skills) Words published...

2

DB2 Basics: db2look

I was a bit shocked when I searched my own blog for entries on db2look and came up with nothing. While it’s not a complicated tool, db2look is an essential tool. What db2look Can Do db2look is a tool provided with DB2. db2look’s primary purposes are: Mimic Statistics – To generate the SQL to update statistics with the idea that...

nhkoningshof 1

Ember Speaking at DB2 Symposium in Eindhoven on 11 June

For the 5th blogiversary of db2commerce.com, I’m taking a European trip. It has been more than decade since I’ve been overseas, so I’m very much looking forward to it. I’ll be speaking at the DB2 Symposium in Einhoven on 11 June! I’ll be giving a day-long intensive on Lessons Learned Running DB2 for E-Commerce. An outline of what I’ll be...