Search results

This redbook describes performance tuning of DB2 Server for VSE & VM Version 5 Release 1 from various aspects. It contains an overview of the performance relevant new functions and features, and how customers can benefit from them. Many details, techniques and recommendations about how to use these new facilities are provided as well as the typical steps for performance tuning regarding databases and applications. Checklists are provided to assist in analyzing performance problems, and recommendations are given for prevention. Sample tools are described that might help perform these tasks, and examples illustrate the versatility of these products. This document is intended for use by database administrators, system programmers, application programmers and those who are involved in using DB2 Server for VSE & VM. It assumes a knowledge of DB2 database administration and basic knowledge of either VM/ESA or VSE/ESA.

This redbook describes the new capabilities of IBM DB2 Server for VSE & VM Version 5 Release 1. It contains an overview of the new functions, features and how customers can benefit from them. Many details, techniques and recommendations about how to set up and use these new facilities are provided as well as DB2 solutions with VSE and VM focusing on base and distributed relational database capabilities involving OS/2, AIX and Windows NT environments. Sample applications such as DRDA2 access to multiple databases, Data Replication and DB2 Internet Gateway illustrate the versatility of this new product. Multiplatform C/S technologies covering aspects such as connectivity, security, administration and application exploitation are also described. This document is intended for use by database administrators, system programmers, application programmers and those who are involved in using DB2 Server for VSE & VM.. It assumes a knowledge of DB2 database administration and basic knowledge of either VM/ESA or VSE/ESA. The CD-ROM .Interactive Learning in Distributed Database & Client/Server Solutions., SG24-4944 provides comprehensive education & training on all related aspects.

Many customers have already recognized the advantages of DB2 Server for VSE & VM over VSE/VSAM, but could not spend the effort to convert their business data and applications. With DB2 VSAM Transparency there is a tool that eases conversion to DB2. After the manual input of the data structures in VSAM and DB2, it performs the data migration automatically and offers transparent access to DB2 from the unchanged VSAM applications. DB2 VSAM Transparency can be used as a first step to exploit DB2; the applications can later be modified step by step to further optimize the data and application structure to the individual needs. This redbook points to the critical areas in a conversion process, and in detail explains the usage of the DB2 VSAM Transparency. It describes the steps in using data migration and application Transparency, puts them in the context of the overall conversion process and gives invaluable hints and tips. The redbook was written primarily for application programmers and system programmers, but also for database administrators, managers and all those who are responsible for planning and performing a database conversion. Basic knowledge of VSE, DB2, and application programming is assumed.

Using the possibilities offered by the Data Restore feature, customers can reduce their archiving time, effort, and resources. Online archives can replace offline user archives, increasing the availability of the database. Duplicate backups, which currently are often practiced, can be avoided, while at the same time the recovery capabilities are improved. This redbook provides detailed information on the usage of the DB2 Data Restore feature. It describes scenarios and gives recommendations relate to the backup and restore of a DB2 database, partially or completely. Procedures are documented so that they can easily be executed for test purposes. It points you to all the facts and provides valuable information that you will need to develop, appraise or update your own DB2 recovery strategy. The document was written for database administrators and for all those people who are responsible for controlling the availability of backups in case something happens to your database and you need to do a full or partial restore. Some knowledge of DB2 database administration is assumed, as well as a basic knowledge of either VM/ESA or VSE/ESA.