BMC Products for DB2
  Installation and configuration
    APPLICATION RESTART CONTROL Administrator Guide
      Introduction
        Overview
        Working with REGISET records
          Types of records
          Record IDs
            Standard qualifiers
            Record ID qualifiers
          Wildcard characters in record qualifiers
          Order of REGISET records
          Examples of wildcard usage
            Example 1
            Example 2
            Example 3
            Example 4
        Getting started with the AR/CTL ISPF interface
          Setting up your ISPF session
          Using general panel elements
          Using the Application Enhancement Series primary menu
          Using the Limit List of Records panel
          Using the List Records panel
          Using the Add Record panel
          Using the Delete Record panel
          Using the Last Update Data panel
      Working with BMC Software subsystems
        BMC Software subsystems
          BMCP
          BCSS
          Multiple BCSSs
          AR/CTL components of the BCSS
          Subsystem procedure names
          Subsystem identifiers
          Types of procedure libraries
          CPU authorization passwords
          BCSS commands data set
          Registration data set DD statements
          Startup sequence of subsystems
        Executing the Installation Check program
          Edit and submit the job
          Check the output
        BMCP command tasks
          Starting the BMCP
          Terminating the BMCP
          Displaying the status of the BMCP
        BCSS operator console command tasks
          Starting the BCSS
          Terminating the BCSS
          Displaying the status of BCSS
          Reinitializing AR CTL components
        AR/CTL component command tasks
          Displaying the status of AR/CTL components
          Enabling AR/CTL components
          Disabling AR/CTL components
        Performing an orderly shutdown before IPL
        Using the AR/CTL Status Check utility
          Executing AESUVBCS as a stand-alone program
          Calling AESUVBCS from an application program
      Working with the REGISET
        REGISET structure and use
          Registration data sets
          Primary registration data sets
          Duplex registration data sets
          REGISET cache
          REGISET records
        Registration data set recovery
          Recovering a primary registration data set
            Recovery with another primary registration data set
            Recovery with a duplex registration data set
            Recovering from a backup copy
          Recovering a duplex registration data set
        REGISET backups
        AR/CTL REGISET population utility
          Records for AR/CTL
          Records for the BCF component of AR CTL
      Working with AR/CTL records
        Overview
        Working with AR/CTL records
          Using the Active BMC Consolidated Subsystems panel
        Working with AR/CTL global options
          AES application supervisor active
          Initialization error option
          Force BCF execution
          Force AR/CTL execution
          Program abend option
          Program return code option
          Normal termination SYSOUT class
        Setting AR/CTL processing options in the AESSYSIN data set
          Control statement syntax
          Keyword summary
        Using AESSYSIN keywords for DB2 connection information
          DB2PLAN keyword
          DB2SSNM keyword
        Working with non-IMS environment registration records
        Working with non-IMS program registration records
        Working with non-IMS program exclusion records
        Working with automatic registration records
          Overview
            Criteria sets
            Usage order
            Creation of non-IMS program registration records
          Enabling and disabling automatic non-IMS program registration
          Enabling and disabling SMF auditing
            Record selection
            Record formatting
          Accessing automatic registration records
          Specifying automatic registration record criteria
        Working with IMS environment registration records
        Working with IMS program registration records
        Working with IMS program exclusion records
      Working with AR/CTL environment options
        Overview
          Environment information
          Accessing the AR/CTL Operating Environment panel
        Displaying information about the operating environment
        Working with AR/CTL LIBDEF table
        Working with AR/CTL LIBDEF variables
        Setting print options
        Setting JOB statement options
        Setting the unit type for temporary files
        Setting panel attribute options
        Setting environment-specific options for AR/CTL ISPF
      Using AR/CTL security
        Overview
        Using AR/CTL external security
          Setting up AR/CTL external security
          Using extended security entity definitions
            Implementation of extended security entity definitions
            Extended security entity definition example
          Individual security entities
          Modifying individual security entities
        Using AR/CTL internal security
          Setting up AR/CTL internal security
          Composite security entities
          Modifying internal security components
        Displaying an AR/CTL security definition
          Internal security definition
          External security definition
        Using the User Security exit
          Implementing the exit
          Activating the exit
          Using registers at entry
          Setting registers for return
      Copying REGISET records
        Overview
          Limitations
          Restrictions
        Using the REGISET Record Copy utility
          Accessing the utility
          Selecting the BCSSs and the record type
          Selecting records to copy
          Changing the record ID
          Replacing a record
    APPLICATION RESTART CONTROL Customization Guide
      Installation overview
        AR/CTL products
          APPLICATION RESTART CONTROL
            AR/CTL checkpoint/restart services
            AR/CTL data services
            AR/CTL operational services
            AR/CTL for IMS functions
            AR/CTL for DB2 functions
            AR/CTL for VSAM functions
          BATCH CONTROL FACILITY component of AR/CTL
            Execution controller
            Physical Logger
            Enhanced processing
            Other AR/CTL BCF component features
          BMC subsystems
            BMCP
            BCSS
          REGISET
          REGISET records
          Enhanced processing
          Application supervisor and product execution modules
          ISPF interface components
          History data sets
          VSAM file control table data set
          AR/CTL Install System and IVPs
          Product authorization
          AR/CTL security
          Samples
        Questions or problems
      Product requirements and considerations
        Overview
        Installation requirements
          Installation considerations
          Password requirements
          Estimated space requirements
        Hardware requirements and considerations
          Processor (CPU)
          DASD requirements
          Shared DASD environment
          Shared REGISET
        Operating system requirements and considerations
          z/OS (DFP levels)
          Subsystems and address spaces
          Storage protect key
          Subsystem CSA/ECSA use
          AR/CTL storage usage in the private region
        IMS, DB2, and CICS
          IMS
          DB2
          CICS
        Security products
          ACF2
          RACF
          Top Secret
          PADS facility
          CICS MRO security
        AR/CTL product requirements
        Other software
          ISPF
          BMC database utilities
          Other BMC products
      Configuring the products
        Overview
        Make decisions and gather information
        Execute the AESIS and enter values
          AESIS JCL defaults
            Job statement information
            AES data set name prefix
          AESIS storage information
            Allocation parameters
            Dynamic allocation default VOLSER
            Work data set unit
          AESIS product data set names
          AESIS miscellaneous data set names
          AESIS APF authorization
            APF-authorized libraries
            AR/CTL enhanced processing options
          AESIS IMS defaults
          AESIS primary/duplex REGISET masking values
            Space parameters
            Allocation parameters
          AESIS primary data set allocation
          AESIS duplex data set allocation
          AESIS subsystem procedure information
          AESIS CPU authorization selection
          AESIS CPU authorization
        Generate the configuration JCL
        Execute the configuration jobs
        Complete AESIS configuration
        Install the ISPF interface
          LIBDEF method
          Logon procedure method
        Perform other configuration tasks
          Automatic enhanced processing installation
          Bind/grant processing
          Refresh MVS Linklist Lookaside
      Migrating to production
        Migration considerations
        Migration of an AR/CTL product to production
      Implementing remote VSAM access
        Overview
        Steps to perform in the z/OS environment
          Set up the VSAM file control table data set
            Create the data set
            Select the format of the data set
            Calculate the size of the data set (PDS)
            Calculate the size of the data set (PDS/E)
            Select the location of the data set
            Initialize the data set
            Provide for maintenance of the data set
          Define cross-system enqueues
        Steps to perform in a CICS environment
          Set up the CICS environment for remote VSAM access
          Create AR/CTL entries in each CICS region
          Set parameter values in file entries
          Evaluate usage of CICS resources
            Resource locks
            Overflow of the CICS system log
        Steps to perform in AR/CTL
          Set AR/CTL processing options
          Work with the CICS connection ID table
          Work with the CICS APPLID table
          Work with the remote VSAM access file table
      Converting to AR/CTL products
        Overview
        Converting from QUICKSTART for z/OS to AR/CTL
      Glossary
        AESIS
        alias
        AR/CTL products
        catalog indirection
        checkpoint/restart
        cloning
        customization
        high-level qualifier (HLQ)
        initial runtime instance
        installation
        low-level qualifier (LLQ)
        merged installation
        non-merged installation
        non-shared DASD
        runtime data sets
        runtime enablement (RTE)
        sample and install libraries
        shared DASD
        system of origin
        target destination system (TDS)
        TDS instance
        transport
    BMC Products and Solutions for DB2 Customization Guide
      Overview of customization tasks
        BMC High Speed Utilities for DB2 customization tasks
        BMC Object Administration for DB2 customization tasks
        BMC Performance for DB2 SQL customization tasks
        BMC Performance for DB2 Databases customization tasks
        BMC Recovery for DB2 customization tasks
        NGT Database Administration for DB2 customization tasks
        NGT Database Performance for DB2 customization tasks
        BMC Administrative Assistant for DB2 customization tasks
        BMC Database Administration for DB2 customization tasks
        Database Performance for DB2 customization tasks
        BMC Recovery Management for DB2 customization tasks
        Administrative products for DB2 customization tasks
        Backup and Recovery products for DB2 customization tasks
        Utility products for DB2 customization tasks
        NGT utility products customization tasks
        System and SQL Performance products for DB2 customization tasks
        EXTENDED BUFFER MANAGER for DB2 (XBM) and SNAPSHOT UPGRADE FEATURE for DB2 (SUF) customization tasks
      Authorizations and security
        Authorization verification
        User authorizations
          Authorization verification mechanisms for the Backup and Recovery products and Utility products
          Granting user authorizations for the Utility products
            Setting CHECK PLUS authorizations
            Setting LOADPLUS authorizations
            Setting REORG PLUS authorizations
            Setting UNLOAD PLUS authorizations
          NGT Copy user authorizations
          RECOVERY MANAGER for DB2 user authorizations
            RACF authorization for RECOVERY MANAGER
            System security authorizations for RECOVERY MANAGER for DB2
            DB2 authorizations for RECOVERY MANAGER for DB2
            APF authorizations for RECOVERY MANAGER for DB2
            Restricting TSO commands for RECOVERY MANAGER for DB2
          NGT Recover user authorizations
          DASD MANAGER PLUS authorizations
            Enabling data set access
            APF authorizations for DASD MANAGER PLUS
          Configuring security for BMC Workbench
            Controlling access to BMC Workbench for DB2
            Managing DBC security
            DB2 security
          Controlling access to the System and SQL Performance products for DB2
            User IDs for the DBC component
            Security and permissions for user IDs for the System and SQL Performance products
            Plan name
            MVS security
            Managing security with CA-ACF2, CA-Top Secret, or RACF security
            DB2 and product security
          Log Master for DB2 user authorizations
            DB2 authorizations for Log Master for DB2
            APF authorizations for Log Master for DB2
            RACF authorizations for Log Master for DB2
          PACLOG for DB2 user authorizations
          R+/CHANGE ACCUM for DB2 user authorizations
            DB2 authorizations for R+/CHANGE ACCUM
            APF authorizations for R+/CHANGE ACCUM
            RACF authorizations for R+/CHANGE ACCUM
            CA-ACF2 authorizations for R+/CHANGE ACCUM
          Granting user authorizations for EXTENDED BUFFER MANAGER
            Configuring CA-ACF2 security
            Configuring CA-Top Secret security
            Configuring RACF security
            RACF resource profiles
            Using XBM user exits
          High-speed Apply Engine user authorizations
            DB2 authorizations for the High-speed Apply Engine
            APF authorizations for the High-speed Apply Engine
          NGT data set access and security settings
          NGT authorizations
            DB2 Plan Authorizations
            APF Authorization
            Required authorizations for NGT Check
            Required authorizations for NGT Reorg
            Required authorizations for NGT LOBMaster
            Required authorizations for NGT Reorg
            Required authorizations for NGT Stats
            Required authorizations for NGT Unload
        Restricting access to the worklist parallelism feature
      System-level changes
        Setting the MEMLIMIT system parameter
        Modifying installation options after customization
          Modifying installation options modules
        Increasing the size of DB2 active logs for LOADPLUS
        Customizing products that prevent x37 abends in LOADPLUS
      Enabling interactions between products
        Enabling interaction between CATALOG MANAGER and BMC utilities (including Backup and Recovery products)
        Enabling interaction between ALTER or CHANGE MANAGER and BMC utilities (including Backup and Recovery products)
        Enabling interaction between DASD MANAGER PLUS and BMC utilities (including Backup and Recovery products)
        DASD MANAGER PLUS use within other products
          Enabling the use of DASD MANAGER PLUS within ALTER or CHANGE MANAGER
          Enabling the use of DASD MANAGER PLUS within CATALOG MANAGER
        Enabling interaction between RECOVERY MANAGER and other products
          Enabling interaction between RECOVERY MANAGER and Log Master
          Enabling interaction between RECOVERY MANAGER and NGT Recover
          Enabling interaction between NGT Copy and RECOVERY MANAGER
          Enabling interaction between RECOVERY MANAGER and PACLOG
        Enabling the use of SQL Explorer for DB2 within CATALOG MANAGER
      Customizing Administrative products
        Specific ALTER and CATALOG MANAGER customization tasks
          Creating indexes to improve performance
          Shared components
            Binding a product to shared components
            Generating environment-specific JCL
            Specifying generation data groups
          BMCDB2PR panel
            Adding products to the BMCDB2PR panel
            Modifying and validating the DB2 catalog access option on the BMCDB2PR panel
            Changing from ALTER to CHANGE MANAGER on the BMCDB2PR panel
          Control table
            Modifying the ISPF control table
            Adding a product to the control table
            Enabling access to data sharing members in the control table
            Specifying separate libraries in the control table
            Specifying the same installation options module in the control table
            Application IDs in the control table
            Application IDs for multiple SSIDs
            Subsequent DB2 subsystems in the control table
            Catalog indirection in the control table
          Fast Path Navigation
          Specifying minimum TSO region size
        Modifying POF values
        Modifying user profile values
          Refreshing installation options values in the user profile
          Refreshing POF values in the user profile
        Using catalog indirection with ALTER, CATALOG MANAGER, and CHANGE MANAGER
          Implement and maintain catalog indirection
          Specify the installation options module
          Specify alias qualifiers during maintenance
          Use a copy of the catalog
          Use a copy of the catalog to reduce catalog contention
        Specific CATALOG MANAGER customization tasks
          Access to catalog information
          Prohibiting access to CATALOG MANAGER functions
          Specifying an entry panel
          Specifying locking options for editing data
          Setting the session profile
          Editing the CONNECT command servers
          Adding ACTEMAIN and ACTDCL to the ISPF command table
          Enabling the use of DDF
          Specifying minimum TSO region size
        Specific DASD MANAGER PLUS customization tasks
          Enabling REXX executables
          Customizing the ISPF-Export utility for DASD MANAGER PLUS
            Recommendations for setting up connections
            Connection list types
            Required authorizations for using ISPF-Export
            SAF authority to access the CCL
            Protection of access controls
            Creation of SAF resources
            Preparing your environment for exporting
          Specifying minimum TSO region size
        Customizing Cross-System Image Manager (XIM)
        Execution of XIM
          Determining the status of XIM
          Starting XIM
          Inactivating XIM initiators
          Shutting down XIM
          Activating XIM initiators
          Modifying MVS image variables
          Troubleshooting the execution of XIM
        Working with CLISTs
          Using the appropriate CLIST
          Enabling the implicit execution of CLISTs
          Working with the BMCDB2 CLIST
            Setting the variables in the BMCDB2 CLIST
            Invoking the BMCDB2 CLIST
            BMCDB2 command
      Customizing Backup and Recovery
        Customizing RECOVERY MANAGER
          Required temporary tables for RECOVERY MANAGER
          Preparing for archive logs greater than 64 KB tracks
          Setting up data sharing for RECOVERY MANAGER for DB2
          RECOVERY MANAGER, LGC, and DBC
          RECOVERY MANAGER for DB2 archive history file
          RECOVERY MANAGER for DB2 option set
          RECOVERY MANAGER for DB2 packages
          RECOVERY MANAGER for DB2 repository
        BCSS commands for PACLOG
      Customizing System and SQL Performance
        Overview
        Post-installation tasks
          Defining a DOMPLEX
          Editing the DOMPLEX option set online
          Verifying the product for data sharing members
          Customizing the CLISTs for SQL Explorer and CATALOG MANAGER
            Setting up the SQLX edit macro
            Addition of subsystem information for the SQLX edit macro and the ACTPSS CLIST
          Creating indexes to improve performance
          Generating Help text from DB2 trace record field descriptions
          Editing or reviewing the DBC JCL procedure
          Adding or replacing the CLIST member for the ISPF interface
          Making products available from a menu
          Invoking SQL Explorer directly
          Invoking System and SQL Performance products without LIBDEFs
          Verifying or changing the global resource enqueues
          Refreshing the MVS Linklist Lookaside
          Verifying the product authorization
        Customizing the System and SQL Performance products
          Verifying or customizing the DOMPLEX option set
            Starting a product session
            Checking the values in the DOMPLEX option set
            Checking or modifying the DB2 subsystems to monitor
            Checking or modifying the output groups
          Verifying or changing DOMPLEX parameters
            Data transfer limit calculations
          Checking the default User Profile
          Additional information about archiving and the NGL
            Renaming the NGLARCH process
            Setting up an archive post-processing job
        Customizing the OPERTUNE for DB2 product
          Copying the OPERTUNE procedure to a PROCLIB
          Invoking the OPERTUNE CLIST or the common BMCDISPN panel
          Creating an OPERTUNE system profile
          Defining security for OPERTUNE
          Starting the OPERTUNE started task
          Preparing ISPF for OPERTUNE diagnostics
          Establishing OPERTUNE communications
      Customizing EXTENDED BUFFER MANAGER and SNAPSHOT UPGRADE FEATURE
        Customizing XBM subsystems
          Completing XBM installation
          Defining and starting the XBM started task
            Parameters
            DD statements
          Defining PROCs for use with multiple XBM subsystems
          Customizing XBM$OPTS for data sharing environments
          Using the XBM initialization command file
        Customizing XBM components
          Setting up the SSI component
          Setting up the PSS component
      Customizing BMC Workbench
        Customization overview
          Architecture of BMC Workbench
          BMC Workbench for DB2 requirements
          Selecting a subsystem for the BMC Workbench repository
        Editing the BMC Workbench option set
        Common Explain
        Expert rules
          Severity codes in rules
          Using predefined rules
          Defining new expert rules
            Structure of rules
            PSSRXSQL external function
            PSSRXSQL return codes
            Printing error messages
      Customizing NGT utilities
        Checkpoint data set considerations
        Block size considerations
        Starting NGT Subsystem
      Customizing the User Interface Middleware (UIM)
        Starting and stopping the UIM server
        Changing UIM server options
        Accessing multiple z/OS systems
          Creating additional UIM servers
          Creating additional JCL Generation POFs
        Merging multiple products into a single UIM server
      Verifying installation
        Verifying the Administrative products’ installation
        Verifying Backup and Recovery product and Utility product installation
        Verifying the installation of System and SQL Performance products
          Starting the DBC subsystem
          Checking the system console log messages
          Starting a product session
          Selecting a DOMPLEX
          Issuing a dynamic Explain command
          Accessing the Index Component reports
          Verifying the SQL Explorer installation
            Testing the Call Attach Facility
            Testing Impact Analysis
            Testing the Distributed Data Facility
          Starting a Pool Advisor or System Performance reporting session
        Verifying the installation of NGT products
          Editing allocation automation
      Migrating to a different version of DB2
        Supported DB2 versions and modes
        New DB2 version migration
          Administrative products and solutions
            Migrating to DB2 Version 12 function level 500 from Version 11
            Migrating to DB2 Version 11 new-function mode from Version 10
            Migrating to DB2 Version 10 from Version 9 new-function mode
            Completing the migration to a new version of DB2
          Backup and Recovery and Utility products and solutions
            Migrating from an earlier version of RECOVERY MANAGER
          System and SQL Performance products and solutions
        Earlier DB2 version fallback
          Administrative products and solutions
            Falling back to DB2 Version 10 from Version 11
          Backup and Recovery products and solutions
            Falling back to an earlier version of DB2
          Utility products
          System and SQL Performance products and solutions
    Installation System Quick Start
      Related publications
      Overview of the installation process
        Installation process flow
        Navigation, function keys, and commands
        Data set naming conventions
      Setting up the Installation System
        Obtaining the Installation System setup utility
        Decompressing the Installation System setup utility
        Running the Installation System setup utility
        Running the SMP/E JCL for the Installation System
        Updating the Installation System
      Preparing for an installation
        Preparing the Installation System repository
        CA ACF2 usage
        Review installation requirements
      Starting an installation
        Before you begin an installation
        Starting the Installation System
        Defining or modifying site-wide default values
        Creating and selecting a project
      Generating installation jobs
        Selecting products to install
        Specifying SMP/E settings
        Specifying JCL values for generated installation jobs
        Generating the installation JCL
      Generating configuration jobs
        BMC products for IMS that do not require configuration
        Specifying runtime data set information
        Specifying product configuration information
        Specifying JCL values for generated configuration jobs
        Generating the configuration JCL
      Running the generated jobs
        Reviewing generated documentation members
        To run the generated jobs
        Result of running the jobs
    Installation System Reference Manual
      Related publications
      Conventions
      Summary of changes
      Overview of the installation process
        Installation process flow
        Installation projects
        Conventions for using the Installation System
          Character for selecting options on panels
          Navigation, function keys, and commands
          Data set naming conventions
          Symbolic variables
          Naming conventions
            Naming conventions for FMIDs
            Naming conventions for SYSMODs, PTFs, and APARs
            Naming conventions for installation images
            Naming conventions for product distribution files
            Naming conventions for runtime libraries
      Setting up the Installation System
        Distribution methods and media
          Methods for obtaining the Installation System setup utility
          Maintenance files
        Obtaining the Installation System setup utility by using direct FTP
        Obtaining the Installation System setup utility by using distributed FTP
        Obtaining the Installation System setup utility by using a web browser
        Obtaining the Installation System setup utility by using physical media
        Decompressing the Installation System setup utility
        Running the Installation System setup utility
        Running the SMP/E JCL for the Installation System
        Updating the Installation System
      Preparing for an installation
        Preparing the Installation System repository
          Preparing when RTCS is available on a system other than the one you are using
          Preparing when RTCS is not installed
          Managing the bootstrap RTCS
        CA ACF2 usage
        Review installation requirements
          Gaining full access to BMC Support Central
          Obtain your CPU authorization password
          Product-specific requirements for installation
          Product-specific considerations for installation
          Review Installation System and product notices
      Starting an installation
        Before you begin an installation
        Starting the Installation System
        Defining or modifying site-wide default values
        Creating and selecting a project
        Managing projects
      Generating installation jobs
        Selecting products to install
        Specifying SMP/E settings
        Specifying JCL values for generated installation jobs
        Generating the installation JCL
      Generating configuration jobs
        BMC products for IMS that do not require configuration
        Specifying runtime data set information
        Specifying product configuration information
        Specifying JCL values for generated configuration jobs
        Generating the configuration JCL
      Running the generated jobs
        Reviewing generated documentation members
        To run the generated jobs
        Result of running the jobs
      Maintaining products
        Overview of product maintenance
          Advantages of BMC ISR over eFix
          Task summary for applying maintenance
        Preparing to use BMC ISR
          Requirements for using BMC ISR
          About the HFS or zFS file system used by BMC ISR
          Setting up initial values for the BMC ISR jobs
        Creating a service package request
          To create a service request by using BMC ISR
          To send a service request manually
          To create a scheduled service request
        Checking the progress of a service package request
        Retrieving and processing a service package
          To retrieve and process a service package by using BMC ISR
          To retrieve and process a service package manually
          To process a previously retrieved service package
        Removing JCL data sets generated by previous requests
        Obtaining product maintenance by using eFix
        Generating jobs to perform SMP/E maintenance from an image
        Running jobs to apply SMP/E maintenance from an image
        Deploying maintenance to BMC product runtime data sets
        Backing up and reassembling option modules for system administration products for IMS
        Maintenance issue for BMC database products for IMS
          Overview of handling modified modules
          Actions to preserve modified modules
          Overview of the DBUCOPY utility
          Sample DBUCOPY job
          Installation procedures
        Non-disruptive maintenance for MAXM Reorg Online products
          Overview of NDM
          Updating MAXM Online products using NDM
      Deploying products to other subsystems, LPARs, and sysplexes
        Copying your JCL library
        Modifying INCLUDE members
        Running the deployment jobs
      Product-specific installation requirements
        Installation requirements for APPLICATION RESTART CONTROL
        Installation requirements for BMC products for DB2
        Installation requirements for BMC database products for IMS
        Installation requirements for BMC system administration products for IMS
        Installation requirements for MainView products
        ALTER requirements
        BMC DB2 Components Services (DBC) requirements
        BMC Workbench for DB2 requirements
        CATALOG MANAGER requirements
        CHANGE MANAGER requirements
        CHECK PLUS for DB2 system and software requirements
        Common SQL (ACS) component requirements
        COPY PLUS requirements
        Cross-System Image Manager (XIM) requirements
        DASD MANAGER PLUS requirements
        Database Performance for DB2 requirements
        EXTENDED BUFFER MANAGER (XBM) and SNAPSHOT UPGRADE FEATURE (SUF) requirements
        High-speed Apply Engine requirements
        Installation authorization requirements for BMC products for DB2
        LOADPLUS system and software requirements
        Log Master requirements
        Prerequisites
        NGT Check software requirements
        NGT Load software requirements
        NGT LOBMaster software requirements
        NGT Reorg software requirements
        NGT Unload software requirements
        PACLOG requirements
        R+/CHANGE ACCUM requirements
        NGT Recover requirements
        RECOVERY MANAGER requirements
        REORG PLUS for DB2 system and software requirements
        System and SQL Performance products and solutions requirements
          Compatible release levels for System and SQL Performance products
        UIM server and console requirements
        UNLOAD PLUS for DB2 system and software requirements
      Product-specific considerations for installation
        Installation considerations for BMC products for IMS
        Installation considerations for MainView products
        BMC Software Consolidated Subsystem considerations for MainView Batch Optimizer
        BMCLINK
        BMCXLINK
        CICS Autoinstall feature
        CICS
        Common modules for BMC products for IMS
        CPC initialization failure
        DATA PACKER/IMS supported database types and organizations
        Database Advisor
        Database Integrity functions
        DEDB support in the MAXM Database Advisor for IMS
        DELTA PLUS and DELTA PLUS VIRTUAL TERMINAL internal security
        DELTA PLUS VIRTUAL TERMINAL and DELTA IMS
        Dispatching priorities for the BMC address space
        EXTENDED BUFFER MANAGER and SNAPSHOT UPGRADE FEATURE
          System-level considerations for XBM
            Dispatching priority for XBM
            Automatic initialization of the XBM subsystem
            SYSTEMS-wide XBM ENQ demotion (PSS component only)
          Repository considerations when upgrading XBM
            Backing up your repository when upgrading XBM
            Migrating your repository when upgrading XBM
          XBM for IMS and Link Pack Area storage
        Image Copy utility
        Installation and configuration options for the APPLICATION RESTART CONTROL products
        Inter-product considerations
        Internal security for EXTENDED TERMINAL ASSIST PLUS (ETA)
        LOCAL COPY PLUS
        LPA ELPA and SVA
        MainView for DB2 considerations
          MainView for DB2 - Data Collector considerations
            Data classes and IFCIDs used by MainView for DB2 - Data Collector
          CATALOG MANAGER for DB2 (Browse only) considerations
          Calculating storage requirements
        MainView for WebSphere Application Server security requirements
        Message Advisor
          Sort
          IMS
          Performance
          Support for active XRF complexes
        Migration considerations for DATA ACCELERATOR Compression
          Engine Level Mask migration
          REGISET sharing
          REGISET migration
          Implementation of a new release
          Fallback considerations
        MRO environments
        Multiple subsystem consideration for Data Optimizer
        z/OS
        Non-VSAM component for DATA ACCELERATOR Compression
        Online Reorg function
        Password considerations for Fast Path products
        Pointer Checker function
        Product configuration methods for BMC products for IMS
        Product compatibility between DATA ACCELERATOR Compression and other products
        Products that run in the BBI-SS PAS
        Recovery Advisor
        RECOVERY MANAGER for IMS functions and utilities
          Suspend-and-resume interface
          Cross-System Coupling Facility limit
          IMS modules and the link pack area
          Databases
          DBRC
          Abbreviated dumps
        Sample usermods for system administration products for IMS
        Shared DASD environment for BMC products for IMS
        Shared DASD environment for MainView products
        Shared REGISET for APPLICATION RESTART CONTROL
        SMS considerations for DATA ACCELERATOR Compression
        Standard CICS user exits for 3270 SUPEROPTIMIZER/CICS
        Sysplex environment requirements for Job Optimizer
        SYSTEMS-wide XBM ENQ demotion (PSS component only)
        Subsystems and address spaces
        Tape GDG for DATA ACCELERATOR Compression
        Transids routed by the CRTE for 3270 SUPEROPTIMIZER/CICS
        TSS unload and load functions for EXTENDED TERMINAL ASSIST PLUS
        Unload extended performance function for some MAXM Reorg products
        Variable resource name qualifiers for EXTENDED TERMINAL ASSIST PLUS
        VSAM component for DATA ACCELERATOR Compression
      Authorizing products
        Overview of licensing and passwords
        Products that use the BMC Product Authorization utility
        How licensing works
          Temporary passwords
          Permanent passwords
          Scenarios for password types
        Overview of the Product Authorization utility
          Product trials and permanent licensing
          CPU upgrades
          CPU failures
          Updates to the product authorization tables
          Run a product on an unlicensed processor
          Product maintenance or version upgrades
        Product authorization worksheet
        Applying and managing passwords with the online interface
          Applying passwords during configuration
          Applying and managing passwords from the main menu
            To start the online Product Authorization utility
            To process a permanent password for an existing processor
            To add authorization for a new processor
            To delete authorization for a processor
            To replace authorization for a processor
            To modify authorization for an existing processor
            To reset authorization for all processors
            Processing a temporary password
            To display product authorization
            To display current processor information
        Applying and managing passwords with the batch interface
          Running the batch Product Authorization utility
          Sample JCL for product authorization
          Control statements and keywords
          Check return codes
      Configuring UIM server options
      Configuring BMC products for DB2
        Product and component identifiers for variables and options
          Specify alias qualifiers
          Specify collection IDs
          Specify database and creator names
        Collection nicknames in CATALOG MANAGER
        Installation options jobs and modules
          Use a single options module for multiple DB2 subsystems
          Use multiple options modules
        Migrate DB2 table data
        Linking an existing version of the BMC Common Statistics component to LOADPLUS or REORG PLUS
        Common utility and repository tables
        Use of the JCL Generation File Information dialog
        Implementing catalog indirection for ALTER, CATALOG MANAGER, and CHANGE MANAGER
        Installation on multiple DB2 subsystems
          Requirements for a MSSID installation
          Performing a MSSID installation
        Installation of multiple product releases on a single DB2 subsystem
        Specify the commands module for CATALOG MANAGER
        Adding the UIM started task to your procedure library
        Applying changes to the $729DOP1 and $730DOP2 jobs
        Upgrade ALTER to CHANGE MANAGER
          Upgrading from ALTER version 10.1.00 or later to CHANGE MANAGER version 10.1.00 or later
          Upgrading from ALTER version 9.3 to CHANGE MANAGER version 10.1.00 or later
      Configuring BMC products for IMS
        BMC products for IMS that do not require configuration
        Product group and category example for the IMS Common Utilities
        IMS system library specification
        Specify EXTENDED BUFFER MANAGER (XBM) options for some database products for IMS
        Specifying PDX DBRC global options modules and DBUSS options
        Specifying CPC Advisor information
        Specifying customized global options modules
        Specifying Energizer for IMS Connect options
        Allocating the repository data set for the RECOVERY MANAGER for IMS functions and utilities
        Allocating the JOBPDS for the RECOVERY MANAGER for IMS functions and utilities
        Specifying startup information for the RECOVERY MANAGER for IMS functions and utilities
        Complete DATA PACKER/IMS configuration
        Complete configuration for the Fast Path database products
      Configuring MainView products
        Configuration scenarios for MainView runtime and user libraries
        Configuring MainView Logger
        Configuring MainView sysplexes and systems
        Configuring a MainView product
        Using the MainView configuration import/export function
          Overview of the csv files
          Overview of creating and modifying input csv files
          Exporting MainView configuration values
          Importing MainView configuration values
      Installation, configuration, and maintenance jobs and files
        Generated installation and configuration jobs and files
        Generated maintenance jobs and files
      Library names
        Library guidelines
        Library names used by most BMC products for DB2
        Library names used by most BMC products for IMS
        Library names used by most MainView products
        Library names used by APPLICATION RESTART CONTROL products
      Enhanced HOLDDATA
        Overview of Enhanced HOLDDATA
        Obtaining Enhanced HOLDDATA
          Downloading Enhanced HOLDDATA
          Receiving Enhanced HOLDDATA
        Running the Exception SYSMOD report
        Sample Exception SYSMOD report
      Installation utilities
        Available utilities
      Migrating installation option values for BMC products for DB2
        Overview of migrating installation option values
        Migrating installation options using the Installation System
        Overview of batch migration
        JOB statement
        EXEC statement
          productCode
          IFILE(inputFile)
          OFILE(outputFile)
          IMEMB(inputMember)
          OMEMB(outputMember)
          ALL
          NV | NAMEVALUE
        DD considerations
        Example JCL
  Usage and reference
    ALTER and CHANGE MANAGER for DB2 Reference Guide
      Object types, commands, and action codes
        DB2 object types
        Command line commands
        Action codes
        Selection List action codes
        Change rules used with object attributes
      Keywords and variables
        Keywords for input streams
          Overview of the keyword tables
          AEXIN keywords
          AEXPIN keywords
          AJXIN keywords
          ALUIN keywords
        Keywords that override installation options
        Symbolic variables for BMC Administrative products
      ALTER and CHANGE MANAGER installation options
        Installation options
      JCL Generation product options
        Example of product options
        Descriptions of product option keywords
      Worklist commands
        File format
          Multi-line commands
          Comment lines
        ALTER and CHANGE MANAGER worklist commands
          -AMS (IDCAMS execution)
          -AUTH (Authorization switching)
          -BASE (Establish baseline)
          -BASF (Mark baseline recoverable)
          -BEGG (Begin global commands)
          -BEGP (Begin parallel processing)
          -BEGU (Begin unit of work)
          -BIND (Bind)
          -BMCB (BMC BASIC UNLOAD utility)
            Use of -BMCB to unload data
            Use of -BMCB to migrate tables with ROWID columns
          -BMCC (NGT Copy utility)
            Use of -BMCC to dynamically allocate copy data sets
            Use of -BMCC to create partition-level image copies
            Use of -BMCC to create sequential migration files
            Notes for -BMCC
          -BMCD (BMC UNLOAD PLUS utility)
            Use of -BMCD to dynamically allocate unload data sets
            Use of -BMCD to perform a fast unload
            Use of -BMCD to unload from image copies
            Use of -BMCD to perform multitasking
            Use of -BMCD to unload converted data
            Use of -BMCD to migrate tables with ROWID columns
            Use of -BMCD to unload data in XML and LOB columns
          -BMCK (BMC CHECK PLUS utility)
          -BMCL (BMC LOADPLUS utility)
            Use of -BMCL to perform a fast load
            Use of -BMCL with multiple work data sets
            Use of -BMCL to register image copies
            Use of -BMCL to create partition-level image copies
            Use of -BMCL to perform multitasking
            Use of -BMCL to migrate tables with ROWID columns
            Use of -BMCL to load data in XML and LOB columns
            Use of -BMCL to delete dynamically allocated discard data sets
            Use of -BMCL to migrate only data with FORCELOADREPLACE
            Notes for -BMCL
          -BMCR (BMC REORG PLUS utility)
            Use of -BMCR with multiple work data sets
            Use of -BMCR to register image copies
            Use of -BMCR to create partition-level image copies
            Use of -BMCR to perform an online reorg
            Use of -BMCR to dynamically allocate data sets
            Notes for -BMCR
          -BMCS (BMC BMCSTATS utility)
          -BMCV (NGT Recover utility)
            Use of -BMCV to rebuild indexes
            Use of -BMCV to load from image copies
            Use of -BMCV to dynamically allocate copy data sets
            Use of -BMCV to register image copies
            Use of -BMCV to create partition-level image copies
            Use of -BMCV to migrate image copy data
          -CHEK (IBM CHECK DATA or CHECK LOB utility)
            CHECK DATA utility
            CHECK LOB utility
          -CMD (DB2 command)
          -COPY (IBM COPY utility)
            Use of -COPY to dynamically allocate data sets
            Use of -COPY with generation data groups
            Notes for -COPY
          -ENDG (End global commands)
          -ENDP (End parallel processing)
          -ENDU (End unit of work)
          -ERR (Error)
          -GLID (Global authorization ID)
          -GOTO (Bypass command)
          -ISMT (Is table empty)
          -ISMX (Is LOB column empty)
          -JCLP (JCL Generation parameter)
            Use of -JCLP to identify SSIDs
            Use of -JCLP to create partition-level image copies
            Use of -JCLP for multiple work data sets
            Use of -JCLP to multitask the unloading and loading of data
            Use of -JCLP to determine the sizes of data sets
          -LCMD (List command)
          -LDXT (IBM LOAD Extended Text utility)
          -LOAD (IBM LOAD utility)
            Use of -LOAD to load data in LOB and XML columns
            Use of -LOAD to migrate tables with ROWID columns
            Use of -LOAD to migrate only data with FORCELOADREPLACE
            Notes for -LOAD
          -MIGR (Migrate phase)
          -NGTU (NGT utilities)
          -RBLD (IBM REBUILD INDEX utility)
          -REBD (DB2 REBIND)
          -REOR (IBM REORG utility)
          -REXC (REXX and CLIST macro execution)
          -RNAM (Rename object)
          -RNST (IBM RUNSTATS utility)
          -SETA (SET SCHEMA statement)
          -SETP (SET CURRENT PATH statement)
          -SETS (Set current SQL ID)
          -SPAC (Space estimation source)
          -SPBX (External SQL stored procedures)
          -SQL (SQL statement)
          -SQLP (Native SQL stored procedures)
          -SSID (Subsystem ID)
          -STOP (Stop)
          -SYNC (Sync point)
          -TIME (File creation time)
          -UNLI (IBM UNLOAD utility)
            Use of -UNLI to dynamically allocate unload data sets
            Use of -UNLI to multitask
            Use of -UNLI to unload data in LOB and XML columns
            Use of -UNLI to migrate tables with ROWID columns
          -UNRC (Unload record)
          -WKID (Work ID)
            Use of -WKID in CM PILOT
          -ZPRM (ZPARM value)
        CM/PILOT worklist commands
          -ANLY (Analysis)
          -BJCL (Batch Execution JCL Generation)
          -COMP (Compare)
          -DML (DML section)
          -IMP (Import)
          -OPTS (Options)
          -REPL (REPL section)
          -TASK (Task ID)
        Other worklist commands
          -BMCU (Execute a BMC utility)
          -DBUG (Debug)
          -DSN1 (IBM DSN1COPY utility)
          -MERG (IBM MERGECOPY utility)
          -MODI (IBM MODIFY utility)
          -NOOP (No operation)
          -QUI (IBM QUIESCE utility)
          -REPO (IBM REPORT utility)
          -REPX (IBM REPAIR utility)
          -SQLM (Group multiple ALTER statements)
          -STOS (IBM STOSPACE utility)
        Authorizations used for authorization switching
          Authorization switching using non-GLID processing
          Authorization switching using GLID processing
      Change Definition Language
        File format
        CDL commands
          -ORGN (CDL origin subsystem)
          -DEST (CDL destination subsystem)
          -CDL (CDL statement)
        CDL reserved words
        CDL statements
          ALTER ALIAS statement
          ALTER AUXILIARY TABLE statement
          ALTER CHECK statement
          ALTER UNIQUE CONSTRAINT statement
          ALTER DATABASE statement
          ALTER FOREIGN KEY statement
          ALTER INDEX statement
          ALTER PROCEDURE statement
          ALTER SEQUENCE statement
          ALTER STOGROUP statement
          ALTER SYNONYM statement
          ALTER TABLE statement
          ALTER TABLESPACE statement
          ALTER TRIGGER statement
          ALTER VIEW statement
          CREATE ALIAS statement
          CREATE AUXILIARY TABLE statement
          CREATE CHECK statement
          CREATE UNIQUE CONSTRAINT statement
          CREATE DATABASE statement
          CREATE FOREIGN KEY statement
          CREATE INDEX statement
          CREATE PROCEDURE statement
          CREATE SEQUENCE statement
          CREATE STOGROUP statement
          CREATE SYNONYM statement
          CREATE TABLE statement
          CREATE TABLESPACE statement
          CREATE TRIGGER statement
          CREATE VIEW statement
          DROP ALIAS statement
          DROP CHECK statement
          DROP UNIQUE CONSTRAINT statement
          DROP DATABASE statement
          DROP FOREIGN KEY statement
          DROP INDEX statement
          DROP PROCEDURE statement
          DROP SEQUENCE statement
          DROP STOGROUP statement
          DROP SYNONYM statement
          DROP TABLE statement
          DROP TABLESPACE statement
          DROP TRIGGER statement
          DROP VIEW statement
      CM/PILOT Data Manipulation Language (DML)
        Actions that you can perform by using DML
        DML statements
          Keywords
          SET clause
          WHERE clause
        DELETE statement
        DELETE SYNCTABLE statement
        DELETE WORKID statement
        LIKE statement
        MIGRATE statement
        REPLICATE WORKID statement
        SET OMITUNICODE statement
        SET PRESERVELIMITKEY statement
        SET SPACE ESTIMATION statement
        UPDATE statement
        Performance enhancements with the JOIN keyword
        Attributes used in SET and WHERE clauses
    ALTER and CHANGE MANAGER User Guide: Volume 1
      Overview of ALTER and CHANGE MANAGER
        Change management
          Identification of your environment
          Location of your environment
          Propagation of your changes
        Overview of change management with ALTER and CHANGE MANAGER
          Overview of ALTER
            Data structure changes
            Data structure migration
            Data structure importation
            Space estimation
          Overview of CHANGE MANAGER
            Data structure change migration
            Data structure recovery
            Change recording and controling
            Change feedback
            Data modeling tools
        ALTER architecture
          ALTER components
            ALTER Front End
            ALTER Specification
            ALTER Import
            ALTER Analysis
            ALTER JCL Generation
            Execution functions
          ALTER objects
            Work IDs
            ALTER worklists
            Unload data sets
            ALTER DDL files
            ALTER internal tables
        CHANGE MANAGER architecture
          CHANGE MANAGER components
            CHANGE MANAGER Front End
            Baseline
            Compare
            CHANGE MANAGER Import
            CHANGE MANAGER JCL Generation
            CHANGE MANAGER Execution
            CM PILOT
          CHANGE MANAGER objects
            CHANGE MANAGER worklists
            Baselines
            Profiles
            CDL files
            CHANGE MANAGER DDL files
            CHANGE MANAGER internal tables
            Task IDs
            Scripts
            Applications
            DML
            CM/PILOT worklists
        Solution integration
          Administrative Assistant for DB2
          Database Administration for DB2
          BMC Object Administration for DB2
          BMC Next Generation Database Administration for DB2
      Overview of the ALTER and CHANGE MANAGER interface
        Before you use the product
        ALTER and CHANGE MANAGER interface
          Main Menu
          Displaying the current product environment
          Using Fast Path Navigation
          ISPF commands
          BMC message information
        Achieving your goals with ALTER and CHANGE MANAGER
          Creating, altering, or dropping DB2 objects
          Migrating DB2 objects
      Setting up ALTER and CHANGE MANAGER
        Using options to control your environment
          Using the installation options
          Using the user options
          Using the product options
          Product option overrides
          Additional installation options module
          How ALTER or CHANGE MANAGER use options
        Data set allocation
        Object names
          Wildcard patterns
          Delimited identifiers
        Nonprintable or nonviewable characters
        Access to components
          ALTER and CHANGE MANAGER plans
          CHANGE MANAGER plans
          Execution component plans
        Authorization switching
          Execution security exit function codes
          Execution security exit testing
        Access to the worklist parallelism feature
          Zap to restrict access to worklist parallelism
          General resource profile for worklist parallelism
        Setting the MEMLIMIT system parameter
        Modification of ISPF skeletons and variables
        JCL Generation data sets sizing function
        Product table maintenance
          Table size maintenance
          Table security
        Setting options
          Setting the attributes for the panel display
          Setting the options for data set allocation
          Setting the processing options for Analysis
          Setting the processing options for Import
          Setting the processing options for Execution
          Setting the processing options for Compare
          Setting the processing options for Baseline
          Setting the options for the baseline report
          Setting the user options for CM/PILOT
          Setting the JCL options for job cards
          Setting the JCL options for STEPLIBs
          Setting the JCL options for static data sets
          Setting the JCL options for tapes
          Setting the JCL options for temporary work data sets
          Setting the JCL options for permanent data sets
          Setting the JCL generation data group (GDG) options
          Setting the JCL debugging, display, and Execution options
          Setting the installation options module names for BMC utilities
          Setting the online reorg options
          Setting the NGT utility options
          Setting the Execution worklist parallelism options
          Setting the worklist options
          Setting the Analysis options
          Setting user variables
          Creating a user POF
          Updating a user POF
          Using multiple POFs
          Refreshing the initial POF
          Generating POF reports
          Reusing a POF in a subsequent installation
          Overriding POF values in SLIBs
          Creating OUTPUT or TEMPLATE descriptors for copies
      Glossary
        ACM
        ACT
        action
        action code
        action name
        action owner
        action POF
        action status
        action type
        Administrative Products for DB2
        AEXIN
        AEXPIN
        AEXPRINT
        AEXPRnnn
        AEXPTRAC
        AEXSYnnn
        AJX variables
        AJXIN
        AJXPOFIN
        AJXPOFVL
        AJXPRINT
        alloc unit
        ALTDD
        ALTER for DB2
        alter-type work ID
        ALU
        ALUIN
        ALUPRINT
        Analysis
        Application
        ARU
        ASU
        attribute
        AUTHID
        authorization ID
        automation modes
        automation spawner
        AutoSub
        auxiliary index
        auxiliary list
        auxiliary table
        auxiliary table space
        base table
        base table space
        baseline
        baseline name template
        baseline profile
        batch component
        BMC object
        BMCCOPY
        BMCCPRS
        BMCLOAD
        BMCREORG
        BMCSTATS
        BMCTRIG
        BMCUNLOAD
        BMCUPRS
        box
        browse function
        buffer pool
        Buffers
        build JCL
        build worklist
        CANCEL (CAN)
        catalog baseline
        catalog indirection
        CATALOG MANAGER for DB2
        CDL
        Change Definition Language (CDL)
        CHANGE MANAGER for DB2
        change rule
        char H/W
        char size
        checkpoint
        child
        CLIST
        CM/PILOT for DB2
        CM/PILOT worklist
        color
        columns
        command
        commit
        Compare
        Compare1
        Compare2
        component
        constraint
        copies
        CopyPend
        corrective action
        Cross-System Image Manager (XIM)
        DASD MANAGER PLUS for DB2
        DASD MANAGER PLUS database
        Data Control Language (DCL)
        data definition language (DDL)
        data definition name (ddname)
        Data Manipulation Language (DML)
        data set sizing
        data structure
        database administrator (DBA)
        database request module (DBRM)
        DBA
        DB2 catalog
        DB2 command
        DBCS
        DD statement
        DDL
        DDL baseline
        ddname
        default options module (DOPTS)
        default value
        delimited identifier
        DeleteAge
        dependencies
        dependent
        dependent object
        destination
        device name
        device type
        double-byte character set (DBCS)
        DOPTS
        duplicate
        edit procedure
        EDITPROC
        END
        Enter key
        entry field delimiter
        estimate source
        events log
        EVENTS table
        exception
        EXCEPTIONS2 table
        exceptions report
        exception status
        Execution
        exit routine
        field procedure
        FIELDPROC
        foreground component
        Front End
        full-recovery baseline
        GDG
        generation data group (GDG)
        Group ID
        hash value
        historical database
        HLQ
        image copy
        import or importation
        Import
        inbound migrate profile
        incremental DDL
        Index Cardinality
        Index Pages
        Index Partition Cardinality
        Index Partition Extents
        Index Partition Leaf Distribution
        Index Partition Page Group
        Index Partition Pages
        installation options module
        internal table
        ISPF skeletons
        JCL
        JCL DSN
        JCL Generation (JCLGEN)
        JCL variable display
        JCLGEN
        job
        JOB table
        justify
        large object (LOB) column
        large object (LOB) table space
        Leaf distribution
        Level
        LEVELINC
        LEVELMIN
        lines
        LINK library
        location
        margin
        markers
        menu
        migrate
        migrate profile
        migrate-type work ID
        mixed list
        Most Frequent Value display
        name propagation
        name template
        NonUniform
        NumIncremt
        null
        object
        object list
        OPNDB2ID
        order
        orient
        option
        origin
        orphaned auxiliary index
        orphaned auxiliary table space
        outbound migrate profile
        page
        PageGroup
        parent
        PartLvl
        partitioned data set (PDS)
        partitioned table space
        pattern
        PctActivHi
        PctActivLo
        PDS
        privilege
        profile
        protected baseline
        QMF
        Recall
        receive-type work ID
        recovery
        reference location
        reference profile
        referenced object
        referential constraint
        referential integrity
        Report
        Restart option
        restart parameter
        rows
        rows/key
        Sample
        Save
        save last used
        SAVESTATS
        SaveStats
        SBCS
        scope
        scope rule
        Script table
        security exit
        selection list
        service
        Simple Space Estimation (SSE)
        single-byte character set (SBCS)
        source
        Space Estimation
        space estimation function
        SpaceOnly
        Specification
        SQL
        SQLID
        SSID
        sequence number
        stack tapes
        Start Over option
        STATAUTH
        STEP table
        Structured Query Language (SQL)
        structure-only baseline
        sub-element
        symbolic variable
        SYNC
        sync point
        SYNC table
        synchronization
        Table Average Row Length
        Table Cardinality
        Table Pages
        Table Percent Pages
        Table Space Pages
        Table Space Partition Cardinality
        Table Space Partition Extents
        Table Space Partition Page Group
        Table Space Partition Pages
        Table Space Partition Percent Active/Drop
        Tables
        target
        Tasks
        task ID
        template
        TOTALIND
        TOTALOFF
        TSO submit exit
        Type
        unit
        unload data set
        UOW
        UOWTRnnn
        unprotected baseline
        user options
        variable
        VCAT allocation
        versioning
        wildcard
        work ID
        work ID name
        work ID name template
        work ID owner
        WORKIDS table
        worklist
        worklist execution log
        worklist parallelism
        XIM
        XIM initiator
    ALTER and CHANGE MANAGER User Guide: Volume 2
      Migrating database environments
        Overview
        Migration of data structures
        Methods of migrating data structures
          Migration via migrate-type work IDs
          Migration via outbound migrate profiles
          Migration via Data Manipulation Language
        Methods to define the scope of a migration
          Outbound migrate profile method
          Specified data structures method
          Identification of changes to data structures
        Modification of data structures using change rules
          Change rules for a migrate-type work ID
          Change rules for an outbound migrate profile
          Types of values for change rule attributes
            Numeric values
            Mathematical operations on current values
            Special numeric values
            Nonnumeric values
            Default values
            Blank values
            Nonstandard characters
            Nonprintable or nonviewable characters
            Name qualifiers
        Change list precedence
          Precedence of change rules for storage group and VCAT partition volume lists
          Propagation of name changes for auxiliary objects
        Migrate options considerations
        Analysis of migration requests
          Analysis using work IDs
          Analysis using migrate profiles
          Analysis run type options
        Overrides of default processing options
          Overrides of general options
          Overrides of the worklist commands
          Overrides of the Analysis parameters
          Overrides of the default settings for utilities and statistics
        Validity and performance checks
          Validation of text dependencies
          Index and tables rebuild considerations
        Review of Analysis results
          Review of the migrate-type worklist
          Edit options for the migrate-type worklist
          Optional check of the sequence numbers in a worklist
          Review of the diagnostic output
        Execution of changes
          Execution options
            JCL generation
            JCL types
            Run type modes of Execution JCL
            Multi-step job option
            Data set name considerations
            Data set size considerations
        Default processing options overrides
          Default JCL Generation option overrides
          Batch Execution JCL Generation Report
          Execution JCL
          Multiple reuse of JCL
          Authorization switching function
            Setting the authorization switching modes
            Global authorization IDs
        The worklist execution process
          Viewing the status of Execution
          Worklist cancellation
          Sync tables
          Migration outputs
          Output for parallel worklists
        Restart methods
          Overview of the restart process
          How the RESTARTPARM keyword affects restarting utilities
          Overview of the startover process
          Considerations for restarting or starting over a worklist
        Accomplishing your goals
          Creating a migrate-type work ID
          Creating a migrate-type work ID in batch mode
          Defining migrate options for a migrate-type work ID
          Creating change rules for a migrate-type work ID
          Converting an external SQL procedure to a native stored procedure
          Specifying the data structures in a migrate-type work ID
          Migrating the auxiliary objects for a LOB column
          Migrating a table space with a history table
          Migrating data structures by using DML
          Assigning a unique name by importing DML
          Defining primary and secondary quantities by importing DML
          Setting a secondary quantity to a factor of a primary quantity by importing DML
          Changing table spaces and indexes to DEFINE NO by importing DML
          Migrating a partitioned table space to a range-partitioned table space by importing DML
          Migrating a single-table table space to a partition-by-growth table space by importing DML
          Migrating tables from an explicit database to an implicit database by importing DML
          Migrating tables that contain inline LOB columns by importing DML
          Migrating stored procedures by importing DML
          Migrating data structures by using a migrate-type work ID
          Creating a stop list
          Creating an outbound migrate profile
          Creating scope rules for an outbound migrate profile
          Specifying locations in an outbound migrate profile
          Creating change rules for a migrate profile
            Using change rules to set objects to DEFINE NO
          Analyzing a migrate-type work ID and generating a worklist
          Creating a receive-type work ID
          Executing a migrate-type worklist
            Migrating only data structures
            Migrating data only or data structures and data
          Restarting a worklist
          Starting a worklist over
        Where to go from here
      Taking a snapshot of a database environment
        Overview
        Overview of baselines
        Strategies to establish baselines
          Application milestone baselines
          Periodic baselines
          Exception baselines
        Considerations for structure-only or full-recovery baselines
          Structure-only baselines
          Full-recovery baselines
        Overview of baseline profiles
        Methods to create structure-only baselines
          Creation of a catalog baseline via a DB2 catalog
          Creation of a DDL baseline via a migrate-type worklist
          Creation of a DDL baseline via a DDL file
        Creation of full-recovery baselines
        Overview of baseline generation
          Available baseline table information
            Objects and authorizations in a baseline
            Work IDs
            Baseline data sets
            Baseline diagnostic output
        Overview of a baseline report
          Baseline report diagnostic output
        Baseline management
          Protection of baselines from deletion
          Deletion of baselines
          Deletion of baselines using DELETEAGE or RETAINMAX
          Deletion of baselines using NoBaseline
          Deletion of baselines explicitly
          Deletion of baselines during a batch run
        Improving the performance of a baseline
        Accomplishing your goals
          Creating a catalog baseline profile
          Creating scope rules for a catalog baseline profile
          Creating a structure-only catalog baseline
          Creating a full-recovery baseline
          Using a script to create a full-recovery baseline
          Browsing a baseline
          Generating a baseline report
          Deleting baselines automatically
          Deleting baselines using a baseline profile
          Deleting a baseline explicitly
          Deleting baselines during a batch run
        Where to go from here
      Comparing database environments
        Before you begin
        Overview
        Comparing data structures
          Synchronizing data structures
            Comparison of a DB2 catalog to a DB2 catalog
            Comparison of a DB2 catalog to a DDL file or a migrate-type worklist
            Comparison of a DDL file or migrate-type worklist to a DDL file or migrate-type worklist
          Versioning data structures
            Comparison of a baseline to a baseline
            Comparison of a catalog baseline to a DB2 catalog
            Comparison of a DB2 catalog to a catalog baseline
            Comparison of a baseline to a DDL file or migrate-type worklist
        Deciding which type of comparison to perform
          Types of scope of a comparison
          Scope rules as the scope
            Baseline profile as the scope
            Outbound migrate profile as the scope
            DDL file or a migrate-type worklist as the scope
          Objects in the input data structures as the scope
            Comparison with a baseline
            Comparison with a DDL file or a migrate-type worklist
            Comparison with a DB2 catalog
        Resolution of mismatched names
          Override the change rules with an outbound migrate profile
        Specifying the options for a comparison
          Types of dependent objects for inclusion
          Object attributes for inclusion
          Uses of outbound migrate profile
          Filter changes via suppress-type rules
          Generate multiple CDL files and change object attributes
        Methods to override the default values for a comparison
          Override data set allocation parameters
          Inclusion of CDL statements
            Inclusion of CDL statement types
            Display of change rules
            Retain the original owner name for an object
        Generating the JCL or the input for the comparison
        Generation of CDL
          Validation of object text dependencies
          Management of renamed objects
        Results of a comparison
          Diagnostic log
          CDL file
        Generation of a CDL file from an alter-type work ID
        Application of the CDL
        Improvement of the performance of a comparison
        Accomplishing your goals
          Comparing a DB2 catalog to a DB2 catalog
          Using a profile to scope a catalog to a catalog comparison
          Comparing a DB2 catalog to a DDL file
          Comparing a DDL file or a migrate-type worklist to a DDL file or a migrate-type worklist
          Comparing a baseline to a baseline
          Comparing a baseline to a DB2 catalog
          Comparing a DB2 catalog to a baseline
          Comparing a baseline to a DDL file
          Generating a CDL file from a work ID
          Using a script to perform a comparison
        Where to go from here
      Altering data structures in a database environment
        Before you begin
        Overview
        Changes to data structures
        Changes to data structures via Specification component
          Identification of changes to data structures
          Changes to auxiliary objects for a LOB column
            Creation of auxiliary objects for a LOB column
            Considerations for changing auxiliary objects for a LOB column
          Conversion of table spaces
            Conversion of a table space to a table-controlled partitioned table space or a range-partitioned table space
            Implicit objects in partition-by-growth table spaces
          Considerations for changing data structures
        Overview of importing files
          Types of file that can be imported
          Types of work IDs that can be used
          Validity checks
          Import results
            Error correction
        Overview of space estimation
        Estimation of space requirements based on user-specified values
        Overview of change analysis
          Methods to override the default processing options
          Validity and performance checks
          Types of Analysis output
        JCL generation
        Execution of changes
          Execution options
          Creation of a multi-step job
          Authorization management
          Worklist execution process
          Outputs of change results
        Accomplishing your goals
          Creating an alter-type work ID
          Creating an alter-type work ID in batch mode
          Sorting work IDs
          Deleting a work ID
          Creating an inbound migrate profile in CHANGE MANAGER
          Replicating multiple work IDs
          Modifying a work ID with values in a user-defined table
          Changing column definitions for imported DDL
          Deleting multiple work IDs
          Deleting sync table entries for multiple work IDs
          Importing a CDL, DDL, or DML file to CHANGE MANAGER
          Importing a DDL file in ALTER
          Specifying changes to data structures
          Creating a primary constraint for a table
          Creating a unique constraint for a table
          Editing the columns for a unique constraint
          Editing a primary key
          Naming a primary key
          Changing the attributes of an index
          Creating indexes for ROWID GENERATED ALWAYS columns by importing DML
          Adding a column to a table
          Dropping a column from a table
          Changing the data type and length of a column
          Moving multiple tables using Quick Edit
          Changing data structures by using an existing work ID
          Receiving DDL to create data structures
          Changing data structures by using DML
          Adding columns to the DB2 PLAN_TABLE table by importing DML
          Deleting aliases by importing DML
          Copying a column by importing DML
          Updating index partitions for a database by importing DML
          Adding WITH RESTRICT ON DROP to tables by importing DML
          Updating table spaces or indexes with existing data sets by importing DML
          Creating synonyms for selected tables by importing DML
          Converting VCAT-defined partitions to STOGROUP-defined partitions by importing DML
          Creating a materialized query table (MQT)
          Creating an application-period temporal table
          Creating a system-period temporal table
          Creating a history table for a system-period temporal table
          Creating a history table from an existing history table
          Creating a history table from a base table
          Creating an archive table from a base table
          Creating an external stored procedure
          Creating a native SQL stored procedure
          Creating a new version of a native SQL stored procedure
          Updating options for a native SQL stored procedure by importing DML
          Updating parameters for a native SQL stored procedure by importing DML
          Estimating the space requirements for a table space
          Estimating the space requirements for an index
          Estimating space requirements for a table space based on user-specified values
          Estimating space requirements for an index based on user-specified values
          Setting space estimation parameters by importing DML
          Estimating the primary and secondary quantities in table space and index partitions by importing DML
          Setting a secondary quantity in table space and index partitions by importing DML
          Creating objects for the SHRLEVEL CHANGE HSSC process
          Modifying and migrating objects for the SHRLEVEL REFERENCE HSSC process
          Converting table spaces to partition-by-growth table spaces by importing DML
          Converting a nonpartitioned table space to an index-controlled partitioned table space
          Converting a nonpartitioned table space to a table-controlled partitioned table space
          Converting a nonpartitioned table space to a range-partitioned table space
          Converting a nonpartitioned table space to a partition-by-growth table space
          Converting a partitioned table space to a nonpartitioned table space
          Changing a partitioned table space to a range-partitioned table space by importing DML
          Converting a table-controlled partitioned table space to an index-controlled partitioned table space
          Converting table-controlled partitioned table spaces to range-partitioned table spaces by importing DML
          Converting a range-partitioned table space to an index-controlled partitioned table space
          Converting an index-controlled partitioned table space to a table-controlled partitioned table space
          Converting index-controlled partitioned table spaces to table-controlled partitioned table spaces by importing DML
          Converting an index-controlled partitioned table space to a range-partitioned table space
          Converting index-controlled partitioned table spaces to range-partitioned table spaces by importing DML
          Converting a partitioned table space to a partition-by-growth table space
          Converting a partition-by-growth table space to an index-controlled partitioned table space
          Converting a partition-by-growth table space to a table-controlled partitioned table space
          Converting a partition-by-growth table space to a range-partitioned table space
          Changing a single-table table space to a partition-by-growth table space by importing DML
          Changing tables in an explicit database to an implicit database by importing DML
          Converting explicit databases and implicit table spaces to implicit databases and table spaces by importing DML
          Changing the encoding scheme for a table space by importing DML
          Adding a ROWID and a LOB column to create a base table
          Creating auxiliary objects for a partitioned table space
          Creating auxiliary objects for a single partition in a partitioned table space
          Liking a base table and creating auxiliary objects for a table space
          Creating auxiliary objects for a nonpartitioned table space
          Converting a VARCHAR data type to a LOB data type
          Creating a new database and new table spaces for tables by importing DML
          Changing multi-table table spaces to single-table table spaces by importing DML
          Moving all empty tables in a database to one table space by importing DML
          Setting table spaces and indexes to DEFINE NO by importing DML
            Updating table spaces and indexes based on cardinality of zero
          Updating table spaces or indexes defined with DEFINE NO by importing DML
          Updating the length of an inline LOB column by importing DML
          Analyzing an alter-type work ID and generating a worklist in CHANGE MANAGER
          Executing an alter-type worklist
          Generating a multi-step job
        Where to go from here
      Maintaining database environments
        Overview
        Migration of changes to data structures
          Sending subsystem considerations
            Establishment of application versions
            Methods for generating CDL
          Receiving subsystem considerations
            Considerations when receiving a DDL file or a worklist
            Evaluation of a CDL file
            Use of an inbound migrate profile
            Implementation of changes
        Migration strategy
          Implementation of a migration strategy
            Benefits of a baseline for control and recovery
        Data structure recovery
        Considerations of the change feedback process
        Use of data modeling tools
          Use of a data modeling tool to import DDL
          Maintenance of catalog information
        Accomplishing your goals
          Migrating data structure changes to other subsystems
          Merging subsystems by using ALTER
          Receiving data structure changes from a strong sender
          Receiving data structure changes from a strong receiver
          Restoring data structures with current data
          Recovering data structures with current data
          Restoring data structures with old data
          Recovering data structures with old data
        Where to go from here
      Managing your PeopleSoft environment with CHANGE MANAGER
        Overview of the PeopleSoft environment
        Meeting the challenges of a PeopleSoft environment
          Snapshot of the initial environments — user case
            Taking a snapshot of the initial environments
          Copies of an existing environment user case
            Creating copies of an existing environment
          Optimization of the design of an environment user case
            Optimizing the design of an environment
      Using scripting tools to automate change management
        Using task IDs
          Creating a task ID
          Listing task IDs
          Editing a task ID
          Executing a task ID
          Viewing the execution status of a task ID
          Browsing a task ID
          Deleting a task ID
        Processing CM/PILOT worklists
          Restarting a CM/PILOT worklist
          Starting a CM/PILOT worklist over
        Using scripts
          Creating a script
          Listing scripts
          Editing a script
          Listing the steps for a script
          Executing a user-defined script
          Browsing a script
          Deleting a script
          Creating a task ID from a script
          Listing task IDs for a script
          Copying a script supplied by BMC
          Copying a user-defined script
        Using applications
          Creating an application
          Listing applications
          Editing an application
          Browsing an application
          Deleting an application
          Creating a task ID from an existing application
          Listing task IDs for an application
      Using utilities with ALTER and CHANGE MANAGER
        Unload utilities options
          The BMC BASIC UNLOAD utility
          The BMC UNLOAD PLUS utility
            Multitask unloading and loading data using UNLOAD PLUS
            Fast unload
            Unload data in separate unload data sets
            Unload data in XML and LOB columns using UNLOAD PLUS
            Dynamically allocate unload data sets using UNLOAD PLUS
            Create an explicit column list
            Unload data from image copies
          The IBM UNLOAD utility
            Dynamically allocate unload data sets using IBM UNLOAD
            Multitask the unloading and loading of data using IBM UNLOAD
            Unload data in LOB and XML columns using IBM UNLOAD
          NGT Recover utility – Unload
            Specify a relative version of the image copy
            Use SHRLEVEL CHANGE or SHRLEVEL REFERENCE copies
          The EXPORT and IMPORT commands
            Specify the number of table spaces per file
            Synchronize the table spaces in the migration file
          Migrating tables with ROWID columns
          Unload Unicode, LOB, and XML data
        Load utilities options
          The BMC LOADPLUS utility
            Convert data with the LOADPLUS utility
            Multiple work data sets using LOADPLUS
            Fast load
            Load data in XML and LOB columns
          The IBM LOAD utility
        Check utilities options
          The BMC CHECK PLUS utility
          The IBM CHECK DATA utility
        Reorg utilities options
          The BMC REORG PLUS utility
            Multiple work data sets in REORG PLUS
          The IBM REORG utility
          Generate SHRLEVEL reorgs
          Dynamically allocate reorg data sets
          Considerations for using the REORG utilities
        Recover and rebuild utilities options
          NGT Recover utility
          The IBM REBUILD INDEX utility
          Considerations for using the RECOVER and REBUILD utilities
        Copy utilities options
          The NGT Copy utility
          The IBM COPY utility
          Copy and register the data sets
          Create image copies
            Build image copies before DROPs or REORGs
            Select the utility to create the image copy
            Create partition-level image copies
          Dynamically allocate copy data sets
            Considerations for using dynamic allocation
        Statistics utilities options
          Statistic collection options
            The BMC BMCSTATS utility
            The IBM RUNSTATS utility
            Use other utilities
          Update statistics options
            BMCSTATS or BMC utility statistics
            IBM RUNSTATS or IBM utility statistics
      Using the Skeleton Library compiler
        SLIB compilation
        SLIB changes
          SLIB verification using ISPF file tailoring
          Compilation of changed SLIBs
        SLIB processing
          Generating the SLIB report
      Using worklist parallelism
        Considerations for enabling worklist parallelism
        Control of XIM execution
          Determining the status of XIM
          Starting XIM
          Inactivating XIM initiators
          Shutting down XIM
          Activating XIM initiators
          Modifying MVS image variables
          Troubleshooting the execution of XIM
        Required conditions for processing a worklist in parallel
    APPLICATION RESTART CONTROL Reference Manual
      Introduction
        Overview
        Working with REGISET records
          Types of records
          Record IDs
            Standard qualifiers
            Special-use qualifiers
            Record ID qualifiers
          Wildcard characters in record qualifiers
          Order of REGISET records
          Examples of wildcard usage
            Example 1
            Example 2
            Example 3
            Example 4
        Getting started with the AR/CTL ISPF interface
          Setting up your ISPF session
          Using general panel elements
            Navigation
            Commands
          Using the Application Enhancement Series primary menu
          Using the APPLICATION RESTART CONTROL primary menu
          Using the Active BMC Consolidated Subsystems panel
          Using the Limit List of Records panel
          Using the List Records panel
          Using the Add Record panel
          Using the Delete Record panel
          Using the Last Update Data panel
      Working with active records
        Overview
        Working with restart control records
          Displaying a restart control record
          Modifying the status in a restart control record
          Displaying and changing restart data set information
          Displaying restart data set contents
          Displaying sequential file information
          Displaying VSAM file information
          Setting the manual restart mode
        Working with VSAM recovery records
        Listing restart control records
          JCL requirements
          Output data
        Resetting restart control record status
          JCL requirements
          Output report
      Using checkpoint pacing and the current shift identifier
        Overview
          Checkpoint pacing intervals
            Pacing interval between checkpoints
            Threshold interval without a checkpoint
          Checkpoint pacing class records
          Current shift identifier
          Checkpoint pacing implementation
        Working with checkpoint pacing records
        Using the General Pacing Class Options panel
          Pacing exit
          Pacing status code
          Pace DB2 applications
          Pace IMS Fast Path applications
          Pacing Interval between Checkpoints—Condition
          Threshold Interval without a Checkpoint—Condition
          Threshold Interval without a Checkpoint—Action
        Using the Checkpoint Pacing Class Options panel
          Pacing Interval between Checkpoints—Checkpoint count
          Pacing Interval between Checkpoints—Checkpoint elapsed time
          Threshold Interval without a Checkpoint—Elapsed time
          Threshold Interval without a Checkpoint—CPU time
        Using the Pacing Class Options panels
          Pacing Interval between Checkpoints—Calls
          Threshold Interval without a Checkpoint—Calls
        Setting the current shift identifier
          Using the Current Shift Display/Update panel
          Using the Set Current Shift utility
            JCL requirements
            Return and abend codes
            Set current shift report
      Using AR/CTL reports
        Overview
        Accessing reports in the history data set
        Understanding Checkpoint reports
          General information
          Environment Description report
          Restart Counts report
          Checkpoint Counts report
          DL/I Call Counts report
          Application Sequential Access Method Call Counts report
          Local Virtual Storage Access Method Call Counts report
          Remote Virtual Storage Access Method Call Counts report
          Elapsed Time During Checkpoints Completed report
          Elapsed Time Between Checkpoints Completed report
        Using the History Record Purge utility
          JCL requirements
          Utility report
      Setting processing options
        Overview
          Processing option records
          ARCSYSIN keywords
          AR/CTL directory
          Changing option values
          Option descriptions
          Pre-Execution Options Summary report
          Option summary
        Working with processing option records
          Accessing processing option records
          Using the processing options panels
        Using the General Options panel
          APPLICATION RESTART CONTROL active
          Default AR CTL identifier (ARCID)
          Bypass execution ddname
          Check XRST
          Check CHKP
          Check IMS updates
          Early termination by time of day
          Early termination time
        Using the Automation Options — Part 1 panel
          Automatic restart
          Automatic checkpoints
          Automatic DB2 cursor repositioning
          Action for no repositioning record
          Defer cursor with hold check
        Using the Automation Options — Part 2 panel
          Pace checkpoints
          Pacing class name
          Reattach application program
          Reattach class name
          Intercept program exceptions
          Program exception class name
        Using the Automatic Checkpoint Options panel
          Trigger count
          Trigger QSAM/VSAM ddname
          Trigger IMS PCB name
          Trigger IMS relative PCB number
          Trigger IMS basic CHKP call
          Trigger IMS SYNC call
          Trigger DB2 cursor name
          Trigger DB2 package/DBRM name
        Using the Automatic Restart Options panel
          Restart return code
          Restore working storage
        Using the Execution Options — Part 1 panel
          Number of history sets
          Normal termination SYSOUT class
          Department name
          Allow cold start overrides
          Always cold start
          XRST call exit name
          CHKP call exit name
          Submit restart exit name
        Using the Execution Options — Part 2 panel
          Ignore job name
          Non-unique job step
          Allow related restart when normal
          Restart Qualifiers
          Previous Qualifiers
        Using the DB2 Options panel
          DB2 attach type
          Intercept SQL return codes
          SQL return code class name
        Using the IMS Options panel
          Replace IMS GSAM with ASAM
          Write checkpoints to IMS log
          Use AUTO$ASB with IMS
        Using the VSAM Options panel
          Perform VSAM logging
          Perform VSAM dynamic backout
          Defer WAL writes
          VSAM dynamic backout log ddname
          CICS SVC number
          Initialize file sharing environment
          VSAM file sharing only
          Autosync trigger ddname
          Autosync trigger count
          VSAM file control table ddname
        Processing options available in ARCSYSIN only
          DEACTOCI
          JSCCBKOUT
          TRACE
          TRMAFTERCKP
          TRMAFTERMAX
          TRMAFTERMIN
          TRMBEFORCKP
          TRMBEFORMAX
        Setting options in the ARCSYSIN data set
          Control statement syntax
          ARCSYSIN keyword summary
      Preparing for dynamic allocation
        Overview
          Dynamic allocation records
          Checkpoint data set
            AR/CTL management of the checkpoint data set
            Allocation information
          Restart data set
          Trace data set
          VSAM dynamic backout log
          Data set/program option library
          AR/CTL DB2 connection parameter library
          History data set
          VSAM file control table data set
        Working with allocation records
          Accessing allocation records
          Using the dynamic allocation options panels
        Using page 1 of the Skeleton Options panel
          SMS data set
          DSN
          Unit
          Unit count
          Space allocation type
          Primary quantity
          Secondary quantity
          Volume serial
        Using page 2 of the Skeleton Options panel
          Label type
          Expiration date
          Retention period
          Management class
          Storage class
          Data class
        Using the Concatenation List Options panel
        Using the ARVFCTAB Data Set Name panel
        Constructing data set name skeletons
          Data set name skeletons for new data sets
          Data set name skeleton syntax
          Data set name skeleton substitution keywords
          Example skeletons
      Setting cursor repositioning options
        Overview
        Enabling cursor repositioning
        Working with cursor repositioning records
        Using cursor repositioning options
          Repositioning method
        Using cursor repositioning column options
      Setting application reattach options
        Overview
          Reattach in an IMS environment
          Reattach in a DB2 environment
          Reattach in a VSAM environment
          REATCLAS default reattach class record
          Reattach for out–of–space conditions on the checkpoint data set
        Working with reattach class records
          Setting up AR/CTL for application reattach
          Accessing reattach class records
        Using the reattach options
          Abend code
          Reason code
          Reattach delay
          Number of reattach attempts
          Number of retry attempts per UOW
        Reattach example
          Setup for reattach
          Reattach processing during execution
      Setting data set and program options
        Overview
          Data set options
          Program options
          AUTO$ASB method
            The AUTO$ASB method and specific FCBs
            Use with non-IMS programs
            Use with IMS programs
            Use with IMS-compatible mode programs
            Considerations for AUTO$ASB use
          Data set and program options with IMS GSAM data sets
          Program and data set option use with IMS-compatible mode
            Use of an existing PSB and existing DBDs
            Use of a program options member
        Working with data set option (FCB) members
          Selecting default data set option members
          Selecting specific data set option members
          Setting data set option values
        Using data set options
          DDname
          Stage output
          Stage blocks
          Stage error
          Reposition options
          User exit name
          Reread record at reposition
          Bypass intercept
          Access level
          CICS file ID
          CICS base cluster file ID
          CICS APPLID
          File type
          IMS RSA emulation
          LRECL
          BLKSIZE
          RECFM
          BUFNO
          NCP
        Working with program option (ASB) members
          Selecting program option members
          Setting program options
          Inserting data set option member names from a list
          Inserting data set option members or placeholders
          Updating ASAM information
      Preparing for remote VSAM access services
        Overview
          Remote VSAM access connection ID table
          Remote VSAM access APPLID table
          Remote VSAM access file table
        Working with the CICS connection ID table
        Working with the CICS APPLID table
        Working with the remote VSAM access file table
      Setting program exception class options
        Overview
        Enabling program exception handling
        Working with program exception class records
        Using the Program Exception Class Options — Part 1 panel
          Active
          Maximum Abend Count
          User Abend Code
          Reason Code
        Using the Program Exception Class Options — Part 2 panel
          Action
          Report file ddname
          Input file ddname
          Reject file ddname
          Field
        Displaying working storage fields in the Program Exception report
          Using program ARCCS01
          Using the initialization call to program ARCCS01
          Using the termination call to program ARCCS01
          Example use of program ARCCS01
        Using the Program Exception report
      Setting SQL return code class options
        Overview
        Enabling SQL return code interception
        Working with SQL return code class records
        Using SQL return code class options
          SQL Return Code
          Abend Code
          Reason Code
          Dump
      Setting unit-of-work boundary automatic checkpoint controls
        Overview
        Enabling unit-of-work boundary processing
        Working with unit-of-work boundary records
          Using the Unit of Work Boundary Detail Insert panel
          Using the Unit of Work Boundary Record Detail panel
          Using the Delete Record Element panel
          Using the Unit of Work Boundary Update Element panel
          Using the Restore Record Element panel
      Implementing user exits
        Overview
        Using the Checkpoint Pacing exit
          Invoking the Checkpoint Pacing exit
          Using Checkpoint Pacing exit registers at entry
          Setting Checkpoint Pacing exit registers for return
        Using the XRST and CHKP exits
          Invoking the XRST exit
          Invoking the CHKP exit
          Using XRST and CHKP exit registers at entry
          Setting XRST and CHKP exit registers for return
          Using the $ARCUEXT control block
        Using the Submit Restart exit
          Implementing and invoking the Submit Restart exit
          Using Submit Restart exit registers at entry
          Setting Submit Restart exit registers for return
        Using the Data Services user exit
          Implementing and invoking the Data Services user exit
          Using Data Services exit registers at entry
          Setting Data Services exit registers for return
          Using the Data Services user exit parameter block
      Using the AR/CTL Batch Registration utility
        AR/CTL Batch Registration utility overview
        JCL Requirements
        Utility report
      Retrieving AR/CTL job information
    APPLICATION RESTART CONTROL User Guide
      Introduction
        Overview
          AR/CTL products
            APPLICATION RESTART Control for IMS
            APPLICATION RESTART Control for DB2
            APPLICATION RESTART Control for VSAM
          AR/CTL functions
            AR/CTL Installation System
            Communication with BMC Software subsystems
            AR/CTL application supervisor
            AR/CTL enhanced processing
            Internal and external security
            Panels for managing the AR/CTL ISPF environment
            Utilities for managing the REGISET
          BATCH CONTROL FACILITY component of AR/CTL
          AR/CTL services
        Checkpoint/restart services
          Restart processing
          Checkpoint processing
          Automated checkpoint data set processing
          Automated checkpoint/restart determination
          Checkpoint control by shift
          Application reattach options
          IMS-compatible mode
          QUICKSTART-to-AR/CTL bridge
        Data services
          Sequential file interception
          Local VSAM access
          Remote VSAM access (file sharing)
          GSAM replacement
          ASAM callable interface
          DB2 cursor repositioning
          Program exception handling
          SQL return code handling
          Unit-of-work boundaries
        Operational services
          Suspend-and-resume interfaces
          Automatic registration of non-IMS programs
          AR/CTL for DB2 batch attachment facility
          Early termination support
          On-demand snap dumps
          Enhanced call tracing
        AR/CTL components
          AR/CTL ISPF interface
          Batch utilities
          Operator communications interface commands
          BMC Software subsystems
            BMCP
            BCSS
          Execution modules
          Registration data sets and REGISET
          REGISET records
          History data set
          Data set options and program options
          Checkpoint/restart data sets
          Trace data sets
          VSAM dynamic backout log data set
          VSAM file control table data set
        Implementation of AR/CTL
        Considerations
          System resources
            Hardware
            Operating system
          Required BMC Software products
          DB2 considerations
            DB2 requirements
            DB2 restrictions
            AR/CTL product license
            Cursor WITH HOLD option
            Connection types
            AR/CTL DB2 plan
            Products that perform batch attach
            Statically-linked DB2 language interface module
            CAF and RRSAF programs
            Execution without AR/CTL
            Data sharing groups
          IMS considerations
            IMS requirements
            AR/CTL product license
            PSB PROCOPTs
            Region types
            Automatic checkpoints
            Fast Path databases
            Abend and restart on different IMS systems
            Multiple MVS tasks
          IMS-compatible mode considerations
            AR/CTL product license
            IMS requirements
            IMS calls
            Generated control blocks
            IMS region types
            Automatic restart and automatic checkpoints options
          CICS/VSAM considerations
            CICS
            AR/CTL product license
            VSAM batch local shared resources
          Considerations for using AR/CTL services
            Temporary data sets
            Concatenated input
            Input sequential PDS and PDS/E members
            Rollback processing
            Truncated blocks
            Performance
            Stream-oriented I/O
          Considerations for other software products
            Job scheduling and job restart packages
            CASE tools
            DASD compression products
            Diagnostic aid products
            Non-IBM software
            Products for application testing
            BMC Software IMS database utilities products
          Operational considerations
            Shared REGISET
            Uncataloged data sets in STEPLIB
            ABEND STEP processing
            Stop region and OS cancel commands
      Getting started
        Overview of AR/CTL tasks
        Getting started with AR/CTL implementation
          Making implementation decisions
          Setting up AR/CTL records
          Setting up AR/CTL with application program changes
          Setting up AR/CTL with JCL changes
          Performing other setup tasks
          Executing with AR/CTL
          Handling problems
        Getting started with AR/CTL setup
          Creating an environment registration record
          Creating a program registration record
          Creating an automatic registration record
          Creating a program exclusion record
          Creating a processing options record
          Setting up cursor repositioning options
          Setting up reattach options
          Setting up program exception class options
          Setting up SQL return code options
          Setting up dynamic allocation options
          Setting the current shift identifier
            ISPF interface
            Batch job
          Setting up checkpoint pacing
          Setting up unit-of-work boundaries
        Getting started with AR/CTL operations
          Using the operator communications interface
            Early termination support
            On-demand snap dump
            Enhanced call tracing
            Using OCI functions
          Using statistical reports
          Working with active records
        Excluding or disabling AR/CTL
          Exclusion methods
          Exclusion considerations
            Exclusion for IMS programs
            Exclusion for DB2 programs
            Exclusion for non-IMS non-DB2 programs
            Exclusion for programs that use the AESDOLLARSIGNssid DD statement
        Testing the application program with AR/CTL
        Using AR/CTL DD statements
        Using the IMS CHKPID parameter
        Setting up DB2 connections
          Specifying DB2 connection information
            Non-IMS programs
            IMS and IMS-compatible programs
          Specifying DB2 connection parameters
        Using the AR/CTL Status Check utility
      Using AR/CTL checkpoint/restart services
        Overview
        Methods for requesting checkpoint/restart services
        Checkpoint/restart processing in an application program
        Checkpoint/restart request considerations
        Application program changes between abend and restart
        Program code to execute at restart
        Forced checkpoints
        Using DB2 commit statements to trigger checkpoints
      Using AR/CTL data services
        Overview
        Methods for using data services
        General data services considerations
          Using checkpoint/restart services with data services
          Output sequential files
          Preallocating data sets
          Using GDGs
          Using ASAM data set allocation parameters
            Existing data set
        Using sequential file interception services
          Application program calls
          Processing option values
          Considerations
        Using local VSAM access services
          Application program calls
          Processing option values
          Considerations
        Using remote VSAM access services
          Application program calls
          Processing option values
          VSAM file control table data set
          AR/CTL enhanced processing
          CICS environment and connection information
          CICS connection ID and APPLID tables
          CICS resource usage
            Resource locks
            Overflow of the CICS system log
          Using automatic syncpoints
            Restart issues
            Requirements for automatic syncpoints
            Actions of automatic syncpoints
            Methods for controlling automatic syncpoints
        Using ASAM services through GSAM replacement
          GSAM replacement call overview
          Data set options
          Processing option values
        Using ASAM services through the ASAM callable interface
          ASAM callable interface supported data set types
          ASAM call
          Data set and program options
        Copying an ASAM data set
          JCL requirements
          SYSIN keywords
          Completion codes
          ASAM Copy utility report
      Using AR/CTL operational services
        Overview
        Using AR/CTL suspend-and-resume interfaces
          Suspend-and-resume overview
            AR/CTL suspend processing
            AR/CTL resume processing
          Interface with BMC Software products for IMS
            Requirements
            CONCURRENT REORG interface processing
            HPC interface processing
            Implementing the interface
          Interface with the REORG PLUS for DB2 Online Feature
            Requirements
            Interface processing
            Implementing the interface
        Using early termination support
          Uses for early termination support
          Backout with early termination
          Processing options for early termination
          OCI commands for early termination
            Examples
          Early termination support with an IMS application program
        Using on-demand snap dumps
        Using enhanced call tracing
          Overview of enhanced call tracing
          Allocating the ARCDLTRC data set
          Starting and stopping enhanced call tracing
            Examples
          Using trace records
        Formatting trace data
          JCL requirements
          SYSIN keywords
            Examples
        Using formatted trace reports
          General information
          IMS Trace Header Information report
          DB2 Trace Header Information report
          IMS Trace Detail Information report
          DB2 Trace Detail Information report
          DB2 Trace Trailer Information report
          IMS Trace Trailer Information report
          Trace Summary report
          Dump Format reports
      Changing COBOL application programs
        Overview
          Supported versions of COBOL
          Types of AR/CTL calls
          Sample COBOL programs
          EXEC parameters
            Length of parameter list
            Original operating system parameters
          Compile and link issues
            Dynamic linking
            IMS environment
            Static linking
            Other compiler options
            Linking of IMS dash compatible programs
          Considerations for using Language Environment
          Considerations for using AR/CTL with COBOL programs
        Using AR/CTL-format checkpoint/restart calls
          Using the restart call
          Coding a restart ID area
          Using the AR/CTL checkpoint call
          Coding the checkpoint ARB
        Managing virtual storage for subprograms
          Overview of the ARCSPVS API
            Virtual storage areas
            Checkpoint data set
            ARCSPVS API structures and functions
            Program changes before restart
          Implementing the ARCSPVS API
          Identifying virtual storage areas to be managed
          Creating the $ARCSPVS parameter block
          Using the Define function
          Using the Refresh function
          Using the Delete function
        Using AR/CTL common calls
          Using the AR/CTL common call
          Coding an I/O area
          Example program using the AR/CTL common call
        Using IMS-compatible checkpoint/restart calls
          Entry and return
          Call function codes
          Using the XRST call
          Using the CHKP call
          Coding the checkpoint I/O area
          Coding the checkpoint PCB mask
        Using ASAM services through GSAM replacement
          Entry and return
          Call function codes
          OPEN call
          GN call
          GU call
          ISRT call
          CLSE call
          ASAM I/O area
          ASAM PCB mask
          Record search arguments
        Using ASAM services through the ASAM callable interface
          ASAM call
          ASAM I/O areas
          ASAM ARB
      Changing PL/I application programs
        Overview
          Supported versions of PL/I
          Types of AR/CTL calls
          Sample PL/I programs
          Coding considerations
          EXEC parameters
            Length of parameter list
            Original operating system parameters
          Compile and link issues
          Run-time considerations
        Using AR/CTL-format checkpoint/restart calls
        Managing virtual storage for subprograms
          Implementing the ARCSPVS API
          Identifying virtual storage areas to be managed
          Creating the $ARCSPVS parameter block
          Using the Define function
          Using the Refresh function
          Using the Delete function
        Using AR/CTL common calls
        Using IMS-compatible calls
        Using ASAM callable interface calls
      Changing Assembler language application programs
        Overview
          Types of AR/CTL calls
          Sample Assembler language programs
          EXEC parameters
            Length of parameter list
            Original operating system parameters
          Assemble and link issues
            Dynamic linking
            Static linking
        Using AR/CTL-format checkpoint/restart calls
        Managing virtual storage for subprograms
          Implementing the ARCSPVS API
          Identifying virtual storage areas to be managed
          Creating the $ARCSPVS parameter block
          Using the Define function
          Using the Refresh function
          Using the Delete function
        Using AR/CTL common calls
        Using IMS-compatible calls
        Using ASAM callable interface calls
      Solving problems
        Overview
        Handling application program situations
          Restarting a non-unique job step
          Cold-starting a job step after an abend
          Restarting at other than the selected checkpoint
            Non-IMS program
            IMS program
        Handling checkpoint/restart data set problems
          Correcting a checkpoint data set out-of-space condition
          Handling a destroyed or damaged checkpoint/restart data set
            Checkpoint records exist in the IMS environment
            Checkpoint records do not exist or non-IMS environment
        Handling ASAM data set situations
          Correcting an ASAM data set out-of-space condition
          Handling a destroyed or damaged ASAM data set
        Handling system problems
          Recovering from a system failure
          Handling a cold start of IMS
          Recovering from a CICS system failure
          Recovering from a disaster
          Handling a checkpoint-in-doubt condition
            DB2-only program
            IMS-only and IMS DB2 program
            BMP-only program
        Contacting BMC Software Customer Support
          Preparing information for Customer Support
          Creating a diagnostic tape
          Obtaining traces
            Printing diagnostic trace data sets
          Obtaining dumps
          System dump options
            Recommended dump options
      Locating samples
        Overview
        Program samples
        JCL samples
        Macro and definition samples
        User exit routines
      Using program ARCCTRL
    APPTUNE for DB2 User Guide
      Overview of APPTUNE
        Introduction
        Operating environment
        Shared infrastructure components
        APPTUNE components
          Data Collector
          Report Manager
          Sysplex support
        APPTUNE features
          APPTUNE report set
          Command interfaces
          SQL Statement Cache monitoring
          User options
          SQL text summarization
          IN-SQL and IN-DB2 time
        APPTUNE administration
          User Profiles
          DOMPLEX option sets
          APPTUNE filters
          Collection options
          Summarization options
          Resource-saving options
          Exception options
          Efficient statement processing
        APPTUNE security
      Getting started with APPTUNE
        Logging on
        Navigation
        Panel layout
          Panel elements
        Online report layout
          Online report elements
        APPTUNE Main Menu
        Online assistance
      APPTUNE reports
        APPTUNE report set
          Navigating between reports
          How to work with reports
            Sort
            Data export
            Report logs
            Display online reports
          Application groups and application profiles
        Report types
          Workload analysis reports
            Report data
            Exception reports
            Object analysis reports
          Explain function
            Logical DB2 Cache Analysis report
          SAP reports
        Batch reports
      Workload analysis tasks
        Preparing for workload analysis
        Identifying a costly SQL statement
        Monitoring a workload by interval
        Filtering report data
        Selecting a numeric or graphical report format
        Monitoring SQL statement cache entries
        Using application groups and profiles
        Viewing near-term historical data from current trace data sets
        Viewing long-term historical data from archived trace data sets using Archive as data source
        Viewing long-term historical data from specific archived trace data sets
      Batch processing
        Overview
        Selecting the source data for reporting
        Archive directory
          Viewing archived data sets
          Viewing interval record details
        DOMBRPT1 utility
          SYSIN control statements
            SYSIN control statement syntax
            SYSIN control statement parameters
          REPORT statement
            REPORT statement syntax
            REPORT statement parameters
          INTERVAL statement and parameter
            Data source
            INTERVAL parameters
          QUALIFIER statement and parameter
          SORT and SORT2 statements and parameters
          EXPAND statement and parameter
          LINESPP statement and parameter
          OUTLIM statement and parameter
          APPPROF statement and parameter
          DB2LOAD statement and parameter
        Batch report output
          SYSPRINT
            SYSIN options
            Filter and sort options
          Batch reports
            Batch SQL Statement Analysis report example
            Plan Analysis (DATA) report example
            Group Analysis (DATA) report example
            Select Analysis Interval report example
            Batch SQL Text report example
            SQL Error Analysis report example
            Batch SQL Exceptions Analysis report example
            Program Analysis report and SQL Statement Analysis report examples
            Buffer Pool Analysis report example
            Page Set Analysis report example
            Batch Object Detail Analysis report example
            Object and User Analysis report example
            Active Index With No Reads report example
          Recommendations
          Other batch utilities
            DOMBLOD1 utility
            Loading data into DB2 tables
            PSSBLOAD utility
            PSSBLOAD utility members
            PSSBLOAD tables
            Preparing to use PSSBLOAD
            Loading APPTUNE data into DB2 tables
        DOMBPLOG utility
        DOMBSWIT utility
      Explaining SQL statements
        Overview of the Explain function
          Explain types
          Explain entry points
          Main panels
          Task bar
          Actions
          Commands
          Layout data set
          Explain parameters
          Explain return codes
        Specifying JCL options in batch mode
        Setting data set options
        Generating a list of packages to Explain
        Specifying Explain options
        Specifying batch Explain options
          Display of accelerator information in batch Explain reports
        Allocating a data set for a specific job
        Expert rules
          Using predefined expert rules
          Severity codes in rules
          Customizing expert rules
          Defining new expert rules
            Structure of rules
            PSSRXSQL external function
            PSSRXSQL return codes
            Printing error messages
          Displaying Help for expert rules
        Explaining a package online
        Explaining a package in batch
        Explaining an ad hoc SQL statement
        Working with Explain results
        Editing the Explain report layout
      MainView APPTUNE
        Overview of the MainView APPTUNE GUI
        Completing MainView customization
        Connecting to MainView APPTUNE
          Logging onto MainView APPTUNE from an ISPF interface
          Accessing MainView APPTUNE from a MainView Explorer session
        Using MainView APPTUNE
          How to open and close MainView APPTUNE views
          How to customize MainView APPTUNE views
          Workload reporting
            Selecting a time interval to analyze
            Using MainView APPTUNE hyperlinks to drill down to a SQL statement Explain
            Accessing data detail for a SQL statement
          Assessing application health
            Accessing data across applications
            Displaying analysis data across applications
            Application health views in graph format
          Using global SQL Performance data filters
          Application health reports
        MainView APPTUNE views
      APPTUNE and Pool Advisor exits
        Set user ID for security checks (DOMEXIT1)
        Override Pool Advisor security attributes (DOMEXIT2)
        Validate DB2 user authority (DOMEXIT4)
        Set Pool Advisor session ID (DOMEXIT6)
      APPTUNE and SQL Performance commands
        Displaying the available Commands panel
        Product commands
          ABOUT
          ADDDB2
          ADDPROD
          ADMIN
          AP
          APPFILT
          APPOFF
          APPRESET
          APPON
          APPSTAT
          BEEP
          CANCEL
            User session
            Data Collector
          CAPS
          CHANGES
          CLEAR
          CMD
          CMDBOT
          CMDDB2
          CMDDC
          CMDMENU
          CMDOPT
          CMDTOP
          COLOR
          DBCS
          DEBUG
          DELDB2
          DELPROD
          DOWN
          DUMP
          END
          ENQS
          ERASE
          EXPAND
          EXPORT
          FIND
          FKA
          FKEYS
          HELP
          HOME
          IEDIT
          IFCIDS
          KEYS
          LEFT
          LOCATE
          LOG
          LOGOP
          MENU
          MODIFY
          NEXT
          OBJSUM
          OPTIONS
          OUTLIM
          PANELID
          PFKEYS
          PFKS
          PRODUCTS
            PFSHOW
          QUIT
          RESET
            Function keys
            Command interfaces
            REFRESH
          RETRIEVE
          RETURN
          RFIND
          RIGHT
          RLOG
          SHOWCMDS
          SHUTDOWN
          SORT
          SPFOFF
          SPFON
          STATUS
            User session
            Report information
            Data Collector
          STATUSR
          STATUSS
          STOP
            User session
            Data Collector
          STORAGE
          SWITCH
          SYSPLEX
          TERSE
          TOP
          UP
          USERS
          ZFILTER
          ZOOM
            Reports
            Explain Panels
      APPTUNE report list and navigation
        Batch reports
        Online reports
        SAP reports
        Load reports
        APPTUNE report navigation
      Sample Explain queries of the History table
        Sample history table Explain queries
      Integrating multiple System and SQL Performance products
        Product description
        Integration
      Available variables for expert rules
        List of variables
      Explain report fields
    CATALOG MANAGER for DB2 User Guide
      Overview of CATALOG MANAGER
        CATALOG MANAGER features
          List of DB2 catalog objects
          Object creation
          DB2 catalog search
          Object description
          Data manipulation
          Command and statement execution
          Utility profiles
          Dropped object recovery
          Action log maintenance
          Remote DB2 subystem access
          Update and execution of SQL statements
          Authorization management
          Indirect catalogs
          SQL Explorer execution
          Support for DB2 Analytics Accelerator for z/OS
        Integration with BMC solutions
          Administrative Assistant for DB2
          Database Administration for DB2
          System Performance for DB2
          BMC Object Administration for DB2
          BMC Next Generation Technology Database Administration for DB2
        Where to go from here
      Getting started with CATALOG MANAGER
        Accessing CATALOG MANAGER functions
          Using the Primary Menu panel
          Using the Command line
          Using a command recognition character
          Working in pop-up windows
          Selecting an Action
          Identifying an object type
          Specifying object qualifiers
            Supported wildcards in qualifiers
            Wildcards with fixed-length CHAR columns
            Qualifiers for objects with two-part names
            Qualifier exceptions
        Using nonprintable or nonviewable characters
        ISPF commands
        Getting help
        Navigation in CATALOG MANAGER
        Generating lists in CATALOG MANAGER
          List panels
          Generating an object list from the Primary Menu panel
          Generating secondary lists
        Listing and executing commands
          Displaying the online command reference
            Displaying the complete online command reference
            Accessing information about a specific command
            Listing commands that are valid for an object list
          Command prefixes
          Abbreviated command keywords and object names
          Omitted object types in commands
          Multiple objects in a command
          Issuing commands from the Cmd column
          Issuing Wait-for-Enter commands against multiple objects
        Using Fast Path Navigation
        Where to go from here
      Setting up CATALOG MANAGER
        Viewing settings
          Viewing information about the environment
          Viewing DB2 initialization parameters
          Viewing the CATALOG MANAGER common area
          Viewing and updating DB2 special registers
        Granting access to CATALOG MANAGER functions
          Plan manipulation commands
        Setting the MEMLIMIT system parameter
        Using options to control your environment
          Using the installation options
          Using the user options
          Using the product options
          How CATALOG MANAGER uses options
        Setting user options
          Defining an options data set
          Setting basic options
          Setting general options
          Setting object use options
          Setting JCL Generation options
          Setting data set options
          Setting SQL and confirm options
          Setting SQL SELECT options
          Setting panel graphic options
          Setting CATALOG MANAGER switches
          Setting DESCRIBE options
        Setting product options
          Setting the JCL options for job cards
          Setting the JCL options for STEPLIBs
          Setting the JCL options for static data sets
          Setting the JCL options for tapes
          Setting the JCL options for temporary work data sets
          Setting the JCL options for permanent data sets
          Setting the JCL generation data group (GDG) options
          Setting the JCL debugging, display, and Execution options
          Setting the installation options module names for BMC utilities
          Setting the online reorg options
          Setting the NGT utility options
          Setting the non-worklist JCL options
          Setting the LISTDEF and TEMPLATE data set options
          Setting user variables
          Creating a user POF
          Updating a user POF
          Using multiple POFs
          Refreshing the initial POF
          Generating POF reports
          Reusing a POF in a subsequent installation
          Overriding POF values in SLIBs
          Adding steps to the JCL
          Obtaining a list of TEMPLATEs or LISTDEFs in CATALOG MANAGER
          Using the commands table
            Setting up and modifying the user commands table
            Editing commands in the user commands table
            Adding commands to the commands table
            Disabling commands in the user commands table
            Commands table syntax and parameters
            Migrating a user commands table to a new release of CATALOG MANAGER
        Writing user commands as CLISTs
          Development aids for user commands
          Command program parameters
          Passing object type and name
        CATALOG MANAGER tables
        Where to go from here
      Accessing other DB2 subsystems
        Using the DB2 Attach feature
          Attaching CATALOG MANAGER to a specified SSID
          Attaching to an SSID or server by using the connection selection list
          Switching catalog access
          Restoring the default attachment
        Using the DB2 Connect feature
          Connecting to a specified SSID
          Obtaining data set information from a remote SSID
          Connecting to a remote SSID from a location list
          Connecting to a remote SSID and issuing DB2 commands to manipulate objects
          Using saved connections
        Viewing the connections table
          Using DB2-identifiers with the CONNECT command
          Identification of attachments or connections with unique values
          Displaying the current server ID
        Troubleshooting a DB2 Attach or DB2 Connect failure
        Where to go from here
      Working with lists and searches
        Using mixed lists
          Valid source objects for mixed lists
          Generating a mixed list
        Combining lists
          Generating a combined list
          Excluding objects from a combined list
        Using SEARCH to generate lists based on object attributes
          Valid objects for searches
          Generating a list by using the SEARCH command
          Using host variables in a search
        Using the Quick-Search feature
          Using saved search variables in a Quick-Search
          Using a WHERE clause in a Quick-Search
        Creating complex searches
          Creating searches that do not contain a JOIN
          Creating searches that contain a JOIN
        Customizing object list displays
          Specifying a new order for displayed columns
          Using the traditional list line format
          Sorting a list by one or more columns
          String value search
          Counting items
        Describing list objects
          DESCRIBE command
          DES command
          D and S commands
          DESTATISTICS command
          Printing lists
        Generating JCL for a job in batch
          Using the BATCH command for a DB2 object list or a mixed list
          Using the BATCH command for a CATALOG MANAGER list or search
        Generating editing and executing SQL
          Confirm SQL panels
          Using the SQL_Table
            Displaying the SQL_Table list
            Copying SQL in the SQL_Table
            Copying external SQL
          Applying SQL model statements
          Using extended SQL processing
        Where to go from here
      Browsing and editing data
        Browsing table data
          Methods for invoking the data browsing function
          Setting options for browsing data
          Browsing data
          Browsing data in LOB columns
        Editing table data
          Methods for invoking the data editing function
          Setting options for editing data
          How CATALOG MANAGER handles lock contention
          Editing data
        Copying table data
          Using the COPY command
          Using the Copy Table Rows option
        Where to go from here
      Creating objects
        Before you begin
        Space requirement estimates based on user-specified values
          Estimating space requirements for a table space
          Estimating space requirements for an index
        Using an existing object as a model to create objects
          Considerations for creating objects
          Example of creating a table
        Generating DDL to create objects
        Where to go from here
      Dropping and recovering objects
        Considerations for dropping objects
          Considerations for dropping a table space
          Considerations for dropping pending changes
          Considerations for dropping a table
          Considerations for dropping an index
        Simulating a drop
        Dropping an object
        Recovering an object and its data
        Where to go from here
      Generating utility jobs
        BMC products
        IBM DB2 utilities
        Multiple utility command limitations
        Utility profiles
          Creating a site profile
          Creating a user utility profile data set
          Creating a utility profile for a single utility
          Creating a utility profile for multiple utilities
          Creating a utility profile from an existing profile
          Editing a utility profile
          Working with the last used utility profile
          Switching utility profiles
        TEMPLATE and LISTDEF control statements
          Available utilities for TEMPLATE and LISTDEF statements
          Incorporating TEMPLATE and LISTDEF statements
        Where to go from here
      Issuing DB2 commands
        Methods for issuing commands
          Using command prompts
          Using model commands
          Command syntax
        DB2 command profiles
        Where to go from here
      Managing authorizations
        Granting privileges by using the GRANT commands
          Granting privileges on a table
          Granting privileges on a hierarchy of DB2 objects
          Importing the SQL in another subsystem
          Copying an SQL_Table entry to another subsystem
        Granting privileges by issuing the COPYAUTHS command
          Copying user ID privileges
          Copying object privileges
        Granting privileges by generating SQL
        Revoking privileges
          Preservation of access to information
          Generating the cascade report
          Revoking privileges on specific objects
          Verifying current authorizations
        Where to go from here
      Customizing CATALOG MANAGER command access
        Authorization requirements to implement session profiles
        Creating session profiles
          Commands to create and edit session profiles
          Creating a session profile with a customized primary menu
          Displaying the session profiles list
          Displaying session profile descriptions
          Creating a session profile with a tailored commands table
          Creating a session profile with an initial list filter
        Editing session profiles
          Deleting session profiles
          Editing a customized Primary Menu
          Editing a tailored commands table
          Retrieving an initial list filter
        Assigning session profiles to users
          Determining the capabilities of a user
          Activating and deactivating session profiles
        Where to go from here
      Maintaining logs
        Accessing the logs
        The Session Log
          Browsing the Session Log
          Purging the Session Log
        The DDL Audit Log
        The Drop Recovery Log
        Where to go from here
      JCL Generation
        JCL Generation data sets sizing function
        Example of Worklist JCL
      Using the Skeleton Library compiler
        SLIB compilation
        SLIB changes
          SLIB verification using ISPF file tailoring
          Compilation of changed SLIBs
        SLIB processing
          Generating the SLIB report
      Integrating CATALOG MANAGER with the Common Explain component
        Before you begin
        Commands to access SQL
          Explaining a DBRM package or plan
          Explaining a statement from a DBRM or package
          Explaining a statement from the SQL_Table
          Editing the SQL statement by using the SQLX edit macro
      JCL Generation keywords and variables
        AEXIN keywords
        Symbolic variables for BMC Administrative products
      CATALOG MANAGER installation options
        Installation option example
        Installation option descriptions
      JCL Generation product options
        Example of product options
        Descriptions of product option keywords
      CATALOG MANAGER worklist commands
        Worklist file format
        Worklist commands
          -BMCU (Execute a BMC utility)
          -DBUG (Debug)
          -DSN1 (IBM DSN1COPY utility)
          -MERG (IBM MERGECOPY utility)
          -MODI (IBM MODIFY utility)
          -NOOP (No operation)
          -NGTU (NGT utilities)
          -QUI (IBM QUIESCE utility)
          -REPO (IBM REPORT utility)
          -REPX (IBM REPAIR utility)
          -SQLM (Group multiple ALTER statements)
          -STOS (IBM STOSPACE utility)
      Commands
        CATALOG MANAGER commands
        DB2 action commands
        Utility commands
        Utility list commands
        Statistics commands
        List commands
        User commands
        Data browsing and editing commands
          Command line commands
          Line commands
      Glossary
        ACM
        ACT
        action
        action code
        action name
        action owner
        action POF
        action status
        action type
        Administrative Products for DB2
        AEXIN
        AEXPIN
        AEXPRINT
        AEXPRnnn
        AEXPTRAC
        AEXSYnnn
        AJX variables
        AJXIN
        AJXPOFIN
        AJXPOFVL
        AJXPRINT
        alloc unit
        ALTDD
        ALTER for DB2
        alter-type work ID
        ALU
        ALUIN
        ALUPRINT
        Analysis
        Application
        ARU
        ASU
        attribute
        AUTHID
        authorization ID
        automation modes
        automation spawner
        AutoSub
        auxiliary index
        auxiliary list
        auxiliary table
        auxiliary table space
        base table
        base table space
        baseline
        baseline name template
        baseline profile
        batch component
        BMC object
        BMCCOPY
        BMCCPRS
        BMCLOAD
        BMCREORG
        BMCSTATS
        BMCTRIG
        BMCUNLOAD
        BMCUPRS
        box
        browse function
        buffer pool
        Buffers
        build JCL
        build worklist
        CANCEL (CAN)
        catalog baseline
        catalog indirection
        CATALOG MANAGER for DB2
        CDL
        Change Definition Language (CDL)
        CHANGE MANAGER for DB2
        change rule
        char H/W
        char size
        checkpoint
        child
        CLIST
        CM/PILOT for DB2
        CM/PILOT worklist
        color
        columns
        command
        commit
        Compare
        Compare1
        Compare2
        component
        constraint
        copies
        CopyPend
        corrective action
        Cross-System Image Manager (XIM)
        DASD MANAGER PLUS for DB2
        DASD MANAGER PLUS database
        Data Control Language (DCL)
        data definition language (DDL)
        data definition name (ddname)
        Data Manipulation Language (DML)
        data set sizing
        data structure
        database administrator (DBA)
        database request module (DBRM)
        DBA
        DB2 catalog
        DB2 command
        DBCS
        DD statement
        DDL
        DDL baseline
        ddname
        default options module (DOPTS)
        default value
        delimited identifier
        DeleteAge
        dependencies
        dependent
        dependent object
        destination
        device name
        device type
        double-byte character set (DBCS)
        DOPTS
        duplicate
        edit procedure
        EDITPROC
        END
        Enter key
        entry field delimiter
        estimate source
        events log
        EVENTS table
        exception
        EXCEPTIONS2 table
        exceptions report
        exception status
        Execution
        exit routine
        field procedure
        FIELDPROC
        foreground component
        Front End
        full-recovery baseline
        GDG
        generation data group (GDG)
        Group ID
        hash value
        historical database
        HLQ
        image copy
        import or importation
        Import
        inbound migrate profile
        incremental DDL
        Index Cardinality
        Index Pages
        Index Partition Cardinality
        Index Partition Extents
        Index Partition Leaf Distribution
        Index Partition Page Group
        Index Partition Pages
        installation options module
        internal table
        ISPF skeletons
        JCL
        JCL DSN
        JCL Generation (JCLGEN)
        JCL variable display
        JCLGEN
        job
        JOB table
        justify
        large object (LOB) column
        large object (LOB) table space
        Leaf distribution
        Level
        LEVELINC
        LEVELMIN
        lines
        LINK library
        location
        margin
        markers
        menu
        migrate
        migrate profile
        migrate-type work ID
        mixed list
        Most Frequent Value display
        name propagation
        name template
        NonUniform
        NumIncremt
        null
        object
        object list
        OPNDB2ID
        order
        orient
        option
        origin
        orphaned auxiliary index
        orphaned auxiliary table space
        outbound migrate profile
        page
        PageGroup
        parent
        PartLvl
        partitioned data set (PDS)
        partitioned table space
        pattern
        PctActivHi
        PctActivLo
        PDS
        privilege
        profile
        protected baseline
        QMF
        Recall
        receive-type work ID
        recovery
        reference location
        reference profile
        referenced object
        referential constraint
        referential integrity
        Report
        Restart option
        restart parameter
        rows
        rows/key
        Sample
        Save
        save last used
        SAVESTATS
        SaveStats
        SBCS
        scope
        scope rule
        Script table
        security exit
        selection list
        service
        Simple Space Estimation (SSE)
        single-byte character set (SBCS)
        source
        Space Estimation
        space estimation function
        SpaceOnly
        Specification
        SQL
        SQLID
        SSID
        sequence number
        stack tapes
        Start Over option
        STATAUTH
        STEP table
        Structured Query Language (SQL)
        structure-only baseline
        sub-element
        symbolic variable
        SYNC
        sync point
        SYNC table
        synchronization
        Table Average Row Length
        Table Cardinality
        Table Pages
        Table Percent Pages
        Table Space Pages
        Table Space Partition Cardinality
        Table Space Partition Extents
        Table Space Partition Page Group
        Table Space Partition Pages
        Table Space Partition Percent Active/Drop
        Tables
        target
        Tasks
        task ID
        template
        TOTALIND
        TOTALOFF
        TSO submit exit
        Type
        unit
        unload data set
        UOW
        UOWTRnnn
        unprotected baseline
        user options
        variable
        VCAT allocation
        versioning
        wildcard
        work ID
        work ID name
        work ID name template
        work ID owner
        WORKIDS table
        worklist
        worklist execution log
        worklist parallelism
        XIM
        XIM initiator
    CHECK PLUS for DB2® Reference Manual
      About this book
        Related publications
        Conventions
        Syntax diagrams
        Summary of changes
      1 Introduction to CHECK PLUS
        Overview
          The need for data consistency
          The CHECK PLUS solution
          When to use CHECK PLUS
          CHECK PLUS benefits
        Types of checking that CHECK PLUS offers
          CHECK TABLESPACE command
          CHECK INDEX command
          CHECK DATA command
        Tasks that CHECK PLUS performs
        Differences between CHECK PLUS and the IBM DB2 CHECK functions
        How CHECK PLUS works
          CHECK PLUS processing phases
          CHECK PLUS data sets
          Associated products and common components that CHECK PLUS uses
      2 Operational considerations
        System setup
          DB2 support
          System requirements
          Software requirements
          Required authorization
          MEMLIMIT system parameter
        Number of DB2 threads that CHECK PLUS uses
        Serialization and concurrency
          Concurrent execution of BMC utilities
          Object status
        CHECK PLUS work file validity checks
          FILECHK=FAIL
          FILECHK=WARN
        Considerations for each type of checking
          CHECK TABLESPACE command
          CHECK INDEX command
          CHECK DATA command
        User-defined RI
        User-defined column condition rules
        Correcting reported errors
          CHECK PLUS message severity codes and return codes
          Responding to table space and index errors
          Responding to constraint errors
          Using the discard data set
        CHECK pending status
          Objects that are in CHKP status
          Objects that are not in CHKP status
          Additional information about CHKP status
        SHRLEVEL CHANGE
          EXTENDED BUFFER MANAGER (XBM) and SNAPSHOT UPGRADE FEATURE (SUF)
        DB2 user exits
        DB2 features that CHECK PLUS does not currently support
      3 Syntax of the CHECK commands
        Command syntax rules for CHECK PLUS
        Specifying object names
        Alphabetical listing of CHECK PLUS options
        CHECK TABLESPACE options
          CHECK TABLESPACE syntax diagrams
          CHECK TABLESPACE option descriptions
        CHECK INDEX options
          CHECK INDEX syntax diagrams
          CHECK INDEX option descriptions
        CHECK DATA options
          CHECK DATA syntax diagrams
          CHECK DATA option descriptions
        Conditions
      4 Building and executing CHECK PLUS jobs
        Building the CHECK PLUS job
          JOB statement
          EXEC statement
          REGION parameter
          Utility parameters on the EXEC statement
          STEPLIB DD statement
          CHECK PLUS DD statements
        Running CHECK PLUS jobs
          Invoking CHECK PLUS
          Restarting CHECK PLUS
          Terminating or canceling a job
      5 Examples of CHECK PLUS jobs
        Overview
        Example 1: Level 2 CHECK TABLESPACE of a segmented table space
        Example 2: Level 2 CHECK TABLESPACE with table check constraints
        Example 3: Level 2 CHECK INDEX of a partitioned table space
        Example 4: Level 1 CHECK INDEX of a specified index
        Example 5: SHRLEVEL CHANGE: CHECK INDEX and CHECK TABLESPACE of a specified table space
        Example 6: CHECK DATA for RI and table check constraint violations in a table space; using ACKESQL to delete rows
        Example 7: CHECK DATA for RI violations in a table space set
        Example 8: CHECK DATA for user-defined RI violations in a table space
        Example 9: Check for DB2- and user-defined RI violations in a table space set
        Example 10: CHECK DATA for user-defined RI using saved rules
        Example 11: CHECK DATA for table space set report only
      6 Tuning CHECK PLUS jobs
        Tuning for performance
          Setting installation options for optimal performance
          Specifying command options for optimal performance
          Additional performance information for installation and command options
          Understanding multitasking
          Additional performance tuning recommendations
          Interpreting performance-related messages
        Tuning to improve memory use
        Using DB2 resources
      A CHECK PLUS installation options
        Overview
        CHECK PLUS installation options
        DYNALOC installation option
      B CHECK PLUS database
        Overview
          Considerations and warnings
          Managing common utility tables
        BMCDICT table
          Considerations
          Maintaining the BMCDICT table
        BMCHIST table
          Maintaining the BMCHIST table
        BMCLGRNX table
        BMCSYNC table
          Considerations
          Maintaining the BMCSYNC table
        BMCTRANS table
        BMCUTIL table
          Maintaining the BMCUTIL table
        BMCXCOPY table
          Maintaining the BMCXCOPY table
        CHECK PLUS RI rules tables
      C Fields and values checked in tables and indexes
        Overview
        CHECK TABLESPACE: page types
        CHECK TABLESPACE: header page
        CHECK TABLESPACE: space map page
        CHECK TABLESPACE: data page
        CHECK INDEX: all index page types
        CHECK INDEX: index header page
        CHECK INDEX: space map page
        CHECK INDEX: physical index data page header
        CHECK INDEX: leaf page
      D SQL batch execution program
        Overview
        Using ACKESQL
        JCL statements and parameters
          EXEC statement
          Input and output DD statements
          Example execution
    Cross-System Image Manager User Guide
      About this book
        Conventions
        Syntax statements
          Syntax diagrams
        Summary of changes
      1 Introduction
        What is XIM?
        XCF Services
      2 Using XIM
        Introduction
        Requirements
        Limitations
        Starting XIM
        Issuing MVS console commands
          ACTIVATE
          DUMPLIMITS
          QUIESCE
          SHUTDOWN
          STATUS
          VERSION
        Using XIM data set tracing
      A Installation
        Overview
        Prerequisites
        Installation considerations
        XIMCHECK
          Parameter options
          Return codes
          Sample XIMCHECK JCL
        Controlling access
        Default options
          Global parameters vs. MVS image parameters
          Parameter specifications
          Default options syntax
          Default XIM parameter list
          Sample JCL procedures
      Glossary
    DASD MANAGER PLUS for DB2 Reference Manual
      DASD MANAGER PLUS jobs
        Statements in a DASD MANAGER PLUS job
          CPU authorization passwords
          JOB statement
          EXEC statement and utilities parameters
            DB2 subsystem identifier (ssid)
            Plan name (planName)
            DB2 catalog VCAT name (VCATName)
            Default options module name (installationOptionsModule)
            Work ID (workID) or Service Action
            Utility ID (utilityID)
            Restart parameter (restartParm)
            REGION parameter
            STEPLIB DD statement
            BMCPSWD DD statement
        DD statements for BMCSTATS, BMCCPRS, and BMCUPRS
          DD statements and temporary data sets for BMCTRIG
          Additional DD statement in BMCTRIG job
        Basic syntax
          command
          objectType
          objectName
          OBJECTSET
          options
        BMCSTATS command line examples
        BMCSTATS options
        BMCTRIG syntax
          Exception conditions
            Exception conditions—copy
            Exception conditions—reorg
            Exception conditions—stats
          Processing options
          Exclusion rules
          JCL options
          Job generation options
          Resize options
        BMCCPRS options
        BMCUPRS options
      DASD MANAGER PLUS database
        Data migration to the most recent version of DASD MANAGER PLUS
        Naming conventions
          Database name
          Table names
          BMC statistics tables
          Plans and aliases
        Statistics tables
          BMCATSnn.RS_COLDIST
          BMCATSnn.RS_COLDISTSTAT
          BMCATSnn.RS_COLSTATS
          BMCATSnn.RS_COLUMNS
          BMCATSnn.RS_INDEXES
          BMCATSnn.RS_INDEXPART
          BMCATSnn.RS_IXPART_DIST
          BMCATSnn.RS_KEYTARGETS
          BMCATSnn.RS_KEYTARGETSTATS
          BMCATSnn.RS_KEYTGTDIST
          BMCATSnn.RS_KEYTGTDISTSTATS
          BMCATSnn.RS_LOBSTATS
          BMCATSnn.RS_STOGROUP
          BMCATSnn.RS_TABLEPART
          BMCATSnn.RS_TABLES
          BMCATSnn.RS_TABLESPACE
          BMCATSnn.RS_TSPART_DIST
          BMCATSnn.RS_VOLUMES
        Action and service tables
          BMCASUnn.ACTION
          BMCASUnn.ACT_SEQ_SVC
          BMCASUnn.DO_WORKIDS
          BMCASUnn.EVENTS
          BMCASUnn.SERVICE
          BMCASUnn.SVC_DD
          BMCASUnn.SVC_DD_DSN
          BMCASUnn.SVC_SNTX
          BMCASUnn.SVC_SNTXT
          BMCASUnn.VENDOR table
          BMCASUnn.WL_SYNC
        Trigger tables
          BMCASUnn.CORR_ACTS
          BMCASUnn.EXCEPTIONS2
          BMCASUnn.EXCEPTION_DFN
          BMCASUnn.OBJ_ACT
          BMCASUnn.OBJ_ACT_JC
          BMCASUnn.THRESHOLDS
        DASD MANAGER History
        BMC utility tables
          Considerations and warnings
          Managing common utility tables
            Determining your site’s table names
          BMCSYNC
            Considerations
            BMCSYNC table maintenance
          BMCUTIL
            BMCUTIL table maintenance
        BMC Common DB2 repository
          Naming conventions for BMC Common DB2 repository
            CMN_OS table
            CMN_OS_DEF table
            CMN_OS_SQL table
        DASD MANAGER PLUS repositories management
        BMCSTATS repositories
        BMCTRIG repositories
        DASD MANAGER PLUS plans and aliases
      BMCTRIG rules
        Object types
        Trigger evaluation
        General rules
        Exception rules
          Exception data source groupings
            DB2 RTS specific exceptions
            DB2 RTS or BMCSTATS exceptions
            BMCSTATS specific exceptions
          Reorg-related exceptions
          Statistics-related exceptions and miscellaneous exceptions
          Copy-related exceptions
        Rules for options and parameters
          PARTLVL
          Resize
            Rule 1
            Rule 2
            Rule 3
            Example 1 Resize option in IBM REORG
            Example 2 RESIZEPCT and RESIZEDOWN options in BMCTRIG
          FAROFF and TOTALOFF and PCTCLUS
          Incremental copy rules
          Return codes
          REXX programs
            Input variables
            Return data
            Connecting to DB2
            SYSEXEC
            Environment and error recovery
            Sample
      Execution
        Overview of the Execution component
          Worklist control-command processing
          Restart and startover processing
        Execution inputs (worklists)
        Execution outputs
          Using sync tables
          Action status update by Execution
          Execution return codes
          Diagnostic output file
            A sample diagnostic output file
        Restart methods
          Restart processing
          How the RESTARTPARM keyword affects restarting utilities
            Omitting the RESTARTPARM keyword
            Including the RESTARTPARM keyword
          Startover processing
          Considerations for restarting or starting a worklist over
          Additional BMCTRIG restart considerations
            Manually restarting JCL and worklists generated by BMCTRIG
            Generating batch JCL Generation for a BMCTRIG job
            Generating JCL for a BMCTRIG job after JCL generation failure
      About Worklist commands
        -AMS (IDCAMS Execution)
        -BIND (Bind)
        -BMCC (BMCCOPY)
        -BMCD (BMCUNLOAD)
        -BMCL (BMCLOAD)
        -BMCR (BMCREORG)
        -BMCS (BMCSTATS)
        -BMCU (Execute a BMC utility)
        -BR14 (IEFBR14)
        -CHEK CHECK DATA (IBM utility)
        -CMNT (Comment)
        -COPY (Image Copy)
        -DBUG (Debug)
        -DSN1 (IBM DSN1COPY utility)
        -JCLI (Job Card Images)
        -JCLP (JCL Generation Parameter)
        -LOAD LOAD (IBM utility)
        -MERG (IBM MERGECOPY utility)
        -MODI (IBM MODIFY utility)
        -NEWJ (New Job)
        -NOOP (No operation)
        -QUI (IBM QUIESCE utility)
        -REBD (Rebind)
        -RECV RECOVER (IBM utility)
        -REOR REORG (IBM utility)
        -REOR REORG UNLOAD ONLY (IBM utility)
        -REPO (IBM REPORT utility)
        -REPX (IBM REPAIR utility)
        -RNST RUNSTATS (IBM utility)
        -SQL (SQL Statement)
        -SQLM (Group multiple ALTER statements)
        -SSID (Subsystem ID)
        -STOP (Stop)
        -STOS (IBM STOSPACE utility)
        -SYNC (Sync Point)
        -TIME (File Creation Time)
        -UDSJ (Generated JCL and SYSIN Data Set)
        -USRP (User Defined Program)
        -WKID (Work ID)
        Other worklist commands
          -GLID (Global AUTHID)
          -REXC (REXX command)
          -SETS (Set Current SQLID)
          -SPAC (Space Estimation Source)
      About User Exits
        Security exits
          Front end security exit
          R0 function codes and return codes
          Authorization switching
            Execution security exit function codes
          Execution security exit testing
          Switching authorization with 8-byte IDs
        RESIZE user exits
          On entry
          On exit
          Primary quantity
            Assembler language example
            C language example
          Assembler user exit parameter block
          Assembler RESIZE user exit
          C language RESIZE user exit
          How to use the source
          How to link edit the Assembler user exit
        Job card user exits
          Types of calls
          Number of jobs generated
          Job name changes
          Source code
          Sample JCL for assembling and linking the job card user exit
      Space estimation formulas
        Space estimation considerations
        Space required for partitioned and nonsegmented table spaces
          Total data pages
          Total number of pages
        Space required for universal table spaces
          Total data pages and free pages for a table
          Total number of pages in a universal table space
        Space required for segmented table spaces
          Total data pages and free pages for a table
          Total data pages and free pages for a table space
          Total number of pages in a table space
        Space required for partition by growth table space
          Total number of pages in a partition by growth table space
        Dictionary pages by segment size (segsize)
        Space required for indexes
          Pages for a unique index
            Total leaf pages for unique index
            Total nonleaf pages for unique index
            Total number of pages for a unique index
          Pages for a nonunique index
            Total leaf pages
            Total nonleaf pages
            Total number of pages for a nonunique index
        Space estimation for compressed indexes
          Pages for a compressed unique index
            Total number pages for compressed unique indexes
          Pages for a compressed nonunique index
            Total number of pages for compressed nonunique indexes
      JCL Generation keywords and variables
        Keywords for input streams
          Overview of the keyword tables
          AEXIN keywords
          AJXIN keywords
        Default options
        Symbolic variables
          Symbolic variables for DASD MANAGER PLUS
          Symbolic variables for BMC Administrative products
      Reserved words
        DASD MANAGER PLUS reserved words list
      Option and field name cross-reference
        DASD MANAGER PLUS option and field name cross-reference list
    DASD MANAGER PLUS for DB2 User Guide
      Introduction to DASD MANAGER PLUS for DB2
        Overview of DASD MANAGER PLUS for DB2
          Solution integration
            Product components
            Technology components
            Features
          Product benefits
          Product features
            Generating utilities
            Collecting and managing statistics
            Set and analyze thresholds
            Customizable reports
            Analyzing trends
            Estimating space
            Deployable object definitions
        System setup
          DB2 support
          Features of DB2 that DASD MANAGER PLUS does not currently support
          System requirements
          Software requirements
        Interaction with other products from BMC Software
          Administrative products for DB2
          Backup and Recovery products for DB2
          BMC Workbench for DB2
          Utility products for DB2
          Associated common components that DASD MANAGER PLUS uses
          Release-level compatibility
      Getting started with the ISPF interface
        Overview of the ISPF interface
          The DASD MANAGER PLUS Main Menu
          ISPF panel types
        ISPF command descriptions
        Panel navigation
        Fast Path Navigation
        Space estimation
        Help for panels
        Wildcard characters
        Long object name fields
        Viewing current environment information
      Setting up DASD MANAGER PLUS
        Before you set up the Interactive System Productivity Facility (ISPF) interface
        CPU authorization passwords
        Using options to control your environment
          Use of the installation options
          Using the user options
            Storing values in the ISPF profile
            Refreshing the user options
          Use of the product options file (POF)
          Using local keywords to override options
          Putting it all together
        Data set allocation
        Naming objects
        Execution and security setup
          Access to DASD MANAGER PLUS plans
          Execution component plans
          Access to the DB2 catalog
          Access to the DASD MANAGER PLUS database
          Access to other databases
        Setting options and authorizations
          Setting general user options
          Setting the JCL options for job cards
          Setting the JCL options for STEPLIBs
          Setting the JCL options for static data sets
          Setting the JCL options for tapes
          Setting the JCL options for temporary work data sets
          Setting the JCL options for permanent data sets
          Setting the JCL generation data group (GDG) options
          Setting the JCL debugging, display, and Execution options
          Setting the installation options module names for BMC utilities
          Setting the non-worklist JCL options
          Setting the BMCTRIG Control-M options
          Setting the NGT utility options
          Setting user variables
          Creating a user POF
          Updating a user POF
          Using multiple POFs
          Refreshing the initial POF
          Generating POF reports
          Reusing a POF in a subsequent installation
          Overriding POF values in SLIBs
          Adding steps to the JCL
          Additional job generation options in DASD MANAGER PLUS
        Customizing DASD MANAGER PLUS (for experienced users)
          Generating JCL
            Modification of ISPF skeletons and variables
            JCL Generation data sets sizing function
          Specifying generation data groups
            Using user options to specify GDGs
            Using Copy DD options to specify GDGs
          Overriding options
            Using action POFs to reset JCL options
          Overview of product options
            Example of product options
            Descriptions of product option keywords
          Overriding installation options
          Descriptions of the installation options
        Post-installation considerations
          Recommendations for reducing system resource requirements
          MEMLIMIT system parameter
      Maintaining and generating Service Actions
        Overview of Service Actions
          Service Actions
          Services
            BMC Software required services
            User-defined programs or services
          Service Action Generation function
            Utility worklist
            Worklist JCL Generation
        Working with Service Actions
          Listing Service Actions
          Creating a Service Action
          Editing Service Action properties
          Copying a Service Action
          Deleting Service Actions
          Generating Service Actions
        Working with Services
          Listing Services
          Editing Service Syntax
          Editing Service properties
          Example of creating a User Defined service
          Deleting a User Defined Service
          Editing Services for an Action
          Previewing generated syntax
        Restarting a Service Action
        Understanding return codes for batch programs
        Access to actions, services, and service syntax
      Using object sets
        Before you begin using object sets
          Overview of object sets
          Wildcards for object names
          Patterns for object sets
          Specify Object Set panel
          Example of defining object sets
          Working with object sets
        Defining and maintaining object sets
          Creating an object set
          Creating dynamic SQL object sets
          Editing object set specifications
          Identifying actions associated with an object set
          Renaming object sets
          Copying object sets
          Deleting object sets
          Editing object set properties
          Viewing object set results
          Use of BMC Workbench for DB2 to create and manage object sets
        Associating object sets with action services
          Associating a new object set with an action service
          Associating an existing object set with an action service
          Associating an existing object set with a new action
        Controlling access to Object Sets
      Collecting and managing statistics
        Overview of collecting and managing statistics
          Quick reference of statistics-related tasks
          Tips for collecting statistics
        Collecting statistics
          IBM RUNSTATS utility
          BMCSTATS utility
          DASD MANAGER PLUS historical database
          BMCSTATS options
            BMCSTATS options for tables
            BMCSTATS performance and tuning
        Sampling statistics
          Minimum size requirements
          Specifying sampling percentages
          Restricting sampling by object type
          Sampling table columns
          Sampling by using a seed value
        Accessing the statistics display features
        Browsing and updating statistics
          DB2 and BMCSTATS statistics
          DB2 table space statistics
          DB2 table statistics
          DB2 table space partition statistics
          DB2 column statistics
          DB2 index statistics
          DB2 index partition statistics
          Updating the DB2 catalog interactively
          Table space statistics update
          Table statistics update
          Table space partition table statistics update
          Column statistics update
          Index statistics update
          Index partition statistics update
        Managing DB2 and BMC Software statistics
          Having authority to collect statistics
          Updating DB2 columns by DASD MANAGER PLUS
          Updating DB2 real-time statistics
          Updating the DB2 catalog by using BMCSTATS
          Updating the DB2 catalog by using BMCUPRS
          Updating DASD MANAGER PLUS statistics by using BMCCPRS
          Altering, renaming, or dropping and re-creating objects
          Deleting BMC Software statistics
          Displaying DB2 object lists
            Creating a DB2 object list
            Listing data sets used by a database
            Updating DB2 catalog statistics
      Analyzing statistical trends
        Before you begin analyzing statistical trends
        Analysis of BMC Software statistics
          Analyzing BMC Software statistics
          BMC Software statistics for DB2 objects
          Table space statistics
            Tips for analyzing table space statistics
          Table space partition statistics
            Table statistics for a partitioned table space
            Tips for analyzing table space partition statistics
          Table space partition pagegroup statistics
            Tips for partition pagegroup statistics analysis
          Table statistics
            Tips for display table statistics analysis
          Column statistics
            Tips for column statistics analysis
          Column value statistics
            Tips for column value statistics analysis
          Index statistics
            Tips for index statistics analysis
          Index partition statistics
            Tips for Index partition statistics analysis
          Index partition pagegroup statistics
          Storage group statistics
            Tips for storage group statistics analysis
          Volume statistics
            Tips for volume statistics analysis
        Graphing statistics
          Creating a statistics graph
          Setting graphic display options
        Estimating space requirements by using statistics
          Simulating changes to DB2 objects
        Estimating space requirements for a table space
        Estimating space requirements for an index
        Estimating space requirement based on user-specified values
        Estimating space requirements for a table space
      Analyzing objects by using BMCTRIG
        Before you begin to use BMCTRIG to analyze objects
        Overview of the main features of BMCTRIG
          System triggers
          Exception conditions
            Threshold priorities
            Corrective actions for exceptions
          Suppressing categories of exceptions from analysis
          Job generation
            Duplicate actions
            Object-action priorities
            Default actions
          Methods of running BMCTRIG
            Grouped services
            Workload balancing
        Setting up BMCTRIG
          Selecting objects to evaluate
          Automating corrective actions
          BMCTRIG processing options
          Sample workflows
            Evaluating exceptions and generating corrective actions
            Evaluating BMCTRIG exceptions
            Generating jobs without evaluating exceptions
            Evaluating exceptions for automation
        Setting exception thresholds
          Shared BMCTRIG exceptions
          Reorganization-related exceptions
            Statistics and miscellaneous related exceptions
          Copy-related exceptions
          Thresholds in BMCTRIG syntax
          System-level thresholds
            Accessing system thresholds
            Creating a new threshold
            Editing an existing threshold
            Deleting a threshold
            Copying a threshold
          Creating user-defined exceptions
          Identifying threshold values
        Managing corrective actions
          Setting a corrective action in BMCTRIG syntax
          Defining system-level corrective actions
          Defining system-level object-action priorities
        Setting up a BMCTRIG job
          Creating an action with BMCTRIG
          Specifying BMCTRIG syntax options
            Selecting processing options
            Specifying What to Analyze options
            Specifying Saving and Reporting Exception options
            Specifying Eliminate Duplicates and Index Escalation options
            Specifying Exclude Objects from Generation options
            Specifying corrective action generation options
            Specifying Rebind and Resize Object options
            Resize limitations
            Specifying Job and JCL Generation options
            Specifying Reorg-Related Override Exceptions
            Specifying statistics-related and miscellaneous override exceptions
            Specifying Copy-Related Override Exceptions
          Generating a BMCTRIG job
          Using worklist format or standard JCL format
            Standard format JCL
            Standard format JCL—more information
            Worklist format JCL
            Worklist format JCL—more information
        Viewing exceptions that BMCTRIG produces
        Working with reorganization guidelines for thresholds
        Generating an automatic reorganization with BMCTRIG
        Setting up a REORG corrective action
        Working with restarts and batch JCL generation
          Using BMCTRIG-generated job restart
          Restart and Startover processing
          Overview of the restart program
            JCL DD processing of GDG data sets
            Restart parameter
            Omitted DD statements
            Online processing
          Restarting jobs that BMCTRIG generates
          Using batch processing
            Parameter list
            Required DD statements
      Changing the secondary quantity
        Prerequisites for changing the secondary quantity
        Understanding the ALTERSEC utility
        Altering the secondary quantity (SQTY)
      Producing reports
        Before you begin working with reports
        Standard reports
          Standard reports descriptions
          Organization of report options
            Redundancy of reports
          Generating the Average length of RID chain report
          Event recording report
          Index analysis report
          Index clustering analysis report
          Index combination statistics report
          Index keys analysis report
          Index leaf distribution report
          Indexspace space detail report
          Monthly detail by tablespace report
          Page update analysis report
          Statistics exception report
          Table column detail report
          Table space extent summary report
          Table space offset RIDs report
          Tablespace space detail report
          Volume analysis report
          Volume free space detail report
        Model JCL for batch generation
        QMF reports
        Customizable reports
          Understanding customizable reports
          Input parameters
            Description of input parameters
          Internal KB switch
          Creating customizable reports
            Running customizable reports
            Running a customizable report in batch mode
            Customizing the report programs
            Adding a report to the customizable reports menu
            Understanding output data sets
            Location return code descriptions
        Customizable report samples
          Action report
          Average Monthly Growth report
          Corrective action cross reference report
          Data Set List by database name report
          Database space detail report
          Database space trend report
          Database storage utilization report
          Exception report for BMCTRIG action
          Index clustering analysis report
          Modified table space pages report
          Space estimation report
          Space estimation trend report
          Space utilization by table report
          Table space and index storage limits report
          Tables With More Than Average Growth report
          Table space and index extents report
          Volume space trend report
      Exporting and deploying product definitions
        Overview of exporting object definitions
          How the Export utility works
            Examples with referenced objects
          Recommendations for setting up connections
          Connection list types
          Required authorizations for using Export
            TCP and IP and UIM Server access
            TCP and IP and user access
          SAF authority to access the CCL
            Protection of access controls
            Creation of SAF resources
          Task summary for exporting object definitions
        Preparing your environment for exporting
        Accessing the Export utility
        Setting up connections
          Setting up enterprise connections
          Setting up destination connections
        Specifying definitions to export
          Specifying action definitions
          Specifying service definitions
          Specifying object set definitions
          Specifying object-action priority definitions
          Specifying exceptions definitions
        Verifying the list of definitions to export
        Selecting the destinations for an export
        Deploying the definitions
        Reviewing the deployment report
      Using the Skeleton Library compiler
        SLIB compilation
        SLIB changes
          SLIB verification using ISPF file tailoring
          Compilation of changed SLIBs
        SLIB processing
          Generating the SLIB report
      Customizable reports
        Overview of customizable reports
        Customizable report programs
          Report program structure
          Sample report program
          Sample report 1
        Report program customization
          Report layout
            Format names
            Reserved word
            Format definitions
          Variables
            Input table-name
            Page number and line number
            Report-dependent variables
            Value-line fields
            REXX EXEC PARM
          SQL
            SQL as argument
            DECLARE and OPEN cursor
            Variables in the SQL
            Retrieving the most recent data
            Quotation marks
          JCL
            The EXEC PARM
            DD statements
        ASURXSQL external function
          ASURXSQL return codes
            Printing error messages
            Call attachment return codes
          SQL support
        ASURXRPT external function
        ASURXLSP external function
        ASURXSE external function
        ASURXLOC external function
        Notes on REXX
        Annotated customizable report
          Sample program
            Specify the DB2 table and report title
            Define report formats
            Connect to the DB2 subsystem and open the plan
            Initialize the report
            Begin reading input and get database names
            Open cursor for SELECT
            Fetch and write the table space data
            The report error procedure
            The CAF error procedure
            The SQL error procedure
            The cleanup procedure
        JCL and execution
        Sample report 2
        Complete sample program
      Example of utility automation
        Overview of utility automation
          BMCSTATS utility
          About the utility-automation example
        Modifying the sample files
        Adding corrective action definitions
        Modifying thresholds and corrective actions
        Modifying the default corrective actions
        Running the BMCSTATS utility
        Modifying the BMCTRIG JCL
        Execute or schedule the BMCTRIG job
        Scheduling the BMCTRIG generated jobs
      Using the UIM server
        Overview of the UIM server
        Starting and stopping the UIM server
        Verifying that the UIM server is running
        Accessing the BMC UIM server Commands web page
          Authorization settings
        Viewing active users
        Changing the security authorization timeout feature temporarily
        Enabling or disabling the overall tracing option temporarily
        Enabling or disabling specific tracing options temporarily
        Refreshing the UIM server content
        Resolving UIM Server problems
          The UIM server does not start because the OMVS segment is not defined
          UIM server does not start and displays message LSCX902 in SYSTERM DD
          UIM server displays message LSCX902 in SYSTERM DD
          UIM server displays message LSCX904 in SYSTERM DD
      Enhanced database performance evaluation using SQL Performance
        Overview of using Performance Advisor with DASD MANAGER PLUS
          Reorganizations based on the candidate table only
          Reorganizations based on the candidate table and BMCTRIG evaluations
          How Performance Advisor works
        Preparing to use REORG Advisor
          Populating the REORG candidate table
          Making BIND modifications
          Obtaining sample JCL files
        Setting up automated reorganizations
    EXTENDED BUFFER MANAGER and SNAPSHOT UPGRADE FEATURE User Guide
      Overview of EXTENDED BUFFER MANAGER
        How XBM and SUF promote data availability
          Increased data availability by using snapshots
            Traditional snapshots
            Instant Snapshots
            BMC utilities that use snapshots
            Snapshot storage devices
            SNAPSHOT UPGRADE FEATURE support for BMC utilities and solutions
          XBM and zIIP processing
          Space map update monitoring
        Features of XBM
          XBM component architecture
          XBM control structures
            Configurations
            Management sets
            Options
          XBM repository
          XBM ISPF interface
          XBM commands
          XBM monitor
            XBM performance statistics and status information
            XBM environment
        How XBM communicates in a data sharing environment
        Task overview: Setting up XBM to perform snapshot processing
        Task overview: Setting up XBM for zIIP processing
      Configuring and managing the XBM subsystem
        XBM prerequisites and installation
        MVS security considerations for XBM
        Multiple XBM subsystems on an MVS system
        Granting user authorizations for EXTENDED BUFFER MANAGER
          Configuring CA-ACF2 security
          Configuring CA-Top Secret security
          Configuring RACF security
          Using XBM user exits
            XBMXAEX1 exit
            XBMXAEX2 exit
        Managing the XBM repository
          Allocating the XBM repository data sets
          Maintaining consistency of repository data sets
          Enforcing repository sharing
            Global records
            Local records
          Handling I/O errors while writing to the repository
          Adding repository data sets
        Starting the XBM subsystem
          Defining and starting the XBM started task
            Parameters
            DD statements
          Using the XBM initialization command file
          Starting the ISPF interface
          Displaying the status of the XBM subsystem
            Output from the DISPLAY XBM command
          Defining PROCs for use with multiple XBM subsystems
        Working with XBM components
          Starting and stopping components
          Displaying the status of an XBM component
        Setting XBM options
          Understanding XBM options
          Specifying XBM options
      Using XBM in a parallel sysplex environment
        Adding XBM structures to the CFRM policy
          Understanding coupling facility structure types
            Cache structure
            List structure
          Rebuilding the coupling facility structure
          Using system-managed coupling facility duplexing
          Adding required structures to the CFRM policy
            Ensuring policy slot availability for XBM structures
            Understanding CF space usage
            Updating the policy data set
            XBMGROUP considerations
        Working with XBM subsystems in sysplex environments
          Initializing XBM subsystems in a data sharing environment
          Adding a DBMS member to a data sharing group during snapshot processing
          Working with different versions of XBM in a parallel sysplex environment
          Stopping remote XBM subsystems in a parallel sysplex environment
        Setting PSS options
          Overview of PSS options
          Setting PSS options
        Displaying XBM subsystem information and PSS performance statistics
          Displaying detailed information for a remote XBM subsystem
          Displaying status information for active XBM subsystems
          Displaying PSS statistics
            Types of available statistics
            Displaying statistics for the PSS coupling facility structure
      Getting started with snapshot processing
        Snapshot types that XBM can process
          Overview of traditional snapshots
            Software snapshots
            Hardware snapshots
          Overview of Instant Snapshots
        How the SSI component works
        Which type of snapshots to use
          Choosing the type of snapshot
          Using data-set-level or volume-level hardware snapshots
          Determining snapshot type by supported hardware devices
        Controlling which types of snapshots are enabled
          Specifying a snapshot template
          Specifying snapshot types through options
          Enabling fallback to software snapshots
          Requesting the snapshot in the utilities
        Setting up XBM to enable snapshot processing
          Enabling XBM to process software snapshots
          Enabling XBM to process traditional hardware snapshots
          Enabling XBM to process Instant Snapshots
          Monitoring and controlling hardware devices
        How the DBMS type affects snapshot processing
          DB2 snapshots
            Standard DB2 data set names requirement
            Parallel sysplex support for DB2 snapshots
            Using XBM for DB2 for a snapshot utility job
          IMS snapshots
            Parallel sysplex support for IMS snapshots
            IMS VSAM SHROPTS requirements
          VSAM snapshots
            Understanding the XBM utility program
            VSAM SHROPTS requirements
          Specifying VSAM options
      Enabling software snapshots
        Supported software
        Overview of the extended buffer
          Structure of the extended buffer
          How XBM and snapshot utilities populate the extended buffer
          How XBM caches pages
        Choosing cache types
          Cache size
          Cache types supported by XBM
          Cache type advantages and disadvantages
          Simulate mode and snapshot processing
        Using compression
          Determining candidates for compression
          Enabling compression
        Performing a software snapshot
          Defining an extended buffer in a configuration
          Creating a snapshot template for software snapshots
          Activating a configuration
          Activating a management set
          Planning for a point of consistency
          Running the utility job
            Utility syntax
            Restartable snapshot utility jobs
          Reviewing the status of a software snapshot job
            Start messages
            Stop messages
        Where to go from here
      Enabling hardware snapshots
        Understanding hardware snapshots
          Supported software
          Supported hardware
          Suspending and resuming mirrors
          Enabling SSI snapshots in SSI options and snapshot templates
        Performing hardware snapshots
          Setting up the hardware environment
            XBM components
            Storage devices
            Additional software for EMC devices
            Additional considerations and restrictions for FlashCopy
            Additional software for Hitachi and generic PPRC devices
          Setting SSI options for hardware snapshots
          Creating a snapshot template for a hardware snapshot
          Activating the management set
          Running the utility job
          Reviewing the status of a hardware snapshot job
            Snapshot messages
            Start messages
            Hardware snapshot messages
            Snapshot stop messages
            DASD volume status
            Performing hardware functions online
      Enabling Instant Snapshots
        Supported software
        Supported hardware
        How Instant Snapshots work
        Performing Instant Snapshots
          Setting up the hardware environment
            XBM components
            Storage devices
            Additional considerations for EMC devices
            Additional considerations and restrictions for FlashCopy
          Setting SSI options for Instant Snapshots
          Running the utility job
          Reviewing the status of an Instant Snapshot job
            Snapshot messages
            DASD volume status
            Performing hardware functions online
      Getting started with monitoring
        Displaying information through the XBM consoles
        Types of performance and statistical information available through the monitors
          XBM performance monitor
          Managing information within the monitors
        What status information is available about the snapshot-enabled utilities
          Using the S/R monitor
          Using the XBM Utility monitor
        Displaying and managing storage devices within XBM
          Types of activities
          Using the SSI monitor
      Monitoring BMC snapshot-enabled utilities
        Displaying XBM status information
        Displaying the status of a management set
        Displaying performance statistics and status
          Displaying suspend/resume group status
            Displaying general status information for suspend resume groups
            Displaying summary status for suspend resume groups
            Displaying status of an individual suspend resume group
            Displaying detail information for an individual suspend resume entry
          Displaying data set statistics for snapshot utilities
            Displaying general statistics for data sets processed by snapshot utilities
            Displaying summary statistics for data sets processed by snapshot utilities
            Displaying statistics for individual data sets processed by snapshot utilities
            Displaying detail statistics for a data set processed by snapshot utilities
          Statistics to check
        Using the Utility monitor
          Displaying utility job statistics with the Utility monitor
          Displaying XBM utility program job statistics
            XBM Utility (Task) panel
            XBM Utility (Snapshot) panel
          Displaying NGT Copy utility job statistics
            COPY PLUS (Task) panel
            COPY PLUS (Snapshot) panel
          Displaying REORG PLUS Online feature utility job statistics
            REORG PLUS Online (Snapshot) statistics
            REORG PLUS Online (Log Apply) statistics
          Issuing commands from the XBM Utility monitor
          Displaying the last command sent to a utility
      Monitoring and managing storage devices
        Using the SSI monitor
          Understanding DASD volume status information
          Accessing the SSI monitor
        Displaying generic DASD volumes
          Displaying summary information about the DASD volume status
          Displaying general information for an individual DASD volume
          Displaying detailed information about individual DASD volumes
        Managing PPRC objects
          Displaying PPRC devices
            Displaying summary statistics for PPRC objects
            Displaying general information for individual PPRC objects
            Displaying detailed information for a PPRC device
          Establishing a PPRC pair
          Reestablishing a PPRC pair
          Suspending PPRC operations for a pair
          Removing a pair from PPRC operations
          Recovering a secondary PPRC device
          Displaying information about a mirrored PPRC device
        Managing EMC TimeFinder objects
          Displaying EMC TimeFinder devices
            Displaying summary statistics for EMC TimeFinder devices
            Displaying general information about EMC devices
            Displaying detailed information for an EMC TimeFinder device
          Establishing a standard device BCV pair
          Reestablishing a standard device BCV pair
          Splitting a standard device BCV pair
          Restoring data to a standard device from a BCV
          Holding and releasing a BCV
          Displaying information about a BCV
          Monitoring and managing virtual volumes
            Viewing detailed information
          Managing virtual devices
        Managing Hitachi ShadowImage and Remote Copy objects
          Displaying Hitachi ShadowImage and Remote Copy devices
            Displaying summary statistics for Hitachi ShadowImage and Remote Copy devices
            Displaying general information for Hitachi devices
            Displaying detailed information for a Hitachi device
          Establishing a PPRC pair with Hitachi devices
          Reestablishing a pair for a suspended Hitachi device
          Suspending PPRC operations for Hitachi devices
          Removing the relationship between a pair of a Hitachi devices
          Recovering a secondary Hitachi device
          Displaying information about a mirrored Hitachi device
      Navigating the XBM ISPF interface
        Introducing the File List panel
        Understanding panel elements
        Displaying files on the File List panel
          Using the Locate command
          Sorting the files
          Using selection criteria to view files
        Printing file lists
        Performing ISPF actions
          Using the action bar pull-down
          Using action codes
          Using function keys
          Using ISPF Fastpath commands
        Understanding XBM pattern-matching and query options
          Pattern-matching characters
          Options for finding XBM subsystems
          XBM subsystem IDs in the XBM$OPTS member
        Using Help for the ISPF interface
      XBM commands
        Commands for managing XBM objects and subsystems
          ACTIVATE command
          Comment command
          DEACTIVATE command
          DISPLAY command
          PING command
          RESETSTA command
          ROUTE command
          SEND command
          SET SIMULATE command
          START command
          STOP command
          XCFCleanup command
        Commands for managing SSI options
        Commands for generating tracing information
        XBM ISPF Fastpath commands
      XBM options
        VSAM options
        Cache options for the extended buffer
        Snapshot template options for software snapshots
        SSI options for hardware snapshots
        Snapshot template options for hardware snapshots
        SSI options for Instant Snapshots
      SMF reporting
        Cache statistics record layout
        Data set statistics record layout
      Using the XBM utility program for a VSAM snapshot copy
        Setting region size
        Preparing the CICS environment
        Creating JCL
          Supported IDCAMS keywords
          Valid XBM utility program keywords
        Establishing a quiesce
        Running the job
        Running restartable jobs
        Reviewing output
    High-speed Apply Engine Reference Manual
      Overview of High-speed Apply Engine
        High-speed Apply Engine features and functions
        How High-speed Apply Engine works
        Input sources for apply requests
          SQL statements
          Logical log
        When to use High-speed Apply Engine
          Transaction recovery
          Data migration
          SQL processing
        How to use High-speed Apply Engine
        Solution integration
        Considerations for DB2 on mainframe targets
          Operational considerations for mainframe DB2
          Static SQL processing
          Database access for mainframe DB2
          DB2 authorizations
          DB2 data type support
          DBCS support
          Sort work data sets
        Considerations for DB2 LUW targets
          Operational considerations for DB2 LUW targets
          Database access for DB2 LUW targets
          DB2 LUW authorizations
          DB2 LUW data type support
          Template file
        Considerations for Oracle targets
          Operational considerations for Oracle targets
          Database access for Oracle targets
          Oracle authorizations
          Oracle data type support
        Distribution of work
          Distribution by object
            Options for distribution by object
          Distribution by unit of recovery
        Conflict resolution
        Restart processing
        File transfer guidelines
          File transfer examples
        Where to go from here
      Defining configurations
        Overview
        Multiple configuration files for DB2 on mainframe targets
        Creating and managing configuration files
          Configuration file management
          Creating or editing a configuration file
        Configurations for specific tasks
          Mapping source object names to target objects
          Creating logical partitions for target tables
      Running High-speed Apply Engine
        Overview
          Overriding parameters in an apply request
          UNIX and Windows command line
          Mainframe batch job
            DD names and data set names
            Specifying DD statements on mainframe targets
            Apply request management for DB2 for mainframe targets
        Creating and running apply requests
          Creating and running an apply request for DB2 on mainframe targets
          Creating and running an apply request for DB2 LUW
          Creating and running an apply request for Oracle
        Where to go from here
      Restart and recovery
        Overview
        Enabling restart processing
          Creating a restart table
          Specifying restart parameters
          Restarting an apply request
        Summary of restart parameter usage
      Conflict resolution
        Overview of conflict resolution
          Format of conflict resolution rules
          Codes for conflict resolution (SQL codes)
            Interaction between conflict resolution rules
            Processing order for conflict resolution rules
          Actions for conflict resolution
        Creating conflict resolution rules
      Configuration file format
        Overview of the configuration file's format
          Sections in configuration files
          Format of configuration parameters
          Comments in configuration files
          Data set and file names in configuration files
            File names for UNIX and Windows
            Data set names for mainframe targets
          Object names in configuration files
            Table names
            Delimited table names
            Wildcards in object names
            Long object names
      Configuration parameters
        Overview
        Quick reference by name
        Quick reference by section
        Agent parameters
          InitialAgents
          MaxAgents
          MaxPrepares
        AnyConflict parameters
          Action
          Code
        Bind parameters
          AuthID
          BindAction
          BindOwner
          CollectionID
          DBPROTOCOL
          DISP
          FreeOption
          Library
          PackageName
          PackagePrefix
          PlanName
          PlanPrefix
        BindTuning parameters
          Using [BindTuning] parameters for performance
          MaxFailedBinds
          MaxPackages
          MaxRetries
          PackageUsage
          StatementCount
          StatementUsage
          Synchronous
        CommitTriggers parameters
          CommitOnDemand
          StatementCount
          Time
        Configuration parameters
          FileName (CFN)
        Conflict parameters
          DataType
          MaxFailedRetries
          MaxRetryFail
          RetryDelay
          RetryFail
          RetryLimit
          RetryValue
        ConflictFile parameters
          DATACLAS
          DISP
          FileNameModel
          LIKE
          MediaType
          MAXVOL
          MGMTCLAS
          RELEASE
          SingleFile
          SPACE
          SpacePri
          SpaceSec
          STORCLAS
          UNIT
          VOLSER
        DDLConflict parameters
        DeleteConflict parameters
        DiagnosticOutput parameter
          FileName
        DisplayOutput parameter
          FileName (DFN)
        DistributionTuning parameters
          Default distribution of work
          Precedence for distribution of work by object
          MaxExecuteImmediateDML
          PartitionClustering
          RIClustering
          RIRecursionLimit
          SimpleTSClustering
          URCheckRI
        ErrorOutput parameter
          FileName (EFN)
        InsertConflict parameters
        LogicalLog parameters
          CCSIDCompatible
          IncludeDDL
          IncludeLOB
          IncludeRI
          IncludeTrigger
          IncludeXML
          IncludeHistory
          Qualify
          PartitionDistribution
          Sort
          SQLType
          UpdateColumns
          UseLLogSysStrings
          WORKNUM
        LogOutput parameters
          FileName (LFN)
          LogType
          Overlap
          Threshold
        MonitorTuning parameters
          CommitTrigger
          CommitValue
          InactivityInterval
          InputTrigger
          InputValue
          ScanInterval
        MultiRowInsert parameters
          MaxConflicts
          MaxRows
          MultiRowInsert
        ObjectCluster parameters
          Cluster
          Table
        ObjectMap parameters
          Positional requirements for object mapping
          Using wildcards to map object names
          SourceColumn
          SourceTable
          TargetColumn
          TargetTable
        ObjectPartition parameters
          Positional requirements for ObjectPartition parameters
          Partition key length
          Considerations for Oracle data types
            Date data types
            Character data types
            Numeric data types
          Column
          LimitKey
          Order
          Partition
          Table
          Value
        Restart parameters
          CheckpointFrequency
          RestartID
          RestartType
          RetainTime
          Retry
          TableName
        SQL parameters
          DecimalPoint
          Format
        StartUp parameters
          BindQualifier
          ConnectionVersion
          Database
          DateFormat
          DBMSType
          DefaultOpts
          DistributionType
          FileName (IFN)
          InputMediaType
          InputType
          LargeStatementSupport
          Login
          Password
          PlanName
          PublicPlan
          SQLTerminator
          SSID
          TimestampFormat
          TimestampTzFormat
          UserID
          zIIP
        TemporaryFiles parameters
          DATACLAS
          Directory
          LIKE
          MGMTCLAS
          SPACE
          SpacePri
          SpaceSec
          STORCLAS
          UNIT
          VOLSER
        UpdateConflict parameters
      Logical log input
        Logical log input considerations
      Installing High-speed Apply Engine on mainframe targets
        Installation overview and prerequisites
        DB2 authorizations for plans, packages, and collections
          Using the user ID running High-speed Apply Engine
            Authorization examples for the user ID running High-speed Apply Engine
          Using BindOwner and a pre-bound plan
            Authorization examples for using a pre-bound plan
          Using a pre-bound plan and package
          Using the AuthId parameter
            Authorization examples for using the AuthID parameter
          Summary of DB2 authorization requirements
        Installation options overview
        Generating installation options
      Installing High-speed Apply Engine on UNIX or Windows
        Overview and prerequisites
          Installation considerations
          Controlling access
        Installing High-speed Apply Engine
        Additional procedures
          Verifying High-speed Apply Engine installation
          Viewing logs
            Contents of the logs
          Verifying server status and response time (Health Check)
          Dropping an existing restart table
          Creating a default restart table after installation
        Uninstalling High-speed Apply Engine
      LOADPLUS and High-speed Apply Engine
        How LOADPLUS uses High-speed Apply Engine
        Requirements for using High-speed Apply Engine with LOADPLUS
        LOADPLUS options and High-speed Apply Engine parameters
      Glossary
        APF
        apply agent
        apply processing
        apply request
        configuration
        configuration file
        configuration manager
        conflict
        conflict manager
        conflict resolution rule
        data migration
        DBCS
        DBRM
        DDL
        DML
        DFSMS
        distributed system
        GDG
        input file
        JCL
        parameter
        PDS
        resolution rule
        restart processing
        restart table
        section name
        SID
        source table
        SPUFI
        SQL
        SSID
        target table
        template file
        transaction recovery
    BMC Infrastructure Components Administration Guide
      BMC infrastructure components
        Overview of DB2 Component Services (DBC)
        Overview of DB2 Product Configuration (LGC)
        Overview of the Next Generation Logger (NGL)
        Overview of the Runtime Component System (RTCS)
        Required authorizations for user IDs
      Working with DB2 Component Services (DBC)
        Working with the DBC subsystem
          Started task for the DBC subsystem
          DBC startup parameters
          Stopping the DBC subsystem
          DBC commands
        DBC security
          Controlling access to DBC resources
          Configuring RACF security for the DBC subsystem
            Authorizing the DBC started task procedure
            Authorizing a user with access to the DBC services
            Creating a SAF resource class (optional)
            Defining a DBC control point resource profile
        DBC security parameters
      Working with DB2 Product Configuration (LGC)
        Overview of the LGC interface
          Expandable sections
          Drop-down menus
          Action list
          Online Help
        Working with option sets
          Accessing the online interface
          Creating a new option set
          Editing an option set
            Example of working with default values for option sets
          Renaming an option set
          Deleting an option set
          Filtering option sets
        LGC command reference
          LGC interface commands
          LGC operator commands
        LGCUTIL batch utility
          lgcutil
          create
          deregister
          export
          import
          list
          migrate
          register
          rename
          update
          Supporting elements
            config
            dbc
            ddname
            defaultdbc
            description
            dsn
            file
            files