SAP DB
Basic Information
The SAP DB Database System
Version Notation
SAP DB Support
Database Instance Type
SAP DB OLTP
SAP liveCache
SAP DB Document Server
SAP DB OLAP
SAP DB E-Catalog
SAP DB Versions and Database Instance Types
Database Instances
Threads
User Kernel Threads (UKT)
Pager
Log Writer
Server Task
Timer Task
Trace Writer Task
User Task
Utility Task
Task State
Special Thread
Caches
Catalog Cache
I/O Buffer Cache
Converter
Data Cache
Log Queue
Volumes
Data Volume
Data Area
Log Volume
Log Area
Log Segment
Database Catalog
Application Data
Directory Structure of the Database System
Performance Requirements
Using Multiple Database Systems
SAP DB Directories
Run Directory
Programs that Are Independent of the Database Software Version
Programs that Are Dependent on the Database Software Version
Libraries for the Client Run-time Environment
Example: SAP DB Directory Structure
Displaying SAP DB Directories
Defining the SAP DB Directories
Database Files
Log Files
Classes of Log Files
Database Trace
Configuration Files
Database Parameters
General Database Parameters
CACHE_SIZE
MAXCPU
MAXUSERTASKS
RESTART_SHUTDOWN
Special Database Parameters (Extended)
_UNICODE
DEFAULT_CODE
DEVNO_BIT_COUNT
JOIN_SEARCH_LEVEL
REQUEST_TIMEOUT
SESSION_TIMEOUT
Multiprocessor Configuration
Database Tools
Database Manager
Database Manager GUI
Database Manager CLI
Web DBM
Architecture of the Database Manager
DBM Server
Database Analyzer
Loader
Architecture of the Loader
Loader Server
Query Tools
Architecture of the Query Tools
SAP DB WebDAV GUI
Architecture of the SAP DB Web Tools
Web Server
X Server
Security Concepts
Availability
Log Settings
Log Mode
Overwrite Mode for the Log Area
Backing Up
Data Backup
Complete Data Backup
Incremental Data Backup
Log Backup
Automatic Log Backup
Interactive Log Backup
Backup History
Backup ID
External Backup ID
Backup Medium
Group of Parallel Backup Media
External Backup Tool
Naming Conventions for Backup Media
Restartability
Restore
User Concept
SAP DB User Classes
Database Manager Operator (DBM Operator)
Authorizations
User Authorizations
Operating System User Authorizations
Database User
Database User Classes
SYSDBA
DBA
DOMAIN
RESOURCE
STANDARD
User Groups
The Role Concept
User Data as Options
Required Options
User Data and XUSER
Using XUSER
XUSER Options
Generating XUSER Data in the Background
XUSER Data
Lock Behavior
Lock
Shared Lock
Exclusive Lock
Optimistic Lock
Requesting and Releasing a Lock
Isolation Level
Isolation Level 0
Isolation Level 1 or 10
Isolation Level 15
Isolation Level 2 or 20
Isolation Level 3 or 30
Phenomena
Dirty Read
Non-Repeatable Read
Phantom
SAP DB as UNICODE Database
UNICODE
Installing a UNICODE-Enabled Database
Setting the Database Parameter _UNICODE
Setting Code Attribute UNICODE
UNICODE and SQL
Example 1
UNICODE in Programming Languages
Example 2
SAP DB Version 7.4
SAP DB Improvements Since 1997
Technical Specification of SAP DB Version 7.4
New Developments in SAP DB Version 7.4
Supported Operating Systems and Platforms
SAP DB Documentation
Terms
Operational State
COMMIT
Database Console
Database Name
Database Session
Unloading Data
Loading Data
Page Pool
Checking the Database Structures
Restart
ROLLBACK
Savepoint
Page
Backup
Language Support (MapChar Sets)
SQL Mode
Timeout Value
Transaction
Version File
Variables
Reference Manual: SAP DB 7.4
Concepts
Users and User Groups
Code Attribute
UNICODE
Code tables
ASCII code
EBCDIC code
Database Catalog/Application Data
Database procedure
Database Session
Data integrity
Data Type
BOOLEAN
Date value
LONG column
NULL value
Special NULL value
Number
Character String
Timestamp value
Time value
Index
Parameter
Privilege
Role
SERIAL
Column
SQL Mode
Subtransaction
Synonym
Table
Transaction
Trigger
Domain
Basic Elements
Character
Digit
Letter
Extended letter
hex_digit
language_specific_character
Special character
Literal (literal)
String Literal (string_literal)
hex_literal
hex_digit_seq
Numeric Literal (numeric_literal)
Fixed point literal
Sign
Digit sequence
Floating point literal
Mantissa
Exponent
Unsigned integer
Integer
Token
Regular token
Keyword
Not reserved keyword
Reserved keyword
Identifier
Simple Identifier (simple_identifier)
First character
Identifier tail character
Underscore
Double quotes
Special Identifier (special_identifier)
Delimiter token
Names
Alias name
usergroup name
User name
Constraint name
Name of a database procedure (dbproc_name)
Domain name
Owner
Result table name
Index name
Indicator name
Mapchar Set Name (mapchar_set_name)
Password
Parameter name
Privilege type (privilege)
Name of a referential constraint (referential_constraint_name)
Reference name
Role Name (role_name)
Sequence name
Column name
Synonym name
Table name
Trigger Name (trigger_name)
Column specification (column_spec)
Parameter specification (parameter spec)
Specifying values (extended value spec)
Specifying Values (value_spec)
Date and Time Format (datetimeformat)
Specifying a string (string spec)
Specifying a Key (key_spec)
Expression
factor
Predicate (predicate)
BETWEEN predicate (between_predicate)
Boolean predicate (bool_predicate)
Comparison Predicate (comparison_predicate)
Comparison operators (comp_op)
Comparison operators (equal_or_not)
DEFAULT predicate
EXISTS Predicate (exists_predicate)
IN Predicate (in_predicate)
JOIN Predicate (join_predicate)
LIKE Predicate (like_predicate)
Pattern element
match_string
match_set
NULL predicate
Quantified Predicate (quantified_predicate)
Quantifier
ROWNO Predicate (rowno_predicate)
SOUNDS predicate
Search Condition (search_condition)
Boolean factor
Functions: Overview
Function (function_spec)
Arithmetic function
ABS(a)
CEIL(a)
EXP(a)
FIXED(a,p,s)
FLOAT(a,s)
FLOOR(a)
INDEX(a,b,p,s)
LENGTH(a)
LN(a)
LOG(a,b)
NOROUND(a)