Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)FrançaisItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Manage the OpenEdge Database

Specialized dump and load techniques

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Database Basics
    • Creating and Deleting Databases
      • Ways to create an OpenEdge database
      • Database creation and large file support
      • Create a database with PROSTRCT CREATE
        • Creating a structure description file
          • Extent pathnames and naming conventions
          • Rules for creating storage areas and extents
          • Extent length
          • Example structure description file
          • Example structure description file for large files
        • Create a database structure extent
          • Adding schema to a void database
      • Create a database with the PRODB utility
      • PRODB maintains pathname convention
      • Create a database with a Data tool
      • Convert an OpenEdge Release 11 Database to OpenEdge Release 12
      • Using the Schema Mover
      • Converting an OpenEdge Release 10 database to OpenEdge Release 12
      • Database conversion utilities
      • Copy a database
        • Copy a database using PROCOPY
          • PROCOPY uses absolute pathnames
      • Delete a database
    • OpenEdge RDBMS Limits
      • Database block sizes
      • Maximum number of records per block
      • Number and size of storage areas
        • Recovery sizes
      • Table and index limits
      • Number and size of sequences
      • Maximum size of the primary recovery (BI) area
      • Maximum database size
      • Number of connections per database
      • Number of simultaneous transactions per database
      • OpenEdge database name limits
      • File Handles
      • Shared memory
      • Data types and values
    • Starting Up and Shutting Down
      • Unified Broker Framework
        • OpenEdge Management
        • OpenEdge Explorer
        • Managing database configurations
        • Using the DBMAN command-line utility
      • Starting a server or broker
        • Specifying international character sets
          • Specifying the operating character set
          • Specifying the character set name of the database log file
        • Network addressing using -S and -H
        • Starting multiple brokers using the same protocol
        • Accessing a server behind a firewall
        • Starting database brokers for TLS connections
      • Threaded Database Server Functionality Delivered on Windows NT64, AIX64, and Linux64 Platforms
        • Initiate a Threaded Server Process
        • Monitor Threaded Servers and Remote Connections
      • Starting and stopping background writers
        • Starting and stopping an APW
        • Starting and stopping a BIW
        • Starting and stopping an AIW
      • Stopping a server or broker
        • PROSHUT command
        • PROMON shut down database option
  • Protecting Your Data
    • Backup Strategies
      • Identifying files for backup
      • Determining the type of backup
        • Full backups
        • Incremental backups
        • Online backups
        • Offline backups
      • Choosing backup media
      • Creating a backup schedule
        • Database integrity
        • Database size
        • Time
        • Unscheduled backups
    • Backing Up a Database
      • Using PROBKUP
        • Performing an online full backup with PROBKUP
          • UNIX full backup example
          • Backup Counter Increment limits using the PROBKUP Utility with Type I storage areas
        • Testing backups
        • Archiving backups
      • Performing an offline backup
      • Performing an online backup
        • Improving performance of an online backup
      • Using database quiet points
      • Performing an operating system backup
      • Database backup examples
        • Incremental backup example
        • Full backup example
      • Verifying a backup
      • CRC codes and redundancy in backup recovery
        • CRC codes
        • Error-correction blocks
      • Restoring a database
        • Using the PROREST utility to restore a database
        • Important rules for restoring backups
        • Obtaining storage area descriptions using PROREST
        • Database restore examples
          • Full backup restore example
          • Incremental backup restore example
    • Recovering a Database
      • Introduction to recovery mechanisms
        • Crash recovery
        • Roll-forward recovery
        • Two-phase commit
      • File locations that ensure safe recovery
      • Developing a recovery plan
        • Time needed for recovery
        • Recovery guidelines
      • Sample recovery plans
        • Example 1: Low availability requirements
        • Example 2: Moderate availability requirements
        • Example 3: Moderate-to-high availability requirements
        • Example 4: high availability requirements
        • Sample recovery scenarios
      • After-imaging and roll-forward recovery commands
      • Recovering from system failures
        • System crash while running RFUTIL ROLL FORWARD
        • System crash while running other utilities
        • System crash while backing up the database
        • System crash while database is up
      • Recovering from media failures
        • Loss of the DB files, BI files, or both
        • Loss of the AI file
        • Loss of database backup
        • Loss of transaction log file
      • Recovering from a full disk
        • After-image area disk
        • Control or primary recovery area disk
          • BI file not on full disk
          • BI file on the full disk
        • Transaction log file disk
      • Truncating the BI file
      • Releasing shared memory
      • Recovering from a lost or damaged control area
      • Unlocking damaged databases
      • Dumping tables from a damaged database
      • Forcing access to a damaged database
    • After-imaging
      • After-image areas and extents
        • Fixed-length extents
        • Variable-length extents
      • Estimating after-imaging disk space requirements
      • Creating after-image areas
        • Adding AI areas to an existing database
      • Enabling after-imaging offline
        • Enabling encrypted after-imaging offline for an encryption-enabled database
        • Enabling unencrypted after-imaging offline for an encryption-enabled database
      • Enabling after-imaging online
        • Enabling encrypted after-imaging online for an encryption-enabled database
        • Enabling unencrypted after-imaging online for an encryption-enabled database
      • Managing after-imaging files
        • Monitoring AI file status
        • Switching to a new AI file
          • Switch to the next extent in the sequence
        • Archiving an AI file
          • Scheduling backups
          • Performing the backup
          • Protecting the backup
          • Extracting AI blocks
        • Making an AI file available for reuse
      • AI File Management utility
        • Automatic extent archiving
          • Timed mode archiving process without OpenEdge Replication
          • Timed mode archiving process with OpenEdge Replication
          • On-demand archiving process without OpenEdge Replication
          • On-demand archiving process with OpenEdge Replication
        • Enabling your database for automated AI file management
          • Enabling an offline database for automated AI file management
          • Enabling an online database for automated AI file management
          • Additional info for enabling automated AI file management
        • Monitoring and adjusting automated AI File Management
        • Restarting the AI file management utility daemon
        • Archived extents
        • Archive log file
          • Version indicator record
          • Archive record
          • Backup record
        • Database recovery with an archival log
      • Add and reorder AI extents
      • Performing roll-forward recovery
        • Roll forward with the OPLOCK qualifier
          • Treatment of operations while under protection
        • Rolling forward multiple files
          • Applying after-images files from a list
      • After-image sequences
        • Sequence not required
        • Sequence required
      • Disabling after-imaging
        • Disabling encryption of AI files when disabling after-imaging
    • Maintaining Security
      • Establishing an OpenEdge user ID and password
        • OpenEdge user IDs
        • OpenEdge passwords
        • Validating an OpenEdge user ID and password
      • Establishing authentication for your OpenEdge database
        • Tables used from ABL only
        • Tables used from SQL only
        • Tables used from both ABL and SQL
      • Connection security
        • Designating valid users in the _User table accounts
        • Designating a security administrator
          • Entering user IDs for security administrators
        • Deleting a user from the _User table accounts
        • Changing a password for database users
      • Running a user report
      • Schema security
        • Freezing and unfreezing schema
      • Operating systems and database security
    • Auditing
      • Auditable events
        • Audit events
        • Security events
        • Schema events
        • Data events
        • Administration events
        • Utility events
        • User events
        • Application events
      • Auditing states
      • Enabling and disabling auditing
        • Enabling auditing
        • Re-enabling auditing from a deactivated state
        • Disabling auditing
      • Auditing tables
        • Indexes on auditing tables
      • Archiving audit data
        • Audit archive process
          • Basic archive process
          • Archive process with seal verification
      • Reconfiguring audit areas
        • Split one audit area into separate data and index areas
        • Combine audit data and index areas into one area
        • Move existing audit data and indexes to new areas
        • Purge data in existing audit data areas
      • Auditing impact on database resources
      • Auditing impact on database utilities
        • Identifying the privileged user
          • _User table
          • Local operating system login
          • Specifying encoded passwords
      • Utility modifications
        • Protected tables
        • Protected areas
        • Enhanced utilities
        • Expanded PROUTIL syntax
    • Transparent Data Encryption
      • Overview
        • Before you start
        • What is encryptable
        • Data considerations
        • Database key store
          • Configuring key store access
        • OpenEdge supported ciphers
      • Enabling Encryption
        • Adding an encryption policy area
        • Running ENABLEENCRYPTION
        • Enabling BI file encryption after enabling encryption
        • Enabling AI file encryption after enabling encryption
        • Verifying enablements
      • Creating encryption policies
        • Creating encryption policies with PROUTIL EPOLICY
        • Creating encryption policies with Data Admin
      • Encrypting your existing data
        • EPOLICY MANAGE UPDATE EXAMPLE
        • All new data is encrypted
      • Running with Transparent Data Encryption enabled
        • Manual start
        • Autostart
          • Change autostart configuration
          • Disabling autostart
          • Temporary files
        • Restricted utility access
        • Database backups
        • Moving tables and indexes
        • Binary dump and load of data
        • Auditing Transparent Data Encryption
        • Replication support
      • Maintaining Transparent Data Encryption
        • Rekey encryption policies with Data Admin
        • Rekey encryption policies with PROUTIL EPOLICY
          • Change the cipher of an encryption policy
        • Viewing encryption policy history in Data Admin
      • Disabling encryption
      • OpenEdge SQL support for Transparent Data Encryption
    • Replicating Data
      • Replication schemes
        • Trigger-based replication
        • Log-based site replication
        • Asynchronous replication
      • Database ownership models
        • Distribution model
        • Consolidation model
          • Peer-to-peer model
      • Implementing log-based site replication
        • Log-based replication procedure
    • Failover Clusters
    • Distributed Transaction Processing
      • Distributed transactions
      • Two-phase commit with ABL clients
        • How the database engine implements two-phase commit
        • Two-phase commit and roll-forward recovery
        • Enabling two-phase commit
        • Modifying the database nickname and priority
        • Transaction log area
        • Deactivating two-phase commit
        • Limbo transactions with two-phase commit
        • Resolve limbo transactions
        • Resolving limbo transactions with PROUTIL
        • Resolving limbo transaction scenarios
          • Scenario 1: You are on a client machine and the server fails
          • Scenario 2: You are starting up PROUTIL and have a power failure
          • Scenario 3: You are on a client machine and it fails
        • Two-phase commit case study
      • Java Transaction API (JTA) support
        • JTA resource impact
        • JTA processing impact
        • Enabling JTA support
        • Disabling JTA support
        • JTA transactions and OpenEdge Replication
        • Monitoring JTA transactions
        • Resolve JTA transactions
  • Maintaining and Monitoring Your Database
    • Managing Performance
      • Introduction to performance management
      • Tools for monitoring performance
        • PROMON utility
        • Virtual system tables
      • Server performance factors
        • CPU usage
        • Disk I/O
        • Database I/O
          • Storage areas
          • Database buffers
          • How the database engine writes modified buffers
          • Monitoring database buffer activity
          • Tuning database buffers
          • Using private read-only buffers
          • Using APWs to improve performance
          • Monitoring APWs
          • Monitoring user I/O
          • LRU Concurrency
        • Before-image I/O
          • Monitoring BI activity
          • Moving the BI file
          • Using a before-image writer
          • Providing more BI buffers
          • Increasing the BI cluster size
          • Increasing the number of BI clusters
          • Increasing the BI block size
          • Delaying BI writes
          • Setting a BI threshold
          • Enabling threshold stall
          • Using PROQUIET to adjust the BI threshold
        • After-image I/O
          • Monitoring AI activity
          • Using an after-image writer
          • Increasing the AI block size
        • Direct I/O
      • Memory usage
        • Process address space overview
        • Controlling memory use
        • Shared memory allocation
        • Shared memory and kernel configuration
        • Monitoring memory use
        • Shared memory summary
      • Alternate Buffer Pool
        • Overview
        • Designating objects to the Alternate Buffer Pool
          • Specifying areas for the Alternate Buffer Pool
          • Specifying objects for the Alternate Buffer Pool
          • Data definition files
        • Viewing Alternate Buffer Pool selections
          • Viewing Alternate Buffer Pool settings with the Data Dictionary
          • Viewing Alternate Buffer Pool settings with PROUTIL
        • Allocating Alternate Buffer Pool
      • Operating system resources
        • Processes
        • Semaphores
          • Allocating semaphores
        • Spin locks
        • File descriptors
      • Network Communication
        • Prefetch tuning
          • Enabling prefetch delay
          • Specifying number of records prefetched
          • Specifying the percent of a network buffer used for prefetch records
          • Calculating prefetch buffer utilization
          • Prefetch priority
        • Message wait
      • Database fragmentation
        • Analyzing database fragmentation
        • Eliminating database fragmentation
        • Managing fragmentation
      • Index use
        • Analyzing index use
        • Compacting indexes
        • Index utilities
        • Rebuilding indexes
          • Overcoming SRT size limitations
          • Maximizing index rebuild performance
          • Reactivating unique indexes
        • Activate a single index
        • Database Client Notification
      • Changing Database Client Notification poll time
      • Change database parameters while the database is running
      • Virtual system tables
    • Maintaining Database Structure
      • OpenEdge Structure utility
      • OpenEdge Structure Statistics utility
      • OpenEdge Structure List utility
      • Using the OpenEdge Structure Add utility
        • PROSTRCT ADD and pathnames
        • Add extents to existing storage areas
      • OpenEdge Structure Add Online utility
      • Extend variable-length database extents
      • Area numbers
        • Area number assignment
        • Trimming unused area memory
        • Error checking
          • Server startup
          • Adding areas online
      • Validating structure description files
      • Using the OpenEdge Structure Remove utility
      • Maintaining indexes and tables
        • Moving tables
        • Change non-structural fields of _File and _Field online
        • Change Int to Int64 online
        • Moving indexes
        • Compacting indexes
      • Performing chain analysis online
        • Important considerations when performing chain analysis online
      • Using virtual system tables
    • Multi-tenant database
      • Multi-tenant database introduction
      • Multi-tenant database architecture
        • Simple tenancy
        • Multi-tenant groups
        • Multi-tenant features
      • Enable multi-tenancy
      • Creating multi-tenant elements
        • Database administration tools
          • Database Administration Console
          • Data Dictionary
          • Data Administration
        • ABL
        • OpenEdge SQL
      • Tenant Data Recovery
        • Restrictions
        • Step 1: Restoring your database backup
        • Step 1A: restricting access to your temporary database
        • Step 2: Rolling forward after-image files
        • Step 3: Moving data with PROUTIL DATAMOVE
          • Move one table with the DATAMOVE command line
          • Move one sequence with the DATAMOVE command line
        • Move multiple tables and sequences with the DATAMOVE user interface
          • Move table data by tenant
          • Move Sequence values by tenant
          • Move table data by group
          • Set records per transaction
        • Step 4: Tenant data recovery clean up
          • Remove access restriction from your source database
          • Delete source database
      • Database utilities
        • Unchanged utilities
        • Indirectly changed utilities
        • Multi-tenant aware utilities
        • Multi-tenant index rebuild
        • Controlling the usage of multi-tenant database resources using multi-tenant governors
        • Showing syntax help for database utilities
    • Table-partitioned database
      • Table partitioning details
      • Table partition types
      • Table partitioning restrictions
      • Indexes for table partitions
      • Partitioning your database
      • Managing partitions
        • Splitting partitions
        • Merging partitions
        • Truncating partitions
        • Renaming partitions
        • Altering partition state
        • Viewing partitions
        • Copying partition data
          • Restrictions on copying a partition
          • Step 1: Restoring your database backup
          • Step 1A: restricting access to your temporary database
          • Step 2: Rolling forward after-image files
          • Step 3: Moving data with PROUTIL PARTITIONMANAGE COPY
            • Copy one partition with the PARTITIONMANAGE COPY command line
            • Copy multiple partitions with the PARTITIONMANAGE COPY user interface
          • Step 4: Partition copy clean up
            • Remove access restriction from your source database
            • Clear partition copy pending state
      • Partition-level database administration
        • Partition-scoped utilities
        • Table-partitioned index rebuild
    • Change Data Capture
      • Change Data Capture highlights
      • CDC and other RDBMS features
      • Enabling CDC
      • Using the CDC cache
    • Diagnostic Data Collection
      • Events
        • Specifying an event
        • Event Levels
      • Data Files
      • Protrace data
      • C stack print option (-cstackPrintopt)
      • DiagProc file
      • Diagnostic data startup parameters
      • Diagnostic data collection in PROMON
        • Diagnostic Data Collection menu
      • Diagnostic data output file formats
        • Diagnostic tracking file
        • Diagnostic BI threshold files
        • Lock table overflow files
        • Syserror event files
    • Dumping and Loading
      • Overview of dumping and loading
        • Dump and load limitations
      • Dumping ABL database definitions
        • Dumping ABL database or table definitions
        • Definition file format
        • Multi-tenant keywords
        • Creating an incremental ABL data definitions file
        • Dumping sequence definitions
        • Dumping auto-connect records
      • Dump Change Data Capture policies
      • Load Change Data Capture policies
      • Dumping database contents
        • Dumping table contents with PROUTIL
          • Results of a binary dump with PROUTIL
          • Format of a binary dump file
        • Dumping selective contents with PROUTIL
        • Dumping table contents with a Data tool
        • Contents file format
        • Dumping sequence values with a Data tool
        • Dumping user table contents with a Data tool
        • Dumping an SQL view file's contents with a Data tool
      • Loading database definitions
        • Loading updated ABL data definitions
      • Loading database contents
        • Loading table contents in binary format with PROUTIL
          • Recovering from an aborted binary load
        • Loading table contents with a Data tool
        • Loading user table contents with a Data tool
        • Loading an SQL view file contents
        • Loading sequence values using a Data tool
      • Bulk loading
        • Creating a Bulk Loader description file
        • Modify a Bulk Loader description file
        • Load table contents with the Bulk Loader qualifier
      • Reconstruct bad load records
      • Specialized dump and load techniques
        • Creating a starting version of a database
        • Using a constant table in multiple databases
        • Economizing disk space
        • Optimizing data for sequential access
        • Optimizing data for random access
        • Using no-integrity mode bulk data loading
        • Saving disk space by deactivating indexes
          • Deactivating indexes from Data Administration
          • Deactivating indexes from the Data Dictionary
    • Logged Data
      • OpenEdge database log file
      • Database log file customization
      • Managing log file size
      • Log file archive and truncate
        • Log file truncate and archive startup parameters
        • PROMON Database Log file management
        • _DbParams VST
        • Archiving
        • Truncated and archived files
      • Saving key database events
        • Defining key events
        • Saving key events
        • Enabling save key events
        • Disabling save key events
        • Stored key events
        • _KeyEvt table
          • _KeyEvt table creation
          • _KeyEvt schema
          • _KeyEvt table maintenance
      • Event logging in Windows
        • Manage OpenEdge RDBMS events in Windows
        • Understand the event log components
        • The Event Log and the registry
      • Client database-request statement caching
      • Find connected brokers and servers
  • Reference
    • Startup and Shutdown Commands
      • Startup command syntax
      • Database startup and shutdown commands
      • PROAIW command
      • PROAPW command
      • PROBIW command
      • PROQUIET command
      • PROSERVE command
      • PROSHUT command
      • PROWDOG command
    • Database Startup Parameters
      • Issuing startup parameters
      • Database server performance parameters
      • Database server-type parameters
      • Database server internationalization parameters
      • Database server statistics parameters
      • Database server consistency check parameters
      • Database server TLS connection parameters
      • Database server network parameters
      • Startup parameter usage categories
      • Alphabetical listing of database startup parameters
        • AdminServer Port (-adminport)
        • After-image File Management Archive Directory List (-aiarcdir)
        • After-image File Management Archive Directory Create (-aiarcdircreate)
        • After-image File Management Archive Interval (-aiarcinterval)
        • After-image Buffers (-aibufs)
        • After-image Stall (-aistall)
        • Area consistency check (-AreaCheck)
        • Blocks in Database Buffers (-B)
        • Blocks in Alternate Buffer Pool (-B2)
        • Base Index (-baseindex)
        • Base LOB (-baselob)
        • Base Table (-basetable)
        • Base user index (-baseuserindex)
        • Base user LOB (-baseuserlob)
        • Base user table (-baseusertable)
        • Before-image Buffers (-bibufs)
        • Threshold Stall (-bistall)
        • Recovery Log Threshold (-bithold)
        • Maximum Private Buffers per Connection (-Bpmax)
        • Schema Cache File (-cache)
        • CDC cache size (-cdcsize)
        • SQL Server Java Classpath (-classpath)
        • Cluster Mode (-cluster)
        • Conversion Map (-convmap)
        • Case Table (-cpcase)
        • Collation Table (-cpcoll)
        • Internal Code Page (-cpinternal)
          • Conversion Map (-convmap)
        • Log File Code Page (-cplog)
        • Print Code Page (-cpprint)
        • R-code in Code Page (-cprcodein)
        • Stream Code Page (-cpstream)
        • Terminal Code Page (-cpterm)
        • Crash Recovery Status (-crStatus)
        • Crash Recovery Transaction Display (-crTXDisplay)
        • C stack print option (-cstackPrintopt)
        • Database consistency check (-DbCheck)
        • Database Notification Operations (-dbnotifyops)
        • Database Notification Time (-dbnotifytime)
        • Delayed BI File Write (-Mf)
        • Diagnostic directory (-diagDir)
        • Diagnostic events value (-diagEvent)
        • Diagnostic event level (-diagEvtLevel)
        • Diagnostic data format (-diagFormat)
        • Diagnostic field separator (-diagFS)
        • Diagnostic pause length (-diagPause)
        • Diagnostic prefix value (-diagPrefix)
        • Diagnostic process (-diagProc)
        • Direct I/O (-directio)
        • Encryption cache size (-ecsize)
        • Enforce Mm (-enforceMm)
        • Event Level (-evtlevel)
        • Before-image Truncate Interval (-G)
        • Group Delay (-groupdelay)
        • Host Name (-H)
        • Hash Table Entries (-hash)
        • No Crash Protection (-i)
        • Index consistency check (-IndexCheck)
        • Index Range Size (-indexrangesize)
        • Internet Protocol (-ipver)
        • Key Alias (-keyalias)
        • Key Alias Password (-keyaliaspasswd)
        • Lock Table Entries (-L)
        • Lock Governor (-LGovernor)
        • Log file archive enable (-lgArchiveEnable)
        • Log file archive directory (-lgArchiveDir)
        • Log file truncate frequency (-lgTruncateFrequency)
        • Log file truncate size (-lgTruncateSize)
        • Log file truncate time (-lgTruncateTime)
        • Limit log file payload (-limitLgPayload)
        • Lock Table Hash Size (-lkhash)
        • Lock release (-lkrela)
        • LOB range (-lobrangesize)
        • LRU force skips (-lruskips)
        • LRU alternate buffer pool force skips (-lru2skips)
        • Auto Server (-m1)
        • Secondary Login Broker (-m3)
        • Maximum area number (-maxAreas)
        • Maximum Clients per Server (-Ma)
        • Maximum Dynamic Server (-maxport)
        • Maximum JTA Transactions (-maxxids)
        • Memory consistency check (-MemCheck)
        • Minimum Clients per Server (-Mi)
        • Minimum Dynamic Server (-minport)
        • Message Buffer Size (-Mm)
        • Maximum Servers (-Mn)
        • Servers per Protocol (-Mp)
        • Maximum Servers Per Broker (-Mpb)
        • Multi-tenancy Partition Cache Size (-mtpmsize)
        • User MUX Latches (-mux)
        • Shared-memory Overflow Size (-Mxs)
        • Network Type (-N)
        • Number of Users (-n)
        • Nap Time (-nap)
        • Nap Maximum (-napmax)
        • Nap Time Steps (-napstep)
        • Login Governor (-nGovernor)
        • Message Wait (-Nmsgwait)
        • TLS No Host Verify (-nohostverify)
        • No Session Cache (-nosessioncache)
        • No Session Reuse (-nosessionreuse)
        • Number of checkpoint statistics (-numCheckpointStats)
        • Omit Log Messages (-omitLgMsgs)
        • Storage Object Cache Size (-omsize)
        • Prompt for Passphrase (-Passphrase)
        • Pending Connection Time (-PendConnTime)
        • Parameter File (-pf)
        • Database Service Communication Area Size (-pica)
        • Database PICA Queue Nap Time (-picanap)
        • Pin Shared Memory (-pinshm)
        • Prefetch delay (-prefetchDelay)
        • Prefetch factor (-prefetchFactor)
        • Prefetch Num Recs (-prefetchNumRecs)
        • Prefetch Priority (-prefetchPriority)
        • Configuration Properties File (-properties)
        • Buffered I/O (-r)
        • Record free chain search depth factor (-recspacesearchdepth)
        • Service Name (-S)
        • Schema Lock Wait Queue(-schlockwq)
        • Security cache size (-secsize)
        • Semaphore Sets (-semsets)
        • Server Group (-servergroup)
        • Type of Server to Start (-ServerType)
        • Session Timeout (-sessiontimeout)
        • Shared memory segment size (-shmsegsize)
        • Spin Lock Retries (-spin)
        • Autonomous Update Statistics (-SQLAutoStats)
        • SQL Open Cursors (-SQLCursors)
        • Lock Wait Timeout (-SQLLockWaitTimeout)
        • SQL rowid identifier(-SQLQuotedRowid)
        • SQL Stack Size (-SQLStack)
        • SQL Statement Cache Size (-SQLStmtCache)
        • SQL Sorting Memory (-SQLTempBuff)
        • SQL Sorting on Disk (-SQLTempDisk)
        • SQL Temp Table Data Page (-SQLTempPageSize)
        • Authorized Data Truncation(-SQLTruncateTooLarge)
        • Autonomous Schema Update (-SQLWidthUpdate)
        • Server-side join (-ssj)
        • TLS Encryption for TCP/IP Connections (-ssl)
        • STS logging level (-stslogginglevel)
        • Temporary Directory (-T)
        • Table consistency check (-TableCheck)
        • Table Range Size (-tablerangesize)
        • Threaded Server (-threadedServer)
        • Threaded Server Stack (-threadedServerStack)
        • Transaction End (TXE) Lock Retry Limit (-TXERetryLimit)
        • Transaction End (TXE) Lock Skip Limit (-TXESkipLimit)
        • User index range (-userindexrangesize)
        • User LOB range (-userlobrangesize)
        • User Table Range (-usertablerangesize)
        • Database Client Notification (-usernotifytime)
        • Century Year Offset (-yy)
    • PROMON Utility
      • PROMON utility
      • PROMON User Control option
      • PROMON Locking and Waiting statistics option
      • PROMON Block Access option
      • PROMON Record Locking Table option
      • PROMON Activity option
      • PROMON Shared Resources option
      • PROMON Database Status option
      • PROMON Shut Down Database option
      • PROMON Currently Connected Tenants option
      • PROMON R&D Advanced Options
      • R&D Status Displays
        • Database
        • Backup
        • Servers
        • Processes/Clients
        • Files
        • Lock Table
        • Buffer Cache
        • Logging Summary
        • BI Log
        • AI Log
        • Two-phase Commit
        • Startup Parameters
        • Shared Resources
        • Shared Memory Segments
        • AI Extents
        • Database Service Manager
        • Servers by broker
        • Client Database-Request Statement Cache
          • Activating database-request statement caching for selected users
          • Activating database-request statement caching for all users
          • Activating database-request statement caching for all future users
          • Deactivating database-request statement caching for selected users
          • Viewing database-request statement caching
          • Specifying a directory for database-request statement caching files
        • Schema Locks & Wait Queue
        • Broker Startup Parameters
      • R&D Activity Displays
        • Summary
        • Servers
        • Buffer Cache
        • Page Writers
        • BI Log
        • AI Log
        • Lock Table
        • I/O Operations By Type
        • I/O Operations by File
        • Space Allocation
        • Index
        • Record
        • Other
      • R&D Other Displays
        • Performance Indicators
        • I/O Operations by Process
        • Lock Requests by User
        • Checkpoints
        • I/O Operations by User by Table
        • I/O Operations by User by Index
        • LOB I/O operations in PROMON
        • Total Locks per User
      • R&D Administrative Functions
        • Check Active Transaction Status
        • Check Two-Phase Transactions
        • Resolve Limbo Transactions
        • Adjust Latch Options
        • Adjust Page Writer Options
        • Restricted Options
        • Server Options
        • Enable/disable block level consistency check
        • Shutdown Database
        • Disconnect a tenant's users
        • Adjust Governor options
        • Caches
        • Diagnostic Data Collection
        • Modify database startup parameters online using PROMON
      • R&D Adjust Monitor Options
      • Advanced R&D
      • PROMON 2PC Transactions Control option
      • PROMON Resolve 2PC Limbo Transactions option
      • PROMON 2PC Coordinator Information option
      • PROMON Resolve JTA Transactions option
      • PROMON Modify Defaults option
    • PROUTIL Utility
      • PROUTIL utility syntax
      • PROUTIL 2PHASE BEGIN qualifier
      • PROUTIL 2PHASE COMMIT qualifier
      • PROUTIL 2PHASE END qualifier
      • PROUTIL 2PHASE MODIFY qualifier
      • PROUTIL 2PHASE RECOVER qualifier
      • PROUTIL AUDITARCHIVE qualifier
      • PROUTIL AUDITLOAD qualifier
      • PROUTIL AUDITRECONFIG qualifier
      • PROUTIL BIGROW qualifier
      • PROUTIL BULKLOAD qualifier
      • PROUTIL BUSY qualifier
      • PROUTIL CHANALYS qualifier
      • PROUTIL CODEPAGE-COMPILER qualifier
      • PROUTIL CONV1112 qualifier
      • PROUTIL CONVCHAR qualifier
      • PROUTIL CONVFILE qualifier
      • PROUTIL DATAMOVE qualifier
      • PROUTIL DBANALYS qualifier
        • Database analysis output
          • Output file format
      • PROUTIL DBAUTHKEY qualifier
      • PROUTIL DBIPCS qualifier
      • PROUTIL DBRESTRICT qualifier
      • PROUTIL DEALLOCATE qualifier
      • PROUTIL DESCRIBE qualifier
      • PROUTIL DISABLEAUDITING qualifier
      • PROUTIL DISABLEAUTHGATEWAY qualifier
      • PROUTIL DISABLEB2 qualifier
      • PROUTIL DISABLECDC qualifier
      • PROUTIL DISABLEENCRYPTION qualifier
      • PROUTIL DISABLEJTA qualifier
      • PROUTIL DISABLEKEYEVENTS qualifier
      • PROUTIL DISABLEMULTITENANCY qualifier
      • PROUTIL DISABLEREADONLYPARTITIONS qualifier
      • PROUTIL DISABLETABLEPARTITIONING qualifier
      • PROUTIL DISPTOSSCREATELIMITS qualifier
      • PROUTIL DUMP qualifier
      • PROUTIL DUMPSPECIFIED qualifier
      • PROUTIL ENABLEAUDITING qualifier
      • PROUTIL ENABLEAUTHGATEWAY qualifier
      • PROUTIL ENABLEB2 qualifier
      • PROUTIL ENABLECDC qualifier
      • PROUTIL ENABLEENCRYPTION qualifier
      • PROUTIL ENABLEJTA qualifier
      • PROUTIL ENABLEKEYEVENTS qualifier
      • PROUTIL ENABLELARGEKEYS qualifier
      • PROUTIL ENABLEMULTITENANCY qualifier
      • PROUTIL ENABLEREADONLYPARTITIONS qualifier
      • PROUTIL ENABLESTOREDPROC qualifier
      • PROUTIL ENABLETABLEPARTITIONING qualifier
      • PROUTIL EPOLICY INFO qualifier
      • PROUTIL EPOLICY MANAGE qualifier
      • PROUTIL EPOLICY SCAN qualifier
      • PROUTIL EPOLICY VIEW qualifier
      • PROUTIL HOLDER qualifier
      • PROUTIL IDXACTIVATE qualifier
      • PROUTIL IDXBLOCKREPORT qualifier
      • PROUTIL IDXANALYS qualifier
      • PROUTIL IDXBUILD qualifier
      • PROUTIL IDXCHECK qualifier
      • PROUTIL IDXCOMPACT qualifier
      • PROUTIL IDXDEACTIVATE
      • PROUTIL IDXFIX qualifier
      • PROUTIL IDXMOVE qualifier
      • PROUTIL INCREASETO qualifier
      • PROUTIL IOSTATS qualifier
      • PROUTIL LOAD qualifier
      • PROUTIL MTIDXBUILD qualifier
      • PROUTIL MVSCH qualifier
      • PROUTIL PARTITIONMANAGE ALTER qualifier
      • PROUTIL PARTITIONMANAGE COPY qualifier
      • PROUTIL PARTITIONMANAGE MERGE qualifier
      • PROUTIL PARTITIONMANAGE RENAME qualifier
      • PROUTIL PARTITIONMANAGE SPLIT qualifier
      • PROUTIL PARTITIONMANAGE TRUNCATE qualifier
      • PROUTIL PARTITIONMANAGE VIEW qualifier
      • PROUTIL RCODEKEY qualifier
      • PROUTIL SETAREACREATELIMIT qualifier
      • PROUTIL SETAREATOSSLIMIT qualifier
      • PROUTIL SETLOBCREATELIMIT qualifier
      • PROUTIL SETLOBTOSSLIMIT qualifier
      • PROUTIL SETTABLECREATELIMIT qualifier
      • PROUTIL SETTABLETOSSLIMIT qualifier
      • PROUTIL TABANALYS qualifier
      • PROUTIL TABLEMOVE qualifier
      • PROUTIL TPIDXBUILD qualifier
      • PROUTIL TRUNCATE AREA qualifier
      • PROUTIL TRUNCATE BI qualifier
      • PROUTIL UPDATESCHEMA qualifier
      • PROUTIL UPDATEVST qualifier
      • PROUTIL VIEWB2 qualifier
      • PROUTIL WBREAK-COMPILER qualifier
      • PROUTIL WORD-RULES qualifier
      • PROUTIL ZEROSTATS qualifier
    • PROSTRCT Utility
      • PROSTRCT utility
      • PROSTRCT ADD qualifier
      • PROSTRCT ADDONLINE qualifier
      • PROSTRCT BUILDDB qualifier
      • PROSTRCT CREATE qualifier
      • PROSTRCT LIST qualifier
      • PROSTRCT REMOVE qualifier
      • PROSTRCT REORDER AI qualifier
      • PROSTRCT REPAIR qualifier
      • PROSTRCT STATISTICS qualifier
      • PROSTRCT UNLOCK qualifier
    • RFUTIL Utility
      • RFUTIL utility syntax
      • RFUTIL AIARCHIVER DISABLE qualifier
      • RFUTIL AIARCHIVER ENABLE qualifier
      • RFUTIL AIARCHIVER END qualifier
      • RFUTIL AIARCHIVER SETDIR qualifier
      • RFUTIL AIARCHIVER SETINTERVAL qualifier
      • RFUTIL AIARCHIVE EXTENT qualifier
      • RFUTIL AIARCHIVE NEXTEXTENT qualifier
      • RFUTIL AIMAGE AIOFF qualifier
      • RFUTIL AIMAGE BEGIN qualifier
      • RFUTIL AIMAGE END qualifier
      • RFUTIL AIMAGE EXTENT EMPTY qualifier
      • RFUTIL AIMAGE EXTENT FULL qualifier
      • RFUTIL AIMAGE EXTENT LIST qualifier
      • RFUTIL AIMAGE EXTRACT qualifier
      • RFUTIL AIMAGE NEW qualifier
      • RFUTIL AIMAGE QUERY qualifier
      • RFUTIL AIMAGE SCAN qualifier
      • RFUTIL AIMAGE TRUNCATE qualifier
      • RFUTIL AIVERIFY PARTIAL qualifier
      • RFUTIL AIVERIFY FULL qualifier
      • RFUTIL MARK BACKEDUP qualifier
      • RFUTIL ROLL FORWARD qualifier
      • RFUTIL ROLL FORWARD OPLOCK qualifier
      • RFUTIL ROLL FORWARD RETRY qualifier
      • RFUTIL ROLL OPUNLOCK qualifier
      • RFUTIL SEQUENCE qualifier
    • Other Database Administration Utilities
      • Parameters for authentication
      • DBMAN utility
      • DBPOLICYUTIL utility
      • DBTOOL utility
        • Running DBTOOL
      • DSRUTIL utility
      • PROADSV utility
      • PROBKUP utility
      • PROCOPY utility
      • PRODB utility
      • PRODEL utility
      • PROLOG utility
      • PROREST utility
    • SQL Utilities
      • SQLDUMP utility
      • SQLLOAD utility
      • SQLSCHEMA utility
    • Virtual System Tables
      • Update access to virtual system tables
      • Accessing VSTs with ABL or SQL
      • Modifiable VSTs on Replication Targets
      • VSTs for LOB Activity
      • Virtual system table summaries
        • After-image log activity (_ActAILog)
        • Before-image log activity (_ActBILog)
        • Buffer activity (_ActBuffer)
        • Index activity (_ActIndex)
        • Input/output activity (_ActIOFile)
        • Input/output type activity (_ActIOType)
        • Lock table activity (_ActLock)
        • Other activity (_ActOther)
        • Page writer activity (_ActPWs)
        • Record activity (_ActRecord)
        • Server activity (_ActServer)
        • Space allocation activity (_ActSpace)
        • Summary activity (_ActSummary)
        • Area status (_AreaStatus)
        • Area threshold (_AreaThreshold)
        • Block (_Block)
        • Buffer status (_BuffStatus)
        • Cache (_Cache)
        • Checkpoint (_Checkpoint)
        • Code Features (_Code-Feature)
        • Database connection (_Connect)
        • Database features (_Database-Feature)
        • Database startup parameters file status (_DbParams)
        • Database status (_DbStatus)
        • Database file status (_Filelist)
        • Index statistics (_IndexStat)
        • Latch statistics (_Latch)
        • License management (_License)
        • LOB activity (_LOBStat)
        • Lock table status (_Lock)
        • Lock request (_LockReq)
        • Logging (_Logging)
        • Master block (_MstrBlk)
          • Master block flags for troubleshooting damaged databases
        • User connection (_MyConnection)
        • Resource queue statistics (_Resrc)
        • Segments (_Segments)
        • Servers (_Servers)
        • SQL query plan (_SQL_Qplan)
        • Table statistics (_TableStat)
        • Transaction (_Trans)
        • Transaction end lock statistics (_TxeLock)
        • User index activity (_UserIndexStat)
        • Database input/output (_UserIO)
        • User LOB activity (_UserLOBStat)
        • Record locking table (_UserLock)
        • User status (_UserStatus)
        • User table activity (_UserTableStat)
Table of Contents

Specialized dump and load techniques

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: March 30, 2020
  • 1 minute read
    • OpenEdge
    • Version 12.2
    • Documentation

The following sections provide step-by-step instructions for dumping and loading data for specialized purposes.

Contents
  • Creating a starting version of a database
  • Using a constant table in multiple databases
  • Economizing disk space
  • Optimizing data for sequential access
  • Optimizing data for random access
  • Using no-integrity mode bulk data loading
  • Saving disk space by deactivating indexes
TitleResults for “How to create a CRG?”Also Available inAlert