Benefits

Team-Fly

---

 

	DB2 Universal Database for OS/390 v7.1 Application Certification Guide By Susan Lawson
	Table of Contents
	Chapter 8.  Stored Procedures

---

Benefits

One of the main reasons for using stored procedures is to reduce the network traffic in a distributed environment caused by client application programs that execute many remote SQL statements. Remote SQL statements can create many network send and receive operations to the server. A stored procedure can encapsulate many of the application's SQL statements into a single message to DB2, thus reducing network traffic.

Another reason for using stored procedures is to encapsulate a business function into a single module, coded once, and stored at the server for all processes to use. (See Figure 8-1.)

Figure 8-1. Stored procedure network improvements.

Additional Benefits

Some of the additional benefits of stored procedures include the following:

• Simplifies development and maintenance.

• Removes client dependency on database design at server.

• Allows for the ability to dynamically change application programs.

• Code is changed and refreshed at the server.

• Client code does not need any change.

• Client code can continue to run while changes are made.

• Most of an application can exist at the server, not the client.

• Less code needs to be globally changed at all client locations.

• Reusable code.

• Improved security.

• Eliminates the need for end- user table authority.

• Moves processing away from end users.

• Provides the ability to access and update data that is not stored in DB2, such as virtual storage access method (VSAM) or information management systems (IMS) data.

---

Team-Fly

Top