SDB DB Integrity checks can be run in three ways:
-
From SQLPlus
-
From SDB Utility Tool available in the product
-
Batch schedule on a regular basis
From SQLPLUS
-
Call the script at the SQL prompt.
-
Type the database connection string.
-
Type the password for the database user.
-
Type the physical path of the database server where the CSV file will be generated within single quotes, for example, ‘D:/oradata/SDB/utl’.
From SDB Utility Tool
-
Run SDBUtility.exe available in product installation path <SDB Installation Folder>\sdbutilitytool\
-
Provide the Database, M_SYS and SDB Schema Passwords, SRD Application User in respective fields, and then click Connect.
-
Select <Project>, <Discipline> and <Language> where scripts need to run on and click OK.
-
Select a single or multiple script to run using left pane checkbox and click Execute.
-
Click Export to Excel to export and save the results into a Microsoft Excel workbook.
Batch Schedule Scripts
-
Include all scripts that need to be scheduled in the BatchInputConfiguration.xml file present in the folder <SDB Installation Folder>\sdbutilitytool\. Use the ScriptsConfiguration.xml file, as a sample.
-
Add the command shown below in the task scheduler after modifying the database details as required.
"<SDB Installation Path>\sdbutilitytool\SDBUtility.exe" -X "<SDB Installation Folder>\ \sdbutilitytool\BatInputConfiguration.xml" -O "<Output file path>" -DN "<Database Server>/<Database SID>" -MSP "<M_SYS Password>" -SSP "MANAGER30" -U "SPRDSDB" -P "SDB" -D "PIPING" -L "ENGLISH".
Results will be saved in the Output folder path mentioned in the command.