System Management Contents

System Management Contents

Introduction

Documentation Objectives

Organization of this Manual

Acronyms, Terms and Trademarks

Related Mimer SQL Publications

System Management Responsibilities

SQL Statement Execution

The Database Environment

The Data Dictionary

Idents - Access and Authority

Mimer SQL System Databanks

Databank Options

Creating Idents and a Databank - an Example

Locating Databank Files

Organizing Databank Files

Protecting Data against Loss

Reserved Directories

Other Performance Issues

Altering Databank Locations

Accessing Databank Files

Databank File Deletion

Transaction Control

Optimistic Concurrency Control

Transaction Phases

Database Security

The Role of Idents in Database Security

Guidelines for Structuring Idents

System, Object and Access Privileges

Cascade Effects Between Privileges

Restriction Views

Entity Integrity

Referential Integrity

Table Integrity

Establishing a Mimer SQL Database

Making the Database Accessible

The Local Database

Accessing a Database Remotely

Client/Server Interface

Mimer SQL License Key

MIMLICENSE on VMS and UNIX

Generating the Mimer SQL System Databanks

Setting the Initial Size

Creating SYSADM

Establishing the Ident and Data Structure

Managing Database Connections

Selecting a Database

Troubleshooting Remote Database Connect Failures

Running BSQL and UTIL

BSQL and UTIL Command-line Arguments

Creating the Example Database

Removing a Database

Managing a Database Server

System Performance

Database Server Memory Areas

Code

Data and Thread Stacks

Communication Buffers

Number of Request Threads

Number of Background Threads

Database Server System Requirements

Physical Memory

Controlling the Database Server - MIMCONTROL

MIMCONTROL Syntax

MIMCONTROL (/STATUS/DCL or -b)

MIMCONTROL Examples

MIMCONTROL Exit Codes

System Information - MIMINFO

The Performance Report

Bufferpool Report

Database Server Log

Runtime Malfunctions

Several Installations on One Machine

Backup and Restore

Background Information

Database Consistency

LOGDB and TRANSDB Importance

Updates Recorded in LOGDB

TRANSDB Considerations

SQLDB Considerations

Databank Backups

System vs. Online Backups

SQL Statements for Backing-up Databanks

Online Backup Commands

Online/Offline Commands

Restore Command

Backing-up and Restoring Databanks

Online Backups Using the SQL Statements

System Backups Using the Host File System

Restoring a Databank

Restoring SYSDB

Re-creating TRANSDB, LOGDB and SQLDB

Databank Check Functionality

Result File Contents

DBC Table Information

DBC Table Information for LOGDB, TRANSDB and SQLDB

Example of Result File

DBOPEN Functionality

DBOPEN Output Example

Shadowing Functionality

Databank Shadowing

Different Levels of Data Protection

All Databanks on One Disk and No Logging

Logging, with LOGDB and TRANSDB on a Separate Disk from the Data

Shadowing, with Shadows on a Separate Disk

Shadowing and Logging

Shadowing Management

The Shadowing Utilities

Backups from Shadows

Shadowing System Databanks

SYSDB

Transform a SYSDB Shadow to a Master

LOGDB

SQLDB

If a Shadow for SYSDB, TRANSDB or LOGDB Is Not Accessible

Testing Your Data Protection

Configuring the System

Performance Aspects of Shadowing

READLOG Functionality

Using the READLOG Functionality

List Definitions (Output Control)

List Restrictions

List Operations

Change Program ID

Database Statistics

Statistical Information

The SQL Statistics Statements

Statistics for the Entire Database

Statistics for Specified Idents

Statistics for Specified Tables

Secondary Index Consistency

When to Use the SQL Statistics Statements

Export/Import

Export/Import Functions

Extent and Authorization

Import - Object Creation

Naming Conflicts

Referential Conflicts

Import - Data Load

Load and Unload Functions

Data File Formats

Unload Operation

Enter and Leave Program Ident

Executing in Single-user Mode

File Protection in Single- and Multi-user Mode

Specifying Single-user Mode Access

Accessing in Single-user Mode

The SINGLEDEFS Parameter File

The SQLHOSTS File on VMS and Unix

The SQLHOSTS File

The Default SQLHOSTS File

Default Section

Local Client/Server Access

The MULTIDEFS File on VMS and Unix

The MULTIDEFS Parameter File

MULTIDEFS Parameters

UNIX Specifics

Automatic Database Start and Stop

Using Raw Device Partitions

Creating a Raw Disk Partition

Arranging to Put a Databank on a Raw Device

Arranging to Take a Databank off a Raw Device

Environment Variables

Data Dictionary Tables

Summary of Data Dictionary Tables

CHECK_CONSTRAINTS

COLUMN_OBJECT_USE

COLUMN_PRIVILEGES

DOMAIN_CONSTRAINTS

KEY_COLUMN_USAGE

LEVEL2_RESTRICT

OBJECT_COLUMN_USE

OBJECT_OBJECT_USE

REFER_CONSTRAINTS

SOURCE_DEFINITION

TABLE_CONSTRAINTS

TABLE_PRIVILEGES

TRIGGERED_COLUMNS

USAGE_PRIVILEGES

USERS

Index