(Roger Sanders) Here’s a quick way to stay on track with your preparation for the DB2 9 DBA certification exam, even at this busy time of year: Try these sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The q
Tag: IBM
XForms and Ruby on Rails at the Doctor’s Office, Part 1: Setting up IBM DB2 9 pureXML
(Michael Galpin) This is the first article in a four-part series about using XForms, IBM DB2 pureXML, and Ruby together to more easily create Web applications. In this series you will develop a hypothetical application for managing patient information at a doctor’s office. You will get a taste of th
Port your Oracle applications to DB2 for Linux, UNIX, and Windows
(Ganesh R. Gosavi) Are you planning to port your Oracle application to IBM DB2 for Linux, UNIX and Windows? Learn how to accomplish this task using the steps described in this article. Sample scripts are included to make the tasks easier.
DB2 9 DBA Exam Sample Questions: Recovering a database and LBAC
(Roger Sanders) How ready are you for the DB2 9 DBA certification exam? Find out by testing your knowledge against these sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted here with
IBM buys again with in-memory DBMS grab
(Martin Veitch) IBM has spent most of the year buying software companies so it shouldn’t surprise us that it has had its lawyers and bean counters busy this festive season to sign a deal announced today to buy Solid Information Technology.
Remote Data Piping into DB2 for z/OS
(Ben Budiman, Joe Kidd and Johannes Schuetzner) With multi-tiered applications, there are often topologies with DB2 for z/OS as database backend and the application logic running on another platform like AIX, Linux or Windows. Using the DRDA protocol, the application remotely accesses DB2. An exampl
A user-defined function for culturally correct collation in DB2 UDB
(Doug Doole) Learn about the user-defined function (UDF) for IBM DB2 Universal Database for Linux, UNIX, and Windows (DB2 UDB) that provides culturally correct collation for Unicode databases. The UDF can be used to order query results in a culturally sensitive manner. It can also be used to provide
Data Integration and Composite Business Services, Part 3: Build a multi-tenant data tier with access control and security
(Mary Taylor and Chang Jie Guo) This article explores how the capabilities of IBM DB2 address the issues of data architecture and data security in a Software as a Service (SaaS) implementation. The primary concern of a SaaS consumer is data security. The primary concern for a SaaS provider is a data
Indexing the DB2 Catalog [DB2 9 for z/OS]
(Craig Mullins) First of all, I want to apologize for the lack of new posts here the last couple of weeks. I’ve been busy traveling and preparing for the holidays — as have most of you I guess, at least the holiday preparation part! Anyway, this will likely be my last post this year and it will be
The IBM DB2 Detective Game
(Joanna Kubasta, Joanne Moore and Matthew Bennett) Here’s a fun way to learn about IBM DB2! Learn or teach the basics of DB2 and relational database with an interactive game called The DB2 Detective Game. The game teaches relational database concepts and shows how technology can be applied to solvin
