U.S. ENVIRONMENTAL PROTECTION AGENCY
•
EPA 903/9-76-026
INSTALLATION OF AIR QUALITY DATA HANDLING
SUBSYSTEM in the Commonwealth of Virginia
' FINAL REPORT
AUGUST 19^6
MIDDLE ATLANTIC REGION-III 6th and Walnut Streets, Philadelphia. Pennsylvania 19106
-------
EPA 903/9-76-026
INSTALLATION OF AIR QUALITY DATA HANDLING
SUBSYSTEM in the Commonwealth of Virginia
FINAL REPORT
AUGUST 19^6
-------
TECHNICAL REPORT DATA
(I'lcoxf n'tnl Instructions mi the rcri'rsi' hrforf cmiiiilfling)
1. RLPORT NO. 2.
903/9-76-026
4. TITLE AND SUBTITLE
Installation of Air Quality Data Handling
Subsystem of the Comprehensive Data Handling
System in the -Commonwealth of Virginia
7. AUTHOR(S)
IBM Corporation
9. PERFORMING ORGANIZATION NAME AND ADDRESS
The IBM Corporation
Federal System Division
18100 Frederick Pike
Gaithersburg, MD 20760
12. SPONSORING AGENCY NAME AND ADDRESS
U.S. E. P. A.
Air and Hazardous Materials Division
6th $ Walnut Streets
Philadelphia, Pa. 19106
15. SUPPLEMENTARY NOTES
3. RECIPIENT'S ACCESSION>NO.
903/9-76-026
5. REPORT DATE
August. 1976
6. PERFORMING ORGANIZATION CODE
8. PERFORMING ORGANIZATION REPORT NO.
None
10. PROGRAM ELEMENT NO.
11. CONTRACT/GRANT NO.
68-02-1379 Task Order 9
13. TYPE OF REPORT AND PERIOD COVERED
Final January - August, 1976
14. SPONSORING AGENCY CODE
EPAL (3A)
i •
16. ABSTRACT •
Process and procedures used to install the air quality data' handling
subsystem (AQDHS-il) an a computer in the Commonwealth of Virginia.
i
17. KEY WORDS AND DOCUMENT
a. DESCRIPTORS b.lDENTI
•
Air Quality Data
Computer Programs, Air Pollution
1<3. UISTHIUUTION STATEMENT 10. SECU
...-.-- -: ---•-• -..:-.-: •::•--•• u;--.--i.---- Nor
20 SECL
Release Unlimited • ,.
Nor
ANALYSIS
FIERS/OPEN ENDED TERMS >.. COSATI J'icld/Group
RITY CLASS (This Hc/iorll 21. NO. OF PAOES
16 _• --->:' .••-:; •,,:• v (•«•«*: ••" ••*s^'2%: • •*. *;•'-><:- ~sl~ .
RITY CLASS (This page) 22. PRICE
ie
EPA Form 2220-1 (9-73)
-------
IT A 905/9-76-026
INSTALLATION OF
Air Quality Data Handling Subsystem (AQDHS^II)
of the
Comprehensive Data Handling System
in the
Commonwealth of Virginia
by
The IBM Corporation
Federal Systems Division
18100 Frederick Pike
Gaithersburg, MD .20760
CONTRACT NO. 68-02-1379 TASK ORDER 9
FINAL REPORT
Prepared for
Environmental Protection Agency
Region III
Air and Hazardous Materials Division
Philadelphia, Pa. 19106
AUGUST, 1976
-------
This air pollution report is issued by Philadelphia Regional
Office, Environmental Protection Agency, to assist state and local
air pollution control agencies in carrying out their program activities.
Copies of this report may be obtained, for a nominal cost, from the
National Technical Information Service, 5285 Port Royal Road, Springfield,
Virginia 22151.
This report was furnished to the Environmental Protection Agency
by the IBM Corporation, Gaithersburg, MD in fulfillment of EPA con-
tract number 68-02-1379 Task Order 9. This report has be'en reviewed
by the Air and Hazardous Materials Division, EPA and approved for pub-
lication. Approval does not signify that the contents necessarily re-
flect the views and policies of-the-Environmental Protection Agency,
nor does mention of trade names or commercial products constitute
endorsement or recommendation for use.
Region III Publication No. EPA 903/9-76-026
-------
Final Report
Installation
Task Order Number 9
by
The IBM.Corporation
Federal System Division
18100 Frederick Pike
Gaithersburg, Maryland 20760
Contract No. 68-02-1379
EPA Project Officer: A. W. Marks
-------
Tliis rpport covers all work accomplished by IBM under
Contract Number 68-02-137^, Task Order Number 9. The purpose
of the task was to implement the Air Quality Data Handling
Subsystem (AQDHS) of the Comprehensive Data Handling System
(CDHS) at the computer installation designated by the agency
and to which the agency had established access. Within the.
reporting tasks per the weekly reports, as each task was
completed, a summary was prepared to clearly document the
objectives of the activities, the approach taken, the
techniques used, the results and reference to previous notes.
Thus, material for the final report evolved throughout the
performance period. This technique has facilitated
presentation of periodic progress reports and preparation of
the final report. Therefore, this final report will consist
of two parts, the first briefly highlights and describes
procedures used in this implementation during the performance
period, and the second contains all reports which describe in
detail all activities, problems and solutions.
2- Task_ Definition
In ordor to perform the activities necessa'ry to accomplish
tha objectives of the task order as stated in the statement
of work, the following tasks were defined: (1) Project
definition; (2) Installation; (3) Operational Support; (4)
Training; and (5) Reporting; and were monitored with respect
to progress, problems, plans and cost.
3- E£oject_Def1nition
Kick-off_Meeting
A meeting was held in Washington, D.C., on January 13, 1976
for introduction of responsible personnel from Region III of
Environmental -Protection Agency and Federal system Division
personnel responsible for contract performance and to discuss
tha statement of work. After a thorough review of the
statement of work, installation reguirements and tentative
performance dates, a schedule was established for
installation and training activities.
4. Installation and Training
_ _»_—..^._ _»
1'Within this task, subtasks were defined, namely,
Pxeinstallation, Installation, Post Installation, Pre-
training. Training and Post Training. Activities contained
and implemented via these subtasks are listed below.
-------
AyiMUi INSTALLATION AND 'i'KA.1.1 NG PHOCKUUK KS
S U U S Y S T !• M IN 5 T A 1.1A '' 10 N
I1 re- Installation Preparation
1. Telephonic Contact To:
* Cooedinato installation date
• I'.stnbli sh agency/contractor contact for Data Base
« Determine equipment conl'iq uration
* Determine computer resources to be allocated
to the subsystem '.I
• Determine local conventions relative to JCL
(or equivalent) and special program, procedure
and data set naming conventions
o Determine peculiarities of 'computer, operating
system, or computers which might reguire
programming changes to the subsystem.
2. He vise JCL to conform to local conventions or prepare
new control statements as reguired and perform detailed
desk check of result.
3. P-erfortii checkout of revised JCL (or euivalent)
contractors computer (or using leased time). This step
may be' postponed until installation.
<4. Revise program, if reguired, and test and document.
Some or all. of this step may necessarily be postponed
until installation depending on type of program changes
needed.
5. Assemble installation tape.
6. Test installation tape by simulating installation to the
extent possible on contractors computer.
INSTALLATION
1. Check out JCL (or equivalent)
2. Check out revised programs, if any
3. Compile all programs
•-U-. .Catalogue (or equivalent) all JCL procedures (or equivalent)
'""5."' Catalogue (or equivalent) source, object and load modules
6. rerforn acceptance demonstrations per Installation
a rid T«-.:.';t Gui do Line
7. G'Mierate intern.;! tables froiii agency provided data
.".. o.Miornte iu.iti.-il data ba.se from aqoncy provided data
9. Prepare tape copy of installed system.
-------
10. C'vllt.'Ci and pack hard copy ol: nstalled subsystem.
POST TN.STALLATIOK
1. Prepare and report clidiiqe.'i; to pcogram documentation
necessitated by installation.
2. Coordinate with instructors so that special adaptations
are included in course material.
3. Annotate and file base copy.
4. rile tape copy.
5. Prepare installation report.
-------
API1 LI CAT lOW/OL'Hi; AT10N liAiNiNG
I'UK I'All AT ION
1. Upvise traininq material to coincide with changes made
for inctallation-
2. Coordinate with aqency to establish course schedule,
special topics and number of students.
3. Prepare course material for special topics.
CONDUCT TRAINING
-------
I'lKiT -TK A I N I MC.
1. Prx;i] iiK'ii t special topi.cs and/or problems tliat arose
during training.
L'. Docii HK,'II t .special problems encountered with course or
program documentation or subsystem capabilities.
3. Prepare training report for EPA.
U. Revise course material as required.
Tlio traininq was prorjented according to the Training Program
outliuos and tentative schedules which follow.
o
-------
A (J U (i 5J - .1. L T /( A I. N .1. N < I S ( U1.) tl I.h'
(Tentativo)
Tl IKS DAY WEDNESDAY
'J:00 AH Overview 'l irannaction
10:00 AM
11:00 AM File
Mai n I-.enance
12:00 PM Lunch
1:00 Tables
File
Update
Old AQDHS
File
Lunch
SARDAD & OLD
AQDHS Input
2:00 PM Site Code AQDHS-II
Input
T:00 PM Pa-raineter Code
Parameter
Standard
THURSDAY
Rot ripval
General
1:45 PM Review
Review
Lunch
AQPHS-II
Ketrieval
Language
Copied COBOL
Inline COBOL
Rev iew
FRIDAY
Reports
SAROAD
Statistical
Lunch
Detail List
Sliding Average
Review
Conference
-------
Src t ion L'.iqe .,
I OVERVIEW
1. 1 A(.;:uio-l r Status
1...! lio.rM.f.) n Overview
1..) AQOIIS-II Overview
. l.'i A ODHS-11 Functional Flow
1.5 How to Use AQDHS-II - Use of JCL to Invoice
Cataloged Procedures
2 FILE MAINTENANCE
2.1 AQDHS-II FILES and Tables
2.2 File Change Concept
2.3 File and Table Names
.3 AQDHS-II
"3.1 Use to Edit Input and Prepare Report Headings
3.2 Table Contents - Diagnostic or Utility
4 SITE CODE TABLE
U. 1 Functional Flow
t|. 2 Table Creation
.4 Table Maintenance - Potential Problems
5.5 Table Overflow
5.6 Examples
5.7 Table in AQDHS-II
5.8 Diagnostic Messages
n PARAMETER STANDARD TABLE
«;>. 1 Functional Flow
0.2 Table Creation
6.3 Table Maintenance - Add, Change, Delete
(>. 4 Examples
6.5 Table in AQDHS-II
0.6 Diagnostic Message
•
7 REVIEW
» . ...
« •"" 'FILE MAINTENANCE
H.1 " Functional Flow
ij.1.1 Transaction Edit
i. 1. 2 Fi lo Update
M.2 AooilS-JT Master File Record
c!.3 Transaction Edit
-------
I' i I.I'' ( \. ''.'I I I. Oil ..
l-'i !«• UfxiaU- .
Kx .1 m i'l .or. - Goii'Ji.Til
'i.V !•'i Lo il j)d,i l.o 0 i/i') no:;t:i.<: f-lossa qos
H.H Transaction F.dit Diagnostic Message
') C f) N V K [(T 0 L D A (.} 0113 F11. K
''. 1 Functional Flow - Conversion . .
'''. 2 . Use wit. (i File Update Procedure
9-3 Diagnostic Messages
10 SAROAH AND OLD AQDIIS MANUAL INPUT
10.1 Functional Flow
10.2 U.-i-o With Transaction Edit
10.3 Use With File Update
10.4 Suppressing Conversion Diagnostic Messages
10.5 Examples
10.6 Diagnostic Messages
10.7 Option to Continue Using as Input
10.8 Action Cards
11 AQDHS-II. MANUAL INPUT
11.1 No Need for Separate Procedure
11.2 Uso With Transaction Edit
11.3 "-. Use With File Update
11.U . AQDHS-II Input Load Sheets
11.5 Option to Change to .AQDHS-II Input
12 REVIEW
13 RETRIEVAL
13.1 Functional Flow
13.2 Retrieval Options
13.2.1 AQDIiS-II Retrieval Language
13.2.2 COBOL - Need for COBOL Expertise
13.3 Select Statement.Structure-
13.4 Retrieval Logic
14 AUDHS-IT RETRIEVAL LANGUAGE
14.1 Retrieve on any Field in Master File Record
14.2 Subject and Object Name
14.3 Examples
14.4 Repeating Data Names in Compound Select Statements
15 COPIED COBOL AMD IN-LINE COBOL
15..1.. . Need to Have COBOL Expertise
15.-2- " Available if Needed
16 KKVLKW
17 OIJ A RTF. }•'!.. Y S A HO AD REPORT
17.1 Functional Flow
REGIOI'I III LIBRARY
-------
17.2 li x a in p 1 e 13
i ' i
in ;.; PATiLiT ICAI. REPORT
1H.1 Kunctiona I Flow
1H.1.1 Hn_:.-,tFT Pi.Linp 1 e Reports
1H.5 Diagnostic Messages
IB.6 Limitations
19 DETAIL LIST REPORT
19.1 Functional Flow
19.2 Options
19.3 Sample Reports
19.1 Diagnostic Messages
20 SLIDING AVERAGE REPORT
20.1 Functional Flow
20.2 Options
20.3 . Sample Reports
2.0.14 -"• Diagnostic Messages
20.5 • Limitations
.10
-------
L! U'_I L dii 'Jilil J:_ L'i!L!JL!12iI Ji
Consul l..i t-. ion wa:; qi.von ho :.;l-ato:; pr' telephone inq ui rior. in
f •••so. I. u t~. i on o i. [>roh L'-iins. H.i.:.;cl'.?ms WOIM corrected,
Mi tot.l and mailed to tho Kl'A uovolopmon t group.
Tho al)ovi? suiiiiiiary of tasks used to imploment Task Ouclev
Number Ten addressed all items within the statement of work
A moire; detail description of activities problems and
solutions are contained in the following reports.
-------
IRI national Uur.inc:;s Machiniir, Corporation
10100 Frederick Pike
Gaithersburg, Maryland 20760
January 26, 1976
Mr. A. W. Marks
USKPA Region III.
(>t.h and Walnut Street
Philadelphia, Pennsylvania 19106
Dear Mr. Marks:
Pre-installation activities were completed week ending Janauary 23, 1976,
in support of the AQDHS-II installation task order for EPA in the
Commonwealth of Virginia.
Installation will commence as sch'eduled, January 26, 1976.
Sincerely,
R. M. Williams
-------
'\ r
UNITED STATES ENVIRONMENT/:. PROTECTION AGENCY , ,- /
,\ w '_; /
-------
-------
, . 3 I)
2. IBM
a. Will utilize the SAUOAD data base furnished by EPA
nnd install it.
b. Program errors or data base errors in material furnished
by EPA are MOT to be fixed; see TASK 8.
3. Virginia
a. Will furnish the up-date data to be used in Task 4.
TASK 4 - Simulated Up-date Cycles
1. IBM
a. Will operate the three simulated up-date cycles in con-
cert with designated Virginia personnel. This will permit Virginia
personnel to achieve operational familiarity prior to actual or "live"
operation.
b. Program errors are NOT to be fixed; see TASK 8.
2. Virginia
a. Will verify the accuracy of each up-date cycle prior to
the beginning of the next up-date cycle. The results of each update
cycle nmst be verified as acceptable prior to initiating subsequent
cycles.
•
TASKS 6 and 10 - Training
1. EPA
a. . Will authorize training to begin only after Tasks 1-4
have been completed.
b. Will review training material prior to initiating training.
2. IBM
a. Will supply an orientation workbook containing site
specific information.
b. Will supply own material for a reasonable number of stu-
dents.
TASK 7 - Keypunching
1. IBM . .
a. Will perform own keypunching
-------
JAiiMJi ~ rrogram/SAKOAD daLa base Errors
1. IBM
a. Will MOT fix errors in programs/data furnished by EPA.
These will be documented, and .forward to the individual designated
in Task 8.
1). All activity on the Task Order will cease immediately
after forwarding the necessary documentation as outlined above.
c. After any errors have been corrected by NADB, and those ' "
corrections received by IBM, installation will continue as soon as
practical. IBM will make every effort to restart installation with-
in one month after notification by the EPA project officer.
2. EPA
a. Will authorize continuance after program/data has been
fixed by NADB.
b. Will expedite the fixing of any-errors in EPA furnished
programs/data. The average time required to correct errors is three
weeks.
TASK 9 - JCL Changes
1. IBM .
*
a. Will document any necessary c'hanges, and make them avail-
able to the project officer.
TASK 5 - On Call
1. Virginia will
a. Notify IBM a. minimum of three weeks in advance for any
assistance during a semi-annual reporting period. The following
will be supplied to IBM:
expected start date
• duration of assistance
amount of assistance requested
b. Notify IBM immediately of any problems that requires
IBM assistance.
c. Notify EPA of problems and semi-annual cycle.
-------
2. IBM will
a. Respond in a timely manner with requests for assistance.
III. Schedule
IBM offered the following schedule:
January 26-30 - Installation of the AQDI1S-II system
February 2-6 - Three Simulated Up-date cycles and bringing
SAROAU data base on-line
February 9-13 - Training preparation
February 16-20 - Training
This proposed schedule was accepted subject to the definition of
scope of work as outlined in the previous section.
IV. Miscellaneous
1. The weekly report as described in item number 11, Reports
shall consist of a verbal report on Monday afternoon. This will be
followed by a more detailed written report.
Sincerely,
A..W. Marks
Computer Systems Analyst
ADP Management Branch
cc: Attendees
Mrs. C. S. Atamanchuk, NCC (M-7) .
Mr. H. Cole, IBM Corporation
Mr. L. Felleisen, EPA, Region III
-------
February 2, 1976
Mr. A. W. Marks
U. S. Environmental Protection Agency
Region III
6th and Walnut Streets
Philadelphia, Pennsylvania 19106
Dear Mr. Marks:
Subject: BOA #68-02-1379, Task Order Number 9
Installation of the AQDHS-II subsystem was completed January 30, 1976.
Par telephone conversation with you and Mr. Hughes, it is agreed that
the training class schedule will be changed. Thus class will start
February 17, 1976, and end February 20, 1976. These adjustments have
worked in the past and I do not anticipate reduction of subject matter.
The approximate total expenditure through week ending January 23, 1976,
is $2,067.
Sincerely,
R. M. Williams, Jr.
-------
,'itiiYI
M.'ichiiic:; Corporation
1(3100 noilurick I'iKo
G.-iithersbury, Md. 20760
February 23, 1976
Mr. A. W. M;irks
U.S. Knv.i ronmental Protection Agency
Region IQ
6th and Walnut Streets
Philadelphia, Pennsylvania 19106
Dear Mr. Marks:
Subject: BOA #68-02-1379, Task Order Number 9
i
Training on the AQDIIS-II subsystem was complete on February 20, 1976.
The Virginia data base is not yet complete. The SAROAD transaction tape,
from which the master fi3e will be generated, contains 147,000 records
representing history going back to 1960. The user has decided that he
is interested in data from about 1970 to the present. He plans to reproduce
the tape, stripping the unwanted data using a utility program provided by
tin.; computer center (TAPS). He must also re-load his Site Code and Parameter
Code Tables, augmenting them with site and parameter codes which it has been
established were missing when we first attempted to bring him on line with
his SAROAD data. With the shortened version of the SAROAD tape and his
tables re-loaded, he will then be in a position to convert the SAROAD
transactions to the new AQDHS-II format and build his master file.
i
The approximate total expenditure thro.ugh week ending February 20, 1976
is $7,114.00. .
Sincerely
------- |