IBM Books

Command Reference

Cmd Ref IBM DB2 Universal Database
Command Reference

Version 5

S10J-8166-00


10J8166

Before using this information and the product it supports, be sure to read the general information under Appendix E. "Notices".

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1993, 1997. All rights reserved.
Note to U.S. government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.


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
  • db2autold - 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
  • 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
  • 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
  • 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 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 BACKUP/HISTORY
  • LIST COMMAND OPTIONS
  • LIST DATABASE DIRECTORY
  • LIST DCS APPLICATIONS
  • LIST DCS DIRECTORY
  • LIST DRDA INDOUBT TRANSACTIONS
  • 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
  • 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 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
  • About the Information Center
  • Appendix E. Notices

  • Trademarks
  • Trademarks of Other Companies
  • Appendix F. Contacting IBM

    Index


    About This Book

    This book provides information about the use of system commands and the IBM DB2 Universal Database command line processor (CLP) to execute database administrative functions.


    [ Top of Page | Next Page | Index ]

    [ DB2 List of Books | Search the DB2 Books ]