1

Going Beyond 2 Servers – HADR as a High Availability/Disaster Recovery option.

When the client considers high availability and disaster recovery, they often do not know what they are talking about. Many times the client may be dropping buzzwords like “five nines”. To them this is the definition of disaster recovery. In other cases, they are thinking of a worst-case scenario where a whole data center falls off the face of the...

file0002061413324 1

db2commerce.com Year in Review – 2015

Site Stats 2015 was again a record year for db2commerce.com. This year saw over 380,000 page views, which is more than 100,000 more than last year! I expect next year to not be such a drastic increase because my traffic has been fairly even through this year instead of the rapid series of upward steps I’ve seen in previous years....

file7551347375723 2

DB2 Basics: The DB2 LUW Sample Database

I find the DB2 sample database useful for trying new things and proving to myself how things work. Why Use the Sample Database? The DB2 sample database is useful for a variety of reasons. Testing Connectivity Sometimes when building a new database server, we need to test connectivity from an application server or some random client into the new server....

file000956896813 3

Archiving Transaction Logs to a Vendor Solution

I have worked with three different vendors for backup solutions for various clients in the last few months, and several others over the course of my career. When either making archive log decisions or evaluating vendors, it is important to know the DB2 details behind what is going on Why Archive Transaction Logs at All? First and foremost, archive logging...

4

Looking at Sort Memory Performance on BLU

Performance tuning of BLU databases is an evolving topic at this time. For BLU databases, sort memory cannot be tuned by STMM, and so must be manually tuned. BLU also makes extensive use of sort memory. It is a bit of a misnomer at this point. It is more of a working memory area that is used for hashes, grouping,...

3

Who/What I’m Thankful for in the DB2 Community

It is a busy time of year for DBAs. Many of us will put in a large number of hours between Friday and Monday keeping ecommerce databases running and our company’s profits rolling. But it’s also a time of year in the USA where we take a moment to be thankful for the things around us and make sure that...

hand and light 2

A Faster Way of Joining When Applying a Distinct

I have been paying a bit of attention to cross-platform SQL optimization lately, and read this interesting post: https://www.periscopedata.com/blog/use-subqueries-to-count-distinct-50x-faster.html?utm_content=bufferaf11f&utm_medium=social&utm_source=linkedin.com&utm_campaign=buffer Being a bit of an experimenter, the first thing that I wondered is how DB2 would handle this scenario. Would the DB2 optimizer be smarter than others, or would the same hold true for DB2 that held true for PostgreSQL? Environment...

select2 0

Administrative SQL Cookbook: BLU Buffer Pool Hit Ratios

Purpose These statements calculates the buffer pool hit ratio for both BLU and non-BLU activity. This post includes three SQLs – for calculating at the database, bufferpool, and tablespace level. The separate BLU calculations are not yet included in sysibadm.bp_hitratio as of the writing of this article. Source While I’ve modified this statement, it comes from these two sources, both...