DB2 UDB for OS/390 objects and related tasks

  • Getting started with DB2 Universal Database for OS/390 objects
  • Tasks common to all DB2 Universal Database for OS/390 objects
  • Changing object privileges for a user ID
  • Filtering objects
  • Granting object privileges to a new user ID
  • Locating objects
  • Aliases -- Working With
  • Altering an alias
  • Creating an alias
  • Buffer Pools -- Working With
  • Altering buffer pools
  • Version 5
  • Version 6
  • Defining buffer pools
  • Version 5
  • Version 6
  • Displaying buffer pool status
  • Version 5
  • Version 6
  • Granting and revoking buffer pool privileges
  • Catalog Tables -- Working With
  • Granting and revoking catalog privileges
  • Querying the catalog for index and table space information
  • Collections -- Working With
  • Granting and revoking collection privileges
  • Customized Object Trees -- Working With
  • Adding a folder in a customized tree
  • Creating a customized tree
  • Defining or viewing properties of a folder in the customized tree
  • Deleting a customized tree
  • Opening a saved customized tree
  • Saving a customized tree
  • Databases -- Working With
  • Altering databases
  • Version 5
  • Version 6
  • Creating databases
  • Version 5
  • Version 6
  • Displaying database status
  • Version 5
  • Version 6
  • Granting and revoking database privileges
  • Starting one or more databases
  • Starting all databases
  • Stopping one or more databases
  • Stopping all databases
  • Data Sets -- Working With
  • Changing a data set template
  • Deleting data sets
  • Listing data sets
  • DB Users -- Working With
  • Changing DB users
  • Version 5
  • Version 6
  • Creating DB users
  • Version 5
  • Version 6
  • Removing DB users
  • DDL -- Working With
  • Generating DDL for Databases
  • Version 5
  • Version 6
  • Generating DDL for Table Spaces
  • Version 5
  • Version 6
  • Generating DDL for Tables
  • Version 5
  • Version 6
  • Generating DDL for Schemas
  • Generating DDL for Distinct Types
  • Generating DDL for User Defined Functions
  • Generating DDL for Procedures
  • Distinct Types -- Working With
  • Creating a distinct type
  • Granting and revoking user-defined data type (UDT) privileges
  • Indexes and Table Spaces -- Working With
  • Version 5 and Version 6 tasks in common
  • Checking index consistency
  • Granting and revoking table space privileges
  • Merge copying a table space
  • Modifying a table space
  • Recovering a table space to a page
  • Reporting index information
  • Starting indexes and table spaces
  • Stopping indexes and table spaces
  • Updating table space statistics
  • Version 5 tasks
  • Altering an index
  • Altering a table space
  • Checking data in table spaces
  • Concurrently copying a table space
  • Copying a table space
  • Creating an index
  • Creating a table space
  • Displaying reports about indexes
  • Displaying table space status
  • Loading data into a table space
  • Recovering indexes
  • Recovering indexes within table spaces
  • Recovering a table space to a current state
  • Recovering table spaces to a point on the log
  • Reorganizing an index
  • Quiescing a table space
  • Recovering a table space to image copy
  • Reorganizing a table space
  • Reporting table space information
  • Running index statistics
  • Version 6 tasks
  • Altering an index, partitioned
  • Altering an index, non-partitioned
  • Altering a table space
  • Checking a LOB table space
  • Checking data in table spaces
  • Concurrently copying an index or table space
  • Copying a table space
  • Creating an index
  • Creating a table space
  • Displaying reports about indexes
  • Displaying table space status
  • Loading data into a table space
  • Quiescing a table space set
  • Rebuilding an index
  • Recovering a table space
  • Recovering a table space or index to a current state
  • Recovering table spaces or indexes to a point on the log
  • Recovering a table space to image copy
  • Reorganizing a table space
  • Reorganizing an index
  • Reporting table space information
  • Running index statistics
  • Locations -- Working With
  • Displaying location status
  • Packages and Plans -- Working With
  • Granting and revoking package privileges
  • Granting and revoking plan privileges
  • Schemas -- Working With
  • Creating a schema
  • Granting and revoking schema privileges
  • Storage Groups -- Working With
  • Altering storage groups
  • Version 5
  • Version 6
  • Creating storage groups
  • Version 5
  • Version 6
  • Displaying storage space
  • Granting and revoking storage group privileges
  • Stored Procedures -- Working With
  • Altering stored procedures
  • Version 5
  • Version 6
  • Creating stored procedures
  • Version 5
  • Version 6
  • Displaying reports about stored procedures
  • Version 5
  • Version 6
  • Granting and revoking procedure privileges
  • Subsystems -- Working With
  • Canceling threads
  • Connecting to the subsystem
  • Displaying archive reports
  • Displaying location properties
  • Displaying Rlimit status
  • Displaying the subsystem parameters
  • Displaying thread status
  • Version 5
  • Version 6
  • Displaying utilities status
  • Granting and revoking subsystem privileges
  • Setting archive values
  • Synonyms -- Working With
  • Creating a synonym
  • Tables -- Working With
  • Altering tables
  • Version 5
  • Version 6
  • Creating tables
  • Version 5
  • Version 6
  • Granting and revoking table privileges
  • Version 5
  • Version 6
  • Renaming a table
  • Triggers -- Working With
  • Adding or changing a comment on a trigger
  • Creating a trigger
  • Granting and revoking trigger privileges
  • User-Defined Functions -- Working With
  • Altering a user-defined function (external scalar or table)
  • Altering a user-defined function (external scalar)
  • Altering a user-defined function (external table)
  • Creating a user-defined function (external scalar)
  • Creating a user-defined function (external table)
  • Creating a user-defined function (sourced)
  • Granting and revoking user-defined function (UDF) privileges
  • Utility Objects -- Working With
  • Modifying the Current Utility ID
  • Using Concurrent Copy in a Utility Procedure
  • Using Concurrent Copy in an Object List
  • Using Copy in a Utility Procedure
  • Using Copy in an Object List
  • Using Quiesce on an Object List
  • Using Quiesce in a Utility Procedure
  • Using Reorganize in a Utility Procedure
  • Views -- Working With
  • Altering a view
  • Creating a view
  • Granting and revoking view privileges

    •