(Paul C. Zikopoulos) IBM DB2 Universal Database for Linux, UNIX, and Windows (herein referred to as DB2 UDB) gives you two methods for entering commands from its command line interface. When using the DB2 UDB Command Line Processor (DB2 UDB CLP) in Interactive mode, you don’t have to prefix your DB2

(Ulf Heinrich) This White Paper provides an insight into the real-time maintenance of DB2 for z/OS and OS/390 databases. First a description of the current standard maintenance techniques is provided and their disadvantages and problems are pointed out. In addition, the rising requirements that

(Kathy Devine) You may be familiar with IBM’s journey into eBusiness On Demand and no doubt your own company is going through a similar transition. Even if you have not heard the term eBusiness On Demand before, you are already searching for it. Why? Because all of us need information that is more m

This tutorial introduces new users of IBM DB2 Universal Database (UDB) to relational database concepts through a fun and interactive game called DB2 Detective. It assumes no prior database knowledge or programming experience in the Structured Query Language (SQL). (R)

(Patricia Fusco) Hewlett-Packard, IBM and Microsoft have been cited as three of the leading suppliers of technology for small- and medium- size businesses by information technology research firm Gartner. In its first ever vendor ratings of the most powerful global technology providers serving the sm

When you update table statistics using the RUNSTATS command, it requires that you run the command against each table, one by one. REORGCHK gives you the capability to update the statistics of a group of tables or all the tables in the database, with only one command.

(Rick Grehan) DB2 Everyplace gets high points for ease of installation: I had a handheld database ready and synchronized not more than an hour or so after I’d installed the product. All the tools and their controls were arranged so that it was easy to figure out what to do and in what order.

(Whei-Jen Chen, Peter Z. He, Andreas Paulsen, Sunminder S Saini and Kang Young Ying) This Redbook discusses the integrated environment of DB2 UDB and WebSphere Application Server (WAS) including design considerations, best practices, operation, monitoring and performance tuning. We provide an ove

(João Alberto de Oliveira Lima) This article describes a simple method for publishing DB2 data in PDF format using XSL (eXtensible Stylesheet Language). The process requires three steps: first, you create an XML file using DB2’s new built-in XML functions; second, you transform that file using XSL-F

(Sarah Ellis) Wherever you are in the world and whatever your own code page requirements, DB2 for z/OS Version 8 will bring Unicode into your world! There are fundamental changes on the horizon which build on Version 7’s ability to create Unicode tables, lifting the current restrictions and signific