The history of VST changes by versions - Forum - OpenEdge General - Progress Community

The history of VST changes by versions

 Forum

The history of VST changes by versions

  • he history of VST changes based on the changes of their CRCs between Progress versions:

    Number  VST \ CRC by vers 10.2B08  11.0    11.1    11.2    11.3.2  11.4    11.5    11.6.4  11.7.5  12.0    12.1
    ------  -----------------  -----   -----   -----   -----   -----   -----   -----   -----   -----   -----   -----
    -16385  _Connect           40449 * 36183   36183   36183   36183   36183   36183 * 16764 * 15681 * 34063 * 54957
    -16386  _MstrBlk           47220   47220   47220   47220   47220   47220   47220   47220   47220   47220   47220
    -16387  _DbStatus          46526   46526   46526   46526 * 13835   13835   13835   13835 * 34160 * 36876 *   968
    -16388  _BuffStatus        11447 * 13779 * 15795   15795   15795   15795   15795   15795   15795   15795   15795
    -16389  _Logging           23227   23227   23227   23227   23227   23227   23227   23227 * 10256   10256   10256
    -16390  _Segments           2951 * 46609   46609   46609   46609   46609   46609   46609   46609   46609   46609
    -16391  _Servers           56747   56747   56747   56747   56747   56747 * 51995   51995   51995   51995   51995
    -16392  _Startup           51801   51801 * 58066   58066   58066   58066   58066   58066   58066
    -16392  _UserLobStat                                                                                6003    6003
    -16393  _Filelist          25916   25916   25916   25916   25916   25916   25916   25916   25916   25916   25916
    -16394  _UserLock          52463 * 19567   19567   19567   19567   19567   19567 * 42924 * 60651   60651   60651
    -16395  _ActSummary        23657   23657   23657   23657   23657   23657   23657   23657   23657   23657   23657
    -16396  _ActServer         13520   13520   13520   13520   13520   13520   13520   13520   13520   13520   13520
    -16397  _ActBuffer         32386 * 20532   20532   20532   20532   20532   20532   20532 * 60509   60509   60509
    -16398  _ActPWs            10498   10498   10498   10498   10498   10498   10498   10498   10498   10498   10498
    -16399  _ActBILog           8913 * 27931   27931   27931   27931   27931   27931   27931   27931   27931   27931
    -16400  _ActAILog           7405    7405    7405    7405    7405    7405    7405    7405    7405    7405    7405
    -16401  _ActLock           20844   20844   20844   20844   20844   20844   20844   20844   20844   20844   20844
    -16402  _ActIOType          3987    3987    3987    3987    3987    3987    3987    3987    3987    3987    3987
    -16403  _ActIOFile         11098   11098   11098   11098   11098   11098   11098   11098   11098   11098   11098
    -16404  _ActSpace          24194   24194   24194   24194   24194   24194   24194   24194   24194   24194   24194
    -16405  _ActIndex          43500 * 35379   35379   35379   35379   35379   35379   35379   35379   35379   35379
    -16406  _ActRecord         33721   33721   33721   33721   33721   33721   33721   33721   33721   33721   33721
    -16407  _ActOther          17012 * 42368   42368   42368   42368   42368   42368   42368   42368   42368   42368
    -16408  _Block             63587   63587   63587   63587   63587   63587   63587   63587   63587   63587   63587
    -16409  _UserIO            58166 * 15442   15442   15442   15442   15442   15442   15442 * 24990   24990   24990
    -16410  _LockReq           57390 * 28054   28054   28054   28054   28054   28054   28054   28054   28054   28054
    -16411  _Checkpoint        21138 *  5330    5330    5330    5330    5330    5330 * 36319 * 52042   52042   52042
    -16412  _Lock              54597 * 47610   47610   47610   47610 * 47896   47896   47896   47896   47896   47896
    -16413  _Trans              4065 * 39797   39797   39797   39797   39797   39797   39797 * 24762   24762   24762
    -16414  _License            9679    9679    9679    9679    9679    9679    9679    9679    9679    9679    9679
    -16415  _TableStat         28340 * 55300   55300   55300   55300   55300   55300   55300   55300   55300   55300
    -16416  _IndexStat         49021 * 20756   20756   20756   20756   20756   20756   20756   20756   20756   20756
    -16417  _Latch             23412 *  6476    6476    6476    6476 * 54477   54477   54477   54477   54477   54477
    -16418  _Resrc             50740   50740   50740   50740   50740   50740   50740   50740   50740   50740   50740
    -16419  _TxeLock           12333   12333   12333   12333   12333   12333   12333   12333   12333   12333   12333
    -16420  _StatBase          47037   47037   47037   47037   47037   47037   47037   47037 * 18194
    -16420  _LobStat                                                                                   42943   42943
    -16421  _UserStatus        42743 * 57433   57433   57433   57433   57433   57433   57433   57433   57433   57433
    -16422  _MyConnection      24771 * 38909   38909   38909   38909   38909   38909   38909 * 39096 * 42836   42836
    -16423  _AreaStatus         7288    7288    7288    7288    7288    7288    7288    7288 * 16089   16089   16089
    -16424  _Repl-Server       28937   28937   28937   28937   28937   28937   28937 * 25934 * 54170 * 58520 *  2108
    -16425  _Repl-AgentControl 25979   25979   25979   25979   25979   25979   25979 * 37733   37733   37733   37733
    -16426  _Repl-Agent        55398   55398   55398   55398   55398   55398   55398 * 59975 * 30065 * 63773   63773
    -16427  _Database-Feature  47668   47668   47668   47668   47668   47668   47668   47668   47668   47668   47668
    -16428  _Code-Feature       4035    4035    4035    4035    4035    4035    4035    4035    4035    4035    4035
    -16429  _AreaThreshold     22611   22611   22611   22611   22611   22611   22611   22611   22611   22611   22611
    -16430  _UserTableStat      5791 * 54692   54692   54692   54692   54692   54692   54692   54692   54692   54692
    -16431  _UserIndexStat     35633 * 15879   15879   15879   15879   15879   15879   15879   15879   15879   15879
    -16432  _DbParams                                                          57152   57152   57152   57152   57152
    -16433  _Repl-AgentControlActivity                                                 11534 * 12465   12465   12465
    -16434  _Repl-AgentActivity                                                         4114    4114 * 59930   59930
    -16435  _DbServiceManager                                                          16067   16067   16067   16067
    -16436  _DbServiceManagerObjects                                                   30742   30742   30742   30742
    -16437  _Cache                                                                             58929   58929   58929
    -16438  _Repl-InterAgentActivity                                                            4290    4290    4290
    -16439  _Repl-AgentAIStreaming                                                                     39066   39066
    
    

    Star ("*") marks the changes between the versions.

    By the way, _File._Last-Change returns 463860476 that means "Sep 12, 1984 18:07:56" for all VST tables regardless from their versions. 1984 is the year of the first Progress commercial release (V2) but VSTs were originally added in V8.2 (Apr 28, 1997). Is it some secret date inside Progress like Chip Ziering's birthday?

    Update:

    Attached file contains the history of the VST changes on the field level.

    History_of_VST_Changes.2019.12.08.txt

    VstVersion.p reports the version of VST set in DICTDB database – a first Progress version that can create a database with the same set of VST tables.

    VstVersion.p

    The next file contains the history of the metaschema changes:

    7888.History_of_Schema_Table_Changes.2019.12.16.xlsx

    Metaschema tables:

    Metaschema_Tables.2019.12.18.txt

    Metadata, Engine Crew Monograph Number 17

    Gus Bjorklund - Metadata.pdf

  • George Potemkin
    By the way, _File._Last-Change returns 463860476 that means "Sep 12, 1984 18:07:56" for all VST tables regardless from their versions. 1984 is the year of the first Progress commercial release (V2) but VSTs were originally added in V8.2 (Apr 28, 1997). Is it some secret date inside Progress like Chip Ziering's birthday?

    The comment on that value says "date/time of last schema change set in empty database by the scdbg utility. it is 9/12/84 2PM." The date was chosen in 1991 or earlier, but the source control system doesn't go back far enough to determine exactly when it came into existence.

    My guess is that the developer needed a value so they spit out the current time and used it.

  • I confirmed it is a birthday via Wikipedia.  Any guesses by someone outside of Progress?
     
    Dave
     
  • All system tables has the same _Last-Change except for:
    _Db
    _File
    _Field
    _Index
    _Index-Field
    Their _Last-Change is 617740379 or 07/29/1989 18:32:59
    Another birthday?

    FUNCTION Timestamp RETURN DATETIME(ipTimestamp AS INTEGER):
      RETURN ADD-INTERVAL(DATETIME(1, 1, 1970, 0, 0, 0, 0), ipTimestamp, "seconds":U).
    END FUNCTION. /* Timestamp */
    
    FOR EACH _File NO-LOCK
       WHERE _File-Number LT 0
         AND _Last-Change NE 463860476:
         DISPLAY _File-Name _Last-Change Timestamp(_Last-Change).
    END.

    Update: the files above (except _Db) exist in all versions of Progress. _Db was added in V5 or V6 (from Dan Foreman's "Progress System Tables" PPT).

  • My guess: Sep 12, 1984 - on this date in 1984 Michael Jordan signed his first NBA contract with the Chicago Bulls.

  • George Potemkin

    All system tables has the same _Last-Change except for:
    _Db
    _File
    _Field
    _Index
    _Index-Field
    Their _Last-Change is 617740379 or 07/29/1989 18:32:59
    Another birthday?

    That one is called VERS6DATE in the code. V6 was released in 1989. The comment says "date/time of last schema change set in vers6 database by scdbg uitilty. it is 7/31/89, and only for _file _db _index _field _index-f".

  • Nope. There is a very strong connection to Progress. 1984 is not the year of birth. It may have meaning, but could also be a coincidence.
     
    Dave
     
  • Very ancient kbase # 13191: How to determine the version compatibility of your database

         version 11      PROGRESS 2.1
         version 12      PROGRESS 2.2 and 2.3
         version 13      PROGRESS 2.4
         version 30      PROGRESS 3.0
         version 31      PROGRESS 3.0 after 12/18/85
         version 32      PROGRESS 3.0 after 12/19/85
         version 40      PROGRESS 4.0 after 1/7/87
         version 41      PROGRESS 4.0 after 1/19/87
         version 42      PROGRESS 4.0 after 2/28/87 (after-image)
         version 50      Reserved for PROGRESS with foreign dbs
         version 51      PROGRESS with foreign dbs after 1/13/88
         version 60      Resrved for PRGRS with foreign dbs & SQL
         version 61      PROGRESS Release 5.0 and 6.0 from 4/12/88
         version 62      PROGRESS Release 6.0 after 8/01/89
         version 63      PROGRESS Release 6.0A after 8/14/89
         version 64      PROGRESS Release 6.3A1B after 10/31/91

    KB-P25408: The History of Progress Software Corporation

    1981 – Progress Software Corporation was founded.
    1983 – Though still not commercially available, RDL was ready to be shown at COMDEX.
    1984 – Renamed Progress Version 2, this was the first commercial release.
    1985 - Version 3
    1987 - Version 4
    1988 - Version 5
    1990 - Version 6
    1991 – Version 6.3
    1993 – Version 7
    1995 - Version 8
    1998 - Version 9.0

    No matching dates

  • That would be fairly close to the date when I first used Progress.  I discovered it at the 1984 COMDEX and did an eval that fall.

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • BTW, 1989 seems to be a birthday of Progress Knowledgebase.

    For example:

    ALL BTOS VERSIONS-local bi(lbi) causes disk fragmentation

    Written by SLK 01/13/89

  • Ghostly big brother looking for everyone, or just a simple bug bug, that shows no content on Great Gus post?

  • I attached the file (in the first post) with the history of the VST changes on the field level. It does not replace the documentation or Dan Foreman's VST Guide. Field descriptions in the file are just the field labels.

    By the way:

    1. Are there any plan to add new VST (or to extend the _Latch VST) that would report the same information as promon/19. BHT Latch Stats?

    2. The _ActRecord table does not have the *-PartitionId field like in _ActIndex or in other correspondent VSTs. Is it a defect?

  • 1. Can't answer that officially but I know of no current effort to add that.  Maybe an enhancement request is in order.

    2. I don't know what the partition id in the _actindex refers to.  I think that is the bug.

  • 1. Can't answer that officially but I know of no current effort to add that.  Maybe an enhancement request is in order.

    2. I don't know what the partition id in the _actindex refers to.  I think that is the bug.