I always:
DISCONNECT
SET MULTI OFF
CONNECT {dbname}
If there are NO errors (if I CAN connect) then we are good to go with a backup.
Also, I stop any web services connecting through Oterro – this seems to have a
persistent connection, as well.
Steve
From: 'Karen Tellef' via RBASE-L <[email protected]>
Sent: Tuesday, April 2, 2024 2:23 PM
To: 'jim schmitt' via RBASE-L <[email protected]>
Subject: Re: [RBASE-L] - CVAL CONNECTIONS
What I've noticed (within my non-network-understanding limits) is that the
connections don't necessarily decrease when they exit RBase, but rather when
they log out of the network. It seems the network thinks they have RBase
connections still open, but not RBase itself.
Karen
On Tuesday, April 2, 2024 at 04:10:45 PM CDT, 'jim schmitt' via RBASE-L
<[email protected]<mailto:[email protected]>> wrote:
Hello, group:
i am using cval('connections') in a backup routine to test and insure that all
users are out of the system before starting the backup.
Some of my users appear to have more connections than they have computers.
One user who has 1 three user network had 26 connections. Does the connections
get reduced as each user exits ?
Just wondering what most of you are using to insure that all users are out of
the database before performing a backup.
Any enlightenment would be helpful.
Thanks, jim
1-614-361-3942
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
[email protected]<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
[email protected]<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1711672630.3821035.1712092984286%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/1711672630.3821035.1712092984286%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BYAPR03MB3718B1CDC371051562846AC3893E2%40BYAPR03MB3718.namprd03.prod.outlook.com.
