Book Image

IBM DB2 9.7 Advanced Application Developer Cookbook

Book Image

IBM DB2 9.7 Advanced Application Developer Cookbook

Overview of this book

With lots of new features, DB2 9.7 delivers one the best relational database systems in the market. DB2 pureXML optimizes Web 2.0 and SOA applications. DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. This DB2 9.7 Advanced Application Developer Cookbook will provide an in-depth quick reference during any application's design and development. This practical cookbook focuses on advanced application development areas that include performance tips and the most useful DB2 features that help in designing high quality applications. This book dives deep into tips and tricks for optimized application performance. With this book you will learn how to use various DB2 features in database applications in an interactive way.
Table of Contents (15 chapters)
IBM DB2 9.7 Advanced Application Developer Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface

Customizing application behavior using registry variables


DB2 provides many registry variables that can affect the database environment. If configured properly, they can have a significant impact on application performance. All registry variables are effective at instance level, which means they will affect all databases in a given instance. In this recipe, we will discuss some registry variables which are relevant from an application-behavior perspective. Most of the time, application developers do not have permissions to change any registry variable, but we should know what impact they can have on the way an application behaves.

Getting ready

Registry variables operate at instance level, so we need the SYSADM authority to view or modify their values.

How to do it...

The following steps discuss the most important registry variables that can have a significant impact on application performance and behavior:

Note

Disclaimer: Registry variables are very sensitive and can behave differently in different...