(Vincent McBurney) This is a step by step guide to setting up user and group security for accessing the IBM Information Server and products on that server such as DataStage 8.

(Ivan Popivanov, Scott Walkty, Angela Yang and Beck Tang) DB2’s autonomic capabilities lighten the load of the DBA and enable you to maximize performance. This article demonstrates how to enable and configure automatic statistics collection, monitor automatic statistics collection progress, and dete

Managing DB2 for z/OS databases becomes more challenging each year. The complexity and volume of data continue to explode exponentially, as applications stretch the limits to provide instantly accessible information. Data warehouses handle multiple terabytes of data. Web-enabling legacy databases h

(John Chun, Christine Law, Salvador Ledezma and Alex Pitigoi) XML is one of the most common data interchange formats on the Web today. DB2 support for pureXML, combined with the parsing and generating XML APIs (REXML) available to Ruby on Rails, provides a powerful combination for Web application de

(Ted) I know from my reading that it is possible to make an Excel spreadsheet read from an iSeries database. I’ve been an RPG programmer for years, and I don’t know where to start. Can you point me in the right direction?

(Mark Leon) Governing data is a little like governing people. Left to themselves, people will devolve into a “state of nature” in which civilization as we know it cannot exist.

BMC CATALOG MANAGER for DB2 automates the tedious, error-prone management tasks involved in complex DB2 Universal Database for z/OS environments. DBAs, application developers, system programmers, and anyone requiring easy access to the information in the DB2 catalog can have BMC CATALOG MANAGER fo

(Alex Woodie) HiT Software last week unveiled a new version of Ritmo/i5, its data provider product connecting Microsoft Visual Studio 2005 to DB2/400. With Ritmo/i5 version 4, HiT is providing support for Visual Studio developers using the latest ADO.NET 2.0 techniques to pull data from their System

(Scott Hayes) You might think you have an OLTP transactional database. Or, you might think you have a Data Warehouse database. But what does your database think? How is it, or the queries within it, really performing?

(Tom Moulder) Performance tuning of DB2 UDB for z/OS subsystems has been a common task since the announcement of that database subsystem by IBM. Performance tuning can be accomplished at the subsystem level or at the SQL statement level. It is generally accepted that 20% of the benefit from tunin