Detailed instructions for use are in the User's Guide.
User Manual: SAP DB
SAP AG
November 2002
Copyright
© Copyright 2002 SAP AG. Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation. For more information on the GNU Free Documentaton License see http://www.gnu.org/copyleft/fdl.html#SEC4.
User Manual: SAP DB
2
SAP AG
November 2002
Icons
Icon Meaning Caution Example Note Recommendation Syntax
Typographic Conventions
Type Style Example text Description Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths and options. Cross-references to other documentation. Example text EXAMPLE TEXT Emphasized words or phrases in body text, titles of graphics and tables. Names of elements in the system. These include report names, program names, transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE. Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools. Keys on the keyboard, for example, function keys (such as F2) or the ENTER key. Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation. Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.
Example text
EXAMPLE TEXT Example text
User Manual: SAP DB
3
SAP AG
November 2002
User Manual: SAP DB ............................................................................................................. 13 Architecture of the Database System .................................................................................. 13 Database Instance ........................................................................................................... 14 Thread........................................................................................................................... 14 User Kernel Thread (UKT) ........................................................................................ 14 Data Writer ............................................................................................................ 15 Log Writer .............................................................................................................. 15 Server Tasks ......................................................................................................... 16 Timer Task............................................................................................................. 16 Trace Writer Task .................................................................................................. 16 User Task .............................................................................................................. 16 Utility Task ............................................................................................................. 16 Special Thread .......................................................................................................... 17 Coordinator............................................................................................................ 17 Dev Thread............................................................................................................ 17 Requester .............................................................................................................. 18 Temporary Dev Thread ......................................................................................... 18 Timer...................................................................................................................... 18 Operating-System-Dependent Special Threads ....................................................... 18 Clock Thread ......................................................................................................... 18 Console Thread ..................................................................................................... 18 Cache............................................................................................................................ 19 Catalog Cache .......................................................................................................... 19 I/O Buffer Cache ....................................................................................................... 19 Converter............................................................................................................... 19 Data Cache............................................................................................................ 20 Log Queue ................................................................................................................ 20 Volume.......................................................................................................................... 21 Data Volume ............................................................................................................. 21 Log Volume ............................................................................................................... 22 Database Instance Type .................................................................................................. 23 SAP DB OLTP .............................................................................................................. 23 liveCache ...................................................................................................................... 23 SAP DB Document Server............................................................................................ 23 SAP DB OLAP .............................................................................................................. 24 SAP DB E-Catalog........................................................................................................ 24 SAP DB Versions and Database Instance Types ............................................................ 24 Operating System Platforms ............................................................................................ 25 Multiprocessor Configuration............................................................................................ 25 User Manual: SAP DB 4
SAP AG
November 2002
User Concept ....................................................................................................................... 25 SAP DB User Classes...................................................................................................... 26 Database Manager Operator (DBM Operator) ............................................................. 26 Authorizations ........................................................................................................... 27 User Authorizations ............................................................................................... 27 Default Authorizations for the First DBM Operator ............................................ 28 Operating System User Authorizations ................................................................. 28 Database User.............................................................................................................. 28 Database User Classes ............................................................................................ 28 SYSDBA ................................................................................................................ 29 DBA ....................................................................................................................... 29 DOMAIN ................................................................................................................ 29 RESOURCE .......................................................................................................... 30 STANDARD........................................................................................................... 30 User Groups.............................................................................................................. 30 The Role Concept ............................................................................................................ 30 User Data as Options ....................................................................................................... 31 Options (C/C++ Precompiler) ....................................................................................... 32 Required Options ............................................................................................................. 34 User Data and XUSER..................................................................................................... 34 Using XUSER ................................................................................................................... 35 XUSER Data................................................................................................................. 35 Generating XUSER Data in the Background................................................................ 36 Security Concepts................................................................................................................ 37 Availability......................................................................................................................... 38 Security Requirements ................................................................................................. 38 Restartability..................................................................................................................... 38 Backup Strategy ............................................................................................................... 39 Backup .......................................................................................................................... 40 Data Backup.............................................................................................................. 40 Complete Data Backup.......................................................................................... 40 Incremental Data Backup ...................................................................................... 41 Parallel Backup...................................................................................................... 41 Saving Data Backups ............................................................................................ 41 Log Backup ............................................................................................................... 41 Automatic Log Backup........................................................................................... 42 Interactive Log Backup .......................................................................................... 42 Saving Log Backups.............................................................................................. 43 External Backup Tool.................................................................................................... 43 Log Concept......................................................................................................................... 43
User Manual: SAP DB
5
SAP AG
November 2002
Log Entry .......................................................................................................................... 44 Redo Log Entry............................................................................................................. 44 Undo Log Entry............................................................................................................. 44 Online Logging ................................................................................................................. 44 Redo Log Management ................................................................................................ 45 Log Queue ................................................................................................................ 45 Log Page................................................................................................................... 46 Log Writer.................................................................................................................. 46 Log Area.................................................................................................................... 47 Undo Log Management ................................................................................................ 47 Undo Log File............................................................................................................ 48 History Management......................................................................................... ...
