Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
  • 1
    Online Resource
    Online Resource
    IBM DB2 9 for z/OS : New Tools for Query Optimization (2007)
    [Erscheinungsort nicht ermittelbar] : IBM Redbooks | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (458 pages)
    Keywords: Electronic books ; local
    Abstract: The cost-based optimizer of IBM DB2 for z/OS has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures, such as star schemas. DB2 for z/OS V8 has provided access path visualization and a Statistics Advisor function through a new Visual Explain. DB2 9 for z/OS starts addressing the challenge of reducing cost of ownership by extending query optimization through expert-based query and workload analysis, server enhancements, and an Index Advisory function. These functions are delivered with two tools: DB2 Optimization Service Center and DB2 Optimization Expert. This book helps you understand the installation, customization, and usage aspects of the tools. You are guided through scenarios of gradually increasing complexity where the functions of the tools are exploited for query optimization.
    Note: Online resource; Title from title page (viewed December 13, 2007) , Mode of access: World Wide Web.
    URL: https://learning.oreilly.com/library/view/-/0738488615/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    DB2 for z/OS Administration Tools for Enhanced Change Management (2007)
    [Erscheinungsort nicht ermittelbar] : IBM Redbooks | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (418 pages)
    Keywords: Electronic books ; local
    Abstract: A database administrator (DBA) has a challenging job trying to maintain databases in today’s nonstop 24x7 environments. This challenge is compounded by the complexity of database structures and the time pressure of trying to be up again as soon as possible without making mistakes. When business expands, several DB2 subsystems have to be maintained, such as multiple development systems, function test, acceptance test, volume test, and production systems. Often changes have to be implemented across multiple DB2 subsystems. The two IBM DB2 for z/OS tools that help database administrators to implement database changes are the DB2 Administration Tool and the DB2 Object Comparison Tool. In this IBM Redbooks publication we show how, with Version 7.2, the two tools offer an enhanced Change Management function to manage and track the changes of your DB2 objects. We show how the tools help you define changes, resolve conflicts, register the changes, analyze the changes to generate a work statement list that applies the changes, and then run the changes in the correct order. The Change Management functions also allow you to back out completed changes and facilitate the management of a convenient audit trail. This book contains a major update to the Change Management functions described in DB2 for z/OS Tools for Database Administration and Change Management, SG24-6420-01.
    Note: Online resource; Title from title page (viewed June 25, 2007) , Mode of access: World Wide Web.
    URL: https://learning.oreilly.com/library/view/-/0738489360/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    DB2 UDB for z/OS : Design Guidelines for High Performance and Availability (2006)
    [Erscheinungsort nicht ermittelbar] : IBM Redbooks | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (490 pages)
    Keywords: Electronic books ; local
    Abstract: Conducting business via the Web and remaining open for business 24 hours a day, seven days a week is now commonplace. Customers come in with unexpected workloads through the Web and operate in a self-service fashion with mostly context-sensitive metadata to guide them. The strong requirement is availability. However, even with new Web applications, most of the core business systems considerations still apply, and performance is critical. Technology has been accelerating for mainframe systems. They had become adept at providing business resiliency accommodating strategic software that has been around for the last several decades such as IMS™ , DB2® , and CICS® , and they have also become a host for developing and running Web applications built in Java™ accommodating the latest business requirements. Businesses need to leverage, extend and integrate the strategic assets which represent multi-year investments to support leading edge technology. DB2 for z/OS® has come a long way and provides facilities to exploit the latest hardware and software technologies, accommodating a majority of user requirements. However, special considerations are required to build high performance applications. If you want to achieve high performance or high availability, you must use the design, programming, and operational techniques applicable to DB2. In this IBM Redbooks publication we discuss many of these techniques and provide guidelines for database and application design. We expect the best practices described in this book will help DB2 professionals design high-performance and high-availability applications. Please note that the additional material referenced in the text is not available from IBM.
    Note: Online resource; Title from title page (viewed January 9, 2006) , Mode of access: World Wide Web.
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Data Integrity with DB2 for z/OS (2006)
    [Erscheinungsort nicht ermittelbar] : IBM Redbooks | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (272 pages)
    Edition: 1st edition
    Keywords: Electronic books ; local
    Abstract: DB2 provides functions to guarantee integrity at the system level and at the application level. From the system point of view, DB2's integration with zSeries and disk storage architecture is the cornerstone for data integrity. Logging functionality and COPY and RECOVER utilities are the building blocks for bringing the table space back to a current or consistent status in case of hardware or software failures or when application events need to be rerun. From the application point of view, DB2 supports locking and commit at the transaction level, and general data integrity (at entity and semantic level), and a set of referential constraint rules for each parent/dependent table relationship. The tables linked by referential integrity are recognized during the execution of the QUIESCE utility. Other logical relations across tables, necessary to support business rules, are implemented via constraints, triggers, user defined functions, and user defined tables. Informational constraints also exist, they are not enforced by the database manager, they are used to improve query performance. In this IBM Redbooks publication, we briefly describe the integration of DB2 for z/OS with System z architecture, we then explore the data integrity options and utilize the standard recovery functions for application-related issues.
    Note: Online resource; Title from title page (viewed July 10, 2006) , Mode of access: World Wide Web.
    URL: https://learning.oreilly.com/library/view/-/0738495549/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    LOBs with DB2 for z/OS : Stronger and Faster (2006)
    [Erscheinungsort nicht ermittelbar] : IBM Redbooks | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (296 pages)
    Keywords: Electronic books ; local
    Abstract: The requirements for a database management system (DBMS) have included support for very large and complex data objects. DB2 UDB for OS/390 Version 6 introduced the support for large objects (LOBs): they can contain text documents, images, or movies, and can be stored directly in the DBMS with sizes up to 2 gigabytes per object and 65,536 TB for a single LOB column in a 4,096 partition table. The introduction of these new data types has implied some changes in the administration processes and programming techniques. The book Large Objects with DB2 for z/OS and OS/390, SG24-6571, introduced and described the usage of LOBs with DB2 for z/OS at Version 7 level. Major enhancements for LOB manipulation have been introduced with DB2 UDB for z/OS Version 8 and DB2 Version 9.1 for z/OS (DB2 9 in this book). These enhancements include performance functions such as the avoidance of LOB locks and DRDA LOB flow optimization, usability functions such as file reference variables, FETCH CONTINUE, and the automatic creation of objects. DB2 utilities provide integrated support with LOAD and UNLOAD, Cross Loader, REORG, CHECK DATA, and CHECK LOB. In this IBM Redbooks publication, we provide a totally revised description of the DB2 functions for LOB support as well as useful information about how to design and implement LOBs. We also offer examples of their use, programming considerations, and the enhanced processes used for their administration and maintenance. We also detail how SAP solutions use LOBs. This book replaces the previous book, Large Objects with DB2 for z/OS and OS/390, SG24-6571, for DB2 Version 8 and Version 9.1. Please note that the additional material referenced in the text is not available from IBM.
    Note: Online resource; Title from title page (viewed November 29, 2006) , Mode of access: World Wide Web.
    URL: https://learning.oreilly.com/library/view/-/0738496936/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    DB2 for z/OS : Data Sharing in a Nutshell (2006)
    [Erscheinungsort nicht ermittelbar] : IBM Redbooks | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (160 pages)
    Keywords: Electronic books ; local
    Abstract: DB2 for z/OS takes advantage of data sharing technology in a z Parallel Sysplex to provide applications with full concurrent read and write access to shared DB2 data. Data sharing allows users on multiple DB2 subsystems, members of a data sharing group, to share a single copy of the DB2 catalog, directory, and user data sets. Data sharing provides improvements to availability and capacity without impacting existing applications. The road to data sharing might seem arduous to a novice user, but once you have started to learn terminology and gain basic understanding, things will become much easier. This IBM Redbooks publication is meant to facilitate your journey towards data sharing by providing a cookbook approach to the main tasks in enabling data sharing and workload balancing. It does not have all the answers, because it is a brief summary of a large field of knowledge, but it contains the key elements and it points you in the right direction to get more details. Throughout this document we assume that your sysplex environment is set up and a DB2 subsystem exists at a currently supported level.
    Note: Online resource; Title from title page (viewed October 16, 2006) , Mode of access: World Wide Web.
    URL: https://learning.oreilly.com/library/view/-/0738496553/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    The Business Value of DB2 UDB for z/OS (2005)
    [Erscheinungsort nicht ermittelbar] : IBM Redbooks | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (230 pages)
    Keywords: Electronic books ; local
    Abstract: We are in a new phase of On Demand Business. Companies must respond to fluctuating market conditions and provide products and services on demand to customers. DB2 for z/OS and IBM eServer technology enable you to maintain your company’s core competencies. They help you to manage global market and competition changes with consistent availability, security, and privacy, everywhere, all the time. DB2 continues to deliver rich functionality for scalable and highly available data for enterprise-scale, on demand applications. Combine the power and capacity of IBM eServer zSeries and the high performance and high availability of z/OS with the new version of DB2. In doing so, you’ll expand and extend your applications in the increasingly competitive on demand environment. DB2 Universal Database (UDB) for z/OS Version 8 delivers power, flexibility, and DB2 family compatibility through synergy with zSeries and z/OS. This IBM Redbooks publication helps you to position DB2 UDB for z/OS as a springboard for the future. It examines how DB2 Database Servers integrate with, and enable the sharing of information across, multiple platforms. It looks at how the zSeries 990 server manages the explosion of data with reliability and security. Plus it explores how DB2 autonomic computing functions reduce the skills and staffing requirements to minimize cost outlays and reduce risk.
    Note: Online resource; Title from title page (viewed June 29, 2005) , Mode of access: World Wide Web.
    URL: https://learning.oreilly.com/library/view/-/0738490245/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...