49-97 OrdinanceRECORD OF ORDINANCES
.~
~,..
ern
Dayton Legal Blank Co.
Form No. 30043
49 97 _ Passed- -- - - - - -- --- -- ------- ----- -19-
Ordinance No.---- - --- -- --- --- - ----- -
An Ordinance Amending The Annual Appropriations Ordinance For The
Fiscal Year Ending December 31,1997
WHEREAS, Section 5705.40 of the Ohio Revised Code allows for supplemental
appropriations to be made to an appropriation measure provided sufficient resources
are available, and
WHEREAS, it is necessary to amend the annual appropriations measure to provide
funding for computer support services and equipment.
NOW, THEREFO , BE IT ORDAINED, by the Council of the City of Dublin,
State of Ohio, of the elected members concurring:
Section 1. That there be appropriated from the unappropriated balance in the General
Fund the amount of $70,000 to account 01-02-13-2349 for computer support
services.
Section 2. That there be appropriated from the unappropriated balance in the Capital
Improvements Tax Fund the amount of $25,000 to account 40-03-14-2571 for the
purpose of acquiring a server and related hardware.
Section 3. That the public hearing be waived in order to provide immediate funding
for the above purposes.
Section 4. That this Ordinance shall take effect and be in force in accordance with
Section 4.04(a) of the Dublin City Charter.
Passed this L~ day of , 1997.
Mayor -Presiding Officer
ATTEST:
_~~~ ~ ~ ~
Clerk of Council
t h~-et,v cera:fy ti,~at copies of this flrd"Hance/~errvr;;re posted in the
City of a~brn its arcardance with Section 731.25 of the Elhio Revised Cody.
~.~
~t (MrMrkl~f 6 uttc~~, 6fin, Ohio
T:\PER\DKP\97\053-7-MG. W PD
I N T E R
MEMO
O F F I C E
To: Members of Dublin City Council
From: Cindy Hide Pittaluga, Member, Ad-hoc Computer Committee of Council
Tom McCash, Member, Ad-hoc Computer Committee of Council
Subject: Funding For Computer Support Services
Date: Apri18, 1997
A meeting of the Ad-hoc Computer Committee of Council was held on March 24, 1997 as a result
of concerns raised at the March 17 City Council meeting with regard to the request for additional
funds to extend the City's contract with Sarcom.
We met with Tim Hansley, Marsha Grigsby and Amy Dellenbach, Information Systems Technician,
from staff and several representatives from Sarcom, including two (2) Systems Engineers who have
been working with the City's systems on a day-to-day basis and an Integration Consultant whose
involvement has been limited to providing expertise with regard to network design and analysis.
The Integration Consultant has also been involved in discussions with staff to address the issue of
preparing acity-wide strategic plan for our computer systems. One of the most time-consuming
elements of preparing a strategic plan is the assessment of the computer infrastructure environment.
Sarcom, based on the time they have spent working for the City, has a good understanding of the
City's systems and issues that need to be addressed. However, the completion of the city-wide
strategic plan is a process that will be completed after the Director of Information Technology
position is staffed and will require additional consideration at that time.
Attached please find a detailed report of work that has been completed by Sarcom since we
contracted with them last fall. A significant amount of work has been completed and has resulted
~.
in improvements to the City's computer systems. Sarcom has identified and addressed many issues
that are critical to providing a sound computer infrastructure foundation on which to support the
City's current and future needs. In addition to the projects completed, Sarcom has provided day-to-
day user support as a result of vacant authorized staff positions.
As detailed in the Sarcom report, the City's computer systems environment has become very
diversified, distributed and complex. The computer systems range from providing police dispatching
and 911 service to processing building permits. City staff, in all departments, has become very
dependent on computer systems and it is critical to provide maintenance and support for both
hardware and software in order to continue to be responsive to the community.
Members of Dublin City Council
Page 2
April 8, 1997
From a maintenance and support standpoint, the industry standard for an information systems
operating budget is $2,800 per computer. Using this standard and the 172 computers utilized by City
staff, the operating budget for this function should be approximately $481,600. For comparison
purposes, the 1997 information systems operating budget was originally $285,340. The additional
amendments requested, the $50,000 authorized on March 17, 1997 and the additional $70,000
included in Ordinance 49-97 will bring the total budgeted amount to $405,340, well with industry
standards.
Based on the attached report that was presented to the Committee and the meeting with staff and
representatives from Sarcom, the Committee is recommending the remainder of the funding
($70,000) previously requested for appropriation be authorized.
At the meeting, staff also raised a concern with one of the file servers at the 5800 Building. This
server is used by the Division of Building Standards and stores all building permit related data, as
well as all GIS data. There have been continuous problems with the server crashing, with the
memory and the disk drives. Because the equipment is an "off-name" brand, the problems have been
compounded by the lack of diagnostic tools available for this brand of server. The problems have
resulted in staff down-time and the inability to provide information and service to builders and
homeowners during the periods of time the machine has been down. Staff has requested that we
authorize funding to replace this server.
Due to the critical nature of the information stored on the server the cost of staff down-time and the
lack of customer service during down-time, the Committee is also recommending that funds in the
amount of $25,000 be authorized for the purchase of a new server at the 5800 Building. The current
server can be used as a test server for less intensive applications.
T:\PER\DKP\9'7\050-7-MG. W PD
Memo
Date: March 24, 1997
To: Ken Estep, Sarcom Systems Engineer
From: Don McNeil, Sarcom Systems Engineer
Subject: City of Dublin project documentation
Attached is an outline of the computer system environment, project accomplishments, major problems
encountered, day-today support problems, future project work and budget history for the City of Dublin.
This report has been prepared based on information taken from monthly reports submitted to the City of
Dublin by Sarcom staff and verbal information gathered from Sarcom staff and City of Dublin staff. The
information is believed to be accurate based on these reports and verbal information. This document has
been submitted for review to involved personnel at least twice prior to the final draft.
This document is to be used as supporting documentation to further fund the City of Dublin computer
systems project work. This document is submitted to you as City of Dublin project leader for
dissemination to appropriate City of Dublin staff.
I. Comuuter Systems Enviro>ament
The City of Dublin computer systems environment is very diversified, distributed and complex. This
environment is not a simple Local Area Network housed in one building with a handful of users connected
to a mainfrante computer. This is not even a campus environment where there aze a couple of buildings
in close proximity. This is a complex metropolitan environment spread out between five different
buildings. Each building performs a different function for the city each requiring different computer
needs, hazdwaze, applications and support. But all buildings and users have a requirement for a reliable
and responsive computer system to perform their job functions, provide a high quality level of service to
the Dublin community and to meet the growth needs of the City of Dublin.
:,:
Currently only two of the five buildings have any computerized means of connectivity. This hampers
user's inter-communication requirements for communication to other users in other buildings. It also
greatly compounds the complexity of city wide computer systems support, not only for new projects but for
day to day user support as well.
It can be clearly seen from a city infrastructure view point that as the city and community grow new roads,
new housing, new sewer systems, new shopping areas must all be put in place to accommodate the
growth. The same is true for the computer system infrastructure the city uses to administer its day to day
business in such a growing community. A rough count of equipment and users is listed below broken
down by building. This is not a static number but changes almost daily as new requirements for
personnel, information and communication needs aze presented.
File
Operating
Servers Users Printers Mainframes Terminals Applications* Systems
City Hall Building 9 35 19
Justice Center Building 3 40 11
Recreation Center Building 1 19 4
Service Complex 2 17 2
5800 Building ~ ¢,1, Q
._ Totals 20 172 45
1 1 11 5
0 0 13 3
0 0 6 3
0 4 7 3
4 4 2~ 4
1 5 62 N/A
* Application information is a rough estimate of the primary applications being used and does not
necessarily account for standalone applications installed on a users local workstation hard drive.
The city computer systems are obviously only a part of the entire picture but they aze a very integral part.
The computer systems require continuous updates, maintenance, and support for both hardware and
software to help the City of Dublin continue its tradition of responsive service to the community.
II. Accomplishments
Below is a listing of project related accomplishments completed since September of 1996. It should be
noted that extreme complications arose in nearly every project which had to be overcome to complete the
project. Complications which in some cases had nothing to do with the original project but prohibited
completion of a project until resolved. Where possible, some of these complications are briefly outlined in
the Major Problems Encountered section of this document. More information regarding problems/issues
can be found under the DAY-to-DAY Support section of this document.
City Hall Building
• File Server Operating System
> Patch Netware operating system -ongoing basis as new patches come out
~-~ • File Server Backup
> Installed and co~gured Cheyenne Areserve backup software
> IBM backup server was replaced with a Compaq. Compaq was configured with Adapter 2940 SCSI
adapter
> First install of tape drive devices was two Exabyte 4mm drives. The capacity of these device was not
enough to backup all required data to tape. This was replaced by the Cybernetics autoloader and tape
drive which had previously been installed in the 5800 building and just returned from Cybernetics for
repair
• Network Communications
> Internet Access -this access was not previously available and was greatly needed by users in City
Hall, Court and Police. This access is to the desktop and available to all users
- Changed current link from 64kb to fractional Tl (128kb)
- Assured ability to step up bandwidth in 64kb increments to full Tl as bandwidth is required
- Installed and configured new hardware to interface with the Tl access
- Completely reconfigured and assigned IP addresses for all IP network devices on the entire
network
- Subnetted IP network to incorporate MAC clients
> Dial-in\Dial-out communications
„„<,$
- installed, configured and tested IBM 8235 communications server. Downloaded and applied all
patches, installed on client workstations and tested, implemented capability for payroll transferred
to Bank One
Groupwise
- Installed and configure Groupwise post office and domains, populated post office, installed clients
for both DOS\Windows client
- Reconfigured Bay Networks AN router to handle MAC services
- Installed MAC Groupwise for Macintosh clients
- downloaded and applied all patches and fixes for Groupwise server and gateway
• Applications
> Installed Cheyenne Inoculan virus protection software on Police Department and City Hall file servers
> Installed VISO software for documenting the city wide network
> Install test lab to provide testing environment before installing applications and hardware in
production network environment
Network Documentation
> Completed graphic documentation of the network and network components between City Hall and
Justice Center
Justice Center Building
Police Department file server
a Transfer applications from old Netware 3.11 file server to Netware 4.10 file server -please see the
Major Problems Encountered section of this document for information related to problems with this
project. This project and the associated problems directly affected the city's 911 service.
• File Server Operating System
> Patch Netware operating system -ongoing basis as new patches come out
• Network Communications
> Groupwise
- Installed and configure Groupwise post office and domains, populated post office, installed clients
- applied all patches and fixes for Gi-oupwise server and gateway
> Internet Access -this access was not previously available and was greatly needed by users in City
Hall, Court and Police. This access is to the desktop and available to all users
- Changed current link from 64kb to fractional Tl (128kb)
- Assured ability to step up bandwidth in 64kb increments to full Tl as bandwidth is required
- Installed and configured new hardware to interface with the Tl access
- Completely reconfigured and assigned IP addresses for all IP network devices on the entire
network
• Network printing
> Moved LEMIS print server to new location and reconfigured it to handle CAD upload process
> Installed and configured Xerox printer
Recreation Center Building
• File Server Operating System
> Patch Netware operating system -ongoing basis as new patches come out
• File Server Backup
> Installed and configured Cheyenne Areserve backup software
• Network Communications
> Groupwise
-Installed and configure Groupwise post office and domains, populated post office, installed clients
- applied all patches and fixes for Groupwise server and gateway
• Network printing
> Setup new printers and print queues
Service Complex
• Setup and install new file server
> Configure IBM desktop as file server until new server could be aquired after old server failed
> Setup, configure and install new server
> Installed Adaptec PCI SCSI controller for tape drive backup system
• File Server Operating System
> Upgrade form Netwaze 3.12 to 4.1
> Patch Netwaze operating system -ongoing basis as new patches come out
• File Server Backup
> Installed and configured Cheyenne Areserve backup software
• Network Communications
> Groupwise
- Installed and configure Groupwise post office and domains, populated post office, installed clients
- applied all patches and fixes for Groupwise server and gateway
5800 Building
• Load balancing
> Setup and install new file server
- Setup, configure and install new server
- Configure bindery synchronization between Nerivaze 4.1 server and Netwaze 3.11 server
- Determine directory structure needs and planning for moving applications off Oracle server
- Analyze and determine application usage and rights requirements
- Client workstation analysis and preparation
- Desktop applications moved to new file server
- Applications installed as required for access from new server
- Application testing from client workstation
- User support following new server install, resulting mainly from lack of client workstation
configuration standazds
Installed new network cards in Oracle and application file servers -this allowed network traffic to be
off-loaded from the Oracle file server, further reducing the load on that server, and allowed network
traffic to be handled by the application file server.
> Reconfigured the Plexcom hub to balance load between heavy Oracle/GIS/AutoCAD user and
standazd desktop application users. All heavy Oracle users were placed on the same token ring as the
Oracle file server. The reduces the routing load on application file server and increases system
performance.
• Oracle File server- ALR Revolution
> Replaced memory expansion board -warranty item
,, ., > Identified set of bad memory SIlVIh~S
> Installed new network card
• Application file server - DEC Prioris
> Replaced three disk drives
> Upgraded firmware and BIOS on disk drives, controller card and system board
> Installed two new network cards
• File Server Operating System
> Upgrade Oracle file server from Netwaze 3.11 to 3.12 to prepaze for Oracle upgrade
> Patch Netwaze operating system -ongoing basis as new patches come out
4
• File Server Backup
> Determine after extensive efforts that Palindrome software needed to be replaced
> Installed first on trial basis, Cheyenne Areserve backup software then live version of application
> provided capability to back up standard data and Oracle database
> Install standalone backup server to remove backup services from Oracle file server
> Install new tape autoloader and tape drives
> Installed Dbagent for Cheyenne Areserve backup software to allow for online backup of Oracle
database
> Created standardized backup jobs to ensure backup process completed within backup window time
frame with reporting and validation procedures
> Monitor backup process on regular basis to ensure reliability
• Workstation Standardization
Attempt to standardize the workstation configurations, no two workstations were configured the same
• Oracle Database
> Completed a detailed analysis of the Oracle installation and configuration
= Created report on findings along with specific recommendations
> Located, installed an NLM based scripting program for running unattended Oracle database exports
> Wrote script for running and managing nightly and weekly exports of the Oracle database
> Wrote script to manage Oracle Redo log files which get created during backup process. If not
managed then files continue to get created and eventually fill the disk space causing the server to
crash, corrupt the Oracle database and possibly corrupt Netware Directory Services
> Incorporated reporting capabilities into the Oracle export and Redo log scripts to ensure processes can
be monitored for proper operation. Designated users to run reports on daily basis by incorporating
reporting process into login script.
> Attempted to upgrade Oracle from version 7.0 to 7.3 on two different occasions
• Network printing
> Setup new printers and print queues for various departments
> Installed new network interface card for Xerox printer which operates under NDS services
• Applications
> Re-installed Perfect Office suite
> Re-installed FolioViews
> Upgraded QEMM on all workstations
> Reconfigured the CD tower to eliminate access problem to the tower and installed new CD client
software on designated workstations
•~ > Installed Cheyenne Inoculan virus protection software on Oracle file server, application file server
and backup file servers
Configured Inoculan client for auto-install to the client workstations, tested install process and
worked to validate compatibility of client install on workstation with other resident applications,
modified configuration as required to determine best possible configuration.
III. Maior Problems Encountered
City Hall Building
Hardware
Diagnose and repair faulty file server equipment -IBM model 95, at time was the City Hall file server,
communication problems on the network, found problems with CMOS and network card problems.
Had to remove server as primary City Hall server due to continued hazdwaze problems and
implement as backup and internet access server. Server continued to experience communication
problems on the network and caused failures on the nightly backup. Server had to be replaced after
multiple attempts to remedy the problems. Was replaced with Compaq Deskpro
HUBS - the Plexcom hub was found to be causing random intermittent communication problems on
the network and interfering with communication between the Justice Center and City Hall across the
fiber link. A diagnostic device was brought into analyze traffic on the network and took considerable
time to isolate the problems. Part of the problem was within the mold-LAN card of the hub which
was working intermittently. This type of problem interferes greatly in diagnosing and resolving other
problems such as the USTI application problems. It is difficult to pin point the source of the problem
due to the erratic nature and to determine if the problem is in an application or a network
hazdwaze problem. The Plexcom hubs were replaced with Baynetworks hubs and resolved the
random communication problems
Passive hubs -there were passive hub mixed in with active hubs which caused multiple intermittent
and random problems through out the network
Active hub -one of the Baynetwork hubs experienced a problem which put it into a continuous boot-up
sequence loop. It was replaced the same day.
Multiple workstation problems -found other machines had a multitude of problems. They were
repaired and configured as needed
CDROM server - failure of CDROM server required repair of the equipment by manufacturer
Cybernetics Tape Autoloader - this device was previously installed in the 5800 building and
had experienced problems with the tape drive device installed in the autoloader. It was removed
from the 5800 building and sent out to Cybernetics for warranty repair. It was installed after being
returned from Cybernetics with no problems found. Two days after it was installed problems with
the tape drive started again, and again it was shipped to Cybernetics for repair. Cybernetics replaced
the tape drive in the autoloader. Again after a couple days the device experienced problems. The
only remedy is to send the unit back to Cybernetics for warranty repair. At this time the unit is still
out for repair and a make shift backup process has been put in place.
Software
Internet email - was not functioning, basic hazdwaze was not connecting reliability to the token ring
Justice Center Building
Hardware
Police Department file server - continuous problem with locking up. Diagnostics were run on the
server. All adapter cards were reinstalled and one network cazd was removed
Random File server disconnects -original source of problem unknown, server was first moved to City
Hall building, a diagnostic device was brought in to analyze traffic on the network. Random
disconnects and lock ups caused multiple problems with database applications
Random Workstation lockup -original source of problem unknown. However, it was related to
problems with file server lockup and disconnects
Media filters - several media filters were creating random problems on the network and were replaced
Software
USTI application - not functioning properly due to workstation and file server lockup problems with
an old DOS Betrieve application being run from within Windows. This is the primary application
used for the city's 911 service and is a critical application.
The vendor of the application was contacted. Their response being it was not their problem, it was a
Betrieve problem, not a problem with the application itself: However, the application specifically
requires the Betrieve database in order to run and store data. Novell was contacted with the Betrieve
issue and again it was referred to Pervasive, the company which now supports Betrieve.
Eventually a work around for the USTI application was put in place until the problems could be
resolved. This work around consisted of running a different Betrieve client at the workstation.
However, this client used more memory so it could not be run from within Windows requiring the
user to exit Windows to run the application.
~"' °` The vendor supplied little help in resolving the issues with the application, had no technical support
staff which could address the Betrieve issues which the application relies upon. Additionally, the
vendor has stated they no longer program using Betrieve as the database engine and have no plans to
upgrade this application under Betrieve to a more current platform such as Windows.
While tracking down answers to the Betrieve problems other related issues and problems became
apparent. Due to the server locking up, the Netwaze Directory Services had become corrupted. This
had to be wiped out and rebuilt. Communication issues developed and the file server had to be
moved to City Hall to help diagnose the communication issues.
Users still experience random problems with the application. But, the major communication
problems were resolved through correcting some of the other problems with the server hazdwaze and
network hubs as listed above both in Justice Center and City Hall. Please see the detail for these
other related issues.
Netware Directory Services corruyted -due to file server lockups and disconnects NDS had to be
reinstalled after moving the file server over to City Hall building
Corporate Keeper -multiple users having problems running this DOS application under Windows due
to memory problems. It was finally recommended to run the program directly from DOS requiring
the user to exit Windows
Recreation Center Building
~~ Hardware
Photo IDprinter -this was a device which was not originally researched thoroughly. However, this is
a critical piece of equipment for the Recreation Center for creating new accounts and validating
members. The inability to create the photo ID cards creates extra work to verify a person is actually a
paid subscriber to the facility. This causes delays and frustration for the facility members.
Resolution to the problem was worked through the softwaze manufactures technical support but took
several calls and still did not resolve the problem. Placed call to the hazdwaze manufacturer and was
able to resolve the problem.
Service Comnlez
Hardware
Diagnose and repair faulty file server equipment -IBM file server randomly locked up due to memory
problems. A user workstation had to be configured as a file server until IBM file server could be
replaced
Software
Corrupt files -Memory problems with IBM file server would cause corruption in the database. This
required rebuilding database indexes on a regular basis
5800 Building
Hardware
Oracle file server - ALR Revolution -continuous problems with server crashing, memory
problems and disk drive problems. These problems aze compounded by the lack of diagnostic tools
°° available for the brand of server. Troubleshooting and diagnostic are performed mainly by
swapping~rnoving suspected bad components to see if problem is resolved or follows a component.
Application file server -DEC Prioris -experienced multiple disk drive failures on two different
occasions. In process to repair disk drive failures, required to upgrade system BIOS, disk controller
BIOS and firmware and individual disk drive firmware
,~.,~ Backup Server install -attempted to use existing, old IBM Value Point as backup server, experienced
extensive problems in getting Netware loaded and in keeping server running. Finally had to replace
with a Compaq Deskpro to ensure reliability
Tape autoloader and lave drive -experienced multiple problems with existing autoloader/tape drive
subsystem, caused multiple failures of backup jobs and backup server crashes.
Software
Workstation Standardization -due to the lack of standazdization on workstations any attempt to install
or make a change to a workstation caused hours of additional work to either correct a configuration
or reconfigure the workstation so all applications would run correctly
Palindrome backup softwaze -attempt to utilize current install and successfully backup data and
Oracle database. Troubleshooting efforts lead to specific requirements for upgrading firmwaze on
tapedrive hazdwaze and upgrading Palindrome with current patches. Some of the upgrades required
server down time which has to be scheduled.
Re-install of Perfect Office applications -The application had to be reinstalled due to the nature of
how the application installs itself on the file server. It cannot just be copied over to the new file
server. This required a reinstall of the client at each workstation. Subsequently, some portions of the
installation did not install correctly and were not identified until users began using the system during
regular business hours. Therefore, the application had to be reinstalled again.
_, ,, Corruption of Oracle database - due to the System volume of the Oracle file server running out
of disk space and subsequent attempts to bring the database back online without sufficient disk space,
the Oracle database experienced major corruption.
Persistent problems with the Oracle database and maintaining its integrity due to continuous
,~,:. hazdwaze problems with the Oracle file server.
QEMM -major problems developed on workstations due to and upgrade of the QEMM memory
manager sofhvaze. What should have been a relatively simple process became difficult and time
consuming again due primarily to lack of workstation configuration standards, the nature of the
applications being run on the workstations and difficulty in obtaining timely and accurate
information on specific application setup parameters
Inoculan Client Install -completing the rollout of the client install became a much longer process than
anticipated based the inability to complete testing of the test workstations and receive timely and
accurate feedback on the nature of problems encountered
IV. Dav-to-Day Support
Current state of computer network across city - due to inadequate staffing and support resources, overall
systems were implemented without proper testing and were installed with underlying problems.
Trouble shooting these type of problems without any documentation and understanding of intent along
with lack of needed resources such as software, hardware and dial out lines made progress painfully
slow. This scenario is city wide and hampered efforts in nearly every aspect of project work. To
confuse issues further multiple copies of the same application would be installed on a file server on
different volumes or under different directories. Sifting through what was a valid usable installation
-~ and what was not is very time consuming. Directory structures were haphazard and represented no
logical groupings of applications, files or user accesability. Directory and file rights assignements for
users or groups of users reflected no logical ordering. Again, lack of specific documentation or intent
as to the directory, file and user structure slowed project work considerably. This is also probably due
to inadequate staffing and lack of centralized control over the computer systems. It requires looking
through directory structures, workstation configurations and talking to users to find out what
applications they are using, how they are using them and arranging applications to fit into a standard
directory and drive mapping structure.
Hardware equipment failure -there has been a continual consumption of time in maintaining previously
installed equipment in an acceptable operating condition. As inferior hardware and associated
components fail, time is taken away from standard project oriented work to diagnose, troubleshoot,
repair and return equipment to an operable online condition. Based on the hardware, the type of
problem experienced and the ease and speed in which the cause of a failure can be identified, dictate
the amount of time consumed. Additionally, determining how a hardware component will be returned
to operating condition also requires time. Is it under warranty? Will the original vendor repair the
equipment? Does the equipment require offsite repair at a manufacturers facility? Will the
manufacturer require certain conditions to be met such as BIOS and firmware levels before they will
even acknowledge a hardware component as faulty?
Current equipment utilization - one of the goals to date has been to utilize previously purchased computer
equipment to help the City of Dublin maintain its current investment in equipment. Much of the
equipment falls short of engineering and design specifications required to adequately and reliably
perform its assigned function. Much of the equipment is also older technology such as the Plexcom
hubs. A great deal of time has been consumed in an effort to make this equipment work where ever
possible. When it has become painfully clear that a piece of equipment will not function for the
assigned task it has been replaced or used for some other function. In cases where the old equipment
was reused, at some later point problems have usually developed which consumed more time and effort
to repair and reconfigure or replace and configure new equipment.
User knowledge level - a great deal of time is spent in basic user support of issues which should or could
have been resolved by the user. A basic issue such as where a file is stored has created user support
calls. The user believing the file has been deleted when in fact the user was not looking on the correct
drive for the file.
V. Future Proiect Work
• Building inspector remote inspection upload and download to Oracle database
• City wide connection of all buildings through ATM backbone
• City wide implementation ofNetware Directory Services standards
NDS tree design
- Determine Partition and replication strategy
- Plan time synchrinization strategy
- Create an accessibility plan: login scripts, security, directory structures, drive mappings etc.
- Naming standards for: NDS tree, users, servers, printers, other network resources
• Complete Groupwise email installations in all buildings
• Complete Inoculan client installations in all buildings
• Complete Inoculan file server installations in all buildings
• Complete installation of Groupwise client on all workstations in all buildings
• Complete Netware Connect installation
• Complete upgrade of all DEC Prioris system board BIOS upgrades
• Criss Cross Access
• Determine workstation disk backup and recovery method and implement
• Implement o$line access to basic word processing functions in the 5800 building
• Implement recommendations for the Oracle database structure in the 5800 building
• Install Managewise in all buildings
• Internet WEB page development and implementation
• Network addressing standazds for IPX and 1P
• Replace hub in Service complex
• Replace Oracle and application file servers in 5800 building
• Replace Plexcom hub in 5800 building
• Setup stand alone workstation for interns to input data to Lotus Approach in the 5800 building
• Tax Connect
• Upgrade BIOS and firmware on remaining DEC Prioris RAID disk controller cazds
• Upgrade Oracle database software from version 7.0 in the 5800 building
• Upgrade Oracle file server Netwaze operating system from version 3.12 to 4.10
• Vehicle maintenance software and hardware upgrade
• Verify and upgrade disk drive firmware on remaining DEC Prioris disk subsystems
10
VI. Comuuter Systems Budget Histo
Amount
Year Appropriated Description
1990 $ 200,000.00 Computerized Police department and Court. Changed hardware and software
for Finance and purchased hardware for administration
1991 $ 300,000.00 Computerized Development (started GIS), Maintenance including Vehicle
Maintenance and additional equipment purchases city wide for additional
staff.
1992 $ 75,000.00 Equipment
1993 $ 50,000.00 Equipment
$ 20,600.00 Justice Center
1994 $ 140,000.00 Equipment
1995 $ 275,000.00 Equipment
$ 35,000.00 ALR computer for 5800 building
1996 $ 325,000.00 Equipment -Digital file servers
$ 35,000.00 Community Recreation Center
1997 $ 80.000.00 Currently budgeted amount for equipment
Total $1,535600.00
Asset AccountinE
~« .. $1,352,000.00 Permanent fixed assets
$ 100.000.00 Deletions to be made
$1,252,000.00
11