https://www-947.ibm.com/systems/support/myview/subscription/css.wss/folders?methodName=listMyFolders&navBar=0&tabInd=0The latest updates about DB2 for z/OSen-USCopyright 2007 IBM Corporation. All rights reservedcssadmin@us.ibm.com (CSN Administrator)Fri, 13 Nov 2009 08:55:00 GMTWed, 25 Nov 2009 10:39:52 GMThttp://www.ibm.com/i/ibm_logo_120x60.gifhttps://www-947.ibm.com/systems/support/myview/subscription/css.wss/folders?methodName=listMyFolders&navBar=0&tabInd=0http://www.ibm.com/support/docview.wss?uid=swg27017265&myns=swgimgmt&mynp=OCSSEPEK&mync=RWe discuss the latest news about DB2 for z/OS, including the changes in disks, IBM System z9 and z10 Integrated Information Processor or zIIP and new z10 processors. Then the discussion will move DB2 9 for z/OS, with XML and SQL that is more consistent across the DB2 family. Utility enhancements help with new function, more LOB and XML support, better performance and improved availability, removing the BUILD2 step from online reorg. DB2 9 enhances DB2's ability to handle new web and enterprise applications.EducationProduct information and publicationsswgimgmt.swg27017265Fri, 13 Nov 2009 08:55:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27017274&myns=swgimgmt&mynp=OCSSEPEK&mync=RThis presentation discusses migration to DB2 9 and preparing to use it. We'll emphasize recommendations from many other customers and items that tend to be missed, with pointers to more information. The content of this session focuses on the tasks of the person who installs DB2. Systems programmers and database administrators generally perform this task.EducationProduct information and publicationsswgimgmt.swg27017274Mon, 09 Nov 2009 17:22:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27005682&myns=swgimgmt&mynp=OCSSEPEK&mync=RThe 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.Product information and publicationsWhite papersswgimgmt.swg27005682Tue, 03 Nov 2009 10:52:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27017277&myns=swgimgmt&mynp=OCSSEPEK&mync=RThis talk will present some of the latest challenges and achievements for DB2 performance, noting some recent measurements and what can be achieved with the latest software and the latest hardware. The discussion will be centered on what you can do to help improve performance in your shop, particularly on the items that can help in DB2 9.EducationProduct information and publicationsswgimgmt.swg27017277Mon, 02 Nov 2009 17:43:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21045823&myns=swgimgmt&mynp=OCSSEPEK&mync=RWhat is DB2 Accounting Class 2 Not Accounted Time?Problem solving informationTechnotes(FAQs)swgimgmt.swg21045823Mon, 02 Nov 2009 14:21:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21409058&myns=swgimgmt&mynp=OCSSEPEK&mync=RCan I use Optimization Service Center and other offerings such as DB2 Optimization Expert and Optim Query Tuner with the same DB2 for z/OS subsystem?Problem solving informationTechnotes(FAQs)swgimgmt.swg21409058Fri, 30 Oct 2009 10:34:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27010423&myns=swgimgmt&mynp=OCSSEPEK&mync=RThe following updates and enhancements are made available in the latest release of IBM Optimization Service Center for z/OSRelease notesProduct information and publicationsswgimgmt.swg27010423Fri, 30 Oct 2009 10:33:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21395621&myns=swgimgmt&mynp=OCSSEPEK&mync=RRelease notes for IBM Optimization Service Center for DB2 for z/OS.Problem solving informationFix readmesswgimgmt.swg21395621Thu, 29 Oct 2009 10:01:00 GMThttp://www.redbooks.ibm.com/abstracts/REDP4604.html?Open&myns=swgimgmt&mynp=OCSSEPEK&mync=RDB2® 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.Product information and publicationsWhite papersswgimgmt.rdb1REDP4604Sun, 25 Oct 2009 04:00:00 GMThttp://www.redbooks.ibm.com/redpieces/abstracts/REDP4604.html?Open&myns=swgimgmt&mynp=OCSSEPEK&mync=RDB2® 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.Product information and publicationsWhite papersswgimgmt.rdb1REDP460400Wed, 14 Oct 2009 04:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21210011&myns=swgimgmt&mynp=OCSSEPEK&mync=RThis document contains keywords that you can use to optimize your search results when searching APAR text.Problem solving informationTechnotes(FAQs)swgimgmt.swg21210011Fri, 02 Oct 2009 09:26:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27004419&myns=swgimgmt&mynp=OCSSEPEK&mync=RThis presentation describes non-uniform statistics for indexes and non-indexed columns, new index statistics, and how statistics are kept for data-partitioned secondary indexes in DB2® for z/OS®, Version 8.Product documentationProduct information and publicationsswgimgmt.swg27004419Thu, 24 Sep 2009 11:05:00 GMThttp://www.redbooks.ibm.com/abstracts/REDP4545.html?Open&myns=swgimgmt&mynp=OCSSEPEK&mync=RThe 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.Product information and publicationsWhite papersswgimgmt.rdb1REDP4545Wed, 16 Sep 2009 04:00:00 GMThttp://www.redbooks.ibm.com/abstracts/SG246952.html?Open&myns=swgimgmt&mynp=OCSSEPEK&mynp=OCSSEPDU&mync=RDistributed 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 RedbooksProduct information and publicationsswgimgmt.rdb1SG246952Fri, 11 Sep 2009 04:00:00 GMThttp://www.redbooks.ibm.com/redpieces/abstracts/REDP4545.html?Open&myns=swgimgmt&mynp=OCSSEPEK&mync=RThe 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.Product information and publicationsWhite papersswgimgmt.rdb1REDP454500Fri, 04 Sep 2009 04:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27003698&myns=swgimgmt&mynp=OCSSEPEK&mync=RProduct documentationProduct information and publicationsswgimgmt.swg27003698Mon, 24 Aug 2009 09:34:00 GMThttp://www.redbooks.ibm.com/redpieces/abstracts/SG246952.html?Open&myns=swgimgmt&mynp=OCSSEPEK&mynp=OCSSEPDU&mync=RRedbooksProduct information and publicationsswgimgmt.rdb1SG24695201Wed, 22 Jul 2009 04:00:00 GMThttp://www.redbooks.ibm.com/abstracts/REDP4499.html?Open&myns=swgimgmt&mynp=OCSSUQKE&mynp=OCSSEPEK&mync=RProduct information and publicationsWhite papersswgimgmt.rdb1REDP4499Tue, 09 Jun 2009 04:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21386786&myns=swgimgmt&mynp=OCSSEPEK&mync=RProblem solving informationTechnotes(FAQs)swgimgmt.swg21386786Wed, 03 Jun 2009 12:29:00 GMThttp://www.redbooks.ibm.com/abstracts/SG247688.html?Open&myns=swgimgmt&mynp=OCSSEPEK&mync=RRedbooksProduct information and publicationsswgimgmt.rdb1SG247688Tue, 02 Jun 2009 04:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21386442&myns=swgimgmt&mynp=OCSSEPEK&mync=RNewsswgimgmt.swg21386442Tue, 26 May 2009 16:01:00 GMThttp://www.redbooks.ibm.com/redpieces/abstracts/REDP4499.html?Open&myns=swgimgmt&mynp=OCSSUQKE&mynp=OCSSEPEK&mync=RProduct information and publicationsWhite papersswgimgmt.rdb1REDP449900Tue, 12 May 2009 04:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21385400&myns=swgimgmt&mynp=OCSSEPH2&mynp=OCSSEPEK&mynp=OCSSZJXP&mync=RProblem solving informationTechnotes(FAQs)swgimgmt.swg21385400Fri, 08 May 2009 11:14:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21383935&myns=swgimgmt&mynp=OCSSEPEK&mync=RProblem solving informationTechnotes(FAQs)swgimgmt.swg21383935Wed, 29 Apr 2009 10:15:00 GMThttp://www.redbooks.ibm.com/abstracts/REDP4537.html?Open&myns=swgimgmt&mynp=OCSSEPEK&mync=RProduct information and publicationsWhite papersswgimgmt.rdb1REDP4537Tue, 28 Apr 2009 04:00:00 GMThttp://www.ibm.com/legal/us/Terms of UseTerms and conditionshttp://www.ibm.com/legal/us/