(Derek Tempongko and Paolo Bruni) This IBM Redpaper provides information about how to setup and configure DB2 9 for z/OS with Secure Sockets Layer (SSL) using the z/OS V1R10 Communications Server: IP Application Transparent -Transport Layer Security (AT-TLS) services. This paper also covers the basi
Tag: IBM
APAR Friday: Part 2, a couple of HIPERs
(Willie Favero) Part 2 of APAR Friday is about two APARs; one for DB2 Version 8 and DB2 9, the other only for DB2 9. However, both APARs are marked as HIPER so you should seriously consider applying them.
IBM Extreme Transaction Processing (XTP) Patterns: Leveraging WebSphere Extreme Scale as an in-line database buffer
(Lan Vuong) Learn how to optimize the performance of an application by leveraging WebSphere eXtreme Scale as the intermediary between the database and the application. This article provides an overview of the theory and implementation of the write-behind caching solution and JPA loader concepts. It
Compare access plan costs for DB2 for z/OS Optim Query Tuner Fix Pack 1
(Vivek Prasad) Hi, all. I am a developer on our Optim Query Tuner products. A new feature called ‘Compare Access Plan’ was shipped in Optim Query Tuner (for DB2 for z/OS) and Query Workload Tuner V2.2 fix pack 1 that allow DB2 for z/OS DBAs to compare the access path cost of SQL statements in packag
APAR Friday: Part 1, a few fixes I thought interesting
(Willie Favero) I will have three APAR Friday posts today; this is Part 1.
Excuse me, what year do we have? – Some usability enhancements for XQuery in DB2
(Henrik Loeser) Imagine that in the XML world there is already 2010, but in your relational world it’s still 2009. This or the reverse could happen if you directly use fn:current-date() in XQuery and the CURRENT DATE special register in SQL. The reason is that XQuery by definition operates in and r
Attribute configuration and inheritance in WebSphere Partner Gateway
(Mohan P Annamala, Anand Bandaru and Anil R Patlolla) This article explains the details of routing object inheritance in WebSphere Partner Gateway V6.2, then shows you how to set routing object attributes and use attribute configuration, attribute inheritance, and overriding attribute values in orde
Fix for ‘Index on Expression’ issue
(Willie Favero) I’ve discussed DB2 9 Index on Expression a couple of times in my blog back in the beginning of 2009.
Protect your data with Secure Sockets Layer support in Informix Dynamic Server, Part 1: Setting up SSL support in IDS
(Manoj Mohan and Lynette D. Adayilamuriyil) Secure Sockets Layer (SSL) protocol is a cryptographic protocol that provides privacy and security for data communication over the network. It uses encryption to provide a reliable end-to-end, secure, and authenticated TCP/IP connection. SSL uses digital c
Converting Number to Words Using SQL
(Shalom Momi Sabag) Two posts in one week? Christmas came early this year.
