(Gene Cobb) If you have been using DB2 Web Query for report and graph development, you may have discovered that the database field list in the development tools (Report Assistant, Graph Assistant, and Power Painter) can be quite lengthy when you have one or both of the following: –A synonym bas

(Patrick Titzler and Zeus Courtois) In Version 1.2, Data Studio Developer and Data Studio pureQuery Runtime include a new feature called client optimization that enables DBAs and developers to take advantage of the benefits of static SQL execution without having to modify their existing custom-devel

Everyone “knows” it’s much easier to design and build a system that is secure, and that it’s much more difficult to retrofit security to an existing environment. But how difficult is it really?

(Willie Favero) OK… to all you people out in blog land, I need a little assistance. I’m trying to build a chart that explains how prefetch works; at the basics. What follows is something I was kicking around the other day.

(Matthew Schroeder) Many SQL Server environments have DB2 servers running that must link to SQL Server. Linking to a DB2 server is challenging because you must first get values from the DB2 engineers who use different terminology and then use those unfamiliar values for the linking process. This art

(Diane J. Masters and Tongsheng Zheng) Learn about the Cognos Content Manager tools that you can use to help you understand the size of your Cognos Content Store database and analyze growth patterns, or understand the properties of objects in the Content Store. Whether you’re a Cognos administrator

(Radhesh Kumar) As I mentioned in my previous post DB2 Partitioning, Database partitioning feature (DPF) of DB2 enables DB2 to provide a very scalable database solution. The applications connecting to database do not have to be aware of database partitioning. However, the DBAs managing the multi-par

(Willie Favero) So, you game plan is to move to DB2 9 for z/OS. Great decision. However, when you upgrade, it would be nice if you could minimize the outages. Then you read about locking protocol 3 being introduced in DB2 9. When locking protocol 2 was introduced back in V8, it was necessary for you

(Burt L. Vialpando and Vikram S. Khatri) The Oracle SQL*Loader uses a control file to load data and so does the DB2 LOAD utility. However, the structure of each of these control files is quite different, and many Oracle and DB2 DBAs would like to know how these compare. In this article, get a compar

(Troy Coleman) Ive written several articles about how to design systems that can store large volumes of data and how to take advantage of new DB2 V9 features like alter-table-rotate-first-to-last (RFTL). Two of my related articles from IBM Systems Magazine, Mainframe edition are here and here.