Kbase 15340: What are the differences among Personal, WorkGroup and Enterprise database server licences?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/5/2011 |
|
Status: Verified
GOAL:
What are the differences among Personal, Workgroup and Enterprise database server licenses?
GOAL:
What are the differences between the three database products?
GOAL:
What are the differences between the Progress Workgroup Database Server license and the Enterprise Database Server license?
GOAL:
Is an Enterprise License different than the Workgroup License?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The difference between each database product are the available features, the physical structure of the database remains the same. The Personal Database is a subset of the Workgroup Database, and the Workgroup Database is a subset of the Enterprise database.
Personal Database Server:
1. Up to 5 local connections can be made to the database. Only connections from localhost are accepted, no remote users can connect.
2. Prior to Version 9, a Personal Database cannot be started in multi-user mode for use with remote 4GL connections even if -H is set to localhost. From Version 9 onward, it is possible to start the database in multi-user mode and to specify -S and -H localhost to allow 4GL and SQL92 client/server connections from localhost only. This was enabled predominantly due to the need to allow SQL92 connections on a standalone machine.
3. The variable database blocksize feature of Progress Versions 8.2x and 8.3x can be used as a single-volume database with any database product. i.e. You can use the pre-created variable-blocksize single-volume empty databases within the Progress installation directory (empty1, empty2.db, empty4.db, empty8.db).
4. You cannot create a multi-user database using the variable database blocksize feature with a Personal Database license.
Workgroup Database Server (Personal Database + features below):
1. Up to 49 users, with a total of 66 connected processes can be made to the database. The database will accept both local and remote connections.
2. 2-phase-commit is supported in the Workgroup Server product despite some early documentation that indicates otherwise.
3. You cannot create a multi-user database using the variable database blocksize feature with a Workgroup Database license.
4. OpenEdge 10.1B Replication for Workgroup
Enterprise Database Server (Workgroup Database + features below):
1. Up to 10,000 connections can be made to the database. The database will accept both local and remote connections.
2. The variable database blocksize feature is supported for multi-volume databases.
3. Performance related asynchronous I/O processes are available. APW, BIW, AIW.
4. Performance related parameters are available. -spin, -pwscan, -pwwmax, -semsets.
5. The PROQUIET utility to enable and disable quiet points is available.
6. Largefile support, which enables database files to be larger than 2GB, is available beginning with Progress 9.1C.
7. Failover clusters w/ Progress 9.1E and OpenEdge 10.0B and higher.
8. Threaded utilities availble OpenEdge 10.0A and higher. -thread -threadnum