2.1.6.3.5 Database Maintenance Plan
· Step 1
Determine what software needs to be included in the plan. Not every piece of software needs to be updated or can be updated. Make sure that you have the important ones -- operating systems, security, virus protection, and production software.
· Step 2
Determine how the software titles are updated. Most software updates can be downloaded from the Internet. A small number may need to have a CD shipped for updates to be applied. Make sure you know which you have.
· Step 3
Determine update frequency. Some software has annual updates; some update daily. For the software maintenance plan to be effective, you need to update as soon as the updates are available.
· Step 4
Write the plan out. Never leave anything to chance with a software maintenance plan. Write it down so anyone can follow the directions.
· Step 5
Select a test machine. Never install updates across a large number of computers until you have tested the updates on a single PC. Updates can cause unexpected results, and you want to make sure that your software maintenance plan improves performance, not hinders it.
· Step 6
Implement the software maintenance plan. Once you have everything ready and you have tested the plan, implement it and keep your software up-to-date.
Checklist: Critical Information
R Concerning operation and maintenance, does the Operation and Maintenance Plan answer all the questions of who, what, where, and when?
R Does the Plan identify the personnel responsible for operation and maintenance?
R Does the Plan identify the human resources and facilities, including tools, needed for operation and maintenance?
R Does the Plan identify funding sources for on-going operation and maintenance?
R Does the Plan describe the operation and maintenance activities to be performed?
R Does the Plan describe the checks to be made, and the data to be collected, for health and performance monitoring?
R Does the Plan cover periodic reporting of system health and performance to provide feedback to management on the effectiveness of operations and maintenance?
R Does the Plan address the training of operators and maintenance personnel?
R Does the Plan address safety and security?
R Does the Plan identify other documents used in operations and maintenance, such as relevant policy directives, system configuration documentation, and operating and maintenance manuals?
R Does the Plan address system testing and configuration documentation updates [may be dealt with in a separate Configuration Management Plan] after configuration changes, repairs, and upgrades?
R Does the Plan address preventive maintenance as well as reactive maintenance?
R Does the Plan address expected life and end-of-life replacement or upgrade?
OPERATION AND MAINTENANCE PLAN TEMPLATE
The following format is one example of many alternatives. If the new system is one of multiple systems operated and maintained by the same personnel, the material described here may be incorporated in an existing Operations and Maintenance Plan covering multiple systems.
| section |
contents |
|---|---|
Title Page |
The title page should follow the Transportation Agency procedures or style guide. At a minimum, it should contain the following information: § OPERATION AND MAINTENANCE PLAN FOR THE [insert name of system] § The organization responsible for preparing the document § Internal document control number, if available § Revision version and date issued |
1.0 Purpose of Document |
This section identifies the scope and purpose of the O and M Plan. It explains how it fits in with related documents such as the Configuration Management Plan, operating manuals, and maintenance manuals. Included is a brief description of the system being operated and maintained. Also covered are its stakeholders, such as agencies and departments within agencies that rely on its successful operation. The system description should list all the system elements that are the subject of this document, including auxiliary equipment and facilities such as special air conditioning, communications links, special lighting, and/or special furniture. |
2.0 Facilities and Resources |
This section identifies the facilities and resources to be used for system operation and maintenance. It should cover at least the following elements: § Personnel, including positions, general qualifications, and specialty skills needed and the percentage of time dedicated to system operation or maintenance, if not full-time. § Building space, including, for example, rooms and space within rooms. Also includes specialty areas, such as workshops, raised floors, additional air conditioning, additional power, and communications trunks. § Furniture, equipment, and tools. § Training needed for operations and maintenance personnel, including off-site courses, on-site courses, and hands-on training on the system itself. § Funding, including the amount needed each year and sources. Attempt to predict future costs, including unusual items such as end-of-life replacement. |
3.0 Operations |
This section describes policies and high-level procedures governing operation of the system. Minimally, it should address the activities described in the project’s Concept of Operations and any other activities needed to achieve the project’s objectives. In general, the following information should be included in this section: § A clear statement of system operation goals and expectations § Hours of operation (if not continuous) or the conditions that trigger the commencement and termination of intermittent system operation § Automated processes involved in system operation § Operation activities (including monitoring of automated processes) needing human involvement and the personnel responsible for each § Backup facilities, personnel, and procedures for invoking the use of backups § Interaction and coordination needed with other systems and personnel, including policies for decision making, overrides, and notification in the event of competing interests § Special procedures and interactions that apply in the event of major emergencies § xxx Parameters used to monitor the effectiveness of system operation. Also, how those data are to be collected and reported § Policies on security, covering access to the system (e.g., log in/out, password management, remote access, and firewalls), and fire and safety. § Procedures related to system health monitoring and reporting, initiation of maintenance actions, and hand-off between operation and maintenance personnel at the start and end of maintenance actions § Policies regarding data collection and archiving, including what data are to be stored for how long § Policies regarding privacy, such as restrictions on the use of cameras and recording of information that may be able to identify individuals § Policies regarding visits, telephone inquiries, and other interactions with interested parties such as other ITS professionals, researchers, news reporters, and the public § Construction activities that must precede deployment § Deployment of interfacing systems (especially by other agencies) that must precede deployment of a system feature § The need to create a viable operational capability at each stage of the deployment. This need influences how much of the system must be deployed at each step Following the statement of the goals and objectives, a high-level view of the deployment strategy is presented. This covers and describes each phase of deployment at each of the sites involved. It describes what is deployed and where it is deployed. What operational capabilities are the results of this phase of the deployment? It ties the plan to the previously identified goals and objectives. The stakeholders should be able to understand the rationale for each phase. This summary should include an estimate of the cost of each phase. The estimate should show that the plan satisfies the funding profile and should show the overall deployment schedule. |
4.0 Maintenance |
This section describes policies and high-level procedures governing maintenance of the system. It should address the proactive (preventive) and reactive (corrective) activities needed to keep the system fully operational. In general, the following information should be included in this section: § Preventive maintenance activities and the time schedule or other triggers for each activity § Corrective maintenance activities, the relative urgency of each, and the maximum target response and correction times for each type of fault § Policies with regard to purchase of spare equipment, manufacturer or vendor maintenance agreements or extended warranties, and third-party maintenance contracts § Parameters used to monitor the effectiveness of system maintenance, and how those data are to be collected and reported § Procedures for coordination with operations personnel and activities § Demarcation of responsibilities relative to maintenance by other parties and procedures for coordination with the personnel responsible for interconnected systems or components that are not part of this system |
Appendix |
Provide a list of the names and contact information of personnel currently assigned to system operation and maintenance. Include the names and contact information of personnel in other parts of the organization or in other organizations, including emergency response services with which system operations and maintenance personnel must interact. |