Who Should Use this Book
How this Book is Structured
About This Book
Who Should Use this Book
How this Book is Structured
Chapter 1. System Commands
How the Command Descriptions are Organized
db2admin - DB2 Administration Server
db2adutl - Work with TSM Archived Images
db2advis - DB2 Index Advisor
db2audit - Audit Facility Administrator Tool
db2atld - Autoloader
db2batch - Benchmark Tool
db2bfd - Bind File Description Tool
db2cc - Start Control Center
db2cdbcr - Create Control Database for Data Warehouse
db2cfexp - Connectivity Configuration Export Tool
db2cfimp - Connectivity Configuration Import Tool
db2cidmg - Remote Database Migration
db2ckbkp - Check Backup
db2ckmig - Database Pre-migration Tool
db2cli - DB2 Interactive CLI
db2cmd - Open DB2 Command Window
db2dclgn - Declaration Generator
db2drdat - DRDA Trace
db2empfa - Enable Multi-page File Allocation
db2eva - Event Analyzer
db2evmon - Event Monitor Productivity Tool
db2exfmt - Explain Table Format Tool
db2expln - DB2 SQL Explain Tool
db2flsn - Find Log Sequence Number
db2fs - First Steps
db2gov - DB2 Governor
db2govlg - DB2 Governor Log Query
db2icrt - Create Instance
db2idrop - Remove Instance
db2ilist - List Instances
db2imigr - Migrate Instance
db2ipxad - Get IPX/SPX Internetwork Address
db2iupdt - Update Instances
db2ldcfg - Configure LDAP Environment
db2licm - License Management Tool
db2look - DB2 Statistics and DDL Extraction Tool
db2move - Database Movement Tool
db2mscs - Set up Windows NT Failover Utility
db2nchg - Change Database Partition Server Configuration
db2ncrt - Add Database Partition Server to an Instance
db2ndrop - Drop Database Partition Server from an Instance
db2perfc - Reset Database Performance Values
db2perfi - Performance Counters Registration Utility
db2perfr - Performance Monitor Registration Tool
db2profc - DB2 SQLJ Profile Customizer
db2profp - DB2 SQLJ Profile Printer
db2rbind - Rebind all Packages
db2sampl - Create Sample Database
db2set - DB2 Profile Registry Command
db2sql92 - SQL92 Compliant SQL Statement Processor
db2start - Start DB2
db2stop - Stop DB2
db2sync - Start DB2 Synchronizer
db2tbst - Get Tablespace State
db2trc - Trace
db2uiddl - Prepare Unique Index Conversion to V5 Semantics
db2untag - Release Container Tag
Chapter 2. Command Line Processor (CLP)
Command Line Processor Invocation
Command Line Processor Options
Command Line Processor Return Codes
Using the Command Line Processor
Using the Command Line Processor in Command Files
Command Line Processor Design
CLP Usage Notes
Chapter 3. CLP Commands
DB2 CLP Commands
ACTIVATE DATABASE
ADD DATALINKS MANAGER
ADD NODE
ATTACH
BACKUP DATABASE
BIND
CALL
CATALOG APPC NODE
CATALOG APPCLU NODE
CATALOG APPN NODE
CATALOG DATABASE
CATALOG DCS DATABASE
CATALOG GLOBAL DATABASE
CATALOG IPX/SPX NODE
CATALOG LDAP DATABASE
CATALOG LDAP NODE
CATALOG LOCAL NODE
CATALOG NAMED PIPE NODE
CATALOG NETBIOS NODE
CATALOG ODBC DATA SOURCE
CATALOG TCP/IP NODE
CHANGE DATABASE COMMENT
CHANGE ISOLATION LEVEL
CREATE DATABASE
DEACTIVATE DATABASE
DEREGISTER
DESCRIBE
DETACH
DROP DATABASE
DROP NODE VERIFY
ECHO
EXPORT
FORCE APPLICATION
GET ADMIN CONFIGURATION
GET AUTHORIZATIONS
GET CLI CONFIGURATION
GET CONNECTION STATE
GET DATABASE CONFIGURATION
GET DATABASE MANAGER CONFIGURATION
GET DATABASE MANAGER MONITOR SWITCHES
GET INSTANCE
GET MONITOR SWITCHES
GET SNAPSHOT
HELP
IMPORT
INITIALIZE TAPE
INVOKE STORED PROCEDURE
LIST ACTIVE DATABASES
LIST APPLICATIONS
LIST COMMAND OPTIONS
LIST DATABASE DIRECTORY
LIST DATALINKS MANAGERS
LIST DCS APPLICATIONS
LIST DCS DIRECTORY
LIST DRDA INDOUBT TRANSACTIONS
LIST HISTORY
LIST INDOUBT TRANSACTIONS
LIST NODE DIRECTORY
LIST NODEGROUPS
LIST NODES
LIST ODBC DATA SOURCES
LIST PACKAGES/TABLES
LIST TABLESPACE CONTAINERS
LIST TABLESPACES
LOAD
LOAD QUERY
MIGRATE DATABASE
PRECOMPILE PROGRAM
PRUNE HISTORY/LOGFILE
QUERY CLIENT
QUIESCE TABLESPACES FOR TABLE
QUIT
REBIND
RECONCILE
REDISTRIBUTE NODEGROUP
REFRESH LDAP
REGISTER
REORGANIZE TABLE
REORGCHK
RESET ADMIN CONFIGURATION
RESET DATABASE CONFIGURATION
RESET DATABASE MANAGER CONFIGURATION
RESET MONITOR
RESTART DATABASE
RESTORE DATABASE
REWIND TAPE
ROLLFORWARD DATABASE
RUNSTATS
SET CLIENT
SET RUNTIME DEGREE
SET TABLESPACE CONTAINERS
SET TAPE POSITION
START DATABASE MANAGER
STOP DATABASE MANAGER
TERMINATE
UNCATALOG DATABASE
UNCATALOG DCS DATABASE
UNCATALOG LDAP DATABASE
UNCATALOG LDAP NODE
UNCATALOG NODE
UNCATALOG ODBC DATA SOURCE
UPDATE ADMIN CONFIGURATION
UPDATE CLI CONFIGURATION
UPDATE COMMAND OPTIONS
UPDATE DATABASE CONFIGURATION
UPDATE DATABASE MANAGER CONFIGURATION
UPDATE LDAP NODE
UPDATE MONITOR SWITCHES
UPDATE HISTORY FILE
Chapter 4. Using Command Line SQL Statements
Appendix A. How to Read the Syntax Diagrams
Appendix B. Naming Conventions
Appendix C. Using the DB2 Library
DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online
Appendix D. Notices
Trademarks