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 Basics: Beyond Just Taking a Backup – Backup Performance, Utilities, and More!While I've covered this topic in detail, and blogged about a specific backup performance problem, I've never talked about this at the basics level. What is a Backup?A backup is a binary image of the entire Db2 database.... Read the rest
SQL Differences Between Db2 and InformixI have been working with Informix from a user perspective recently. I learned about some of the SQL differences and developed a greater empathy for developers in the process. CTE Support is covered, along with comparing the date and time handling syntax.
SQL That Meant Well: Where Functions are AppliedNot only was this delete running unreasonably slow – it was also causing lock timeouts on the MEMBER table while running because of the slowness. This post contains application specific details that you don’t need to understand the underlying concept here, which applies across many SQL statement…
SQL That Meant Well: Applying Conditions in the Subquery vs the Outer QueryThis is a new series that has been percolating in my head for a while. When I help clients with SQL, we're often adding (or removing) indexes to help SQL performance. It has been said (though not by me) that SQL re-write is obsolete because the Db2 Optimizer will take care of that.... Read the rest …
Connecting to an Informix Database from Jupyter NotebookThere is almost nothing in this blog post about Db2. This is unusual for me. But I had a bear of a time figuring this out, so I need to share. I have a lot of Db2 performance data that is stored in an Informix databse. This means that if I want to apply things I'm learning with Jupyter Notebook and …
Update on Ember’s Data Science Journey – February 18, 2019I've been moving along well this year on my data science journey. I've been thoroughly enjoying an edX class: Python for Data Science from UC San Diego. I started using Jupyter Notebooks (Python Kernel) over a year and a half ago, so I am enjoying the course on three levels: It seems easy because I …
Db2 SQL Basics: The Column ListLearning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.... Re…
Db2 SQL Basics: The Most Basic Select StatementLearning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.... Re…
Using Windows AD groups in DB2DB2 has an "interesting" relationship with Windows OS, and one of the areas where that relationship comes to the surface is user authentication and authorization, particularly when one is trying to use Active Domain groups for authorization purposes. Here are a few pointers: Don't use CLIENT authent…
IBM Moves RFE Process to Aha PlatformI’ve long been both a proponent and a critic of IBM’s RFE(Request For Enhancement) program. For a several years, it was clear that RFEs just went into a black hole. Then, several years ago, IBM started actually paying attention and implementing them. There have been a number of them implemented …