Project

General

Profile

Support #16693

Many MOOC front-ends have no backup keeper

Added by Dennis Nicklaus over 2 years ago. Updated over 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Dennis Nicklaus
Category:
-
Start date:
05/26/2017
Due date:
% Done:

0%

Estimated time:
Duration:

Description

These are the Operational MOOC front-ends without a backup keeper assigned

select name, keeper_cuid from appdb.johnson.acnet_node_info where bkeeper_cuid=999994 and status_id=1 and software_id=7
2> go
 name   keeper_cuid 
 ------ ----------- 
 APAB10        1009 
 APAB20        1009 
 APAB30        1009 
 APAB40        1009 
 APAB50        1009 
 APAB60        1009 
 BAPS           252 
 BLLRF1          45 
 BLLRF2          45 
 CUB01           45 
 HINSGP          45 
 HNSPLC         129 
 IBPMAL          45 
 MBPM10          45 
 MBPM12          45 
 MCHRM1          45 
 MCR01           45 
 MCR02           45 
 MCR03           45 
 MFBI            45 
 MI14            45 
 MI39            45 
 MI65B           45 
 MS4             45 
 NBPB65          45 
 NMLA            45 
 NMLB            45 
 NMLGP1          45 
 NMLGP2          45 
 NMLGP3         129 
 NMLLD1          45 
 NMLLEC          45 
 NMLTOR        1047 
 PBEAM         1047 
 PXINT         1047 
 RAMPMT         573 
 RDLOSS          45 
 RTPM10        1047 
 RTPM20        1047 
 RTPM30        1047 
 RTPM40        1047 
 RTPM50        1047 
 RTPM60        1047 
 SBPMF1        1047 
 SBPMF3        1047 
 SRFMPS         573 
 STATE           45 
 STATEA          45 
 UCDA            45 
 UCDB            45 
 UCDHIN          45 
 UCDNML          45 
 UPMA30        1047 
 UPMF23        1047 
 UPMF27        1047 
(55 rows affected)

Just for completeness sake, below are the operational, non-MOOC front-ends with no backup keeper assigned :
It seems to be pretty standard practice that there is no backup for Java OACs.

1> select name, keeper_cuid from appdb.johnson.acnet_node_info where bkeeper_cuid=999994 and status_id=1 and software_id!=7
2> go
 name   keeper_cuid 
 ------ ----------- 
 ACLDEV         570 
 ALARMZ         761 
 AP2BPM         679 
 BACKUP         761 
 BATCH          679 
 BCCDB          820 
 BIGSAV         761 
 BOOLOS         285 
 BUNNY0         840 
 BUNNY1         840 
 BUNNY2         840 
 BUNNY3         840 
 BUNNY4         840 
 BUNNY5         840 
 BUNNY6         840 
 CONSAD         679 
 CONSAR         679 
 CRYOPC         739 
 DAMPE2         679 
 DAMPE3         679 
 DAMPE5         679 
 DBNEWS         573 
 DCE10          679 
 DCE11          741 
 DCE13          679 
 DCE26          761 
 DCE27          820 
 DCE34          761 
 DCE35          761 
 DCE36          679 
 DCE37          679 
 DPE09          739 
 ESTATS         761 
 EVENTH         761 
 EVENTN         761 
 EXPOPC         739 
 FGATE          573 
 HALORT         679 
 HEARTB         761 
 LEVELS         840 
 LINBPM         293 
 LJALRM         761 
 LJOAC          761 
 LRHVAC         129 
 MACALC         679 
 MAGLEV         679 
 MCOPC          739 
 MIBBIM         679 
 MIBLMS        1172 
 MIEFFS        1172 
 MIRROR         761 
 MISWIC         820 
 MITUNE        1172 
 MIWIRS        1172 
 MJRROR         761 
 MONITR         761 
 MTNRNG         820 
 NDOSPS         739 
 NMLBBM         815 
 NMLOPC         739 
 NOVAPS         739 
 NUM101         820 
 NUM118         820 
 NUM121         820 
 OPCOAC         739 
 PIDLUP         679 
 RACKMN        1172 
 REMOTE         761 
 SBDMI         1078 
 SERBAL         739 
 SNAP           761 
 STATES         190 
 TIMEAV         679 
 VACAVE         679 

(74 rows affected)
3>

History

#1 Updated by Richard Neswold over 2 years ago

  • Description updated (diff)

Used the "preformatted" mark-up so it's easier to read the SQL output.

Also available in: Atom PDF