(Willie Favero) The amount of space available in a table space can always be a concern. When that table space happens to be on of the DB2 directory table spaces, then it can become a significant concern. SPT01 just happens to be one of those table spaces in the directory that can cause one’s heart t

(Dave Beulke) Designing the Unit-of-Work for a given transaction entails many components. Different techniques and methods are incorporated depending on the components such as Hibernate, iBatis, JPA or Enterprise Bean technology to process the transaction. The Java transaction framework and the ob

(Sailaja Bandlamoori and Tawanna Harris) As a DBA, it is crucial that you perform regularly scheduled database system backups as part of your backup and recovery strategy. In the event of an application or hardware failure, you can use these backups to restore your database. This article follows a d

(Paolo Bruni and Michael Schenker) This IBM Redpaper provides a step-by-step introduction on how to get started with Web services using Data Studio V2.1. Our goal is to explain basic concepts and introduce the functions that can help you take your first steps in the Web services arena with DB2 for z

(Radhesh Kumar) Few days ago, I received an e-mail from my colleague with following error message

(Shiu Fun Poon and Sid Misra) This article will cover how to use WebSphere DataPower SOA Appliances as the enforcement point of the WS-Security Policy. As well as discuss in detail how to offload Web Service Security Policy from WebSphere Application Server to WebSphere DataPower by using Policy Fra

(Lydia Parziale, Karen Bogart, Gerard Ceruti, Anbu Govindasamy, Sabine Jaeschke, Jörg Maier, Jochen Röhrig and Jon vonWolfersdorf) The power of the IBM System z, combined with the flexibility of Linux on System z, provides the ideal platform on which to implement SAP application servers. System z pr

(Patrick Titzler) IBM Data Studio pureQuery Runtime 2.1 includes a new feature, called client optimization, that enables database administrators and developers to take advantage of the performance and security benefits of static SQL execution against IBM DB2 databases without having to modify their

(Willie Favero) I thought reordered row format (RRF) was such a cool feature in DB2 9 for z/OS. Then, while presenting at IDUG in Warsaw, I was asked how to turn it off. I was completely unprepared for that question. After all, as I just stated, I liked the feature I was shocked that someone might w

(Conor O’Mahony) DB2 provides several options for storing and managing XML data. For many applications, the best option is to use pureXML, which stores XML data in its native XML format. However, in certain situations, other storage options can be beneficial. This article explains the XML storage op