Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

File identification records

A description of the file identification records follows. File identification records appear when a new log unit has been started

  • at the beginning of a new DBH session

  • at the beginning of a new file (previous one was full, RECOVER statement, DAW, etc.)

  • when a backup copy of a space is made.


Examples

SEDI70/SQL   VERS. <version>  TSN:3Q2S  ID.:SQLDB111 SEDI70 - LOGGING FILE - EVALUATION      <date> <time>       PAGE     1  
USER IDENTIFICATION          TA ID      STMT     ACTION   SPC   TAB    REC NR                                                      
***********************************************************************************************************************************
**********          FILE NAME:  CME.000008.D.0003                                              BLOCK:  00000001          **********
**********          DBH SESSION WITH TRANSACTION-SECURITY = *YES                               <date> <time>  LOC        **********
***********************************************************************************************************************************


The following file identification record appears after a DBH restart when a new file is started:

>SEDI70/SQL   VERS. <version>  TSN:3Q2S  ID.:SQLDB111 SEDI70 - LOGGING FILE - EVALUATION       <date> <time>      PAGE     3 
USER IDENTIFICATION          TA ID      STMT     ACTION   SPC   TAB    REC NR                                                      
***********************************************************************************************************************************
**********          FILE NAME:  CME.000008.D.0003                                              BLOCK:  00000001          **********
**********          <<< D B H - R E S T A R T >>>                                              <date> <time>  LOC        **********
***********************************************************************************************************************************


All transactions that are not terminated by a COMMIT are rolled back.