Database Studio
Starting and Configuring Database Studio: Overview
Starting Database Studio
Configuring Database Studio
Database Studio Preferences: Database Studio
Database Studio Preferences: Editors
Database Studio Preferences: Export/Import
Database Studio Preferences: Label Decorations
Database Studio Preferences: Log File Viewer
Database Studio Preferences: Logging
Database Studio Preferences: Query Result
Database Studio Preferences: Repository
Database Studio Preferences: User Management
Database Studio Screen Areas
My Repository
Explorer Tree
Administration Editor
Table Editor
View Editor
Sequence Editor
SQL Editor
Visual Query Editor
Explain (View)
Actions (View)
Event Log Viewer
Updating SQL Optimizer Statistics
Showing or Hiding Databases
Managing Database Landscapes
Logging On to a Database
Creating Login Templates
Starting or Stopping Databases
Creating and Updating Databases: Overview
Creating Databases
Loading Demo Data
Updating the System Tables
Creating and Using Database Objects: Overview
Creating Schemas
Deleting Schemas
Creating Tables
Changing Table Properties
Defining Custom Table Properties
Deleting Tables
Creating Columns
Changing Column Properties
Defining Constraints for Columns
Deleting Columns
Defining Foreign Key Dependencies
Creating View Tables
Renaming View Tables
Deleting View Tables
Creating Synonyms
Renaming Synonyms
Deleting Synonyms
Creating Indexes
Changing Index Properties
Activating or Deactivating Indexes
Deleting Indexes
Creating Sequences
Deleting Sequences
Creating Database Procedures
Executing Database Procedures
Deleting Database Procedures
Creating Database Functions
Using Database Functions
Deleting Database Functions
Creating Database Triggers
Deleting Database Triggers
Testing Prepared Statements
Changing Database Properties: Overview
Displaying the Database Properties
Changing Database Parameters
Adding or Deleting Data Volumes
Activating or Deactivating the Dynamic Adjustment of the Data Area
Adding Log Volumes
Changing the Log Mode
Activating or Deactivating Overwrite Mode for the Log Area
Activating or Deactivating Redo Log Management
Activating or Deactivating the Automatic Recreation of Damaged Indexes
Activating or Deactivating the Automatic SQL Optimizer Statistics Update
Changing Data in the Database
Monitoring Databases: Overview
Displaying Information About the Data Area
Displaying Information About the Log Area
Displaying Information About the Database Analyzer
Displaying the History of Administration Actions (DBA History)
Displaying Information About Caches (Working Memory Areas)
Displaying Information About Database Activities
Displaying Information About Tasks
Displaying Information About Threads
Monitoring Databases in a Database Landscape
Using Database Events
Backing Up Databases: Overview
Defining Backup Templates
Changing the Properties of Backup Templates
Deleting Backup Templates
Backing Up Data
Backing Up Log Entries
Activating or Deactivating Automatic Log Backup
Checking Backups
Opening the Backup History
Making Snapshots of the Data Area
Displaying Information About Snapshots
Reverting to a Snapshot
Deleting Snapshots
Exporting and Importing: Overview
Exporting Data and/or Information from the Database Catalog
Importing Data and/or Information from the Database Catalog
Transporting Data and/or Information from the Database Catalog
Saving SQL Statements or Definitions of Database Objects in a Repository
Editing Objects in a Repository
Managing Users: Overview
Creating Database Users
Changing the Properties of Database Users
Deleting Database Users
DBM Operators: Creating, Editing and Deleting
Analyzing Database Performance: Overview
Analyzing the Performance of SQL Statements
Configuring the SQL Performance Analysis
Displaying Bottleneck Candidates
Analyzing Bottleneck Candidates
Displaying the Search Strategies Used by SQL Statements (EXPLAIN)
Displaying SQL Locks
Starting or Stopping Database Analyzer
Working with Database Analyzer Charts
Introduction to Database Analyzer Charts
A Quick Tour (Synopsis)
Analyzing the Performance While Being Connected to the Database
Analyzing the Performance Offline
Using Database Analyzer Charts
Starting Database Analyzer Charts
The Database Analyzer User Interface - an Overview
Working with Database Analyzer Charts
Prerequisites
Opening Database Analyzer Files for Charting
Opening Database Analyzer Files for Charting while being Online
Opening Database Analyzer Files for Charting while being Offline
Table and Column List in Detail
Elements/Components of the Table Editor and the Column List
Identifying which Column in the Table Corresponds to the Column in the Legend
The Column List
The Context Menu of the Table Editor
The Context Menu of the Column List
Functionality of the Table and Column List
Rearranging the Column Order
Sorting Tables
Selecting a Metric for Display in a Chart
Hiding and Displaying a Column in the Table
Issuing Warnings for Values
Removing Warnings for Values
Virtual Columns
Adding Virtual Columns with Derived Values
Editing the Script (Formula) of a Virtual Column
Arithmetic Operations, Functions and Constants in Scripts (Formulas)
The Diagnosis Chart View in Detail
Elements/Components of the Diagnosis Chart View
The Context Menu
Functionality of the Diagnosis Chart View
Identifying which Metrics are displayed in the Chart
Selecting the Time Interval for the Displayed Data
Restoring the Chart Display of a Former Time Interval
Displaying a Value on the Chart and Synchronizing it with the Table Content
Displaying a Second Scale on the Right Side
Navigating between recently opened charts/time intervals
Zooming in and out
Comparing different Charts for the same Time Interval
Exporting Image Files
Supported Image Formats
Combining two CSV Files to a merged Product
Metric Templates
Working with Metric Templates
Specifying the Location for Remote Metric Templates
Overriding the Default Metric Template of a CSV File
Defining Named Metric Templates
Using Named Metric Templates
Comparing two Views of a different Metric at the same Time Interval
Defining a Default Time Interval
Setting Up a Database Analyzer Project
What is a Database Analyzer Project?
In Detail
Multiple Opportunities and Ways for Analyzing Database Analyzer Data
Performing an Analysis
Retaining an Analysis
Reproducing an Analysis
Applying a predefined Analysis to another Database
Performing the Same Analysis for Another Point in Time
Comparing Results Comfortably
Working Offline with Database Analyzer Data
Settings for Working offline with Database Analyzer Data
Defining Local Locations for remote Database Analyzer Data
Associating the Diagnosis Editor with Database Analyzer Files
Importing Database Analyzer Data into the Local Locations
Working Offline with Database Analyzer Data in the Explorer View
Working with the Navigator
Working offline with the Navigator
Defining a Linked Folder in the Navigator View
Setting Up Hot Standby Systems: Overview
Setting Up a Hot Standby System (With Shared Log Area)
Troubleshooting: Overview
Displaying Configuration and Log Files
Creating a Log File Archive for Support
Checking Database Structures
Displaying Indexes
Creating Database Traces
Restoring Databases: Overview
Restoring Databases
Initializing Databases
Recreating Damaged Indexes
Logging Users Off from a Database
Deleting Databases
Executing DBM Commands
Working with SQL Statements: Overview
Visual Query
Entering and Executing SQL Statements