Best DB2 Articles and News

Contains links to Fix Central for DB2® Version [<b>9.1 Fix Pack 8</b>] for Linux®, UNIX®, and Windows®.

DB2® database product documentation by product version is available by accessing the DB2 Information Center online, downloading the DB2 Information Center, or downloading documentation in Portable Document Format (PDF).

JCC Universal driver is not supported for databases using GB18030 code set

Fix Pack 8 for DB2 V9.1 is now available which includes fixes to close some serious security vulnerabilities and HIPER APARs. These fixes, where applicable, are also available in Fix Pack 18 for DB2 Version 8, and FixPak 4 for DB2 Version 9.5 IBM® recommends that you review the vulnerability descriptions and deploy one of the above fix packs to remove the vulnerabilities on your affected DB2 installations.

The financial impact of fraud is increasing for banks worldwide. Fraudulent attacks and data breaches are costly, not only in terms of reputation and loss of revenue, but also in the administrative costs of restoring the customer’s accounts and reporting exposures to regulatory agencies. Banks are also required to keep an increasing amount of capital reserve for fraud losses. All of these issues are placing a greater internal focus on enterprise risk management. Fraud is becoming a growing concern for financial institutions and an adequate enterprise-wide solution is required to deal with this issue effectively. Fraud detection needs to be near real-time and complex analysis across multiple channels needs to be done on a continuous base. This IBM® Redguide positions ACI Proactive Risk Manager (PRM) solution to address this issue and reduce enterprise fraud across all payment channels, and achieve operational cost reductions by implementing the solution on the IBM System z® platform.

Distributed Relational Database Architecture™ (DRDA®) is a set of protocols that permits multiple local and remote database systems and application programs, to work together. Any combination of relational database management products that use DRDA can be connected to form a distributed relational database management system. DRDA coordinates communication between systems by defining what can be exchanged and how it must be exchanged. DB2® for z/OS® Distributed Data Facility (DDF) is a built-in component which provides the connectivity to and from other servers or clients over the network. DDF is a full-function DRDA compliant transaction monitor which, equipped with thread pooling and connection management, can support very large networks. Different z/OS workload management priorities can be assigned to different, user-specified classes of DDF-routed application work. In this IBM® Redbooks® publication we describe how to set up your DDF environment, and how to deploy the DDF capabilities in different configurations, including how to develop applications that access distributed databases. We also describe a set of more advanced features, such as thread pooling and high availability distributed configurations, in a DB2 data sharing environment, as well as the traces available to you to do performance monitoring and problem determination. In summary, we show how a high-volume, highly available transactional application can be successfully implemented with a DB2 for z/OS data server accessed by all types

The financial impact of fraud is increasing for banks worldwide. Fraudulent attacks and data breaches are costly, not only in terms of reputation and loss of revenue, but also in the administrative costs of restoring the customer’s accounts and reporting exposures to regulatory agencies. Banks are also required to keep an increasing amount of capital reserve for fraud losses. All of these issues are placing a greater internal focus on enterprise risk management. Fraud is becoming a growing concern for financial institutions and an adequate enterprise-wide solution is required to deal with this issue effectively. Fraud detection needs to be near real-time and complex analysis across multiple channels needs to be done on a continuous base. This IBM® Redguide positions ACI Proactive Risk Manager (PRM) solution to address this issue and reduce enterprise fraud across all payment channels, and achieve operational cost reductions by implementing the solution on the IBM System z® platform.

When using the JDBC TYPE 2 driver to retrieve a Date, Time, or Timestamp column, the results are returned in JIS format. Is there a way to have the columns returned in ISO format?

Server virtualization technologies are becoming more popular to help efficiently utilize resources by consolidating servers. IBM® , the first company that developed and made available the virtual technology in 1966, offers advanced, powerful, reliable, and cost-saving virtualization technologies in various hardware and software products including DB2® for Linux, UNIX, and Windows. This IBM Redbooks® publication describes using IBM DB2 9 with server virtualization. We start with a general overview of virtualization and describe specific server virtualization technologies to highlight how the server virtualization technologies have been implemented. With this introduction anyone new to virtualization will have a better understanding of server virtualization and the industry server virtualization technologies available in the market. Following the virtualization concept, we describe in detail the setup, configuration, and managing of DB2 with three leading server virtualization technologies: IBM Power Systems™ with PowerVM™ VMware Hyper-V We discuss the virtual machine setup with DB2 in mind to help IT support understand the effective ways of setting up a virtual environment specific for DB2. We explain the architecture and components of these three server virtualization technologies to allow DBAs to understand how a database environment using DB2 can benefit from using the server virtualization technologies. In addition, we discuss the DB2 features and functions that can take advantage o