(John Chun and Paolo Cirone) Packages in DB2 are control-structure database objects that contain executable forms of SQL statements or placement holders for executable forms. In DB2 for Linux, UNIX, and Windows, packages may also be referred to as access plans. Packages are stored in the database sy

(Chris Eaton) No doubt this will be a controversial posting but I will give you my perspective on how DB2 Viper Table Partitioning compares to Oracle 10gR2 and Microsoft SQL Server 2005.

(Tony Lau) WebSphere Application Server and DB2 UDB has continued to be the industry leader in J2EE performance. IBM’s latest SPECjAppServer submission has demonstrated more than 10,000 concurrent clients and produced more than a million transactions over the benchmark’s one-hour run duration. The I

(Howard Fosdick) Developers and DBAs involved in DB2 support might also want to consider a valuable self-study test that few are aware of: the DB2 Problem Determination Mastery Exam. Developed by IBM’s DB2 UDB technical support staff, this exam’s goal is to show that you’ve mastered the problem dete

(Cengiz H. Satir, Edward Huang and Allan Tham) DB2 Document Manager (DM) is one of IBM’s strategic applications that leverages the DB2 Content Manager repository for scalability and performance, while surfacing advanced document management capabilities through a Web-based interface and commonly-used

(Mark Fontecchio) Mainsoft Corp. has released extensions that allow IBM customers to run Microsoft’s ASP.Net applications natively on the WebSphere Portal server.

(Paul C. Zikopoulos) Part 5 and 6 of this series focus on the built-in SQL Builder and SQL Editor (here-in referred to as the SQL Builder) in Rational AD. Here in Part 5 I will show you how to use it to build SQL statements that you can use in your Java programs, Web services, routines, or just stan

(Chris Eaton) So far we have discussed new DB2 Viper Table Partitioning overview, the details on creating a partitioned table and how to attach new partitions. In this posting we will cover the DETACH operation.

(Rikki Kirzner) Business transactions running on IBM zSeries and other mainframes are rapidly increasing with the growth of Internet-based computing and IBM forecasts mainframe-based transactions to double by 2010. Meanwhile, Service Oriented Architecture (SOA) has become a key strategic initiative

(Hernando Bedoya, Elvis Budimlic, Morten Buur Rasmussen, Peggy Chidester, Fernando Echeveste, Birgitta Hauser, Kang Min Lee and Dave Squires) The goal of database performance tuning is to minimize the response time of your queries. It is also to optimize your server’s resources by minimizing network