How to use the DB2 Universal Database help
Getting started with the Control Center
Adding DB2 Universal Database systems, instances, and databases to the object tree
Adding DB2 for OS/390 systems to the object tree
Adding DB2 Server for VSE & VM to the object tree
Creating database objects
Customizing the list of displayed columns
Displaying objects in the Control Center
Dropping or removing an object
Filtering the list of displayed objects
Information on Stored Procedure Builder
Limiting the number of objects displayed in the Control Center.
Generating DDL statements for database objects
Locating an object
Saving files using the Control Center file extension
Setting Alert Center properties
Invoking an action when the status of a node changes to down or unknown
Changing the fonts for menus and text.
Setting DB2 Universal Database for OS/390 Control Center properties
Obtaining DB2 diagnostic information
Opening new Control Centers
Performing administrative tasks on Control Center objects
Refreshing objects in the Control Center
Setting online help properties
Setting replication properties
Showing commands or SQL
Showing related objects
Shutting down server administration tools
Sorting the list of displayed objects
Specifying a command statement termination character
Specifying the server administration tools startup property
Testing and updating multiple databases
Typing characters using the Alt-Gr key
Using wizards to perform tasks quickly and easily
DB2 UDB objects and related tasks
Aliases -- Working With
Buffer Pools -- Working With
Databases -- Working With
Database Connection Partitions -- Working With
Database Partitions -- Working With
DB Groups -- Working With
DB Users -- Working With
DB2 Spatial Extender -- Working With
DBSpaces -- Working With
Federated Database System -- Working with
Indexes -- Working With
Instances -- Working With
Nicknames -- Working With
Nodegroups -- Working With
Nodes -- Working With
Replication Subscriptions -- Working With
Replication Sources -- Working With
Schemas -- Working With
Servers -- Working With
Systems -- Working With
Tables -- Working With
Table Partitions -- Working With
Table Spaces -- Working With
Table Space Partitions -- Working With
Triggers -- Working With
User-Defined Types -- Working With
User Mappings -- Working With
Views -- Working With
Wrappers -- Working With
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
Aliases -- Working With
Buffer Pools -- Working With
Catalog Tables -- Working With
Collections -- Working With
Customized Object Trees -- Working With
Databases -- Working With
Data Sets -- Working With
DB Users -- Working With
DDL -- Working With
Distinct Types -- Working With
Indexes and Table Spaces -- Working With
Locations -- Working With
Packages and Plans -- Working With
Schemas -- Working With
Storage Groups -- Working With
Stored Procedures -- Working With
Subsystems -- Working With
Synonyms -- Working With
Tables -- Working With
Triggers -- Working With
User-Defined Functions -- Working With
Utility Objects -- Working With
Views -- Working With
Monitoring performance
Introducing performance monitoring
Changing the default monitor
Changing a monitor
Copying a monitor
Creating a monitor
Making changes to an active monitor
Removing monitors
Renaming a monitor
Saving a monitor under a different name
Starting a monitor
Stopping monitors
Viewing a list of monitors
Viewing a list of monitored objects
Viewing monitor data
Working with the Alert Center
Identifying a performance variable that has reached a threshold
Setting Alert Center preferences
Stopping performance monitoring from the Alert Center
Suspending alerts
Viewing nodes that are down or in an unknown state
Analyzing SQL statements (formerly Visual Explain)
Creating an access plan graph
Creating explain snapshots
Displaying and using an access plan graph
Dynamically explaining an SQL statement
Reading the contents of the Visual Explain windows
Tuning your SQL queries
Viewing explainable statements for a package
Viewing the history of previously explained SQL statements
Viewing a graphical representation of an access plan
Working with jobs and scripts
Command Center - Working With
Script Center - Working With
Journal - Working With
Scheduler - Working With
Getting Started with the Data Warehouse Center
Getting started with the Data Warehouse Center
Logging on to the Data Warehouse Center
Creating a data warehouse
Changing Data Warehouse Center properties
Defining warehouse users
Defining warehouse groups
Defining a subject area
Defining an agent site
Defining a warehouse source
Defining a warehouse target
Defining a warehouse schema
Defining programs
Defining a step
Creating a schedule
Publishing metadata to the information catalog
Moving and transforming data
Monitoring a step or process
Importing and exporting metadata
Managing objects
Changing a Data Warehouse Center password
Getting started with the Satellite Administration Center
Administering Satellites
Application Versions -- Working With
Authentications -- Working With
Batches -- Working With
Groups -- Working With
Logs -- Working With
Replication -- Working With
Satellites -- Working With
Scripts -- Working With
Success Code Sets -- Working With
Targets -- Working With
Working with the Information Center
Finding task instructions
Finding reference information
Finding a particular book
Finding troubleshooting information
Finding information on sample programs
Finding DB2 information on the World Wide Web
Getting started with the License Center
Adding a license
Adding a registered user
Changing the enforcement policy
Changing the enforcement policy for DB2 Relational Connect
Changing the license type policy
Changing the license type policy for DB2 Relational Connect
Changing the number of concurrent non-DB2 data sources
Changing the number of concurrent users
Changing the number of licensed processors
Removing a license
Removing a registered user
Using the measured usage policy
Using the user-based policy
Viewing processor status information
Viewing concurrent users policy information
Viewing license information
Viewing measured usage license information
Viewing user statistics
Viewing non-DB2 data source statistics
Reference material
Control Center icons
Satellite Administration Center icons
Configuration Parameters
Data Elements
Performance Variables Reference
General concepts
DB2 DB2 Universal Database concepts
DB2 UDB for OS/390 concepts
Data Warehouse Center concepts
Satellite concepts
Performance monitoring concepts
Visual Explain concepts
Glossary
Index
Notices
Trademarks