[Ncep.list.ms3info] RFC 5693 - Routine Maintenance on TG databases wde_prd in DBS1, DBS2, DBHIST at BLDR - START

[Chi-Thuan Truong - NOAA Federal]

" WHAT the change is: Standard 6 month keep healthy RFC. Need to do routine
maintenance on system table syslogs and all dynamic users' tables for
checking, fixing potential corruptions in the tables, or partitions and the
indexes. This change requires the coordination of SA, MQ, and application
developers.. - WHY this change is being made: Prevent future and potential
issues for tables and databases at DBS1, DBS2 and DBHIST at BLDR. - WHO the
intended users are: onboarding team, dataflow team, data management team
and Sybase utility users. - WHERE the changes are being made: DBS1, DBS2
and DBHIST at BLDR and CP. - IMPACT of the change: Sybase at BLDR is now
acting as the inactive site as all major applications are now active at
CPRK. There should be only 20 minutes outage when failing back from DBS2 to
DBS1 as brokers and all apps need to stop their connections to the database
servers. BB will flag red/purple on the latency and connections at DBS1,
DBS2, DBHIST, and flag red on DSI at DBREP2 during the maintenance period.
- HELPDESK TICKET NUMBER (if applicable): N/A - ROOT CAUSE ( if this change
is for a bug fix): N/A - RELEASE NOTES (only if available - please provide
link): N/A. bldr 5/13 - 5/14. Failover 5/15. CP 5/16 - 5/17."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://www.lstsrv.ncep.noaa.gov/pipermail/ncep.list.ms3info/attachments/20190513/4c10e932/attachment.html