DBMS Information

 

The DBMS Information function will query the selected database connection for DBMS version information and whether any DataVeil objects are present as described below.
   

To perform the DBMS Information function on all connections defined in the current project, click on the main menu Database, and choose 'DBMS Info'.
  

 

To perform the DBMS Information function on only one or more selected connections (in case your project has many connections defined), first choose the desired database node(s) in the Project explorer tree (hold down CTRL key to click on multiple nodes), then right click and choose 'DBMS Info'.
  

 

Typically, the result shall appear similar to the following:
  

 

Name

This is the database or schema name of the connection.
  

Host

These are the address details that have been configured for this connection.
  

Type

This is the DBMS type for this connection. E.g. Oracle, SQL Server, MySQL, etc.
  

DBMS Version

This is the version information returned by the DBMS on this connection.
  

DV Native Library

If the DataVeil Native Library has been installed on the DBMS then the version number shall be displayed. Otherwise 'Not found' shall be displayed. Please refer to Native Library for further information.
  

DV Artifacts

This should normally show 'None'.

During a masking run, including preview runs, DataVeil uploads masking functions and creates some temporary work tables ("artifacts"). After the completion of a masking run DataVeil automatically performs a cleanup and removes all such artifacts. This cleanup is always performed even if a masking run terminates with errors.

If you perform this DBMS Information function while a masking run is in progress then the value in this column may be 'Masking in progress' and this is normal.

On very rare occasions it may occur that some DataVeil artifacts are left behind on the DBMS. This is most likely to have happened if the DataVeil process was somehow abnormally terminated while a masking run was still in progress and therefore DataVeil did not have an opportunity to perform the regular cleanup.

If DataVeil artifacts are found on the DBMS then this column shall show 'FOUND' and a 'Clean' button shall appear as shown below.
 


 

Clicking on the Clean button shall cause DataVeil to perform a normal cleanup of all DataVeil artifacts on the DBMS and a confirmation message shall be logged.

This cleanup is the same as is performed by DataVeil prior to the start of every masking run and also after the completion of every masking run. Therefore, even if the DataVeil process is somehow stopped during a masking run, you would likely be aware that a serious environmental error has occurred and would attempt another run of the DataVeil masking project at which time DataVeil would automatically perform a cleanup.

It should also be understood that if the DataVeil process is terminated while a masking project is running then the database schema may be left in an inconsistent state because DataVeil may have dropped indexes, constraints, triggers and only partially updated some tables. Therefore, in such a situation a restore of the database schema is recommended.