SQL Manager 2011 for DB2 - User's Manual

Contents

---

Welcome to SQL Manager for DB2!

What's new

System requirements

Feature Matrix

Installation

Registration

How to register SQL Manager

License Agreement

Version history

EMS SQL Manager FAQ

Other EMS Products

Getting Started

Selecting style and language

First time started

Using Desktop Panel

Database navigation

Working with database objects

Using context menus

Node context menu

Database context menu

Object context menu

Working with windows

Database Explorer

Managing database registration info

Connecting to databases

Operations with database objects

Selecting multiple objects

Using tabs for database navigation

Recently opened objects

Managing projects

Searching within the tree

SQL Assistant

Configuring Database Explorer

Managing Favorite queries

Database Management

Register Node wizard

Selecting registration type

Using an existing entry

Selecting Node

Specifying tunneling parameters

Setting specific options

Adding a new catalog entry

Specifying connection parameters

Specifying tunneling parameters

Setting specific options

Create Database wizard

Setting DB name and Node info

Setting connection properties

Defining database files

Register Database wizard

Selecting registration type

Using an existing entry

Selecting database

Setting specific options

Adding a new catalog entry

Specifying connection parameters

Setting specific options

Database Registration Info

Connection

Common options

Display options

Default directories

Logs

Data options

Change management

Repository management wizard

Selecting operation

Selecting version control provider

Configuring provider settings

Configuring CVS settings

Configuring VSS settings

Configuring TFS settings

Specifying repository settings

Performing operation

Find Option

Database Properties

Database variables

Recovery

Logs

Maintenance

Applications

Performance

Status

Environment

Monitor

Node Properties

Node variables

Applications

Monitor

Diagnostic

Parallelism

Miscellaneous

Connection

Environment

Management

SSL

Node Registration Info

Connection Info

Find Option

Database Objects Management

New Object

Duplicate Object Wizard

Selecting the source database

Selecting object to duplicate

Selecting destination database

Modifying the new object's definition

Schemas

Schema Editor

Using Navigation bar and Toolbar

Creating/editing schema

Schema Objects

Tables

New table

Using Navigation bar and Toolbar

Setting table properties

Specifying fields

Managing dimensions

Managing partitions

Managing distribution

Table Editor

Using Navigation bar and Toolbar

Managing fields

Managing indexes

Managing constraints

Primary and Unique keys

Foreign keys

Checks

Managing triggers

Working with table data

Table Properties

Fields

Field Editor

Indexes

Index Editor

Primary/Unique keys

Primary/Unique Key Editor

Foreign keys

Foreign Key Editor

Checks

Check Editor

Triggers

Trigger Editor

Creating table-based objects

View from Table

Options

View info

View triggers

Procedures from Table

Options

SELECT procedure

INSERT procedure

UPDATE procedure

DELETE procedure

Views

View Editor

Using Navigation bar and Toolbar

Creating/editing view

Managing fields

Managing triggers

View plan

Working with data

Procedures

Procedure Editor

Using Navigation bar and Toolbar

Creating/editing procedure

Editing SQL

Managing parameters

Aliases

Alias Editor

Using Navigation bar and Toolbar

Creating/editing alias

Viewing data

Functions

Function Editor

Using Navigation bar and Toolbar

Creating/editing function

Editing SQL

Managing parameters

MQ Tables

MQ Table Editor

Using Navigation bar and Toolbar

Creating/editing MQ Table

Managing distribution

Nicknames

Nickname Editor

Using Navigation bar and Toolbar

Creating/editing nickname

Sequences

Sequence Editor

Using Navigation bar and Toolbar

Creating/editing sequence

UDS Types

UDS Type Editor

Using Navigation bar and Toolbar

Creating/editing UDS Type

Attributes

Methods

UD Types

UD Type Editor

Using Navigation bar and Toolbar

Creating/editing UD Type

Packages

Package Editor

Using Navigation bar and Toolbar

Creating/editing package

Triggers

Trigger Editor

Using Navigation bar and Toolbar

Creating/editing trigger

Indexes

Index Editor

SQL Variables

SQL Variable Editor

Using Navigation bar and Toolbar

Creating/editing SQL Variable

Global Temporary Tables

Global Temporary Table Editor

Using Navigation bar and Toolbar

Creating/editing Global Temporary Table

Manging Fields

Managing Distribution

Modules

Module Editor

Using Navigation bar and Toolbar

New Module

Editing Module

Non-schema Objects

Table spaces

Tablespace Editor

Using Navigation bar and Toolbar

Creating/editing table space

Managing containers

Buffer Pools

Buffer Pool Editor

Using Navigation bar and Toolbar

Creating/editing buffer pool

Partition Groups

Partition Group Editor

Using Navigation bar and Toolbar

Creating/editing partition group

Event Monitors

Event Monitor Editor

Using Navigation bar and Toolbar

Creating/editing event monitor

Setting Output

Using event filter

Wrappers

Wrapper Editor

Using Navigation bar and Toolbar

Creating/editing wrapper

Editing Options

Users

User Editor

Using Navigation bar and Toolbar

Creating/editing user

Managing grants

Groups

Group Editor

Using Navigation bar and Toolbar

Creating/editing group

Managing grants

User Mappings

User Mapping Editor

Using Navigation bar and Toolbar

Creating/editing user mapping

Adding/editing options

Servers

Server Editor

Using Navigation bar and Toolbar

Creating/editing server

Roles

Role Editor

Using Navigation bar and Toolbar

Creating/editing role

Managing grants

Defining ancestors

Trusted Contexts

Trusted Context Editor

Using Navigation bar and Toolbar

Creating/editing trusted context

Audit Policies

Audit Policy Editor

Using Navigation bar and Toolbar

Creating/editing audit policy

Security Label Components

Security Label Component Editor

Using Navigation bar and Toolbar

Creating/editing security label component

Security Policies

Security Policy Editor

Using Navigation bar and Toolbar

Creating/editing security policy

Security Labels

Security Label Editor

Using Navigation bar and Toolbar

Creating/editing security label

Local scripts

Shared scripts

TFS

CVS

VSS

Query Management Tools

SQL Editor

Using Navigation bar and Toolbar

Working with SQL Editor area

Using the context menu

Viewing query plan

Using object links

Executing queries

Viewing query logs

Favorites editor

Merging queries

Visual Query Builder

Using Navigation bar and Toolbar

Working with diagram area

Joining two objects

Setting criteria

Setting output fields

Setting grouping criteria

Setting sorting parameters

Working with the editor area

Query execution

Query parameters

Input parameters dialog

Data Management

Data View

Using Navigation bar and Toolbars

Grid View

Customizing columns

Grouping data

Filtering records

Using the context menu

Working in multi-level mode

Create Grid Level wizard

Specifying master level

Defining source for detail level

Binding master and detail levels

Query parameterization

Setting additional parameters

Working in card view mode

Column Summary

Copying records

Form View

Print Data

Page Setup

Page

Margins

Header/Footer

Scaling

Report Formatter

View

Behaviors

Formatting

Styles

Preview

Cards

Charts

Setting report options

Print dialog

BLOB View

Navigation within BLOB Editor

Editing as Hexadecimal

Editing as Text

Editing as Rich Text

Editing as Image

Editing as HTML

Editing as XML

Applying changes

Custom Filter

Filter Builder dialog

Invoking the Filter Builder dialog

Adding a new condition

Setting filter criteria

Setting filter operator

Setting filter criteria values

Adding a new group

Setting group operator

Applying filter conditions

Import/Export Tools

Export Data Wizard

Setting destination file name and format

Selecting fields for export

Adjusting data formats

Setting header and footer

Setting format-specific options

Excel options

Data format

Fields

Options

Styles

Extensions

Hyperlinks

Notes

Charts

Cells

Merged Cells

Advanced

Access options

Word / RTF options

Base Styles

Strip Styles

HTML options

Preview

Basic

Multi-file

Advanced

PDF options

TXT options

CSV options

XML options

MS Excel 2007 / ODS options

MS Word 2007 / ODT options

Setting common export options

Exporting data

Import Data Wizard

Selecting source file name and format

Selecting data source

Setting fields correspondence

Excel

Access

DBF

XML Datapacket

TXT

CSV

HTML

XML Generic

MS Excel/Word 2007, ODF

Adjusting data formats

Setting advanced field formats

Setting import mode

Customizing common options

Importing data

Export as SQL Script

Selecting destination DBMS

Setting destination file name

Setting BLOB options

Selecting fields to export

Editing table definition

Setting export options

Exporting as SQL Script

Database Tools

Common DB Tools

Dependency Tree

Using Navigation bar and Toolbar

Viewing dependency tree

Visual Database Designer

Using Navigation bar and Toolbars

Using Diagram Navigator and DB Objects pane

Using context menus

Working with diagram objects

Adding/removing objects to/from diagram

Incremental search

Creating objects

Creating relations

Working with diagram pages

Reverse engineering

Printing diagram

Print Preview

Print Setup dialog

Saving/loading diagram

Setting diagram options

SQL Script Editor

Using Navigation bar and Toolbar

Working with SQL Script editor area

Using Script Explorer

Script execution

Extract Database Wizard

Selecting source database

Specifying destination file name

Setting extraction mode

Setting BLOB options

Selecting objects for structure extraction

Selecting objects for data extraction

Customizing script options

Start of extraction process

Print Metadata

Using Navigation bar and Toolbar

Printing options

Print Preview

HTML Report Wizard

Selecting database and directory

Selecting object types

Specifying CSS

Setting additional report options

Creating HTML report

Reports management

Create Report Wizard

Specifying database name and report options

Selecting report bands

Selecting report style

Specifying page settings

Specifying paper settings

Specifying margins

Specifying other page settings

Report Designer

Adding dialog form

Adding database and query components

Adding report data

Viewing the report

Saving the report

Report Viewer

Using Navigation bar and Toolbar

SQL Monitor

Using Navigation bar and Toolbar

Working with SQL Monitor

Search in Metadata

Using Navigation bar and Toolbar

Setting search conditions

Viewing search results

Specific DB Tools

Grant Manager

Using Navigation bar, Toolbar and context menu

Managing database-specific privileges

Filtering objects in list

Rollforward Database

Setting DB name and final state

Setting rollforward options

Starting rollforward database

Backup Database

Setting DB name and backup mode

Setting backup options

Specifying additional parameters

Selecting table spaces to backup

Running backup

Restore Database

Setting DB name and restore mode

Selecting containers

Selecting backup image

Setting restore options

Running restore

Run Statistics

Setting DB name

Selecting tables

Setting runstats options

Running statistics

Reorganize Tables

Specifying the source database name

Selecting tables

Setting reorganize options

Setting runstats options

Reorganizing tables

Reorganize Indices

Setting DB name

Selecting tables

Setting reorganize options

Setting runstats options

Reorganizing indices

Activity Monitor

Using Navigation bar and Toolbar

Working with Activity Monitor

CLP Tools

CLP Export

Specifying DB name and connection info

Specifying data destination

Specifying DEL file modifiers

Specifying LOB destination

Specifying SQL SELECT statement

Exporting data

CLP Import

Specifying DB name and connection info

Specifying data source and destination

Specifying common file modifiers

Specifying advanced file modifiers

Specifying LOB source

Specifying fields to import

Specifying additional parameters

Importing data

CLP Load

Specifying DB name and connection info

Specifying data source and destination

Specifying common file modifiers

Specifying advanced file modifiers

Specifying action

Specifying LOB source

Specifying load parameters

Specifying fields to load

Specifying additional parameters

Loading data

CLP Move

Specifying DB name and connection parameters

Specifying EXPORT destination

Specifying COPY destination

Setting IMPORT/LOAD options

Selecting objects to export/copy

Specifying COPY options

Moving data

CLP Console

Using Navigation bar and Toolbar

Working with editing area

Viewing execution results

Ping Database

Specifying database

Pinging database

Change management

Create tag wizard

Selecting source database

Specifying tag caption

Performing operation

Check repository wizard

Selecting database

Selecting object types

Checking repository

Specifying action for each difference

Selecting objects to remove from the repositary

Checking and correcting script

Adding comments

Performing operation

Get change script wizard

Selecting source database

Selecting script generation method

Specifying start and end points for the script

Specifying comments

Defining script destination

Performing operation

History

History of database changes

Object history

Instance Tools

Quiesce Database Wizard

Setting DB name and connection info

Specifying additional parameters

DB quiescence

Unquiesce Database Wizard

Setting DB name and connection info

DB unquiescence

Start Database Manager Wizard

Setting node name and connection info

Starting Database Manager

Stop Database Manager Wizard

Setting node name and connection info

Stopping Database Manager

Restart Database Wizard

Setting DB name and connection info

Restarting database

Personalization

SQL Manager Options

Environment Options

Preferences

Full mode activation

Confirmations

Windows

Tools

DB Explorer

Table Editor

SQL Editor

SQL Monitor

Activity Monitor

CLP Console

SQL Script

Query Builder

Style & Color Palette

Visual Database Designer

Print Metadata

Dependencies

Data Export

Fonts

Grid

Data Options

Print Data

Color & Formats

Advanced

Column Options

Localization

Global Shortcuts

Find Option

Editor Options

General

Display

Highlight

Quick Code

SQL Formatter

SQL Words

Key Mapping

Spell Checking

Find Option

Visual Options

Bars and menus

Trees and lists

Edit controls

Check boxes

Buttons

Page controls

Group boxes

Splitters

Navigation bar

Find Option

Save Settings

Specifying destination file

Selecting settings

Selecting databases

Saving settings

Localization

Localization Editor

Select Program Language

Keyboard Templates

Object Templates

Find Option dialog

External Tools

External Tools dialog

External Tool Info editor

How To...

Work with Nodes and Databases

Register Node

Unregister Node

Create Database

Drop Database

Register Database

Unregister Database

Connect to Database

Disconnect from Database

View Database Registration Info

View Database properties

View Node properties

Managing user grants

Backup Database

Restore Database

Rollforward Database

Quiesce Database

Unquiesce Database

Start Database Manager

Stop Database Manager

Restart Database

Work with Database Objects

Create Database Object

Edit Database Object

Drop Database Object

Work with Schemas

Create Schema

Edit Schema

Drop Schema

Work with Tables

Create Table

Edit Table

Drop Table

Manage Table Fields

Add Table Field

Edit Table Field

Drop Table Field

Manage Foreign Keys

Add Foreign Key

View Foreign Key

Drop Foreign Key

Manage Table Checks

Create Check

View Check

Drop Check

Manage Table Indexes

Create Index

Edit Index

Drop Index

Manage Table Triggers

Create Trigger

Edit Trigger

Drop Trigger

Work with Views

Create View

Edit View

Drop View

Work with Procedures

Create Procedure

Edit Procedure

Execute Procedure

Drop Procedure

Work with Aliases

Create Alias

Edit Alias

Drop Alias

Work with Functions

Create Function

Edit Function

Drop Function

Work with MQ Tables

Create MQ Table

Edit MQ Table

Drop MQ Table

Work with Nicknames

Create Nickname

Edit Nickname

Drop Nickname

Work with Sequences

Create Sequence

Edit Sequence

Drop Sequence

Work with UDS Types

Create UDS Type

Edit UDS Type

Drop UDS Type

Work with UD Types

Create UD Type

Edit UD Type

Drop UD Type

Work with Packages

Create Package

Edit Package

Drop Package

Work with Triggers

Create Trigger

Edit Trigger

Drop Trigger

Work with Indexes

Create Index

Edit Index

Drop Index

Work with SQL Variables

Create SQL Variable

Edit SQL Variable

Drop SQL Variable

Work with Tablespaces

Create Tablespace

Edit Tablespace

Drop Tablespace

Work with Buffer Pools

Create Buffer pool

Edit Buffer pool

Drop Buffer pool

Work with Partition Groups

Create Partition Group

Edit Partition Group

Drop Partition Group

Work with Event Monitors

Create Event Monitor

Edit Event Monitor

Drop Event Monitor

Work with Wrappers

Create Wrapper

Edit Wrapper

Drop Wrapper

Work with Users

Create User

Edit User

Drop User

Work with Groups

Create Group

Edit Group

Drop Group

Work with User Mappings

Create User Mapping

Edit User Mapping

Drop User Mapping

Work with Servers

Create Server

Edit Server

Drop Server

Work with Roles

Create Role

Edit Role

Drop Role

Work with Trusted Contexts

Create Trusted Context

Edit Trusted Context

Drop Trusted Context

Work with Audit Policies

Create Audit Policy

Edit Audit Policy

Drop Audit Policy

Work with Security Label Components

Create Security Label Component

Edit Security Label Component

Drop Security Label Component

Work with Security Policies

Create Security Policy

Edit Security Policy

Drop Security Policy

Work with Security Labels

Create Security Label

Edit Security Label

Drop Security Label

Work with Global Temporary Tables

Create Global Temporary Table

Edit Global Temporary Table

Drop Global Temporary Table

Work with Modules

Create Module

Edit Module

Drop Module

Work with Shared scripts

Create Shared Script

Work with existing Shared Script

Work with Queries

Create Query

Open Query

Execute Query

Save Query

Work with External Tools

Add External Tool

Remove External Tool

Manage Program Localization

Change Program Language

Edit Localization

Create New Localization

Appendix

Program interface

Viewing object DDL structure

Editing object description

Browsing object dependencies

Compile window

Tip of the Day

Find Text dialog

Replace Text dialog

Format specifiers

Language Info Editor

Using templates

Supported file formats

To-Do List

Windows List

Customize toolbars and menus

SSH tunneling options

Connection Lost dialog

SQL Manager Direct

Database Login dialog

Overwriting existing output file

Script conversion

Label-Based Access Control

Select Object dialog

SQL Manager shortcuts