BUt if you really want to monitor you nodes.
Well UVMS not fit to do this
BUT but but.... here a pleasant way to do this:
Launch the unilst NODE to have your list of your DUAS 6
<uvmsbindir>/unilst NODE -type DU6 -csv
Then, if you have an UVMS, it also be important/elegant to have a Management DUAS close to UVMS (use for reporterClient, package cleanup mngt, Maintenance session for the UVMS, etc ...)
Then you can launch the ./uxlst fnc node=<OneNode>
This can be easily implemented into your storeProc
(don't forget to add the user that execute the command into the userpattern)
That's it ?
Eric
------------------------------
Main director
SynApps
------------------------------
Original Message:
Sent: 12-03-2020 04:37 PM
From: Eric Delawoevre
Subject: Trying to find $U Node status in SQL database
Ok Great,
So some points:
* If you are cluster DUAS, don't forget to upgrade both DUAS parts
* If you have SQLServer, you can check on Console/administration/UVMS left panel the Request of the Host table
* Note that the status is quite différent. The heartbeat is sent by the DUAS on v6 (push). Not sure that the UVMS do as for the v5 DUAS (pull)
* When you right click/Engines... what is the automates list result ?
UVMS on 4 clutered nodes: so 4 UVMS (actif/passif) on 1 SQLS alias ?
Also, what was the previous version of your UVMS (before upgrading 6.10.21) ?
Because arround 6.2, UVMS Cluster mode become innoperate and you need to switch all the UVMS to a switch multipart UVMS
(so unidtl FROMCLUSTER command etc... let you check this into the admin documentation)
------------------------------
Main director
SynApps
Original Message:
Sent: 12-03-2020 11:05 AM
From: Charlie Barr
Subject: Trying to find $U Node status in SQL database
We are running Dollar Universe 6.10.21
UVMS - 6.10.21 - 4 node Windows 2016 Cluster with a 4 node Windows 2016 / MSSQL 2017 AWO cluster (NO DERBY DB ON UVMS)
UVC - 6.10.21 connected to the UVMS Active Cluster member - The UVC shows the connection status of our 73 DUAS agents
73 DUAS agents (mostly 6.10.21 with the exception of 3 agents running 6.3.21)
So, the UVC has to be getting the connection status of the DUAS from somewhere. I assumed it comes from the SQL DB used by the UVMS. What I'm trying to do is find a way to report when a DUAS has disconnected from the UVMS. The easiest way I can see to do this is to run a SQL Agent job to query DUAS connection status. But...I do not know where to look for the DUAS connection status in the database.
Upcoming OOO - 12/7/2020 - 12/17/2020
12/28/2020 - 12/31/2020
Original Message:
Sent: 12/3/2020 10:45:00 AM
From: Synapps_Partner
Subject: RE: Trying to find $U Node status in SQL database
Ok Just understand the Point.
The SQL DB is the Univiewer Management Server externat DB Right ? not a $U SQLServer Manager
But the $U 6.10.21 is what ? UVMS? Console? or DUAS?
To check the connection beetween DUAS and UVMS , you can try the unims
To be sure about registering "things" into the UVMS DB, you can unregister then register back the DUAS node (commande unims -unregister or remove the node into the console) (unims -register to add it)
Beware of the previous version, Perhaps a need to update the UVMS DB structure
All the Best
Eric
------------------------------
Main director
SynApps
Original Message:
Sent: 12-02-2020 09:30 PM
From: Charlie Barr
Subject: Trying to find $U Node status in SQL database
It's not so much a matter of it "still" happening. The issue is that I do not know where to look in the SQL DB to find the information I need.
Upcoming OOO - 12/7/2020 - 12/17/2020
12/28/2020 - 12/31/2020
Original Message:
Sent: 12/2/2020 6:20:00 PM
From: Synapps_Partner
Subject: RE: Trying to find $U Node status in SQL database
Hi,
Sorry for the late.
Is it still happening ?
Regards
------------------------------
Main director
SynApps
Original Message:
Sent: 09-10-2020 10:53 AM
From: Charlie Barr
Subject: Trying to find $U Node status in SQL database
We have upgraded our $U 6.10.21 install to use an external SQL server database. The connected Node status is displayed in the UVC. I'm trying to create a job in SQL that will alert me when the connected node status is NOT "Connected". The problem I'm having is finding the table/column where that status is stored in the database. I'm positive it has to be in there somewhere. Does anyone know where I need to look?