[Progress Communities] [Progress OpenEdge ABL] Ability to query database and object sizes using VSTs or other similar mechanism

  • Thread starter Thread starter kirchner
  • Start date Start date
Status
Not open for further replies.
K

kirchner

Guest
We want to be able to query database size and individual object sizes. The prefered mechanism would be VSTs but something similar would be OK. It should be queryable remotely by ABL and SQL. This feature has a lot of applications, but right now our main driver is our licensing team which wants to offer customers a license model based on data volume, ignoring indexes and LOBs. The other products in the company working with Oracle, SQL Server, Informix, DB2, etc, were able to implement this quite easily. For the products that work with Progress OpenEdge it was decided we would charge the customer for the full database size obtained through _DbStatus. It's not ideal but no practical solutions were found. Just as a concrete example of what this idea is about, in Oracle we have DBA_SEGMENTS and USER_SEGMENTS, and in SQL Server sys.partitions and sys.allocation_units.

Continue reading...
 
Status
Not open for further replies.
Back
Top