Search results

The DSNZPARM installation parameter CONTSTOR (DSN6SPRM macro) controls whether DB2 for z/OS periodically contracts the Agent Local Non-System pool for each DB2 thread. This white paper explains the effects of specifying CONSTOR=YES.

DB2® buffer pools are a key resource for ensuring good performance. This is becoming increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor. A System z® processor can be configured with large amounts of storage which, if used wisely, can help compensate by using storage to avoid synchronous I/O. The purpose of this Redpaper is to: - Describe the functions of the DB2 buffer pools - Introduce a number of metrics for read and write performance of a buffer pool - Make recommendations on how to set up and monitor the DB2 buffer pools - Provide results from using this approach at a number of customers The paper is intended to be read by DB2 system administrators but it may be of interest to any z/OS® performance specialist. It is assumed that the reader is familiar with DB2 and performance tuning.

This presentation discusses the new backup and recovery features in DB2® 9 for z/OS®. The presentation discusses the DB2 managed FlashCopy solution in Version 8 and the new copy pool enhancements, including managing copy pool backups to tapes, using copy pool backups as the source for DB2 table and index recovery, and features of incremental FlashCopy. The presentation also discusses restart enhancements, including how to extend RECOVER utility to support point-in-time recovery with transaction level con

Read this presentation to gain new insight on large objects (LOBs). This presentation discusses new features relating to LOBs in DB2® 9 for z/OS® , and ways to use LOBs. Some other topics covered in this presentation are file reference variable support in DB2 9, LOB support in DB2 utilities, and improved LOB handling for LOAD and UNLOAD in DB2 9. Some preliminary performance results are also discussed.

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.

With Version 8, QMF® has included significant enhancements for our customers who are considering, or are actively deploying business intelligence applications. This white paper provides a very thorough yet concise overview of QMF V8.1, and talks about the various packaging options, along with descriptions of the new features.

This white paper is targeted to our DB2® for z/OS® customers who are deploying Java™ Enterprise Database Applications and are looking for information about what IBM® and DB2 provides them for better management of these business-critical applications.

This IBM® Redpapers™ publication provides insight into IBM WebSphere® Customer Center (WCC) transaction performance and scalability. It explores some of the most important features and implementation factors with regard to their performance impact. It also provides specific tuning recommendations for deployment. This paper is more relevant for WebSphere Customer Center version 6.5 and 7.0 and is intended for those who are experienced with WCC. Certain performance considerations and recommendations are also applicable to later releases of the IBM Master Data Management (MDM) products including later releases of the MDM server.

The dollar-to-data ratio of solid-state drives (SSDs) is still high when compared with the dollar-to-data ratio of traditional spinning disks in the enterprise storage market; however, the SSDs ratio is expected to improve with investments in the not too distant future. By avoiding seeks and rotational delays, SSDs have the potential to improve the performance of disk storage. This IBM® Redguide™ publication provides a broad understanding of SSDs and shares several early experiences in a laboratory setting using SSDs to improve the performance when accessing DB2 for z/OS® data.

This IBM® Redpaper™ provides a step-by-step introduction on how to get started with Web services using Data Studio V2.1. Our goal is to explain basic concepts and introduce the functions that can help you take your first steps in the Web services arena with DB2® for z/OS®. We start with describing and setting up the basic software components and showing a step-by-step guide to creating your first Web service. We then show how you can test and deploy Web services and let DB2 operate as a Web service requester (consumer) and a Web service server (provider). Last, we introduce the SOAP UDFs that enable DB2 to act directly as a Web service consumer and we show how stylesheets can easily transform your Web service response into a service message in HTML format.