(Clint Boulton) IBM said it has added features to its database software for its eServer zSeries mainframes to help businesses improve and automate the flow of their information.

You may encounter situations where you would like to include a function in a GROUP BY statement. For example, let’s say that you have a database with tables that have TIMESTAMP columns. A number of summary reports are produced against these tables, but at the DATE level as opposed to the TIMESTAMP l

(Kim Moutsos) After three years under construction – and a year of pre-ship buzz – DB2 UDB for z/OS v.8 is ready for the big “reveal.” DB2 Magazine talks to the product’s lead architect for a preview of the changes.

(Rochelle Garner) Let no one say that IBM doesn’t court independent software vendors. At its PartnerWorld conference in Las Vegas, IBM unveiled a cavalcade of programs, products and projects aimed at ISVs that target midsize businesses (fewer than 1,000 employees) in specific industries. Big Blu

(Bob Swart) This article shows how to add authentication to DataSnap applications using a special Login method; points out that the importance of combining this with SSL certificates for increased security; and describes how to deploy the DataSnap server application on a Web server machine.

(Jalud Abdulmenan and Raul F. Chong) This is the fifth article in a series discussing connectivity scenarios involving DB2 UDB for Linux, UNIX and Windows version 8, DB2 UDB for iSeries 5.2 and DB2 UDB for z/OS V8. The focus of this article is on workstation application development connectivity for

Looking for enhanced scalability and availability for the data in your e-business applications? Good news: IBM DB2 Universal Database for z/OS Version 8 is here. You are invited to attend a special Webcast, which will show IT professionals how to prepare for and migrate to this latest version of

(Terry Purcell) Since the introduction of the Star Join access method in Version 6 of DB2 UDB for z/OS and OS/390, there have been many additional enhancements to improve the detection of star schema queries to determine the most efficient access path, and also to minimize regression of non-star sch

(Michael H. Alcorn) Anyone who has ever surfed the Web or tried to buy something online knows how critical performance is to Internet-based companies. Fast responses and well-designed sites don’t guarantee that customers will do their research on or buy something from a particular company’s site. Bu

(Bonnie Baker) One of the questions folks ask me is, “How can I get just one row out of DB2 when I know that many rows will qualify for my SQL statement?” In this column I will discuss the different ways you can make this happen in DB2 for OS/390 and, more importantly, the performance differences an