Loading...
HomeMy WebLinkAboutAgenda - 10-19-1999 - 10a1 ORANGE COUNTY BOARD OF COMMISSIONERS ` ACTION AGENDA ITEM ABSTRACT Meeting Date: October 19, 1999 Action Agenda Item No. SUBJECT: Orange County Y2K Preparations DEPARTMENT: County Manager PUBLIC HEARING: (YIN) FNo ATTACHMENT(S): INFORMATION CONTACT: IT Compliance Summary Rod Visser, ext 2300; Pam Jones, ext Y2K Essential Services Summary 2650;,. Public Safety lCompliance Summary Jim McGimsey, Y2K Coordinator, ext 3070 Embedded Chips Compliance Summary TELEPHONE NUMBERS: Hillsborough 732 -8181 Chapel Hill 968 -4501 Durham 688 -7331 Mebane 336 -227 -2031 PURPOSE: To receive a report. on County preparations to deal with Year 2000 technology challenges. BACKGROUND: Experts believe. that many computer systems will have at least some - difficulties in coping with the challenges presented when the year changes from 1999,to 2000, because of limitations in old computer programming codes. There are concerns that many computer programs and electronic devices with embedded microchips will malfunction because of an.inability to:correctly recognize dates of January 1, 2000 and beyond. At their April. 6, 1.999 meeting, the Board .approved a contract with McGladrey & Pullen, LLP, to provide assistance to County staff in assessing, correcting, and testing the County's preparednessto continue operations in light of these potential problems. At their May 18, 1999 meeting, the Board received a Y2K implementation status report that outlined the County's critical systems. On June 30, the Board received .a report that indicated that Orange County's critical systems are Year 2000 compliant: Work'on other less critical systems has continued over the summer. The focus for the remainder of 1999, is on testing. non- critical systems, expanding the public information component, and: finalizing departmental contingency planning, for continuity of the most important County services; .should circumstances beyond the County's control (e.g. widespread unavailability of electrical power) preclude normal operations and prevent the use of automated systems that the County has rendered Y2K compliant: 2 Extensive documentation of County assessment, repair, testing, and validation efforts to date are maintained by the Y2K Coordinator and are available for review.at the Board's request. Y2K Coordinator Jim McGimsey and staff members of the County's Y2K Steering Committee will be available at this meeting to respond to any Board questions about the County's Y2K implementation plan. Summaries of current compliance status for the County's four major identified categories are provided as outlined in the list of attachments. FINANCIAL IMPACT: Funding for most necessary County technology replacements and repairs has already been included in the current CIP and current or previous operating budgets. If additional costs are noted during the completion of the County's Y2K implementation plan, they can be addressed through a Y2K reserve in the 1999 -2000 CIP. RECOMMENDATION(S): The Manager recommends that the Board receive the report for information only.. 3 IT Y2K Status Report October 8, 1999 Overview Mainframe, network and PC systems all must Y2K compliant: • Mainframe hardware is certified compliant. • Mainframe mission critical software systems have been modified, tested and are compliant: • Remaining mainframe software systems will be modified and tested in. October. and November. . Networksoftware and hardware has been reviewed and is certified compliant; network hardware will be tested to confirm compliance in October anal November: • PCs have been certified Y2K compliant, including those currently being installed.; PCs will be tested to confirm compliance in October and November. • Desktop and network -based software and databases will be tested and updated if needed. Mainframe Mission critical mainframe software systems listed below have already been modified, tested and certified compliant. Critical.. Test Script Testing- Start System . Completed Status Date Finish Date1 Personnel Y Compliant 24 -May 4 -Jun . Direct Deposit. Y Compliant 24 -May 4 -Jun Payroll Y Compliant 24- May, 4 -Jun Land Records.. Y Compliant 7 -Jun 18 -Jun Register. of Deeds Y Compliant .,7 -Jun. 18 -Jun Tax Billing Y Compliant .14 -Jun 18 -Jun Tax Collection Y Compliant 14 -Jun 18 -Jun 4 Mainframe software currently in modification and testing includes: Software Modifications Testing System Completed Status Notes Health Y November Developed with compliant. procedures. Testing .required. Planning Y October Modifications complete. Testing required: Purchasing Y October Modifications complete. Testing required. Animal Control. Y November Modifications complete. Testing required. Town of Carrboro N October Modifications Financial and underway. Testing. . Personnel Systems required: Some applications have been or will be converted from mainframe software environments'to network systems, which resolves Y2K issues in the process. The Boards and Commissions database system has been converted and tested The Board Minutes system will be converted by'November. 117-M I 11 The countywide data network and connections to State systems and the Internet have been 'upgraded as part of the, ongoing strategic IT Plan. Hardware and software elements are certified compliant or have been confirmed to not involve Y2K issues. Desktop Systems and Network Applications 'By late. October, all PCs will have been replace'with Y2K- compliant equipment under the strategic IT Plan desktop initiative. We will, however, use network based Y2K scanning software to scan all PCs, PC applications and data files for Y2K issues. This software, a standard used by the State technology organization; will detect any anomalies and identify. Y2K issues. Due to the new technology in place we expect few Y2K issues to arise. Any unusual cases identified will be resolved using software corrections deployed over the network.' 5 IT Contingency Planning Contingency planning for IS Department operations is underway, IS Department staffing schedules are being developed for Y2K and contingencies. IS staff will be at the IS Computer Center during the transition to the new year and the contingency planning will focus on what is required for critical operations to resume in the event of power or communications outages: A.second refurbished mainframe was acquired by Information Systems for Y2K testing and will provide for a. complete duplicate mainframe system to be. used as a backup should the operational mainframe system be effected by power or communications outage. A generator will be acquired to provide continuous power to critical network systems at the IS Computer Center. If power outages'are lengthy, the backup mainframe can be moved to another County location with more substantial power backup and .operated over the countywide network from that location. A Business Recovery Plan has been in place since 1997, based on a contractual program with IBM; it provides for our mainframe operations to be back in operation within 72 hours of a disaster, such as fire, flood or storm. While this is not a Y2K- specific program,, it does provide for recovery in the event of a similar disaster. 6! N (U Om V. cd R Cd W cn cn U p -glA .' U � O O Lid ''' a O �U CIS a �o m ,y It •E U , �AU t� +" O W O ® O v� N Q' cd p•i O .� "b O fu .O ai aaA•3 tw A.Q� tiri Sri A «s U �° U CCi N 0. •� � � Ll2 0.7 O �y U N P4 A 6! N 4-4 to V. cd cn cn U p -glA .' O O Lid ''' p ,y It �m) , �AU O W O U b Q' cd p•i O .� "b O .O aaA•3 A.Q� tiri Sri A «s a� v O O O N ad O O Q w •U U O `�`U rg s� c (U, •d , v G c�C cI > a 4cd a� bn p i—i U o vii y '�, U U td U o v� ai U O U O U �' ° ° ol P-4 v cu cu v U v w W ° O •rn w 6! N U O rij CV Z b. O V qA b u U N bA cd 'En W 7 rn rn o 00 0000 00 00 00 0000 01 O d 0000 01 � N O 00 000 00 0000 00 0000 00 00 M mM p N N N M C*N N 01 N 01 N M t` �. d- It �o �. N M tz. N M N M N M It d' 01 01 01 01 Ol 01 01 01 01 01 01 01 01 ON 01 01 01 01 01 01 01 01 Ol ON � o U 0 ¢' U U Imo. W CD U �O C bA Cd rn o 0 cliq U o w o � P-1 o ° U o U N bA cd 'En W 7 rn rn o v a� •;� v P" Cl O ej -4-+ a v a� •;� v P" Cl O ej -4-+ �2r � 0 i 00 0 h to ° _ y, N O N .o � N ctt � � . Z to .. 0 El- �. ° °,. U .- �c:Uwv a� wU 4 w I �wNUaU N O 48, p _ �°+ iN i O 1-4 to �Oh M r to O U ' ' pi 'N C�� N .,�-� 9 N ..vi " d N " 00 40, VV)ZN rn � NO �a a�U �0 � °Uoa A N. b A Q U "" O N a Z. ,� z "� Z 00 110 cis 0 a�� p ofi,� o q C 1:4uva p cd 10 rn kn 0 x O x a � . °. p p a N p N W p g N "p • } �Z1 U I. CN ) OZ � N Z � ' •p Nt p, c�i v O lM �, 43-0 o 3 0 o, �rx °Up'�.,U w�Uat�aa v 0 a� U W � a,� x4 „° o� a Up �U N p uNEO 0 v to 0 t-t� p N p C) .0 E oUU Z z 00 � offm o (V �_ N� r� NM C� f4 w '�' fir, ' • •�! p" ° ° G ° Q + �' • ° ai v Gq ai U C o o; cc o a cy Q�+ o of o C3 •N M t� «S —U tti •p a N 0 , p „0 0 '�t�iMUp,•.0 0.�i,d'U.PrUU0.�id'UWU U,?'WUp.iU 11 c 1 0 U a � b (1) b O ° Q, +CA W � � • c^' rn a v o a a.. �.00. � oo' ax �. Z �4x , ° , a� o � o :� Cd a o f 4-+ N U (1) a vb o 2 , ot 'U er pa, ;�. W W +.� En' .�0 3 N bo a o .'< � bao A o. aW i r�U ap U10 � 0S a � �bn0 Z o � �U Id - U b ° y o o • o a �, �,,a oU a rU a�i cd tb.a t cc) . P., � ° o ° .�a^o d o o v cJOH• :°Ori.°O(�a�r a� 4i U 0 U• - u � y 0 U td ^� —� W o b O 13 . o •� o o o A o o 0 x .pq c� 8 40. b C, .? . 0 •-+ `� P•� o ` p. a p pi m V 0' O co O Ci 0 N U rti O N .� �"' '.� N � � M � d• c� to � t� O, O �o o v a 0 W o C ,C� V 0 H 13 . o •ice CK Ism I a{ .� U U 4-4 O O y bpA 0 c� �1 qA.� o a� O c rA 10 _� o a� cn a Q,.�'� .�coU� x' x x 0 "° ;'� o.v 8 U moo. 3b b Id cd °y o0'. �b '��°�' wl co°'A� —a) O U .� 4= U cd bp 0 > p p 0 tj 1.4 0! a o U 4 4-4 o 0 o a a) o rn . b a a �+a,a,v•���� �aa��� cl • w 'o �'+ ai o o o a s a� Cd p 12 bo U" b 0 C C3 cX U O a `', w N m d= bo U O 0 Cd >.lul �. A ' 4°, W c W t W 6 � 14 _� o 0 O ,SCI O �i O En !� �o ��� o � m Uw O 0 O Sa H 0 o a�i o orh xx UHV ca N :�• wQ O O CA o �'ai r� Uinta V H O to ^� H CCS N. Cd U N bl) CCf rn N boO om o R1 0 N O dN O �O � ccll U N O -4 4-- F7 con 0 U cll 2 O U.1 H U• t-i N N O a3 U b Rf CCt U �'' N t0; W 0 N U ja "d .0 Q ,+o 2 H "d i�GA to -0 O 'd 0 OU '� O O O U .P, -� 49 bl) "d 0 N c4 to N•�� 4-i HO :U � Q t3, �i cV c*i 4 —+ N m 55, 8 N O li U N ++ ccf R N U -o CA vi y i� ��°� t rs a,4) cn 0 w� 6 b b W rn o, `o ig ' ty . V o ' t b � � a W ig a o ' t W p ago vi AA. ® 0 -a O N �� laq 4 CO N Ca ax a oc� ;5 0 N O N rn 'b •H cd o. tay O. O ff.. a �j ye a v_ o M O A 0 O •ice+ b M ' o 00 ' a, 0, .0 U m �1. CXI 0 '-+ CV o A N O 'n P4 a •� M S r -0,0 U +U' cn O U � -- rP4 •� o a� C;3: U -d ,., Q, a . as o r c� o cl .� 6 v U W p ago •� U W 1-+ m O � � w � �"� o. 04u 0 A� O .A yO Gi H p•+ H o 0 �t -a O �� laq 4 ax a oc� ;5 0 N rn 'b •H cd o. tay O. O ff.. (1) 1 c �j ye a v_ o-*0 a � 0 1 4: 0. q -, U a 0 bA b a ' a, 0, .0 , P4 a a�., Z �1. CXI '-+ CV -+ N N O 'n P4 a •� M S r -0,0 +U' cn U 'N .fl 'E •� . C;3: U -d ,., Q, a . r���o ci -+S o boo Cj W <C w o v cn 17 -a O cn L w �/ F•r•�I o A �. U c A A 4 h � � � O ,° .� I A ° � U Z .E ' N � �i � O �+ ° Q _� o • Z .o ° A, � Cd 04) . baU .o.�,. N In _ v .. p 0 0) 42 5,. ¢„ cd clx� c�Za?.. p 0 o C4 ' aQi ;j {-+ C� �-; n • N � c*i . r-� n —4 N` rr m 0 bo .fl rn CIS •° 4 Q °') 40' It �, W In 0 . '2 N l 0 W � �•5 18 01 _� o 19 a _ o c� 0 o . O d to U _ N N Cd U C� � i�r w � y iq O.. Fil 20 . 1 0 � i�r w � y iq O.. Fil 0 • A N O z N . cd 0 O b ¢. o '45 cl w U pq bA .. .� � s� a� Cd 14 on ,.� 'd P, (y M v' o bA .O � O . -O 'a 0 rl AW� �" a a O aW0�i bn ° V p; 0 o Q'� �. o a � Cd too o •d 4-, �, .�, ia,oa 4., cd' °14 o: a� .. M m W 'b W V1 CC O CM W N 0 21 _ o 22 U N N rn o � U ° U R U y t° a� ° p, o �.� a�• Cl o cl 4 i� 41 d) � ° ti o ; a 8 �' r 9 a� �°. a po m �. a tea.' rn•o. c '0 o o q N O �o. .° U w r/l •� .� ,� a 'd � b 3 0 4.4 . a. o o O U, 0 0 z (D o El m �U .. Q 78 0 O .�� o �. a� 01 O w O N - O D1 N rD O � fl o 0 o a o A. 4. ON Q' � V2 o U �-� en W . ° Q � o El El u clj °'. Q Q b N U ° a 0 O S Z U . N a� ° Cd OV .�, °�� U� bo 4 8b in ° . : O .p 0 ' N o U � �= H U i= cd fl ci 23 _� o 24 b O b !ll rte.., Q � .. .. • Q N N . b O � ' ° N a� P� o Fzi o 25 Y2K- Public Safety Committee Update As of September 30, 1999 Departments who have worked together as the Y2K- Public Safety committee include: • Emergency Management (including Fire Service and volunteer Emergency Medical and Rescue Services) • Sheriff's Department • Public Works • County Engineer • Purchasing and Central Services Department With the exception of the records management system in the Sheriff's .Department (Visions system),Y2K compatibility assessments had been completed by June 30, 1999 for mission critical functions carried out by these departments. Equipment supporting mission critical functions is listed on the attached inventory. You will note that the Visions system was to have been upgraded by 9/1/99., This work has.. been, comp.leted.; and the system in now in full compliance: Each department continues to finalize the contingency plans that will be implemented if any component of the emergency service delivery system'fails. Contingency plans may be categorized.in_two broad areas: • Those situations which may affect the public in general;. • Those situations that may affect the operation of the individual. department. In a "normal emergency ", such as a natural disaster, the County routinely operates under the Multi- Hazard Plan as drafted by the Emergency Management Department several years ago. The plan outlines how service providers will respond in addressing emergencies that affect the public, such as setting up shelters, assisting with debris removal, giving advise on protecting livestock, etc. This plan has been reviewed and detail added to departmental duties to ensure a clear understanding of what is to be done by each service provider. The plan covers County Departments who may have a role in service delivery during an emergency event and also to outside service providers, such as Red Cross .and the school systems. In addition to the countywide issues that. are addressed.by the multi- hazard plan, each department is tasked with presenting a departmental contingency plan. The departmental contingency plan will outline how essential services will be provided in the event of failure of a critical support component. For example, it is critical that County vehicles be able to obtain fuel during emergencies, thereby necessitating a contingency plan if power fails. To answer that potential problem,'the fueling station is backed up by a generator. A systematic check of all generators serving various County buildings is made to ensure that they.are kept in peek running order and that the maximum amount of fuel is available in the event it is needed. However, in the event of generator failure, a manual dispensing option is available for the fuel system. Each Y2K- Public.Safety. . department is. looking at essential services to that degree of detail. The Y2K- Public Safety committee will continue to meet until the ultimate Y2K test is completed on December 31, 1999. However, at this time, we feel confident that our 27 _a c c m ca o.•Q E U ppE U rh+ C N C a) C a) Q, E E . N N to V) N U) N to U) V) V) W V) V) tq N to O tq tb to w N to (WD U) fq W U) U rrr = =r r � }rrrrmrr rrrrrrrrr a) U C a) Q U C N E > a) a1 o to O C N �.0 C a) 17 O O O a) aoiC aEi Q tm c.- m c ° 3 °o. � to No26 o f wv o ornWZ o o c v, `� c': .o U co U `ma:a;,a3 U a)a) a) UNEO°N `oo w to m c. 0 aD) of — c ca 3 3 E o c c ate' .� in E. N : mNEEEs'� iii i)i vi w = 'tp c a) E w .�: .� aN.. N >+ ��., ��Q (L O O N tnrnNNO V Y.'' U U C >+ O C �>, N L d rN) U +�.. O U - d C a) . co co N tN0 N O. N C C U j `«� o O 2 O >+ O Y c N Q� N � N N r C C to U `- N N >� >, W >. U). >, N_ - S N C � N a) T rr W O ° a) C U U a) a) —C>L ,.5. co O- to Co a) CL U U U a) p` °-' w E O 4 C- aNi °: m ro°_' mma�i'cc- a� ..0 "m co 'm 'm'ro�mmmca�mma m E `�° }o odm C� U i- -� �m�om -� -� -� -� �. -� -a. -� -� -� x w w U i.l_ a C9 ,j h .s+ C td Q E O to () N a) to a) N a) to () m ar N (D N a) N a) V) (D N a) to a) N a) (n a) (n N U) N N N N a) N N N a) U) a) N N U) (D N a) N a) N a) N a) N Q) N () N () N a) N a) to N N O U rr rrr.rrrrrrrrrrrrrrrrrrrrr rrrrrrrr Q. fOq a) N C N m C CD N 0 U CU O (n O N E a) a) of N C N '- of a) 'a' m a) m t O E a) 0 0- a) C O d a) U (6 O d N U L) 'O C 0 a) U Co n A— O ` N > N Q• E CL u) 0 E D in a) . v 0 N CY N Q ''C •a' U OJ�� O N W 0 .r• 0 -�H� a) O III N N Q �a O O E V c o ' od_o o C m c No EU� Co N w= — E n N .2 0 N O�O 0 a) U 'S�'EW E o o 0 o C a) c a) o N r- c c c o ZD�N ° is m w @ V o o-a N c oU N 0) E E E o —€ to o c O o E o E °=<t X EQQMUpLLLI. cUOW CD W O a) c a) •-� O O " O ro CC c 0 - O EJ U! UUUd -II�M� V 1�0 O C O O a o E O N C C O C O O W A>+¢ NX Oc�(nCnONNCO O �dO.NNr V 00� -(/J U CU ` G �. d_N (1�J11�iM U N � a D x N O. •� ODU U 'a..O AO U) = N --• N ;b N 9 a) (%� (%� E) S` . `p +-• :/� =� N v — N VO'u)titir `2 �' -r- E O a), C _"Jn C >, n T co i_ >, U) U V C o m (A tSf (-6 N 0 a) 0- d- co-i O) -i LdtY]Ln W f�CUCOCOC�00M(tOjN1s� +�� U — O�� N N U O � N N C L 0 d�- ii. IL,a- o) rnrnrn� -� iii ii t0 C9 tII C7C7> a) t� _a 28 Embedded Chips The effort to identify embedded chip issues in equipment or applications that are not related to information systems equipment and software has led staff to conclude that there are no insurmountable or even serious problems related to embedded chips. To date we have identified . only one problem that cannot be resolved by either software reprogramming/replacement or by minor equipment replacement. That problem is with the computerized HVAC control system for the Central Government Services Building; which would require the replacement of $50,000 to $75,000 worth of hardware (thermostats, controllers) and software to make the system Y2K compatible. Rather than replacing this system, staff has determined that the date on the program controlling the system can be set back to some point between 1900 and 2000, and the system will continue to function without problem. Continuing staff effort related to embedded chip issues are now focused on due diligence issues: That is,' staff is in the process of ensuring that we have in hand any and all documents that: a) list all equipment containing embedded chips; b) certify that each piece of equipment containing chips is either y2k compatible orlas no y2k issue (no time /date function); c) denote the availability of a y2k software repair /patch and certify that such repairs have. been effected, d) outline reproducible y2k compatibility testing procedures. and actual test results for each piece of equipment where testing can be used: This process is approximately 98 Dercent complete, with most of the y2k certifications having been downloaded from the internet sites of equipment manufacturers. It is anticipated that all such documents will be in hand and available in a well organized report format by the first of November.