Profile cover photo
Profile photo
db2commerce
56 followers -
Expert Tips on DB2 and WebSphere Commerce at http://db2commerce.com
Expert Tips on DB2 and WebSphere Commerce at http://db2commerce.com

56 followers
About
Posts

Post has attachment
New Post: DB2 Administrative SQL Cookbook: Finding Unused Indexes
Add a comment...

Post has attachment
New Post: 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. Despite the drastic increase in views, this was the first year I didn’t double the page views from the previous y...
Add a comment...

Post has attachment
New Post: 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. Having the sample database available makes this easy because we can test the full range ...
Add a comment...

Post has attachment
New Post: DB2 LOAD Utility and Check Pending States - Loading data into a DB2 database using the LOAD utility has a lot of ins and outs. If a DBA has spent a lot of time working in a database without referential integrity or check constraints, then they may forget to check for tables in a check-pending state after loading data. To illustrate the points here, I’ll be using the SAMPLE database and examples you can work through to learn the concepts in detail. The Problem This problem is fairl...
Add a comment...

Post has attachment
New Post: 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 must be enabled to take online backups. Even in some of the smaller data ware...
Add a comment...

Post has attachment
New Post: 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, aggregations and more. Each query may easily allocate more than one sortheap. Each operator in the explain plan can have its o...
Add a comment...

Post has attachment
New Post: 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 the people we are thankful to and for are aware of it. I am thankful for a lot of things in the world, but here are some of the things...
Add a comment...

Post has attachment
New Post: 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, ...
Add a comment...

Post has attachment
New Post: Administrative SQL Cookbook: BLU Buffer Pool Hit Ratios
Add a comment...

Post has attachment
New Post: Insight 2015 Brain Dump - I call my post-conference blog posts brain dumps because that is largely what they are – information formatted in a way my brain understands but not necessarily as thoroughly organized and researched as you might be used to seeing from me. Conference Generalities Overall Themes I sure wish that DB2 was more highlighted overall, but I’m sure that’s largely a personal bias. I find Insight to be very buzzword oriented. This year’s buzzwords were clearly Cogn...
Add a comment...
Wait while more posts are being loaded