Contents
About This Book ..........vii
Who Should Use this Book .......vii
How this Book is Structured ......vii
Chapter 1. System Commands .....1
How the Command Descriptions are
Organized .............2
db2admin - DB2 Administration Server . . . 3
db2adutl - Work with TSM Archived Images . 5
db2advis - DB2 Index Advisor ......9
db2audit - Audit Facility Administrator Tool 12
db2atld - Autoloader .........13
db2batch - Benchmark Tool .......14
db2bfd - Bind File Description Tool ....20
db2cc - Start Control Center.......21
db2cdbcr - Create Control Database for Data
Warehouse ............23
db2cfexp - Connectivity Configuration Export
Tool...............24
db2cfimp - Connectivity Configuration Import
Tool...............26
db2cidmg - Remote Database Migration. . . 27
db2ckbkp - Check Backup .......28
db2ckmig - Database Pre-migration Tool . . 31
db2cli - DB2 Interactive CLI.......32
db2cmd - Open DB2 Command Window . . 33
db2dclgn - Declaration Generator .....35
db2drdat - DRDA Trace ........38
db2empfa - Enable Multi-page File Allocation 40
db2eva - Event Analyzer ........41
db2evmon - Event Monitor Productivity Tool 43
db2exfmt - Explain Table Format Tool . . . 44
db2expln - DB2 SQL Explain Tool .....45
db2flsn - Find Log Sequence Number . . . 46
db2fs - First Steps ..........48
db2gov - DB2 Governor ........49
db2govlg - DB2 Governor Log Query . . . 51
db2icrt-CreateInstance........52
db2idrop - Remove Instance ......55
db2ilist - List Instances ........56
db2imigr - Migrate Instance.......57
db2ipxad - Get IPX/SPX Internetwork
Address .............58
db2iupdt - Update Instances ......59
db2ldcfg - Configure LDAP Environment . . 61
db2licm - License Management Tool ....62
db2look - DB2 Statistics and DDL Extraction
Tool...............64
db2move - Database Movement Tool ....69
db2mscs - Set up Windows NT Failover
Utility ..............74
db2nchg - Change Database Partition Server
Configuration...........75
db2ncrt - Add Database Partition Server to an
Instance.............77
db2ndrop - Drop Database Partition Server
fromanInstance..........80
db2perfc - Reset Database Performance Values 82
db2perfi - Performance Counters Registration
Utility ..............83
db2perfr - Performance Monitor Registration
Tool...............84
db2profc - DB2 SQLJ Profile Customizer . . 85
db2profp - DB2 SQLJ Profile Printer ....87
db2rbind - Rebind all Packages .....88
db2sampl - Create Sample Database ....90
db2set - DB2 Profile Registry Command . . 92
db2sql92 - SQL92 Compliant SQL Statement
Processor .............95
db2start-StartDB2.........98
db2stop-StopDB2 .........99
db2sync - Start DB2 Synchronizer ....100
db2tbst - Get Tablespace State......101
db2trc - Trace ...........102
db2uiddl - Prepare Unique Index Conversion
to V5 Semantics ..........105
db2untag - Release Container Tag ....107
Chapter 2. Command Line Processor
(CLP) .............109
Command Line Processor Invocation . . . 110
Command Line Processor Options ....112
Command Line Processor Return Codes . . 119
Using the Command Line Processor . . . 120
Using the Command Line Processor in
Command Files .........121
Command Line Processor Design . . . 121
CLPUsageNotes.........124
Chapter 3. CLP Commands ......127
© Copyright IBM Corp. 1993, 2000 iii
