(Willie Favero) I just returned home from almost a full week at SHARE. One fun aspect of attending conferences is the vendor area (or Expo as they call it). I get to stroll around and pick up really cool throw-away pens, small pieces of chocolate (lots of Nestles Mini Crunch bars this year for some

(Vikram Khatri) For example, if you have this Oracle UPDATE statement and wondering how can you use this in DB2. Here is the solution.

(Moira Casey and Marichu Scanlon) IBM Data Studio Developer V2.1 introduces new application developer functions and features, some of which are a direct result of the changes in the underlying Eclipse framework that Data Studio Developer uses. Data Studio V1.2 was developed using Eclipse 3.2.2, and

(Scott Hayes) It was about a year ago that a DBA in Sydney Australia asked me if I knew of a way to correlate database tuning efforts to Energy savings. IBM’s Smarter Planet campaign gave me renewed inspiration to research this important topic, for the fourth pillar of Smarter Planet involves seekin

(Dave Beulke) Validate the settings between your CICS transaction configurations. Make sure the maximum workload from one TOR, AOR or DOR is not overwhelming another CICS processing partner.

(Dave Screen) Security is an integral part of SOA, and since WebSphere ESB is at the heart of many SOA solutions, the security of a WebSphere ESB server and its transports is vital to the enterprise systems that use it. Messaging, such as the JMS implementation provided by WebSphere ESB, is particul

(Willie Favero) Two different problem scenarios and with one simple solution. I can’t believe I never noticed this bit of text in the manuals.

(Troy Coleman) In last week’s blog entry, I discussed the XML schema registration process, but I didn’t explain what the schema registration is used for. DBAs like it when the DBMS enforces the existence or non-existence of a column (not NULL versus NULL). It’s also nice to know that data values are

(GGZ) In one of my previous postings, I mentioned that there is no special setup needed to get started with XML in DB2 9 for z/OS. However, if you or your folks are getting more serious, some installation and serviceability parameters (zparms) related to XML may need to be adjusted. Here I will talk

(Henrik Loeser) I am always surprised how often I use the DB2 Information Center. I still remember my days as research assistant when I was the Informix DBA in our research group. We only had few printed manuals for each of the database products (Informix, DB2, ObjectStore, Illustra, Ingres, …) an