One more question, Are all other vst's part of PUB schema other than _sysdbauth and _systabauth? I raised this question because I quickly double checked my db analysis report and only the user created tables are PUB.table1, PUB.table2 etc. None of the VST's are with 'PUB.'
Code:
RECORD BLOCK SUMMARY FOR AREA "Schema Area" : 6
-------------------------------------------------------
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
PUB.table1 32 2.4K 47 97 75 32 1.0 1.3
PUB.table2 78817 17.1M 127 763 227 78817 1.0 1.3
PUB.table3 1 46.0B 46 46 46 1 1.0 1.0
_Db 1 628.0B 628 628 628 1 1.0 1.0
_Field 15988 2.9M 153 359 190 17847 1.1 4.7
_Field-Trig 0 0.0B 0 0 0 0 0.0 0.0
_File 1063 275.0K 156 1811 264 1526 1.4 5.1
_File-Trig 1156 47.2K 37 59 41 1156 1.0 3.5
I understand that it's not a good practice to have user tables under schema area but as part of migration I am moving it to a different area - but this is data is from my current system to show PUB is there on user tables and not on system tables.
All system tables have negative file numbers (_file._file-number), except for the SQL views, as you've seen above. VSTs are system tables but not all system tables are virtual (VSTs). VSTs all have file numbers < -16384. All other system tables have higher numbers and are real (i.e. exist on disk), not virtual.
The fact that the tables shown in your dbanalys output aren't prefixed with "PUB." is just how the code is written; it doesn't reflect the schema. All application tables you add via ABL and all system tables with _file-number < 0 are in the PUB schema. Here is similar output from an 11.4 table analysis report, reflecting this fact:
Code:
RECORD BLOCK SUMMARY FOR AREA "Schema Area": 6
-------------------------------------------------------
RECORD BLOCK SUMMARY FOR SHARED TABLES
--------------------------------------------
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
PUB._Client-Session 0 0.0B 0 0 0 0 0.0 0.0
PUB._Codepage 0 0.0B 0 0 0 0 0.0 0.0
PUB._Collation 0 0.0B 0 0 0 0 0.0 0.0
PUB._Constraint 0 0.0B 0 0 0 0 0.0 0.0
PUB._Constraint-Keys 0 0.0B 0 0 0 0 0.0 0.0
PUB._Db 1 652.0B 652 652 652 1 1.0 1.0
Also, dbanalys/tabanalys only shows info about real tables, not virtual tables.