SAP Library - BC R/3 Database Guide: DB2 Universal Database for UNIX & Windows

BC R/3 Database Guide: DB2 Universal Database for UNIX & Windows

The SAP-DB2admin Tool

SAP-DB2admin Architecture

The Admin Database

Rebuilding the Admin Database

Checking Admin Database Replication

Calling SAP-DB2admin Functions

SAP-DB2admin Options

Redirected Restore Tool

The DB6CLP Command

Host Directory Structures

R/3 Directory Structure: DB2 UDB on UNIX Platforms

R/3 Directory Structure: DB2 UDB on the Windows NT Platform

Log File Management

Log File Management: Concepts

Archiving Log Files using BRARCHIVE

Restoring Log Files using BRRESTORE

Emergency Restore of Log Files using brrestore-ex

Restoring the Admin Database from Log File Archive

Log File Maintenance

Log File Management: Troubleshooting

Managing Device Classes

Managing Devices

Using the Journal

Command Line Options for Log File Management Tools

Examples of BRARCHIVE and BRRESTORE Operations and Command Synta

Changes to BRARCHIVE and BRRESTORE

Tablespace Management

Reorganizing a Tablespace

Reducing the Size of a Tablespace

Rebalancing a Tablespace

Table Management

Check for Reorganization

Reorganizing Tables

CCMS Enablement

User Management

Managing Passwords

Configuration Parameters

Configuration Database

Profiles

Environment

Database Configuration Parameters

DBM Configuration Parameters

Log File Management Parameters

Log File Management Protocols

Backup/Recovery History

Database Diagnostics

Messages

SAP-DB2admin Messages

DB2 User Exit Messages

BRARCHIVE and BRRESTORE Messages

Tracing

IBM DB2 UDB for UNIX & Windows Documentation

Installing SAP-DB2admin GUI Utilities

Installing DB2 UDB Administration Client

Installation of the R/3 Control Center Extension

Cataloging the Databases to be Administered

Checking the Installation of the SAP-DB2admin Utilities

Configuring the SAP-DB2admin Utilities