Progress A Database Administration Guide and Reference.pdf

(3588 KB) Pobierz
Progress
Database Administration
Guide and Reference
778283023.001.png
© 2002 Progress Software Corporation. All rights reserved.
Progress ® software products are copyrighted and all rights are reserved by Progress Software Corporation. This manual is also
copyrighted and all rights are reserved. This manual may not, in whole or in part, be copied, photocopied, translated, or reduced
to any electronic medium or machine-readable form without prior consent, in writing, from Progress Software Corporation.
The information in this manual is subject to change without notice, and Progress Software Corporation assumes no responsibility
for any errors that may appear in this document.
The references in this manual to specific platforms supported are subject to change.
Progress, Powered by Progress, Progress Fast Track, Progress Profiles, Partners in Progress, Partners en Progress, Progress en
Partners, Progress in Progress, P.I.P., Progress Results, ProVision, ProCare, ProtoSpeed, SmartBeans, SpeedScript, and
WebSpeed are registered trademarks of Progress Software Corporation in the U.S. and other countries. A Data Center of Your
Very Own, Allegrix, Apptivity, AppsAlive, AppServer, ASPen, ASP-in-a-Box, Empowerment Center, Fathom, Future Proof,
IntelliStream, OpenEdge, PeerDirect, POSSE, POSSENET, Progress Dynamics, Progress Software Developers Network,
SectorAlliance, SmartObjects and WebClient are trademarks or service marks of Progress Software Corporation in the U.S. and
other countries.
SonicMQ is a registered trademark of Sonic Software Corporation in the U.S. and other countries.
Vermont Views is a registered trademark of Vermont Creative Software in the U.S. and other countries.
Java and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
Any other trademarks and/or service marks contained herein are the property of their respective owners.
Progress Software Corporation acknowledges the use of Raster Imaging Technology copyrighted by Snowbound Software 1993-
1997, the IBM XML Parser for Java Edition, and software developed by the Apache Software Foundation (http://
www.apache.org/).
© IBM Corporation 1998-1999. All rights reserved. U.S. Government Users Restricted Rights — Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
Progress is a registered trademark of Progress Software Corporation and is used by IBM Corporation in the mark Progress/400
under license. Progress/400 AND 400 ® are trademarks of IBM Corporation and are used by Progress Software Corporation
under license.
The implementation of the MD5 Message-Digest Algorithm used by Progress Software Corporation in certain of its products is
derived from the RSA Data Security, Inc. MD5 Message-Digest Algorithm.
May 2002
Product Code: 4590
Item Number: 89434;V9.1D
778283023.002.png 778283023.003.png
Contents
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxiii
Purpose . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxiii
Audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxiii
Organization of This Manual . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxiii
Part I Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxiii
Part II Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxiv
Part III Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxv
How To Use This Manual . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxvi
Typographical Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxvi
Syntax Notation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxvii
Example Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxxi
Progress Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxxiv
Other Useful Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxxvi
Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxxvi
Development Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxxvii
Reporting Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxxviii
4GL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xxxix
Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xl
DataServers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xl
SQL-89/Open Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xli
SQL-92 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xli
Deployment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xlii
WebSpeed. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xlii
Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
xliii
1.
The Progress Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–1
1.1
Progress Database Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–2
1.1.1
Other Database-related Files . . . . . . . . . . . . . . . . . . . . . . . . . .
1–4
1.2
Storage Design Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–5
778283023.004.png
Contents
1.2.1
Storage Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–7
1.2.2
Extents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–7
1.2.3
Storage Areas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–7
1.3
Determining Configuration Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–9
1.3.1
System Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–9
1.3.2
Connection Modes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–9
1.3.3
Database Location . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–10
1.3.4
Database Configurations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–10
1.4
Operating System Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–12
1.5
Multi-threaded Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–13
1.6
Multi-tier and Cluster Configurations . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–14
1.7
Self-service and Network Clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1–15
1.8
Relative- and Absolute-path Databases . . . . . . . . . . . . . . . . . . . . . . . . .
1–15
2.
Administrative Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
2–1
2.1
Block Size Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
2–2
2.1.1
Guidelines For Choosing Storage Area Locations . . . . . . . . . .
2–3
2.2
Calculating Database Disk Requirements . . . . . . . . . . . . . . . . . . . . . . . .
2–3
2.3
Storing Database Extents On Raw Partitions . . . . . . . . . . . . . . . . . . . . .
2–7
3.
Progress Database Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–1
3.1
Database Block Sizes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–2
3.2
Number and Size Of Storage Areas . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–2
3.3
Maximum Number Of Records Per Block . . . . . . . . . . . . . . . . . . . . . . . .
3–5
3.4
Table and Index Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–5
3.5
Number Of Sequences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–5
3.6
Maximum Size Of the Primary Recovery (BI) Area . . . . . . . . . . . . . . . . .
3–6
3.7
Maximum Database Size . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–6
3.8
Number Of Connections Per Database . . . . . . . . . . . . . . . . . . . . . . . . . .
3–7
3.9
Number Of Simultaneous Transactions Per Database . . . . . . . . . . . . . .
3–7
3.10
Size Of Database Buffer Pool . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–7
3.11
Progress Database Name Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–8
3.12
Applicable Operating System Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–8
3.13
Data Types and Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3–10
4.
Creating and Deleting Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4–1
4.1
Ways To Create a Progress Database . . . . . . . . . . . . . . . . . . . . . . . . . .
4–2
4.2
Creating a Database With PROSTRCT CREATE . . . . . . . . . . . . . . . . . .
4–2
4.2.1
Creating a Structure Description File . . . . . . . . . . . . . . . . . . .
4–3
4.2.2
Create a Database Structure Extent . . . . . . . . . . . . . . . . . . . .
4–10
4.2.3
Adding Schema To a Void Database . . . . . . . . . . . . . . . . . . . .
4–11
4.3
Creating a Database With the PRODB Utility . . . . . . . . . . . . . . . . . . . . .
4–12
4.4
Creating a Database With the Data Administration Tool . . . . . . . . . . . . .
4–14
4.5
Migrating Version 8 Databases To Version 9 Databases . . . . . . . . . . . .
4–15
iv
Contents
4.5.1
Converting a Single-volume Version 8 Database With
PROCOPY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4–16
4.5.2
Converting a Single-volume Version 8 Database With
PROREST . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4–17
4.5.3
Converting a Single-volume Version 8 Database With
PROSTRCT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4–18
4.5.4
Converting a Version 8 Database To Version 9. . . . . . . . . . . .
4–18
4.6
Using the Schema Mover After Conversion . . . . . . . . . . . . . . . . . . . . . .
4–19
4.7
Copying a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4–22
4.8
AutoConvert Utility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4–24
4.9
Deleting a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4–24
5.
Starting Up and Shutting Down . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5–1
5.1
The Progress Explorer Framework . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5–2
5.1.1
AdminServer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5–2
5.1.2
Progress Explorer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5–2
5.1.3
Command-line Configuration Utilities . . . . . . . . . . . . . . . . . . .
5–3
5.1.4
Using the DBMAN Command-Line Utility . . . . . . . . . . . . . . . .
5–4
5.2
Starting a Server Or Broker . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5–5
5.2.1
Using the PROSERVE Command . . . . . . . . . . . . . . . . . . . . . .
5–5
5.2.2
Specifying International Character Sets . . . . . . . . . . . . . . . . .
5–6
5.2.3
Network Addressing With Progress (- S and -H) . . . . . . . . . .
5–7
5.2.4
Starting Network Brokers and Servers. . . . . . . . . . . . . . . . . . .
5–7
5.2.5
Starting Multiple Brokers Using the Same Protocol . . . . . . . .
5–8
5.2.6
Accessing a Server Behind a Firewall . . . . . . . . . . . . . . . . . . .
5–9
5.3
Starting and Stopping Background Writers . . . . . . . . . . . . . . . . . . . . . .
5–10
5.3.1
Starting and Stopping an APW . . . . . . . . . . . . . . . . . . . . . . . .
5–10
5.3.2
Starting and Stopping a BIW . . . . . . . . . . . . . . . . . . . . . . . . . .
5–11
5.3.3
Starting and Stopping an AIW . . . . . . . . . . . . . . . . . . . . . . . . .
5–11
5.4
Stopping a Server Or Broker . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5–12
5.4.1
PROSHUT Command . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5–12
5.4.2
PROMON Shut Down Database Option . . . . . . . . . . . . . . . . .
5–15
6.
Backup and Recovery Strategies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–1
6.1
Identifying Files For Back Up . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–2
6.2
Determining the Type Of Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–3
6.2.1
Incremental Backups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–4
6.2.2
Online Backups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–5
6.2.3
Offline Backups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–6
6.3
Choosing Backup Media . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–6
6.4
Creating a Backup Schedule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–7
6.4.1
Database Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–7
6.4.2
Database Size . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–8
6.4.3
Time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
6–8
v

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin