User Guide

SAP AG November 2002
Optimistic Lock ........................................................................................................... 115
Requesting and Releasing a Lock ................................................................................. 115
Isolation Level ................................................................................................................ 116
Isolation Level 0.......................................................................................................... 117
Isolation Level 1 or 10................................................................................................. 117
Isolation Level 15........................................................................................................ 118
Isolation Level 2 or 20................................................................................................. 118
Isolation Level 3 or 30................................................................................................. 118
Phenomena .................................................................................................................... 119
Dirty Read................................................................................................................... 119
Non-Repeatable Read ................................................................................................ 119
Phantom...................................................................................................................... 119
SAP DB Version 7.4........................................................................................................... 120
SAP DB Improvements Since 1997 ............................................................................... 120
SAP DB Tools................................................................................................................. 120
Technical Specification of SAP DB Version 7.4............................................................. 121
Improvements in SAP DB Version 7.4 ........................................................................... 122
Terms ................................................................................................................................. 123
Application Data ............................................................................................................. 125
Automatic Log Backup ................................................................................................... 126
Backup............................................................................................................................ 126
Backup History ............................................................................................................... 126
Backup ID ....................................................................................................................... 127
Backup Medium.............................................................................................................. 127
B* Tree ........................................................................................................................... 128
Cache ............................................................................................................................. 129
Catalog ........................................................................................................................... 129
COMMIT ......................................................................................................................... 129
Converter........................................................................................................................ 129
Data Cache..................................................................................................................... 130
Data Volume................................................................................................................... 130
Data Area ....................................................................................................................... 131
Data Backup................................................................................................................... 131
Database Administrator.................................................................................................. 131
Database Catalog........................................................................................................... 131
Database Instance ......................................................................................................... 132
Database Instance Type ................................................................................................ 132
Database Manager......................................................................................................... 133
Database Manager CLI .................................................................................................. 133
Database Manager GUI ................................................................................................. 134
User Manual: SAP DB 10