(Robert Catterall) First of all, if your organization uses DB2 for z/OS, I hope that you have a DB2 monitor on the system. While several of the DB2 DISPLAY commands provide information that’s useful for monitoring activity on a DB2 subsystem (a favorite of mine is -DISPLAY BUFFERPOOL(ACTIVE) DETAIL)
Other News
Load Knowledge Module Oracle to Oracle using database links
(Uli Bethke) ODI comes with an LKM to extract data from another Oracle database instance using db links via a view that is created at the source system.
Handling unique constraint violations by Hibernate
(Jeffrey Kemp) A particular table in our system is a M:M link table between Bonds and Payments, imaginatively named BOND_PAYMENTS; and to make the Java devs’ jobs easier it has a surrogate key, BOND_PAYMENT_ID. Its structure, therefore, is basically:
MDS or BIPLATFORM Schema Password Change Considerations
(Christian Screen) As you know the OBI 11g installation requires that the Repository Creation Utility (RCU) be run in advance to create a metadata repository for information used by OBI. During the installation of the RCU and the creation of the database users/schemas a password (or multiple depend
Using SSL with MySQL
(Daniël van Eeden) Since MySQL 4.0 it’s possible to use SSL to secure the connections to MySQL. Unfortunately this is not used very often.
XML Data Source – How To Convert Elements to Attributes
(Ged Mead) In this earlier blog on using an XmlDataSource as the data source of a DataList control in a web application, I mentioned that the XML data needs to be structured in a particular way. That is, all the data has to be structured in the XML document as attributes.
How indexing makes XPath fast
(Evan Lenz) Last year, I built my first MarkLogic app (RunDMC, on which this site is based). I used a lot of XSLT and a dash of XQuery and everything worked just as I expected it would. It also performed reasonably well.
XML Matters: SVG and the scriptless script
(Dethe Elza and David Mertz) Scalable Vector Graphics (SVG) browsers are becoming mainstream now, and they can be used in many powerful ways. Continuing on from David’s earlier SVG column, Dethe looks at some of the ways that declarative markup can replace script for animation and other common scrip
Identifying Worker Process (w3wp.exe) – IIS 6.0 and IIS 7.0 for Debugging ASP.NET Application
(Abhijit Jana) If you are debugging a ASP.NET web application which is hosted on IIS, you need to attach the particular worker process in Visual Studio to start debugging.
Microsoft SQL Server 2008 – Change Data Capture (CDC)
(Keshav Singh) Microsoft SQL Server 2008 has introduced a very exciting feature for logging DML changes. Previously, whenever there was a need for tracking all the modifications on critical tables done by ETL jobs or manual DMLs, developers needed to create triggers and log changes in explicit table