(GaryCrupi) What’s that sucking sound? It’s the sound of ad-hoc, monster queries hitting your operational data, robbing your core business transactions of the processing cycles they need to generate cash and keep your customers happy.

A description of how the dimensional function periodsToDate can be used outside of a time dimension to calculate a running total against on online analytical processing (OLAP) data source.

(Klaas) In the last blog I told you that I started as a computer operator. That is a long time ago! In fact DB2 was not born yet and IMS was THE database. I am talking about 1979 and the computer in use was a 370/168. This computer had 16MB of memory and our total DASD space was less than […]

(Robert Catterall) Sometimes, an important DB2 for z/OS feature can be out there for years, and yet not be fully appreciated by lots of people in the DB2 user community. Table-controlled partitioning is such a feature. In this blog entry I want to generally set the record straight about table-contro

(Andrew J. Howes) This article shows you how to set up a Microsoft .NET web service and client that use Message Transmission Optimization Mechanism (MTOM) encoded attachments to interoperate with a WebSphere Enterprise Service Bus mediation. This is new function available in WebSphere Enterprise Ser

(Ember Crooks) Affects db2Œs locking/scanning behavior when using CS or RS isolation levels. Causes DB2 to skip uncommitted inserts as if they did not exist. Variable is activated at database start time, and is engaged (or not) at statement compile or bind time.

(Rebecca Bond) Synergy is important to a DBA. Throughout our day, we work toward outcomes that are greater than the sum of the individual tasks. When DB2 10 for LUW was released recently, I decided that synergy was important when it came to training as well. Fortunately, the timing of the relea

(Dave Beulke) Learning more about DB2 10 for LUW shows that this new release continues DB2’s leadership for reliability, availability and scalability over the rest of the DBMS industry options. In the previous weeks I have highlighted several of the other new features and today I would like to talk

(Ember Crooks) One of my most popular posts that’s specific to WebSphere Commerce is The 10 Commerce Tables You Should Be Familiar With. This is an updated version of that post, since the preferred method of dealing with attributes has changed. As a result, this post is only applicable to WebSphere

(Glenn Galler and Ron Bisceglia) Every customer needs a Disaster Recovery (DR) plan. The strategies used differ from one customer to another and they differ in time to recovery and loss of data. For IMS, there are five types of DR solutions: restart, recovery, recovery and restart, coordinated IMS a