DB2 Server for VM: System Administration

Organization of This Manual

Summary of Changes lists the changes made to the product since Version 6 Release 1.
Chapter 1, Planning for Installation summarizes the software, hardware, and storage requirements for installing the database manager.
Chapter 2, Planning for Database Generation describes how to set up your initial database, including specifying parameters to define the logical and physical limits for its capacity and setting its initial DASD allocations.
Chapter 3, Planning for Database Migration explains the planning you must do before migrating a database from a previous release of the database manager to the Version 7 Release 1 level. For the actual migration steps, see the DB2 Server for VM Program Directory .
Chapter 4, Planning for Operation of the Database Manager explains how to choose appropriate startup parameters which will determine the operational characteristics of the application server when it is started by the DB2 Server for VM operator.
Note: Starting, operating, and stopping the application server are also discussed in the DB2 Server for VSE & VM Operation manual.
Chapter 5, Operating the Online Support for VSE Guest Sharing explains how to enable VSE guest users to access the application server on a VM/ESA operating system, and how to operate the online support for CICS/VSE^(R) transactions.
Note: These subjects are also discussed in the DB2 Server for VSE & VM Operation manual.
Chapter 6, Maintaining Database Security discusses how to control access to the application server.
Chapter 7, Managing Database Storage explains how to manage the disk storage allocated to the database, including adding (or defining) dbspaces, defining storage pools, adding dbextents to storage pools, and managing storage pools.
Chapter 8, Saved Segments discusses using, defining and running saved segments.
Chapter 9, Making Backups and Recovering from Failures describes facilities provided for recovery from system failures and DASD failures; how to back up your database; and how to recover from different types of failures.
Chapter 10, Special Topics in Recovery Design discusses dual logging and switching log modes.
Chapter 11, Using the Accounting Facility describes the DB2 Server for VM accounting facility, which tracks how database resources are consumed by users.
Chapter 12, Planning and Implementing Configurations describes configuration topics like adding database and user machines, and configuring for different operating systems.
Chapter 13, Choosing a National Language and Defining Character Sets contains information on national language character set and coded character set identifier (CCSID) support, as well as how to provide HELP text and messages in languages supported by the database manager.
Chapter 14, Creating Installation Exits describes the types of installation exits that you can code to customize the database manager:
- Accounting exits, to customize account information
- Date and time exits, to create your own date or time format if the IBM-supplied formats do not fit your requirements
- TRANSPROC exits, to carry out DBCS conversions
- Cancel exits, to replace the product-supplied cancel function when coding your own interactive program
- Field Procedures, to change the sorting sequence by encoding and decoding data if the standard sorting sequence does not meet your requirements.
Chapter 15, Using a DRDA Environment discusses using the database manager in a distributed environment; benefits; how to prepare DB2 Server for VM application requesters and application servers; administrative responsibilities; and using the database services utility (DBS Utility) and ISQL to access a non-DB2 Server for VM application server. Considerations for distributed databases and for choosing the PROTOCOL parameter are also discussed.
Chapter 16, Using TCP/IP with DB2 Server for VM discusses using TCP/IP to access application servers.
Appendix A, Virtual and Real Storage Requirements presents guidelines for estimating the processor requirements needed for running the database manager.
Appendix B, Estimating Database Storage contains procedures for estimating the sizes of the database directory, public dbspaces, and the ISQL dbspace.
Appendix C, Maximum Values contains the system and database maximums for the database manager.
Appendix D, Updating SYSTEM.SYSSTRINGS details how to update this catalog table to support your own CCSID conversion.
Appendix E, Defining Your Own Character Set describes how to create your own character set.
Appendix F, Macro List lists the macros identified as programming interfaces for customers by the database management system.
Appendix G, Service and Maintenance Execs lists and describes service and maintenance execs.
Appendix H, DRDA Considerations discusses what you should consider in a distributed environment.
Appendix I, Incompatibilities Between Releases describes the incompatibilities between releases.

A bibliography is provided at the back of the book.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]