Chapter 13. GT.CM Client/Server
.
Prev
|
Next
Chapter 13. GT.CM Client/Server
Revision History
Revision V5.5-000/6
19 July 2012
Corrected the example of starting a GT.CM server.
Revision V5.5-000/4
6 June 2012
First published version.
Contents
Introduction
Overview
GT.CM Server
GT.CM Client
GT.CM Server Startup and Shutdown
Types of Operations
Error Messages
Examples
Contents
Search
About This Manual
Intended Audience
Purpose of the Manual
How to Use This Manual
Overview
Conventions Used in This Manual
About GT.M
Hardware/Operating System Environment
Installation
Security
Program Development Environment
Database Subsystem
GT.M Utility Programs
GDE
MUPIP
LKE
DSE
Command Qualifiers
Database Integrity
Interprocess Communication
Installing GT.M
Obtaining GT.M Distribution Media
Before you begin
Installation Procedure
Reference Implementation Plugin - Shared Library Dependencies
Creating a symbolic link from the unversioned .so (libxxxxxx.so) to libxxxxx.so.<ver>
Recompiling the Reference Implementation Plugin
gtminstall script
Basic Operations
GT.M Environment Setup
gtmprofile
gtmcshrc
gtmbase
gdedefaults
gtm
Environment Variables
Configuring and operating GT.M with Unicode™ support (optional)
M mode and UTF-8 mode
Compiling ICU
Starting GT.M
Configuring huge pages for GT.M x86[-64] on Linux
Global Directory Editor
Global Directory
GDE Overview
Identifying the Current Global Directory
Creating a Default Global Directory
Mapping Global Variables in a Global Directory
Examining the Default Global Directory
Global Directory Abbreviations
Customizing a Global Directory
Adding a Journaling Information Section
Using GDE
Guidelines for Mapping
Example of a Basic Mapping
Global Director Editor Commands
Specifying File Names in Command Lines
Font/Capitalization Conventions Used in this Chapter
@
Add
-Name
-Segment
-Region
-Gblname
Change
Delete
Exit
Help
LOCks
LOG
Quit
Rename
SEtgd
SHow
Template
Verify
Name, Region, and Segment Qualifiers
Name Qualifiers
Region Qualifiers
Segment Qualifiers
Gblname Qualifiers
GDE Command Summary
GDE Command Qualifier Summary
General Database Management
Introduction
Operations - Standalone and Concurrent Access
MUPIP
Commands and Qualifiers
BACKUP
-BKupdbjnl
-Bytestream
-Database
-NETtimeout
-NEWJNLFILES
-Online
-Record
-REPLace
-REPLInstance
-Since
-Transaction
Examples for MUPIP BACKUP
CREATE
-Region
Examples for MUPIP CREATE
DOWNGRADE
-VERSION={V4|V5}
Examples for MUPIP DOWNGRADE
ENDIANCVT
-OVerride
Examples for MUPIP ENDIANCVT
EXIT
EXTEND
-Blocks
Examples for MUPIP EXTEND
EXTRACT
-FOrmat
-FReeze
-LAbel
-LOg
-Select
-STdout
Examples for MUPIP EXTRACT
FREEZE
-OFf
-ON
-OVerride
-Record
Examples for MUPIP FREEZE
FTOK
-DB
-JNLPOOL
-RECVPOOL
INTEG
-ADjacency
-BLock
-BRief
-FAst
-FIle
-FUll
-Keyranges
-MAP
-MAXkeysize
-Online
-Region
-Subscript
-TN_reset
-TRansaction
Examples for MUPIP INTEG
INTRPT
JOURNAL
LOAD
-FOrmat
-BEgin
-End
-FIll_factor
-Stdin
Examples for MUPIP LOAD
REORG
-Exclude
-Fill_factor
-Index_fill_factor
-Resume
-Region
-Select
-Truncate
Examples for MUPIP REORG
REPLICATE
RESTORE
-Extend
Examples for MUPIP RESTORE
RUNDOWN
-File
-Region
-Override
SET
-Access_method
-PArtial_recov_bypass
-File
-Region
-Extension_count
-Flush_time
-Global_buffers
-Lock_space
-INST_freeze_on_error
-Mutex_slots
-Journal
-Qdbrundown
-REServed_bytes
-Version
Examples for MUPIP SET
SIZE
STOP
TRIGGER
Examples for MUPIP TRIGGER
UPGRADE
Example for MUPIP UPGRADE
MUPIP Command Summary
GT.M Journaling
Introduction
Journal Files
Recovery from a Journal File
Forward Recovery
Backward Recovery
rolled_bak* files
Journal Files Access Authorization
Triggers in Journal Files
BEFORE_IMAGE Journaling
NOBEFORE_IMAGE Journaling
Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE
Broken Transaction File
Lost Transaction File
Journaling Benefits
Backup Journal Files
Select database files for Journaling
Fencing Transactions
Deciding Whether to Use Fencing
Fencing Advantages
Fencing Disadvantages
VIEW Keywords
$VIEW() Keywords
SET
SET Object Identifying Qualifiers
SET Action Qualifiers
SET -JOURNAL Options
Examples for MUPIP SET
JOURNAL
Journal Action Qualifiers
-EXtract[=<file-name>|-stdout]
-RECover
-ROLLBACK [{-ON[LINE]|-NOO[NLINE]}]
-SHow=show-option-list
-[NO]Verify
Journal Direction Qualifiers
Journal Time Qualifiers
Journal Sequence Number Qualifiers
Journal Control Qualifiers
Journal Selection Qualifiers
Journal Extract Formats
Database Replication
Introduction
Database Transaction Number
Journal Sequence Number
Stream Sequence Number
Examples
Simple Example
Ensuring Consistency with Rollback
Rollback Not Desired or Required by Application Design
Two Originating Primary Failures
Replication and Online Rollback
Limitations - SI Replication
Replication Architecture
Helper Processes
Filters
Replication Instance File
Implementing Replication and Recovery
Application Architecture
Implement a Message Delivery System
System Requirements
Root Primary Status Identification
Cutover
Instance Freeze
TLS/SSL Replication
Creating a root-level certification authority
Creating leaf-level certificates
Creating a configuration file
Network Link between Systems
Choosing between BEFORE_IMAGE and NOBEFORE_IMAGE journaling
Recovery
Comparison other than Recovery
Database Repair
Procedures
Normal Operation
Startup
Multi-Site to Single-Site
Normal Cutover
Shutting Down an instance
Failures
Dual-Site Failures
Complex Dual-Site Failure
Rolling Software Upgrades
Creating a new instance file without an -updateresync qualifier
Upgrade Replication Instance File
Creating a Supplementary Instance
Starting / Resuming SI Replication
Changing the Replication Source
Switchover between instances having triggers
Schema Change Filters
Recovering from the replication WAS_ON state
Setting up a new replicating instance of an originating instance (A->B, P->Q, or A->P)
Replacing the replication instance file of a replicating instance (A->B and P->Q)
Replacing the replication instance file of a replicating instance (A->P)
Setting up a new replicating instance from a backup of the originating instance (A->P)
Setting up an A->P configuration for the first time if P is an existing instance (having its own set of updates)
Changing the database schema of a replicating instance (A->B and A->P)
Setting up a secured TLS replication connection
Commands and Qualifiers
Turning Replication On/Off
Creating the Replication Instance File
Displaying/Changing the attributes of Replication Instance File and Journal Pool
Starting the Source Server
Shutting down the Source Server
Activating a Passive Source Server
Deactivating an Active Source Server
Stopping the Source Filter
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Stopping a Source Server
Reporting the Current Backlog of Journal Records
Processing Lost Transactions File
Lost Transaction File format
Starting the Receiver Server
Starting the Update Process
Stopping the Update Process
Checking Server Health
Changing the Log File
Enabling/Disabling Detailed Logging
Reporting the Current Backlog of Journal Records
Rolling Back the Database After System Failures
M Lock Utility (LKE)
Introduction
To Invoke and Exit LKE
To establish a Global Directory
LKE Commands and Qualifiers
Clear
SHow
Exit
Help
SPawn
Summary
LKE Exercises
Exercise 1: Preventing concurrent updates using M Locks
Exercise 2: Rectifying a deadlock situation
GT.M Database Structure(GDS)
Database File Organization with GDS
Database File Header
File Header Data Elements
MLOCK Space
Local Bitmaps
Master Bitmap
Database Structure
Tree Organization
GDS Blocks
GDS Records
Using GDS records to hold spanning nodes
GDS Keys
Compression Count
Use of Keys
Characteristics of Keys
Global Variable Names
String Subscripts
Numeric Subscripts
Database Structure Editor
Operating in DSE
DSE Commands and Qualifiers
ADD
Qualifiers of ADD
Examples for ADD
ALL
Qualifiers
Examples of ADD
Buffer_flush
CHange
CHANGE -BLock Qualifiers
CHANGE -FIleheader Qualifiers
Examples for CHANGE
CAche
Qualifiers of CACHE
Examples for CACHE
CLose
CRitical
Qualifiers of CRITICAL
Examples for CRITICAL
Dump
Qualifiers of DUMP
Examples for DUMP
EValuate
Qualifiers of Evaluate
Examples for EVALUATE
EXit
Find
Qualifiers of FIND
Examples for FIND
Help
Integrit
Qualifiers of Integrit
Maps
Qualifiers for MAP
Examples
OPen
Qualifiers for OPEN
Examples for OPEN
OVerwrite
Qualifiers for OVERWRITE
Examples for Overwrite
Page
RAnge
Qualifiers of RANGE
Examples for RANGE
REMove
Qualifiers of REMOVE
REStore
Qualifiers of RESTORE
SAve
Qualifiers of SAVE
SHift
Qualifiers of SHIFT
SPawn
Examples of SPAWN
Wcinit
DSE Command Summary
Maintaining Database Integrity
Verifying Database Integrity
Regularly Scheduled Verification
Before or After Major Transfers
Immediately after Catastrophic Events
Immediately after Run-Time Database Errors
Immediately After Database Repairs
Approaches to Database Recovery
Recover from Journals
Restore from Backup
Repair with DSE
Preventive Maintenance
Determining the Cause of the Problem
MUPIP Recovery
Follow-up
Repairing the Database with DSE
Using the Proper Database File
Locating Structures with DSE
Safety in Repairs
Discarding Data
Concurrent Repairs
Terminating Processes
Recovering data from damaged binary extracts
CORRUPT Errors
LDSPANGLOINCMP Errors
Example–Repairing an error in a binary extract
Finding and Fixing Database Errors
C1–Possible Cache Control Problems
H1–Process Hangs
H3–Database Access Problems
H4–Database Cache Problems
H5–Critical Section Problems
H6–UNIX Problems
H7–Disk Hardware Problems
H8–Application Problems
Persistent LOCKs
Deadlocks
Preventing Deadlocks
I1–MUPIP INTEG Errors
Evaluating the Danger Level of a Database Problem
Requires Immediate Attention
Can Be Deferred
I2–GT.M Version Mismatch
I3–File Header Errors
I4–File Size Errors
I5–More Database Access Problems
I6–Transient Errors
I7–Database Rundown Problem
I8–Repair-Induced Problems
K1–Bad Key
K2–Keys Misplaced
K3–Block Doubly Allocated
K4–Pointer Problems
K5–Star Key Problems
K6–Compression Count Error
K7–Key Warning
M1–Bitmap Errors
M2–Bitmap Header Problems
O1–Bad Block
O2–Record Errors
O3–Data Block Errors
O4–Salvage of Data Blocks with Lost Indices
O5–Salvage of a damaged spanning node
P1–Process Damage
Q1–Restricting Database Access
R1–GT.M Run-Time Errors
R2–Structural Database Integrity Errors
R3–Run-time Database Cache Problems
R4–Stopped Processes
R5–No More Room in the File
R6–GTMASSERT and GTMCHECK Errors
R7–Interlocked Queue Hardware Problems
R8–Database Tree Maximum Level Exceeded
R9–Read-only Process Blocked
Database Encryption
Introduction
Overview
Disclaimer
Limitations of GT.M Database Encryption
Data Not At Rest Not Protected
Keys in the Process Address Space / Environment
Long Lived Keys
Voluminous Samples of Encrypted Data
Encryption Algorithms Neither Endorsed Nor Supported by FIS
No Key Recovery
Human Intervention Required
MM Databases
Alternatives to Database Encryption
Device IO
Replication and GT.CM
FIPS Mode
Theory of Operation
Definition of Terms
Overview
Warning
Data in Database and Journal Files
Symmetric and Asymmetric Ciphers
Key Ring on Disk
Master Key File and Key Files
Memory Key Ring
Key Validation and Hashing
Database Operation
Examples of use
Key Management
Tested Reference Implementations
Special note - Gnu Privacy Guard version 2
Installation
Administration and Operation of Encrypted Databases
Utility Programs
GDE
Format / Upgrade
-[NO]ENcryption
MUPIP
MUPIP CREATE
MUPIP JOURNAL
MUPIP LOAD
DSE
Changing the hash in the database file header
Changing Encryption Keys
Database Creation
Plugin Architecture & Interface
Packaging
Extensions to the GT.M External Interface
Operation
Using the V5.4-001 Reference Implementation with Older Releases
Installation
GT.CM Client/Server
Introduction
Overview
GT.CM Server
GT.CM Client
GT.CM Server Startup and Shutdown
GT.CM Server Startup
GT.CM Server Shutdown
Types of Operations
Error Messages
Examples
GT.M's IPC Resource Usage
Examining GT.M's IPC Resources
gmtsecshr
Monitoring GT.M Messages
Monitoring GT.M Messages
Compiling ICU on GT.M supported platforms
Compiling ICU
Compiling ICU 4.4 on AIX 6.1
Installation Instructions
Compiling ICU 4.2 on AIX 6.1
Installation Instructions
Compiling ICU 4.2 on AIX 5.3
Installation Instructions
Compiling ICU 3.6 on AIX 5.2
Installation Instructions
Compiling ICU 4.2 on HP Integrity IA64 HP-UX 11.31
Installation Instructions
Compiling ICU 3.6 on HP Integrity IA64 HP-UX 11.31
Installation Instructions
Compiling ICU 3.6 on HP PA-RISC HP-UX 11.31 (11iv3)
Installation Instructions
Compiling ICU 3.6 on HP PA-RISC HP-UX 11.11
Installation Instructions
Compiling ICU 4.2 on Red Hat Enterprise Linux 4 Update 2
Installation Instructions
Compiling ICU 3.6 on Red Hat Enterprise Linux 4 Update 2
Installation Instructions
Compiling ICU 4.4 on Solaris 9 (SunOS 5.9)
Installation Instructions
Compiling ICU 4.2 on Solaris 9 (SunOS 5.9)
Installation Instructions
Compiling ICU 3.6 on Solaris 9 (SunOS 5.9)
Installation Instructions
Building Encryption Libraries
Building Encryption Libraries
Ubuntu 8.04 LTS (x86_64)
Red Hat Enterprise Linux 5.4 (x86_64)
Red Hat Enterprise Linux 5.5 (x86)
Red Hat Enterprise Linux 5.3 (IA64)
IBM z/OS (zSeries)
GPG-ERROR
GCRYPT
GPGME
GNUPG
IBM AIX 5.3 (pSeries)
GPG-ERROR
CRYPTO (From OpenSSL)
GPGME
GNUPG
Solaris 9 and 10 (SPARC)
GPG-ERROR
GCRYPT
GPGME
GNUPG
HP-UX 11.31 (IA64)
GPG-ERROR
GCRYPT
GPGME
GNUPG
SUSE Linux Enterprise Server 11 (x86_64)
SUSE Linux Enterprise Server 11 (s390x)
SUSE Linux Enterprise Server 10 (s390x)
GT.M Security Philosophy
Philosophy
Normal User and Group Id Rule
Exceptions
Shared Memory Exception for BG
gtmsecshr Exception
Triggers
Recommendations
gtmsecshr commands
Shared Resource Authorization Permissions
GTMPCAT - GT.M Process/Core Analysis Tool
Overview
Usage
Interactive Mode
Packaging GT.M Applications
Setting up a Captive User Application with GT.M
Sample .profile
Invoking GT.M through a C main() program
Defensive Practices
Other
Glossary
Index
Search
