Articles & Content

DB2 for WebSphere Commerce

Expert tips on building and administering DB2 LUW databases for WebSphere Commerce

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

 
DB2 Administrative SQL Cookbook: Finding Unused IndexesPurposeTo generate a list of unused or not recently used indexes. Remember to not go entirely off of LASTUSED when deciding to drop an index, but to consider factors like when the database was last restarted and such. This SQL looks for Indexes that are: Not block or dimension indexesNot DB2 system …
db2commerce.com Year in Review – 2015Site Stats2015 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 step…
DB2 Basics: The DB2 LUW Sample DatabaseI 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 ConnectivitySometimes when building a new database server, we need to test connectivity from an applicati…
DB2 LOAD Utility and Check Pending StatesLoading 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…
Archiving Transaction Logs to a Vendor SolutionI 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 Tra…
Looking at Sort Memory Performance on BLUPerformance 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 has…
Who/What I’m Thankful for in the DB2 CommunityIt 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 tha…
A Faster Way of Joining When Applying a DistinctI 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…
Administrative SQL Cookbook: BLU Buffer Pool Hit RatiosPurposeThese 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 art…
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 ThemesI sure wish that DB2…