The database verification utility (B97DBVER) checks the version of the Adabas Audit Data Retrieval database.
You can use this program to check whether all required database updates have been applied to the database used by a given Adabas Audit Data Retrieval subsystem.
Run the database verification utility when you encounter messages during online or batch processing that may be caused by a database error, for example, TABLE NOT FOUND or FIELD NOT FOUND.
Tailored JCL for this job can be found in member B97DBVER in the BETA97.CNTL.
+-----------------------------------------------------------------------+
|jobcard |
|//B97DBVER EXEC PGM=BST01RFF,REGION=0M,PARM=('S=97', |
|// 'PGM=B97DBVER', |
|// 'B01LST=xx', |
|// 'B97LST=xx', |
|// 'SIGNON=YES') |
|//* |
|//STEPLIB DD DISP=SHR,DSN=BETA97.LOAD |
|// DD DISP=SHR,DSN=BSA.LOAD |
|//* |
|//B97DEF DD DUMMY |
|//SFFPARM DD DISP=SHR,DSN=BETA.PARMLIB |
|//* |
|//IRMLOG DD SYSOUT=* |
|//IRMERROR DD SYSOUT=* |
|//* |
|//IRMPRINT DD SYSOUT=* |
|//BQLPRINT DD SYSOUT=* |
|//SYSPRINT DD SYSOUT=* |
|//* |
|//SFFFDUMP DD SYSOUT=* |
|//SYSABEND DD SYSOUT=* |
+-----------------------------------------------------------------------+
|
0 |
All required database changes are installed. |
|
16 |
The database level is not up-to-date. Check which database updates are missing and run the appropriate database update jobs before starting to work with this database. |
|
20 |
This return code can occur due to several reasons:
|
|
24 |
Communication error |
|
32 |
BQL abend |
|
36 |
BQL command error |
Note: (*) indicates standard return codes that can be modified.
The following log is written to DD IRMPRINT. It contains a list of all database updates.
+------------------------------------------------------------------------------------------------+
|Date: date Product: Beta 97 VERIFY DATABASE CHANGES IN : Page: 1 |
|Time: time Version: V7R2 BETA97.DB.DEF |
| |
| |
|Table Field Version PTF-No. BSA-Level Installed Installation Member |
|-------- -------- ------- --------- ---------- --------- ----------------------------------- |
| |
|... |
| |
|LAY LAYDYNV1 4.3.0 New BSA0943-03 YES |
|IGR SRCOBT 4.3.0 New BSA0943-03 YES |
|ADS ADSEATTR 4.3.0 PIR3084 BSA0943-03 YES |
| |
|IGR IGRMPABS 6.1.0 New BSA1461-00 YES |
|EXTUPR UPRBR001 6.1.0 New BSA1461-00 YES |
|LGFCTL LGFPROD 6.1.0 New BSA1461-00 YES |
|LGFFLD LGFPROD 6.1.0 New BSA1461-00 YES |
|LGFREC LGFPROD 6.1.0 New BSA1461-00 YES |
|LGFREP LGFPROD 6.1.0 New BSA1461-00 YES |
|LGFSYS LGFPROD 6.1.0 New BSA1461-00 YES |
|LGFFLD LGFPRCF1 6.1.0 PIR6040 BSA1461-01 YES |
|LGFREP LGFREP00 6.1.0 PIR6040 BSA1461-01 YES |
| |
|LGFFLD LGFFOFMT 7.1.0 New BSA1771-00 YES |
|UGF INMASK 7.1.0 New BSA1771-00 YES |
|IGR IGRAFLGS 7.1.0 New BSA1771-00 YES |
+------------------------------------------------------------------------------------------------+
Following is an example of the log if database updates are missing (RC=16):
+------------------------------------------------------------------------------------------------+
|... |
|LGFREP LGFPROD 6.1.0 New BSA1461-00 YES |
|LGFSYS LGFPROD 6.1.0 New BSA1461-00 YES |
|LGFFLD LGFPRCF1 6.1.0 PIR6040 BSA1461-01 NO PIR6040 - SAMPLIB |
|LGFREP LGFREP00 6.1.0 PIR6040 BSA1461-01 NO PIR6040 - SAMPLIB |
+------------------------------------------------------------------------------------------------+
|
Column |
Description |
|---|---|
|
Table |
Name of the affected table |
|
Field |
Name of the affected field in this table |
|
Version |
Version and release of the database update |
|
PTF Number |
PTF number of the database update |
|
BSA-Level |
Highest available BSA level at the time when the database update was made available |
|
Installed |
YES Database update has been installed NO Database update has not been installed |
|
Installation Member |
If updates are missing from the database: Member name and library (SAMPLIB or CNTL) where the database update was made available |
A processing log is written to DD IRMLOG.
+------------------------------------------------------------------------------------------------------+
|IRM1561I PROGRAM: B97DBVER VERSION: V7R2M00 PTFLVL: ptflvl COMPILED: date, time |
|IRM2400I DATABASE VERIFICATION FOR SUBSYSTEM B97P STARTED - DATE: date TIME: time |
|IRM2210I ************************************************************************************* |
|IRM2210I SSID : B97P |
|IRM2210I SYSTEM : B97PROD |
|IRM2210I LOCATION : BERLIN |
|IRM2210I DEFINITION FILE : BETA97.DB.DEF |
|IRM2210I ************************************************************************************* |
|IRM2499I DATABASE VERIFICATION FOR SUBSYSTEM B97P ENDED - DATE: date TIME: time RC: 0000|
+------------------------------------------------------------------------------------------------------+