(Peggy Zagelow) When I describe native SQL procedures in DB2 9 for z/OS, I often hear variations of these types of questions: 1. Doesn’t the external WLM-managed infrastructure provide some throttling of stored procedures? What’s going to happen when this is gone? 2. Can DBM1 handle the same

(Chris Smith) Those folks at Centerfield Technology certainly are on their toes. An opportunity arises in their field (which is databases), and they’re on it. This week the company introduced a new service: installing, configuring, and verifying the functionality of DB2 Web Query for System i.

(Antonio Cangiano) This guide is a basic tutorial that’ll quickly get you started with the ibm_db Ruby driver. You’ll be querying DB2 from Ruby in no time, but please bear in mind that this document is not meant to be thorough (use the API reference for this purpose). Also, this is a guide for the I

(Roger Sanders) Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, to help you prepare for the certification test. The questions are reprinted with permission. Check back each week for more, and try past

(Willie Favero) If you’re into stored procedures, here’s an APAR to put on your watch list. It’s APAR “PK59752: Complete Support of Package Path Keyword on Create Procedure and Create Function”. This APAR is for DB2 9 for z/OS and, as the title states, completes the work is doing with PACKAGEPATH v

(Walt Geddes and Lai-Fong Leung) Learn how to create and deploy information services to access legacy databases without writing any code. The generated web services are created using the IBM Information Server components including WebSphere DataStage, WebSphere Federation Server, WebSphere Informati

(Radhesh Kumar) Locking issues in a database often lead to finger-pointing between DBAs and Application developers. Application folks will complain that their application is performing poorly because of database locking issues. DBAs will respond that it’s the application design issue that’s causing

(Yinghong Fei) External Database Access (EDA) has been created to allow U2 users the flexibility of storing some or all of their data in external relational database management systems (RDBMS). While EDA documentation describes all the EDA features and their usages, the purpose of this article is to

(Craig Mullins) Most seasoned SQL programmers know that when you use host variables, DB2 may not always come up with the absolutely most optimal access path at bind time. Without knowing the actual values of the host variables the optimizer has to make some best guesses as to how best to satisfy the

(Benjamin Lieberman) Information content management involves identifying useful information, organizing that information into an intuitive structure, and governing changes made to that information. Content comes in many forms, including text, graphics, tables, charts, illustrations, recordings, maps