Most users connect using 4GL clients. And we have some programs that connect using SQL (that we want to be highly available with no downtime). But, occasionally we want to prevent typical users from connecting thru 4GL. (but, everytime we stop that broker, it also kills SQL connections).
I...
We have two server groups:
[configuration.prod.defaultconfiguration]
database=prod
displayname=defaultConfiguration
servergroups=prod.defaultconfiguration.prodsql, prod.defaultconfiguration.prod4gl]
So, you are saying that we can't stop/start 4GL without affecting the SQL?
In Progress Explorer, we have a database 'PROD' with 2 connections (1 for 4GL and 1 for SQL).
What would the command-line command be to stop the 4GL service only (leave SQL running)?
call dbman -stop -db prod (closes both 4GL and SQL)
Ok so would it be something like this:
proserve dbname -S prod4GL -H myhost -Mn 10 -Mpb 4 -ServerType 4GL
proserve dbname -S prodSQL -H myhost -Mpb 4 -m3 -ServerType SQL
And then to shut down 4GL:
proshut dbname -S prod4GL -H myhost -by
1) This seem correct?
2) And SQL will still be running...
I have a question regarding progress database using 4GL and SQL connections.
-We are wanting to have a progress database running that allows 4GL and SQL connections.
-Occasionally, we want to stop the service listening for 4GL connections (to kick off and prevent users that use a GUI that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.