SAP Library - Database Administration

Start Level 1 Node: Database Administration

Database Administration

End Level 1 Node: Database Administration

Start Level 2 Node: Creating Databases

Creating Databases

End Level 2 Node: Creating Databases

Start Level 3 Node: Planning Databases

Planning Databases

End Level 3 Node: Planning Databases

Start Level 3 Node: Database Templates

Database Templates

End Level 3 Node: Database Templates

Start Level 3 Node: Conventions for Database Names

Conventions for Database Names

End Level 3 Node: Conventions for Database Names

Start Level 3 Node: Encryption

End Level 3 Node: Encryption

Start Level 2 Node: Periodic Administration Tasks

Periodic Administration Tasks

End Level 2 Node: Periodic Administration Tasks

Start Level 2 Node: Automating Administration Tasks

Automating Administration Tasks

End Level 2 Node: Automating Administration Tasks

Start Level 2 Node: Changing Database Properties

Changing Database Properties

End Level 2 Node: Changing Database Properties

Start Level 3 Node: Changing the Database Size

Changing the Database Size

End Level 3 Node: Changing the Database Size

Start Level 3 Node: Activating Automatic Database Start

Activating Automatic Database Start

End Level 3 Node: Activating Automatic Database Start

Start Level 4 Node: Example: Start Script for a Database (Linux)

Example: Start Script for a Database (Linux)

End Level 4 Node: Example: Start Script for a Database (Linux)

Start Level 3 Node: Database Parameters

Database Parameters

End Level 3 Node: Database Parameters

Start Level 4 Node: General Database Parameters

General Database Parameters

End Level 4 Node: General Database Parameters

Start Level 4 Node: Special Database Parameters

Special Database Parameters

End Level 4 Node: Special Database Parameters

Start Level 4 Node: Support Database Parameters

Support Database Parameters

End Level 4 Node: Support Database Parameters

Start Level 4 Node: liveCache Database Parameters

liveCache Database Parameters

End Level 4 Node: liveCache Database Parameters

Start Level 4 Node: Obsolete Database Parameters

Obsolete Database Parameters

End Level 4 Node: Obsolete Database Parameters

Start Level 4 Node: Properties of Database Parameters

Properties of Database Parameters

End Level 4 Node: Properties of Database Parameters

Start Level 3 Node: Configuring Logging

Configuring Logging

End Level 3 Node: Configuring Logging

Start Level 3 Node: Configuring Locks

Configuring Locks

End Level 3 Node: Configuring Locks

Start Level 3 Node: Configuration Files

Configuration Files

End Level 3 Node: Configuration Files

Start Level 2 Node: Monitoring Databases

Monitoring Databases

End Level 2 Node: Monitoring Databases

Start Level 2 Node: Backing Up Databases

Backing Up Databases

End Level 2 Node: Backing Up Databases

Start Level 3 Node: Backup Templates and Data Carriers

Backup Templates and Data Carriers

End Level 3 Node: Backup Templates and Data Carriers

Start Level 3 Node: Backing Up Data

Backing Up Data

End Level 3 Node: Backing Up Data

Start Level 3 Node: Backing Up Log Entries

Backing Up Log Entries

End Level 3 Node: Backing Up Log Entries

Start Level 3 Node: Archiving Backup Files

Archiving Backup Files

End Level 3 Node: Archiving Backup Files

Start Level 3 Node: Backing Up to a Group of Parallel Data Carriers

Backing Up to a Group of Parallel Data Carriers

End Level 3 Node: Backing Up to a Group of Parallel Data Carriers

Start Level 3 Node: Backing Up and Restoring with Remote Computers

Backing Up and Restoring with Remote Computers

End Level 3 Node: Backing Up and Restoring with Remote Computers

Start Level 3 Node: Using Third-Party Backup Tools

Using Third-Party Backup Tools

End Level 3 Node: Using Third-Party Backup Tools

Start Level 2 Node: Making Snapshots of the Data Area

Making Snapshots of the Data Area

End Level 2 Node: Making Snapshots of the Data Area

Start Level 2 Node: Exporting and Importing

Exporting and Importing

End Level 2 Node: Exporting and Importing

Start Level 2 Node: Managing Users

End Level 2 Node: Managing Users

Start Level 3 Node: Database System Administrator

Database System Administrator

End Level 3 Node: Database System Administrator

Start Level 3 Node: DBM Operators

End Level 3 Node: DBM Operators

Start Level 3 Node: Database Users

End Level 3 Node: Database Users

Start Level 3 Node: Conventions for User Names and Passwords

Conventions for User Names and Passwords

End Level 3 Node: Conventions for User Names and Passwords

Start Level 3 Node: Special Operating System Users and Groups

Special Operating System Users and Groups

End Level 3 Node: Special Operating System Users and Groups

Start Level 4 Node: Special Operating System User Group on Microsoft Windows

Special Operating System User Group on Microsoft Windows

End Level 4 Node: Special Operating System User Group on Microsoft Windows

Start Level 4 Node: Special Operating System Users and Groups on Unix and Linux

Special Operating System Users and Groups on Unix and Linux

End Level 4 Node: Special Operating System Users and Groups on Unix and Linux

Start Level 5 Node: <sdb_user> (Special Operating System User)

<sdb_user> (Special Operating System User)

End Level 5 Node: <sdb_user> (Special Operating System User)

Start Level 5 Node: <sdba_group> (Special Operating System Group)

<sdba_group> (Special Operating System Group)

End Level 5 Node: <sdba_group> (Special Operating System Group)

Start Level 5 Node: Support Group (Special Operating System Group)

Support Group (Special Operating System Group)

End Level 5 Node: Support Group (Special Operating System Group)

Start Level 2 Node: Analyzing Database Performance

Analyzing Database Performance

End Level 2 Node: Analyzing Database Performance

Start Level 3 Node: SQL Optimizer

End Level 3 Node: SQL Optimizer

Start Level 4 Node: SQL Optimizer Procedure

SQL Optimizer Procedure

End Level 4 Node: SQL Optimizer Procedure

Start Level 4 Node: Search Conditions

Search Conditions

End Level 4 Node: Search Conditions

Start Level 5 Node: Equality Condition

Equality Condition

End Level 5 Node: Equality Condition

Start Level 5 Node: Range Condition

Range Condition

End Level 5 Node: Range Condition

Start Level 5 Node: IN Condition

End Level 5 Node: IN Condition

Start Level 5 Node: LIKE Condition

End Level 5 Node: LIKE Condition

Start Level 5 Node: Restrictions for UPDATE Statements

Restrictions for UPDATE Statements

End Level 5 Node: Restrictions for UPDATE Statements

Start Level 4 Node: Search Strategies

Search Strategies

End Level 4 Node: Search Strategies

Start Level 5 Node: Sequential Search (Table Scan)

Sequential Search (Table Scan)

End Level 5 Node: Sequential Search (Table Scan)

Start Level 5 Node: Search Conditions for Key Columns

Search Conditions for Key Columns

End Level 5 Node: Search Conditions for Key Columns

Start Level 5 Node: Search Conditions for Indexed Columns

Search Conditions for Indexed Columns

End Level 5 Node: Search Conditions for Indexed Columns

Start Level 5 Node: Search Conditions Linked with OR

Search Conditions Linked with OR

End Level 5 Node: Search Conditions Linked with OR

Start Level 5 Node: Postponement of the Search to the FETCH Time

Postponement of the Search to the FETCH Time

End Level 5 Node: Postponement of the Search to the FETCH Time

Start Level 5 Node: Joins

End Level 5 Node: Joins

Start Level 6 Node: JoinSearchLevel Database Parameter

JoinSearchLevel Database Parameter

End Level 6 Node: JoinSearchLevel Database Parameter

Start Level 5 Node: List of All Search Strategies

List of All Search Strategies

End Level 5 Node: List of All Search Strategies

Start Level 6 Node: CATALOG KEY ACCESS

CATALOG KEY ACCESS

End Level 6 Node: CATALOG KEY ACCESS

Start Level 6 Node: CATALOG SCAN

End Level 6 Node: CATALOG SCAN

Start Level 6 Node: CATALOG SCAN USING USER EQUAL CONDITION

CATALOG SCAN USING USER EQUAL CONDITION

End Level 6 Node: CATALOG SCAN USING USER EQUAL CONDITION

Start Level 6 Node: DIFFERENT STRATEGIES FOR OR-TERMS

DIFFERENT STRATEGIES FOR OR-TERMS

End Level 6 Node: DIFFERENT STRATEGIES FOR OR-TERMS

Start Level 6 Node: EQUAL CONDITION FOR INDEX

EQUAL CONDITION FOR INDEX

End Level 6 Node: EQUAL CONDITION FOR INDEX

Start Level 6 Node: EQUAL CONDITION FOR KEY

EQUAL CONDITION FOR KEY

End Level 6 Node: EQUAL CONDITION FOR KEY

Start Level 6 Node: IN CONDITION FOR INDEX

IN CONDITION FOR INDEX

End Level 6 Node: IN CONDITION FOR INDEX

Start Level 6 Node: IN CONDITION FOR KEY

IN CONDITION FOR KEY

End Level 6 Node: IN CONDITION FOR KEY

Start Level 6 Node: INDEX SCAN

End Level 6 Node: INDEX SCAN

Start Level 6 Node: JOIN VIA INDEXED COLUMN

JOIN VIA INDEXED COLUMN

End Level 6 Node: JOIN VIA INDEXED COLUMN

Start Level 6 Node: JOIN VIA KEY COLUMN

JOIN VIA KEY COLUMN

End Level 6 Node: JOIN VIA KEY COLUMN

Start Level 6 Node: JOIN VIA KEY RANGE

JOIN VIA KEY RANGE

End Level 6 Node: JOIN VIA KEY RANGE

Start Level 6 Node: JOIN VIA MULTIPLE INDEXED COLUMNS

JOIN VIA MULTIPLE INDEXED COLUMNS

End Level 6 Node: JOIN VIA MULTIPLE INDEXED COLUMNS

Start Level 6 Node: JOIN VIA MULTIPLE KEY COLUMNS

JOIN VIA MULTIPLE KEY COLUMNS

End Level 6 Node: JOIN VIA MULTIPLE KEY COLUMNS

Start Level 6 Node: JOIN VIA RANGE OF MULTIPLE INDEXED COL.

JOIN VIA RANGE OF MULTIPLE INDEXED COL.

End Level 6 Node: JOIN VIA RANGE OF MULTIPLE INDEXED COL.

Start Level 6 Node: JOIN VIA RANGE OF MULTIPLE KEY COLUMNS

JOIN VIA RANGE OF MULTIPLE KEY COLUMNS

End Level 6 Node: JOIN VIA RANGE OF MULTIPLE KEY COLUMNS

Start Level 6 Node: NO RESULT SET POSSIBLE

NO RESULT SET POSSIBLE

End Level 6 Node: NO RESULT SET POSSIBLE

Start Level 6 Node: NO STRATEGY NOW (ONLY AT EXECUTION TIME)

NO STRATEGY NOW (ONLY AT EXECUTION TIME)

End Level 6 Node: NO STRATEGY NOW (ONLY AT EXECUTION TIME)

Start Level 6 Node: RANGE CONDITION FOR INDEX

RANGE CONDITION FOR INDEX

End Level 6 Node: RANGE CONDITION FOR INDEX

Start Level 6 Node: RANGE CONDITION FOR KEY

RANGE CONDITION FOR KEY

End Level 6 Node: RANGE CONDITION FOR KEY

Start Level 6 Node: SUBQ CONDITION FOR INDEX

SUBQ CONDITION FOR INDEX

End Level 6 Node: SUBQ CONDITION FOR INDEX

Start Level 6 Node: SUBQ CONDITION FOR KEY

SUBQ CONDITION FOR KEY

End Level 6 Node: SUBQ CONDITION FOR KEY

Start Level 6 Node: TABLE SCAN

End Level 6 Node: TABLE SCAN

Start Level 4 Node: Cost Determination

Cost Determination

End Level 4 Node: Cost Determination

Start Level 5 Node: SQL Optimizer Statistics

SQL Optimizer Statistics

End Level 5 Node: SQL Optimizer Statistics

Start Level 4 Node: Problem Analysis

Problem Analysis

End Level 4 Node: Problem Analysis

Start Level 5 Node: EXPLAIN Statement

EXPLAIN Statement

End Level 5 Node: EXPLAIN Statement

Start Level 6 Node: EXPLAIN Statement for Joins

EXPLAIN Statement for Joins

End Level 6 Node: EXPLAIN Statement for Joins

Start Level 6 Node: EXPLAIN Statement for Complicated SELECT Statements

EXPLAIN Statement for Complicated SELECT Statements

End Level 6 Node: EXPLAIN Statement for Complicated SELECT Statements

Start Level 6 Node: EXPLAIN Statement for SELECT Statements with Subqueries

EXPLAIN Statement for SELECT Statements with Subqueries

End Level 6 Node: EXPLAIN Statement for SELECT Statements with Subqueries

Start Level 6 Node: STRATEGY Column

STRATEGY Column

End Level 6 Node: STRATEGY Column

Start Level 2 Node: Troubleshooting

Troubleshooting

End Level 2 Node: Troubleshooting

Start Level 3 Node: Log Files

End Level 3 Node: Log Files

Start Level 3 Node: Traces

End Level 3 Node: Traces

Start Level 3 Node: Checking Database Structures

Checking Database Structures

End Level 3 Node: Checking Database Structures

Start Level 4 Node: Fixing Errors in the Database Structure

Fixing Errors in the Database Structure

End Level 4 Node: Fixing Errors in the Database Structure

Start Level 3 Node: Tracking Problem Messages in PTS

Tracking Problem Messages in PTS

End Level 3 Node: Tracking Problem Messages in PTS

Start Level 3 Node: Getting Support

Getting Support

End Level 3 Node: Getting Support

Start Level 2 Node: Restoring Databases

Restoring Databases

End Level 2 Node: Restoring Databases

Start Level 3 Node: Initializing Databases

Initializing Databases

End Level 3 Node: Initializing Databases

Start Level 3 Node: Restoring from a Group of Parallel Data Carriers

Restoring from a Group of Parallel Data Carriers

End Level 3 Node: Restoring from a Group of Parallel Data Carriers

Start Level 2 Node: Replication and High Availability

Replication and High Availability

End Level 2 Node: Replication and High Availability

Start Level 3 Node: Database Copy

End Level 3 Node: Database Copy

Start Level 3 Node: Standby Database

Standby Database

End Level 3 Node: Standby Database

Start Level 4 Node: Making the Standby Database the Active Database

Making the Standby Database the Active Database

End Level 4 Node: Making the Standby Database the Active Database

Start Level 3 Node: Hot Standby

End Level 3 Node: Hot Standby

Start Level 4 Node: Architecture of a Hot Standby System

Architecture of a Hot Standby System

End Level 4 Node: Architecture of a Hot Standby System

Start Level 4 Node: What Happens When the Master Database of a Hot Standby System Fa

What Happens When the Master Database of a Hot Standby System Fa

End Level 4 Node: What Happens When the Master Database of a Hot Standby System Fa

Start Level 2 Node: Developing Database Applications

Developing Database Applications

End Level 2 Node: Developing Database Applications