Distributed relational database administration for the Spiffy Corporation

 

Spiffy Corporation requires that each dealership have one or more System i™ products and that those systems must be available to the network at certain times.

However, each dealership manages its data processing resources and procedures as a stand-alone enterprise. The size of the system and the number of business processes that are automated on it are determined by each dealership's needs and the resources available to it.

The Spiffy Corporation requires all dealerships to be active in the inventory distributed relational database. Because the corporation operates its own dealerships, it has a full complement of dealership software that might or might not access the distributed relational database environment. The Spiffy dealerships use the full set of software tools. Most of the private franchises also use them because they are tailored specifically to the Spiffy Corporation way of doing business.

The regional distribution centers manage the inventory for their region. They also function as the database administrator for all distributed database resources used in the region. The responsibilities involved vary depending on the level of data processing competency at each dealership. The regional center is always the first contact for help for any dealership in the region.

The Minneapolis regional distribution center has a staff of i5/OS^® programmers with a wide range of experience and knowledge about the systems and the network. The dealership load is about one half that of other regional centers to allow this center to focus on network-wide i5/OS support functions. These functions include application program development, program maintenance, and problem handling.

Listed here are the database responsibilities for each level of activity in the network:

 

Dealerships

• Perform basic system operation and administration

• Enroll local users

 

Regional distribution centers

• Set up data processing for new dealerships

• Disperse database resources for discontinued dealerships

• Enroll network users in region

• Maintain inventory for region

• Develop service plans for dealerships

• Operate help desk for dealerships

 

Other activities

In addition to the regional distribution center activities, the Minneapolis System i competency center does the following activities:

• Develop applications

• Operate help desk for regional centers

• Tune database performance

• Resolve database problems

Examples used throughout this topic are associated with one or more of these activities. Many examples show the process of obtaining a part from inventory in order to schedule customer service or repairs. Others show distributed relational database administration tasks used to set up, secure, monitor, and resolve problems for servers in the Spiffy Corporation distributed relational database network.

 

Parent topic:

Example: Spiffy Corporation distributed relational database