IBM Books

Database objects and related tasks

Partial Table-of-Contents

  • Aliases -- Working With
  • Altering an alias
  • Creating an alias
  • Dropping an alias
  • Buffer Pools - Working With
  • Altering a buffer pool
  • Altering a buffer pool for a partitioned database
  • Creating a buffer pool
  • Creating a buffer pool for a partitioned database
  • Databases - Working With
  • Adding a database
  • Altering a database
  • Database Authorities
  • Granting and revoking database authorities for users
  • Granting and revoking database authorities for user groups
  • Backing up a database or a database partition
  • Backing up a database using a SmartGuide
  • Configuring a database
  • Setting the userid and password for a specific system, instance, or database
  • Creating a new database with default settings
  • Creating a new database with tailored settings
  • Creating a database from a backup
  • Performing a simple create database from a backup
  • Modifying containers
  • Performing roll-forward recovery
  • Leaving the database in the roll-forward pending state
  • Configuring database parameters for performance using a SmartGuide
  • Improving performance for a database with different workloads using a SmartGuide
  • Restoring a database or database partition
  • Performing a simple restore
  • Restoring selected table spaces
  • Modifying containers
  • Performing roll-forward recovery
  • Leaving the database or database partition in the roll-forward pending state
  • Restoring a database using a SmartGuide
  • Restoring a backup image to a new database
  • Performing a simple restore to a new database
  • Modifying containers
  • Performing roll-forward recovery
  • Leaving the database in the roll-forward pending state
  • Rolling forward a database or a database partition
  • Performing roll-forward recovery
  • Leaving the database or database partition in the roll-forward pending state
  • Rolling forward selected table spaces
  • Database Connection Partitions -- Working With
  • Database Partitions -- Working With
  • DB Groups -- Working With
  • Changing a group's authorizations
  • Changing database authorities
  • Changing schema privileges
  • Changing table privileges
  • Granting and revoking the CONTROL privilege on indexes
  • Changing view privileges
  • Granting authorizations to a new group
  • Defining a new group of database users to DB2
  • Granting database authorities to a new group
  • Granting schema privileges to a new group
  • Granting table privileges to a new group
  • Granting the CONTROL privilege on indexes to a new group
  • Granting view privileges to a new group
  • Indexes - Working With
  • Altering an index
  • Creating an index
  • Dropping an index
  • Index privileges
  • Granting and revoking index privileges for users
  • Granting and revoking index privileges for user groups
  • Instances - Working With
  • Adding an instance
  • Changing an instance
  • Configuring an instance
  • Forcing applications off an instance
  • Listing applications
  • Setup Communications
  • Configuring NetBIOS
  • Configuring TCP/IP
  • Configuring IPX/SPX
  • Direct Addressing
  • File Server Addressing
  • Configuring named pipe
  • Configuring APPC
  • Stopping an instance
  • Nodegroups - Working With
  • Altering a nodegroup
  • Creating a nodegroup
  • Nodes -- Working With
  • Replication Subscriptions - Working With
  • Activating and deactivating a subscription
  • Changing a subscription
  • Cloning a subscription
  • Defining a subscription
  • Adding a replication source
  • Changing a target table
  • Confirming replication source removal
  • Removing a subscription
  • Running a subscription file
  • Replication Sources - Working With
  • Changing a replication source
  • Defining a custom replication source
  • Defining a join for a replication source
  • Defining a replication source using default values
  • Removing a replication source
  • Running an SQL file
  • Schemas - Working With
  • Altering a schema
  • Creating a schema
  • Granting and revoking schema privileges for users
  • Granting and revoking schema privileges for user groups
  • Systems - Working With
  • Adding a system
  • Changing a system
  • Tables - Working With
  • Altering a table
  • Changing table properties when altering a table
  • Adding columns when altering a table
  • Changing existing columns when altering a table
  • Selecting predefined columns when altering a table
  • Editing column lists when altering a table
  • Defining the primary key when altering a table
  • Changing the primary key when altering a table
  • Adding partitioning key columns when altering a table
  • Removing partitioning key columns when altering a table
  • Adding foreign keys when altering a table
  • Changing foreign keys when altering a table
  • Adding check constraints when altering a table
  • Changing check constraints when altering a table
  • Changing a table's quiesce mode
  • Copying a table
  • Creating a table
  • Defining table properties when creating a table
  • Adding columns when creating a table
  • Selecting predefined columns when creating a table
  • Editing column lists when creating a table
  • Defining the primary key when creating a table
  • Defining the partitioning key when creating a table
  • Adding foreign keys when creating a table
  • Adding check constraints when creating a table
  • Creating a table using a SmartGuide
  • Dropping a table
  • Exporting a file
  • Specifying file options when exporting a file
  • Storing large objects in separate files when exporting a file
  • Adding column names when exporting a file
  • Granting and revoking table privileges
  • Granting and revoking table privileges for users
  • Granting and revoking table privileges for groups
  • Importing Tables
  • Importing a file into a table
  • Creating a new table from an input file
  • Loading data into a table
  • Specifying the location and file type to be loaded
  • Specifying how to load ASC data into the table columns
  • Specifying how to load DEL data into the table columns
  • Specifying how to load IXF data into the table columns
  • Specifying conditions for loading data file rows into table columns
  • Specifying options to collect statistics when loading data into a table
  • Specifying options for saving a copy of changes when loading data into a table
  • Specifying various options for loading data into a table
  • Restarting an interrupted load operation
  • Terminating an interrupted load operation
  • Percentage of free space to be left on index pages
  • Renaming a table
  • Reorganizing a table
  • Running statistics for a table
  • Turning off constraint checking for a table
  • Turning on constraint checking for a table and checking the data
  • Turning on constraint checking for a table without checking the table data
  • Viewing a sample of a table's contents
  • Table Partitions
  • Table Spaces - Working With
  • Altering a table space or table space partition
  • Altering performance parameters for an existing table space
  • Backing up a table space or table space partition
  • Creating a table space
  • Creating a table space using a SmartGuide
  • Restoring a table space or table space partition
  • Performing a simple restore
  • Modifying containers
  • Performing roll-forward recovery
  • Rolling forward a table space or table space partition
  • Performing roll-forward recovery
  • Leaving the table space or table space partition in the roll-forward pending state
  • Table Space Partitions -- Working With
  • Triggers -- Working With
  • Adding, changing, or deleting a comment on a trigger
  • Viewing the definition of a trigger
  • Creating a trigger
  • Specifying information for a trigger
  • Specifying a triggered action
  • Dropping a trigger
  • User-Defined Types - Working With
  • Defining properties when creating a distinct type
  • DB Users -- Working With
  • Changing a user's authorizations
  • Changing database authorities
  • Changing schema privileges
  • Changing table privileges
  • Granting and revoking the CONTROL privilege on indexes
  • Changing view privileges
  • Granting authorizations to a new user
  • Defining a new database user to DB2
  • Granting database authorities to a new user
  • Granting schema privileges to a new user
  • Granting table privileges to a new user
  • Granting the CONTROL privilege on indexes to a new user
  • Granting view privileges to a new user
  • Views -- Working With
  • Altering a view
  • Creating a view
  • Dropping a view
  • Exporting a file
  • Granting and revoking view privileges
  • Granting and revoking view privileges for users
  • Granting and revoking view privileges for groups
  • Showing related views
  • Viewing a sample of a view's contents

    • [ Top of Page | Table of Contents | Glossary | Index ]

    [ DB2 List of Books | Search the DB2 Books ]