While VST's should be updated between Minor releases with PROUTIL -C UPDATEVST, running updatevst is generally not necessary when upgrading a major version as the VST are updated as part the upgrade process, e.g. if using conv1112.
VST's are never '
re-named', they are enhanced and with a Major version change, VST's that remain purely for backward compatibility are removed.
In the event of issues in which VST may be implicated, PROUTIL -C UPDATEVST should be run as an initial step.
OpenEdge 12.0 dropped 2 VST Tables:In OpenEdge 12.0, the
_DbParams VST replaces the
_Startup and
_Statbase VST tables from previous versions and have been removed.
- Any application code that makes use of these _Startup or _Statbase VST tables, will need to be re-written to use the _DbParams VST instead.
- The _DbParams VST has been available since OpenEdge 11.5 to support startup parameters that can be modified at runtime with VST code. Refer to Article:
OpenEdge 12.0 introduces 3 new VST tables:
- _LobStat
- _UserLobStat
- _Repl-AgentAIStreaming
OpenEdge 12.0 introduces new fields to existing VST's:
_Connect._Connect-ServerPid [integer]
_Connect._Connect-ServerTid [integer]
_Connect._Connect-Tid [integer]
_DbStatus._DbStatus-lastLgTruncateTime [character]
_MyConnection._MyConn-ServerPid [integer]
_MyConnection._MyConn-ServerTid [integer]
_MyConnection._MyConn-Tid [integer]
_Repl-Agent._ReplAgt-TransEndTrigger [integer]
_Repl-Agent._ReplAgt-AIStreaming [logical]
_Repl-Agent._ReplAgt-DRTransitionToAgents [character]
_Repl-Agent._ReplAgt-ApplyStreamingData [logical]
_Repl-AgentActivity._ReplAgtAct-LastBlockSeq [int64]
_Repl-AgentActivity._ReplAgtAct-LastBlockBlock [int64]
_Repl-AgentActivity._ReplAgtAct-ServerBlocksToSend [integer]
_Repl-AgentActivity._ReplAgtAct-LastBlockCountTime [character]
_Repl-AgentActivity._ReplAgtAct-BlockProcDelay [integer]
_Repl-Server._ReplSrv-TransEndTrigger [integer]
_Repl-Server._ReplSrv-DRTransitionToAgents [character]
OpenEdge 12.0 introduces new fields / indexes to existing to meta-schema, authorization and SQL Catalog Tables:
_Db._Db-auth-key [character]
_Field._Dropping [logical]
_Field._New-Name [character]
_Field-Trig._Trigger-Version [integer]
_Field-Trig._DigitalSignature [int64]
_Field-Trig._Rcode [blob]
_File._Owner-DomainId [int64]
_File._Creator-DomainId [int64]
_File._Trigger-Version [integer]
_File._Dropping [logical]
_File-Trig._Trigger-Version [integer]
_File-Trig._DigitalSignature [int64]
_File-Trig._Rcode [blob]
_Index._Owner-DomainId [int64]
_Index._Dropping [logical]
_sec-granted-role._Grantor-DomainId [int64]
_sec-granted-role._Grantee-DomainId [int64]
_sec-granted-role._Role-type [int64]
_sec-granted-role._Role-attr [character]
_sec-granted-role._SnapshotVer [integer]
_sec-granted-role._BiGrantee (INDEX == _Role-name; _Grantee-DomainId; _Grantee; _Grantor-DomainId; _Grantor; _SnapshotVer)
_sec-granted-role._Role-namtyp (INDEX == _Role-name; _Role-type)
_sec-granted-role._Role-type (INDEX == _Role-type; _Role-name)
_sec-role._Role-type [int64]
_sec-role._Role-attr [character]
_sec-role._AuthVer [integer]
_sec-role._Role-type (INDEX == _Role-type; _Role-name; _AuthVer)
_Sequence._Seq-Owner-DomainId [int64]
_Sequence._Seq-Identifier [character]
_Sequence._Dropping [logical]
_Sequence._Seq-Id (INDEX == _Db-recid; _Seq-Identifier)
_Sysviews._Owner-DomainId [int64]
_Sysviews._Creator-DomainId [int64]
