System Management Contents

Introduction

Documentation Objectives
Prerequisites
Organization of this Manual
Acronyms, Terms and Trademarks
Related Mimer SQL Publications
System Management Responsibilities
SYSADM
SQL Statement Execution

The Database Environment

The Data Dictionary
Idents
USER Idents
OS_USER Idents
PROGRAM Idents
Group Idents
Idents - Access and Authority
Schemas
Databanks
Mimer SQL System Databanks
User Databanks
Databank Options
Creating Idents and a Databank - an Example
Locating Databank Files
Organizing Databank Files
Protecting Data against Loss
Balanced I/O
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
Data Integrity
Domains
Entity Integrity
Referential Integrity
Table Integrity
View 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
SDBGEN Syntax
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
Bufferpool
Communication Buffers
SQLPOOL
Threads
Number of Request Threads
Number of Background Threads
Database Server System Requirements
Physical Memory
Virtual Memory
Global Pages
Controlling the Database Server - MIMCONTROL
MIMCONTROL Syntax
MIMCONTROL (/STATUS/DCL or -b)
MIMCONTROL Examples
MIMCONTROL Exit Codes
System Information - MIMINFO
MIMINFO Syntax
The Performance Report
Bufferpool Report
SQLPOOL 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

DBC Syntax
Functions
Authorization
Result File Contents
DBC Table Information
DBC Table Information for LOGDB, TRANSDB and SQLDB
Example of Result File
Error Messages

DBOPEN Functionality

DBOPEN Syntax
Functions
Authorization
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
TRANSDB
LOGDB
SQLDB
If a Shadow for SYSDB, TRANSDB or LOGDB Is Not Accessible
Testing Your Data Protection
Configuring the System
Performance Aspects of Shadowing
Tuning

READLOG Functionality

Functions
Authorization
Using the READLOG Functionality
List Definitions (Output Control)
List Restrictions
List Operations
Change Program ID
Output Format

Database Statistics

Statistical Information
Authorization
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
Export Options
Extent and Authorization
Exported Files
Import Options
Import - Object Creation
Naming Conflicts
Referential Conflicts
Import - Data Load
Authorization
Load and Unload Functions
Data File Formats
Load Operation
Unload Operation
Authorization
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 Section
REMOTE 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
API_FUNCTION
AST_CODES
AST_SOURCES
BACKUPS
CHAR_SETS
CHECK_CONSTRAINTS
COLLATIONS
COLUMNS
COLUMN_OBJECT_USE
COLUMN_PRIVILEGES
DATABANKS
DOMAINS
DOMAIN_CONSTRAINTS
FIPS_FEATURES
FIPS_SIZING
KEY_COLUMN_USAGE
LEVEL2_RESTRICT
LEVEL2_VIEWCOL
LEVEL2_VIEWRES
MANYROWS
MESSAGE
MODULES
OBJECTS
OBJECT_COLUMN_USE
OBJECT_OBJECT_USE
ONEROW
PARAMETERS
REFER_CONSTRAINTS
ROUTINES
SCHEMATA
SEQUENCES
SERVER_INFO
SEVERITY
SOURCE_DEFINITION
SPECIFIC_NAMES
SQL_LANGUAGES
SYNONYMS
TABLES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TABLE_TYPES
TRANSLATIONS
TRIGGERED_COLUMNS
TRIGGERS
TYPE_INFO
USAGE_PRIVILEGES
USERS
VIEWS

Index