IBM Books

Command Reference

Table of Contents

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 ADSM Archived Images
  • db2audit - Audit Facility Administrator Tool
  • db2atld - Autoloader
  • db2batch - Benchmark Tool
  • db2bfd - Bind File Description Tool
  • db2cc - Start Control Center
  • db2cidmg - Remote Database Migration
  • db2ckmig - Database Pre-migration Tool
  • db2cli - DB2 Interactive CLI
  • db2cmd - Open DB2 Command Window
  • 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
  • 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
  • db2look - DB2 Statistics Extraction Tool
  • db2migdr - Local Database Directory Migration
  • db2mscs - Set up Windows NT Failover Utility
  • db2profc - DB2 SQLJ Profile Customizer
  • db2profp - DB2 SQLJ Profile Printer
  • db2rbind - Rebind all Packages
  • db2sampl - Create Sample Database
  • db2set - DB2 Profile Registry Command
  • db2split - Data Declustering Tool
  • db2sql92 - SQL92 Compliant SQL Statement Processor
  • db2start - Start DB2
  • db2stop - Stop DB2
  • db2tbst - Get Tablespace State
  • db2trc - Trace
  • db2uiddl - Prepare Unique Index Conversion to V5 Semantics
  • db2untag - Release Container Tag
  • db2upd52 - Update Catalog to Support Version 5.2
  • db2vexp - Dynamic Visual Explain

    • Chapter 2. Command Line Processor (CLP)

  • Command Line Processor Invocation and Options
  • Using the Command Line Processor

    • Chapter 3. CLP Commands

  • DB2 CLP Commands
  • ACTIVATE DATABASE
  • ADD NODE
  • ATTACH
  • BACKUP DATABASE
  • BIND
  • CATALOG APPC NODE
  • CATALOG APPCLU NODE
  • CATALOG APPN NODE
  • CATALOG DATABASE
  • CATALOG DCS DATABASE
  • CATALOG GLOBAL DATABASE
  • CATALOG IPX/SPX 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 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
  • QUERY CLIENT
  • QUIESCE TABLESPACES FOR TABLE
  • QUIT
  • REBIND
  • RECONCILE
  • REDISTRIBUTE NODEGROUP
  • 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 NODE
  • UNCATALOG ODBC DATA SOURCE
  • UPDATE ADMIN CONFIGURATION
  • UPDATE CLI CONFIGURATION
  • UPDATE COMMAND OPTIONS
  • UPDATE DATABASE CONFIGURATION
  • UPDATE DATABASE MANAGER CONFIGURATION
  • UPDATE MONITOR SWITCHES
  • UPDATE RECOVERY HISTORY FILE

    • Chapter 4. Using Command Line SQL Statements

    Appendix A. How to Read the Syntax Diagrams

    Appendix B. Naming Conventions

    Appendix C. IMPORT/EXPORT/LOAD Utility File Formats

  • Delimited ASCII (DEL) File Format
  • Sample DEL File
  • DEL Data Type Descriptions
  • PC Version of IXF File Format
  • PC/IXF Record Types
  • PC/IXF Data Types
  • PC/IXF Data Type Descriptions
  • General Rules Governing PC/IXF File Import into Databases
  • Data Type-Specific Rules Governing PC/IXF File Import into Databases
  • FORCEIN Option
  • Differences between Version 1 PC/IXF and Version 0 System/370 IXF
  • Non-delimited ASCII (ASC) File Format
  • Sample ASC File
  • ASC Data Type Descriptions

    • Appendix D. How the DB2 Library Is Structured

  • SmartGuides
  • Online Help
  • DB2 Books
  • Viewing Online Books
  • Searching Online Books
  • Printing the PostScript Books
  • Ordering the Printed DB2 Books
  • Information Center

    • Appendix E. Notices

  • Trademarks
  • Trademarks of Other Companies

    • Appendix F. Contacting IBM

    Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]