DB2 Server for VSE: 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. It does not describe the actual installation procedure. For information on that, see the DB2 Server for VSE Program Directory.
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 VSE 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 VSE 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 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, 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 9, Special Topics in Recovery Design discusses dual logging and switching log modes.
Chapter 10, Using the Accounting Facility describes the DB2 Server for VSE accounting facility, which tracks how database resources are consumed by users.
Chapter 11, Generating Additional Databases describes how to add databases to your system.
Chapter 12, 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 13, 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 14, Using a DRDA Environment discusses using the database manager in a distributed environment.
Chapter 15, Using TCP/IP with DB2 Server for VSE discusses using TCP/IP to access application servers.
Appendix A, Processor 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, DRDA Considerations discusses what you should consider in a distributed environment.
Appendix H, 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 ]