(Jeffrey Berger and Kyoko Amano) DB2 for OS/390 and z/OS supports three types of encoding schemes: EBCDIC, ASCII and UNICODE. Traditionally IBM mainframes have been based on EBCDIC, and Unix and Windows applications based on ASCII. To handle larger character sets, which are absolutely necessary in A

If the TCP/IP DDM Server on the AS/400 is not started, the following data providers cannot connect over TCP/IP: –Microsoft OLE DB Provider for AS/400 –VSAMMicrosoft OLE DB Provider for DB2Microsoft ODBC Driver for DB2

(Naveen Balani) This tutorial shows developers how to render PDF applications using DB2 XML Extender, WebSphere Studio Application Developer (Application Developer) and the Apache Formatting Objects Processor (FOP) project. (R)

(Hernando Bedoya) This IBM Redbook presents an overview of all V5R3 iSeries Navigator functions to manage and administer DB2 Universal Database (UDB) for iSeries. It serves as a companion guide for the database administrator to use DB2 UDB for iSeries. This redbook includes the latest announced feat

(Paul C. Zikopoulos and Leon Katsnelson) Are you trying to ensure you’re licensing your DB2 servers correctly in a high availability environment? Don’t have the time nor the will to read through the announcement letters, PLETs, or your licensing sheets? This article explains it all in plain English.

(Namik Hrle and Johannes Schuetzner) A precise correlation of work done in DB2 on behalf of the application process is the basis for efficient monitoring, accounting, charge-back, capacity planning and workload management. For example, systems administrators should not, in general, terminate a

(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physica

(Paul C. Zikopoulos) In a side-by-side comparison table, This article makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed DB2 Universal Database (DB2) server family.

(Eric Garrigue Vesely) Parallelism can be employed in static and dynamic queries, local and remote data access, queries using single table scans and multi-table joins, access via an index or table scan, or list prefetch, sort, and inserts. Most parallel operations can be used on either partitioned o

(John Ganci) This IBM Redbook and sample code provide IT architects, IT specialists, and developers with the critical knowledge to design, develop, deploy and manage a portal based document management system using IBM WebSphere Portal V5.0.2 and IBM DB2 Content Manager V8.2. (pdf)