DB2 UDB objects and related tasks

  • Aliases -- Working With
  • Altering an alias
  • Creating an alias
  • Dropping an alias
  • Buffer Pools -- Working With
  • Creating a buffer pool
  • Altering a buffer pool
  • Creating a buffer pool for a partitioned database
  • Altering 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 wizard
  • Configuring a database
  • Setting the userid and password for a specific system, instance, or database
  • Creating a database with default or tailored settings using a wizard
  • 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 wizard
  • Improving performance for a database with different workloads using a wizard
  • 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 wizard
  • 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
  • Restarting a database
  • Database Connection Partitions -- Working With
  • Database Partitions -- Working With
  • Configuring a database partition
  • Configuring database parameters for performance using a wizard
  • Improving performance for a database with different workloads using a wizard
  • Restarting a database partition
  • Backing up a database partition
  • Restoring a database partition
  • Rolling forward a database partition
  • Taking a database partition out of the roll-forward pending state
  • 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
  • Granting and revoking the USE privilege on table spaces
  • 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
  • Granting the USE privilege on table spaces to a new group
  • DB Users -- Working With
  • Changing database authorities
  • Changing schema privileges
  • Changing table privileges
  • Granting and revoking the CONTROL privilege on indexes
  • Granting and revoking the USE privilege on table spaces
  • Changing view privileges
  • 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 the USE privilege on table spaces to a new user
  • Granting view privileges to a new user
  • DB2 Spatial Extender -- Working With
  • DBSpaces -- Working With
  • Updating DBSpace Statistics
  • Federated Database System -- Working with
  • Indexes -- Working With
  • Altering an index
  • Creating an index
  • Creating an index on the DB2 Server for VSE & VM
  • Creating indexes using a wizard
  • Creating a workload
  • Editing a workload
  • Adding a SQL statement to a workload
  • Changing a SQL statement in a workload
  • Importing SQL statements
  • Viewing workload details
  • Viewing a SQL statement in a workload
  • Dropping an index
  • Granting and revoking index privileges
  • Granting and revoking index privileges for users
  • Granting and revoking index privileges for user groups
  • Reorganizing an index on the DB2 Server for VSE & VM
  • Instances -- Working With
  • Adding an instance
  • Changing an instance
  • Configuring an instance
  • Configuring a multisite update using a wizard
  • Testing multisite update
  • Viewing a list of local databases applications for an instance
  • Forcing local databases applications for an instance
  • Viewing a list of gateway applications for an instance
  • Forcing gateway applications for an instance
  • Setting up Communications
  • Configuring APPC
  • Configuring IPX/SPX
  • Configuring named pipes
  • Configuring NetBIOS
  • Configuring TCP/IP
  • Stopping an instance
  • Nicknames -- Working With
  • Creating nicknames
  • Nodegroups -- Working With
  • Altering a nodegroup
  • Creating a nodegroup
  • Nodes -- Working With
  • Starting nodes
  • Stopping nodes
  • Tracing nodes
  • Displaying the diagnostics log
  • 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
  • Servers -- Working With
  • Creating a server
  • Adding a server option
  • Altering the values for server options
  • Dropping server options
  • 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
  • Changing column categories 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
  • Changing column categories 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 wizard
  • 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
  • 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
  • Updating Table statistics for a table on the DB2 Server for VSE & VM
  • Viewing a sample of a table's contents
  • When to manually set constraint checking for a table
  • Basic table copy
  • Table Partitions -- Working With
  • 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 wizard
  • Renaming a table space
  • 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
  • Granting and revoking table space privileges
  • Granting and revoking table space privileges for users
  • Granting and revoking table space privileges for user groups
  • Table Space Partitions -- Working With
  • Altering a table space partition
  • Backing up a table space partition
  • Restoring a table space partition
  • Rolling forward a table space partition
  • Taking a table space partition out of the roll-forward pending state
  • Triggers -- Working With
  • Adding, changing, or deleting a comment on a trigger
  • Viewing the definition of a trigger
  • Specifying information for a trigger
  • Specifying a triggered action
  • Creating a trigger
  • Dropping a trigger
  • User-Defined Types -- Working With
  • Defining properties when creating a distinct type
  • User Mappings -- Working With
  • Creating user mappings
  • Altering user mappings
  • Views -- Working With
  • Exporting a file
  • Altering a view
  • Creating a view
  • Dropping a view
  • Granting and revoking view privileges for users
  • Granting and revoking view privileges for groups
  • Viewing a sample of a view's contents
  • Wrappers -- Working With
  • Creating a wrapper

    •