Command Reference

Index

Special Characters
A B C D E F G H I J K L M N O P Q R S T U V W

Special Characters

!, shell command (1494)

\, line continuation character (1522)

abnormal termination

restart (2028)

access path

creating new (2049)

optimizing (2044)

action

precompile/bind option (1544), (1935)

ACTIVATE DATABASE (1533)

ADD NODE (1534)

admin configuration

file (1648)

network parameter values (2099)

resetting to default (2012)

sample (1647)

adsm_mgmtclass

database configuration parameter (1664)

adsm_nodename

database configuration parameter (1665)

adsm_owner

database configuration parameter (1666)

adsm_password

database configuration parameter (1667)

agent_stack_sz

database manager configuration parameter (1739)

agentpri

database manager configuration parameter (1740)

alias

naming conventions (2140)

anyorder (1903)

app_ctl_heap_sz

database configuration parameter (1668)

APPC node

uncataloging (2089)

applheapsz

database configuration parameter (1669)

application record, PC/IXF (2189)

ASC data type descriptions (2235)

ASC file

format (2231)

sample (2234)

ASC, as an import file type (1842)

aslheapsz

database manager configuration parameter (1741)

ATTACH (1535)

Audit Facility Administrator Tool (1396)

audit_buf_sz

database manager configuration parameter (1742)

authentication

database manager configuration parameter (1743)

authentication ID

naming conventions (2152)

authorities

granting when creating a database (1614)

authority level

direct, defined (1653)

for creating databases, granting (1616)

indirect, defined (1654)

report (1652)

Autoloader (1397)

autorestart

database configuration parameter (1670)

avg_appls

database configuration parameter (1671)

backbufsz

database manager configuration parameter (1744)

BACKUP DATABASE (1537)

backup_pending

database configuration parameter (1672)

Benchmark Tool (1399)

binarynumerics (1917)

BIND (1543)

to create new access path (2050)

Bind File Description Tool (1401)

bindfile

precompile option (1936)

binding

defaults (1576)

errors during (1613)

implicitly created schema (1577), (1982)

blocking

precompile/bind option (1545), (1937)

buffpage

database configuration parameter (1673)

case sensitivity (1524)

in naming conventions (2134)

CATALOG APPC NODE (1579)

CATALOG APPCLU NODE (1580)

CATALOG APPN NODE (1581)

CATALOG DATABASE (1582)

CATALOG DCS DATABASE (1586)

CATALOG GLOBAL DATABASE (1591)

CATALOG IPX/SPX NODE (1592)

CATALOG LOCAL NODE (1593)

CATALOG NAMED PIPE NODE (1594)

CATALOG NETBIOS NODE (1595)

CATALOG ODBC DATA SOURCE (1596)

CATALOG TCP/IP NODE (1597)

catalogcache_sz

database configuration parameter (1674)

cataloging

database (1584)

host database (1587)

CCSIDG

precompile/bind option (1546), (1938)

CCSIDM

precompile/bind option (1547), (1939)

CCSIDS

precompile/bind option (1548), (1940)

CHANGE DATABASE COMMENT (1600)

CHANGE ISOLATION LEVEL (1604)

character string delimiter (2163)

characters, special

permitted in CLP commands (1525)

chardel (1638), (1862), (1923)

charsub

precompile/bind option (1549), (1941)

chngpgs_thresh

database configuration parameter (1675)

CLI configuration

sample (1659)

CLOSE statement

executing through the CLP (2118)

cnulreqd

precompile/bind option (1550), (1942)

codepage (1913)

database configuration parameter (1676)

codeset

database configuration parameter (1677)

coldel (1639), (1863), (1924)

collection

precompile/bind option (1551), (1943)

column

naming conventions (2147)

column descriptor record, PC/IXF (2183)

column values, invalid (2207)

columns, incompatible (2205)

command line processor

accessing databases through (1486)

accessing help (1496)

batch mode (1489)

command mode (1488)

description (1484)

interactive input mode (1487)

invoking (1485)

quitting (1491), (1990)

shell command (1493)

terminating (1492), (2069)

using (1514)

command syntax

interpreting (2129)

compound (1850)

configuration, admin

resetting to default (2013)

sample (1646)

configuration, CLI

sample (1658)

configuration, database

resetting to default (2018)

sample (1662)

updating (2105)

configuration, database manager

sample (1737)

conn_elapse

database manager configuration parameter (1745)

connect

precompile option (1944)

CONNECT statement

database connection (1519)

executing through the CLP (2119)

consistency

required for backup (1542)

continuation character, line

in command line processor (1521)

Control Center (1405)

conventions, naming

for aliases (2138)

for authentication IDs (2151)

for columns (2144)

for database manager objects (2132)

for databases (2137)

for tables (2145)

for views (2146)

in SNA (2133)

copyprotect

database configuration parameter (1678)

country

database configuration parameter (1679)

cpuspeed

database manager configuration parameter (1746)

CREATE DATABASE (1611)

Create Instance (1433)

Create Sample Database (1457)

cursor stability (CS)

changing (1605)

Data Declustering Tool (1461)

data fragmentation

eliminating, by table reorganization (2001)

data integrity

maintaining, with isolation levels (1610)

data record, PC/IXF (2186)

data skew, redistributing data in nodegroup (1995)

data type descriptions

ASC (2236)

DEL (2166)

PC/IXF (2199)

data types

PC/IXF (2193)

database

cataloging (1583)

changing comments in directory (1601)

checking authorizations (1650)

connection, overview of (1516)

deleting, ensuring recovery with log files (1623)

exporting table to a file (1629)

home directory entry, definition of (1886)

implicit connection (1517)

importing file to table (1839)

indirect directory entry, definition of (1885)

information (1836)

migrating, command for (1933)

monitor, resetting (2025)

naming conventions (2139)

recovering (2039)

remote directory entry, definition of (1884)

removing (1622)

removing entries (uncataloging) (2077)

removing host DCS entries (2084)

reorganizing (2005)

restarting (2030)

restoring (rebuilding) (2032)

roll-forward recovery of (2040)

statistics (2046)

database access

starting database manager (1515)

database backup

history file (1984)

database configuration

network parameter values (2106)

resetting to default (2017)

sample (1663)

updating (2104)

Database Connection Services (DCS) directory

uncataloging entries (2082)

database directories

changing comments (1602)

definition of (1883)

sample content of (1882)

database manager

accessing from command prompt (1390)

instances of (1827)

monitor switches, checking (1824), (1830)

starting (2058)

statistics (1834)

stopping (2066)

system commands (1389)

database manager configuration

file (1821)

network parameter values (2109)

sample (1738)

database monitor

description (2112)

Database Pre-migration Tool (1408)

Database System Monitor

database system monitor

GET DATABASE MANAGER MONITOR SWITCHES (1825)

GET MONITOR SWITCHES (1831)

GET SNAPSHOT (1835)

RESET MONITOR (2026)

UPDATE MONITOR SWITCHES (2113)

database_consistent

database configuration parameter (1680)

database_level

database configuration parameter (1681)

datesiso (1640), (1864), (1925)

datetime

precompile/bind option (1552), (1945)

db2

CMD description (1490)

command syntax (1495)

DB2 Administration Server (1392)

DB2 Connect

supported connections to other systems (1589)

DB2 Governor (1429)

DB2 Governor Log Query (1431)

DB2 Interactive CLI (1410)

DB2 library

books (2240)

Information Center (2249)

language identifier for books (2241)

late breaking information (2242)

online help (2239)

ordering printed books (2248)

printing PostScript books (2247)

searching online books (2246)

setting up document server (2244)

SmartGuides (2238)

structure of (2237)

viewing online books (2243)

DB2 Profile Registry Command (1459)

DB2 SQL Explain Tool (1425)

DB2 SQLJ Profile Customizer (1451)

DB2 SQLJ Profile Printer (1453)

DB2 Statistics Extraction Tool (1445)

db2admin (1393)

db2adutl (1395)

db2atld (1398)

db2batch (1400)

db2bfd (1402)

db2cc (1404)

db2cidmg (1407)

db2ckmig (1409)

db2cli (1411)

db2cmd (1413)

db2drdat (1415)

db2empfa (1418)

db2eva (1420)

db2evmon (1422)

db2exfmt (1424)

db2expln (1426)

db2flsn (1428)

db2gov (1430)

db2govlg (1432)

db2icrt (1434)

db2idrop (1436)

db2ilist (1438)

db2imigr (1440)

db2ipxad (1442)

db2iupdt (1444)

db2look (1446)

db2migdr (1448)

db2mscs (1450)

DB2OPTIONS

environment variable (1499)

db2profc (1452)

db2profp (1454)

db2rbind (1456)

db2sampl (1458)

db2set (1460)

db2split (1462)

db2sql92 (1464)

db2start (1466), (2057)

db2stop (1468), (2065)

db2tbst (1470)

db2trc (1472)

db2uiddl (1477)

db2untag (1479)

db2upd52 (1481)

db2vexp (1483)

dbheap

database configuration parameter (1682)

DEACTIVATE DATABASE (1617)

dec

precompile/bind option (1553), (1946)

decdel

precompile/bind option (1554), (1947)

DECLARE CURSOR statement

executing through the CLP (2120)

decplusblank (1641), (1865), (1926)

decpt (1642), (1866), (1927)

default

admin configuration, resetting to (2014)

database configuration, resetting to (2019)

defer_import (1868)

deferred_prepare

precompile option (1948)

degree

precompile/bind option (1555), (1949)

DEL data type descriptions (2165)

DEL file

format (2159)

sample (2162)

delimited ASCII (DEL) file format (2157)

delimiter

character string (2164)

DEREGISTER (1618)

DESCRIBE (1619)

DETACH (1620)

device, tape (1539)

dft_account_str

database manager configuration parameter (1747)

dft_client_adpt

database manager configuration parameter (1748)

dft_client_comm

database manager configuration parameter (1749)

dft_degree

database configuration parameter (1683)

dft_extent_sz

database configuration parameter (1684)

dft_loadrec_ses

database configuration parameter (1685)

dft_mon_bufpool

database manager configuration parameter (1750)

dft_mon_lock

database manager configuration parameter (1751)

dft_mon_sort

database manager configuration parameter (1752)

dft_mon_stmt

database manager configuration parameter (1753)

dft_mon_table

database manager configuration parameter (1754)

dft_mon_uow

database manager configuration parameter (1755)

dft_prefetch_sz

database configuration parameter (1686)

dft_queryopt

database configuration parameter (1687)

dftdbpath

database manager configuration parameter (1756)

diaglevel

database manager configuration parameter (1757)

diagpath

database manager configuration parameter (1758)

differences between PC/IXF and System/370 IXF (2225)

dir_cache

database manager configuration parameter (1759)

dir_obj_name

database configuration parameter (1688)

database manager configuration parameter (1760)

dir_path_name

database manager configuration parameter (1761)

dir_type

database manager configuration parameter (1762)

directories

Database Connection Services (DCS), uncataloging entries (2083)

database, changing comments (1603)

deleting entries (2088)

node, removing entries from (2096)

system database, removing (2080)

uncataloging (2076)

disconnect

precompile option (1950)

disconnecting

command line processor front-end and back-end processes (2072)

discover

database manager configuration parameter (1763)

discover_comm

database manager configuration parameter (1764)

discover_db

database configuration parameter (1689)

discover_inst

database manager configuration parameter (1765)

dl_expint

database configuration parameter (1690)

dl_num_backup

database configuration parameter (1691)

dl_num_copies

database configuration parameter (1692)

dl_time_drop

database configuration parameter (1693)

dlchktime

database configuration parameter (1694)

dldel (1636), (1851), (1904)

dos_rqrioblk

database manager configuration parameter (1766)

DRDA Trace (1414)

drda_heap_sz

database manager configuration parameter (1767)

DROP DATABASE (1621)

DROP NODE VERIFY (1625)

dumpfile (1914)

dumping a trace to file (1473)

Dynamic Visual Explain (1482)

dynamicrules

precompile/bind option (1556), (1951)

ECHO (1626)

Enable Multi-page File Allocation (1417)

environment variables

auto-commit option (-c) (1502)

DB2OPTIONS (1500)

display DB2 interactive prompt option (-p) (1507)

display output option (-o) (1506)

display SQLCODE/SQLSTATE option (-e) (1503)

log commands in history file option (-l) (1505)

read from input file option (-f) (1504)

save all output to file option (-z) (1513)

save to report file option (-r) (1508)

show SQLCA data option (-a) (1501)

show warning messages option (-w) (1512)

statement termination character option (-t) (1510)

stop execution on command error option (-s) (1509)

verbose output option (-v) (1511)

error messages

database configuration file (1735)

dropping remote database (1624)

during backup (1541)

during binding (1578)

invalid checksum, database configuration file (2021), (2107)

invalid checksum, database manager configuration file (2015), (2023), (2100), (2110)

estore_seg_sz

database configuration parameter (1695)

Event Analyzer (1419)

Event Monitor Productivity Tool (1421)

example

forcein (2219)

explain

bind option (1557), (1952)

Explain Table Format Tool (1423)

explsnap

precompile/bind option (1558), (1953)

EXPORT (1627)

export utility file formats (2154)

exporting (1628)

choosing file formats for (1634)

database table to a file (1631)

to PC/IXF format (1635)

fastparse (1905)

fcm_num_anchors

database manager configuration parameter (1768)

fcm_num_connect

database manager configuration parameter (1770)

fcm_num_rqb

database manager configuration parameter (1771)

fcm_num;buffers

database manager configuration parameter (1769)

FETCH statement

executing through the CLP (2121)

file format

delimited ASCII (DEL) (2158)

non-delimited ASCII (ASC) (2230)

PC version of IXF (PC/IXF) (2168)

file formats

for exporting table to file (1632)

for importing file to table (1843)

fileserver

database manager configuration parameter (1772)

Find Log Sequence Number (1427)

FORCE APPLICATION (1644)

forcein (1869), (1929)

code page semantics (2216)

data type semantics (2220)

example (2218)

general semantics (2214)

option (2212)

summary of PC/IXF file import with (2222)

funcpath

precompile/bind option (1559), (1954)

generic

precompile/bind option (1560), (1956)

GET ADMIN CONFIGURATION (1645)

GET AUTHORIZATIONS (1649)

GET CLI CONFIGURATION (1657)

GET CONNECTION STATE (1660)

GET DATABASE CONFIGURATION (1661)

GET DATABASE MANAGER CONFIGURATION (1736)

GET DATABASE MANAGER MONITOR SWITCHES (1822)

GET INSTANCE (1826)

Get IPX/SPX Internetwork Address (1441)

GET MONITOR SWITCHES (1828)

GET SNAPSHOT (1832)

effect on UPDATE MONITOR SWITCHES (2114)

Get Tablespace State (1469)

grant

bind option (1561)

grant_group

bind option (1562)

grant_user

bind option (1563)

header record, PC/IXF (2177)

HELP (1837)

host systems

cataloging databases located on (1588)

connections supported by DB2 Connect (1590)

removing DCS catalog entries (2085)

host variables

not supported in command line processor (1530)

implicit connection

database access (1518)

implieddecimal (1856), (1915)

IMPORT (1838)

import

of PC/IXF files, with forcein (2224)

import of PC/IXF files

data type-specific rules (2211)

general rules (2202)

import utility file formats (2155)

importing

choosing file formats for (1847)

database access through DB2 Connect (1848)

DEL files (1845)

file to database table (1841)

PC/IXF file to table (1844)

PC/IXF, multiple-part files (1849)

WSF files (1846)

incompatible columns (2204)

index

reorganization (2007), (2010)

statistics (2045)

indexfreespace (1906)

indexixf (1870)

indexrec

database configuration parameter (1696)

database manager configuration parameter (1773)

indexschema (1871)

indexsort

database configuration parameter (1697)

indicator

record length (2174)

indoubt transaction field, description (1892)

INITIALIZE TAPE (1873)

insert

precompile/bind option (1564), (1955)

Integration Exchange Format (IXF) (2170)

intra_parallel

database manager configuration parameter (1774)

invalid PC/IXF column values (2206)

invalid PC/IXF data type (2195)

INVOKE STORED PROCEDURE (1874)

ipx_socket

database manager configuration parameter (1775)

IPX/SPX node

uncataloging (2090)

isolation

precompile/bind option (1565), (1957)

java_heap_sz

database manager configuration parameter (1776)

jdk11_path

database manager configuration parameter (1777)

keepdari

database manager configuration parameter (1778)

keywords

syntax for (2127)

langlevel

precompile option (1958)

level

precompile option (1959)

line continuation character

in command line processor (1520)

LIST ACTIVE DATABASES (1878)

LIST APPLICATIONS (1879)

LIST COMMAND OPTIONS (1880)

LIST DATABASE DIRECTORY (1881)

LIST DCS APPLICATIONS (1887)

LIST DCS DIRECTORY (1888)

LIST DRDA INDOUBT TRANSACTIONS (1889)

LIST HISTORY (1890)

LIST INDOUBT TRANSACTIONS (1891)

List Instances (1437)

LIST NODE DIRECTORY (1893)

LIST NODEGROUPS (1894)

LIST NODES (1895)

LIST ODBC DATA SOURCES (1896)

LIST PACKAGES/TABLES (1897)

LIST TABLESPACE CONTAINERS (1898)

LIST TABLESPACES (1899)

LOAD (1900)

remote filenames (1902)

LOAD QUERY (1931)

load utility file formats (2156)

lobsinfile (1637), (1852), (1907)

Local Database Directory Migration (1447)

local node

uncataloging (2091)

locklist

database configuration parameter (1698)

locks

resetting maximum to default (2020)

locktimeout

database configuration parameter (1699)

log file

listing during roll forward (2042)

log_retain_status

database configuration parameter (1706)

logbufsz

database configuration parameter (1700)

logfilsiz

database configuration parameter (1701)

loghead

database configuration parameter (1702)

logpath

database configuration parameter (1703)

logprimary

database configuration parameter (1704)

logretain

database configuration parameter (1705)

logsecond

database configuration parameter (1707)

max_connretries

database manager configuration parameter (1779)

max_coordagents

database manager configuration parameter (1780)

max_idleagents (1793)

max_rt_degree

database manager configuration parameter (1781)

max_time_diff

database manager configuration parameter (1782)

maxagents

database manager configuration parameter (1783)

maxappls

database configuration parameter (1708)

maxcagents

database manager configuration parameter (1784)

maxdari

database manager configuration parameter (1785)

maxfilop

database configuration parameter (1709)

maxlocks

database configuration parameter (1710)

maxtotfilop

database manager configuration parameter (1786)

messages

accessing help text (1498)

precompile/bind option (1566), (1960)

metacharacters (1526)

MIGRATE DATABASE (1932)

Migrate Instance (1439)

min_priv_mem

database manager configuration parameter (1787)

mincommit

database configuration parameter (1711)

mon_heap_sz

database manager configuration parameter (1788)

monitoring databases (1823), (1829)

multipage_alloc

database configuration parameter (1712)

naming a binary file for output (1474)

naming conventions

for aliases (2136)

for authentication IDs (2150)

for columns (2141)

for database manager objects (2130)

for databases (2135)

for tables (2142)

for views (2143)

in SNA (2131)

NetBIOS node

uncataloging (2092)

newlogpath

database configuration parameter (1713)

nextactive

database configuration parameter (1714)

nname

database manager configuration parameter (1789)

no commit (NC)

changing (1606)

no_type_id (1853)

nochecklengths (1872), (1930)

node

directories, removing entries from (2095)

node, SOCKS (1599)

nodefaults (1854)

nodetype

database manager configuration parameter (1790)

nodoubledel (1643), (1867), (1928)

noeofchar (1857), (1916)

noheader (1908)

nolinemacro

precompile option (1961)

non-delimited ASCII (ASC) file format (2229)

norowwarnings (1909)

NULL string

use in setting blanks (1523)

nullindchar (1858), (1918)

num_estore_segs

database configuration parameter (1715)

num_freqvalues

database configuration parameter (1716)

num_initagents

database manager configuration parameter (1791)

num_iocleaners

database configuration parameter (1717)

num_ioservers

database configuration parameter (1718)

num_poolagents

database manager configuration parameter (1792)

num_quantiles

database configuration parameter (1719)

numdb

database manager configuration parameter (1794)

numsegs

database configuration parameter (1720)

objectname

database manager configuration parameter (1795)

Open DB2 Command Window (1412)

OPEN statement

executing through the CLP (2122)

optimization (1999)

option

forcein (2213)

optlevel

precompile option (1962)

output

precompile option (1963)

owner

precompile/bind option (1567), (1964)

package

force new access paths, after running statistics (2051)

precompile option (1965)

recreating (1992)

packeddecimal (1919)

pagefreespace (1910)

parameters

syntax for (2126)

password

changing through ATTACH (1536)

changing through CONNECT (2124)

PC version of IXF (PC/IXF) file format (2167)

PC/IXF

contrasted with System/370 IXF (2226)

data type descriptions (2198)

data types (2192)

invalid column values (2208)

invalid data type (2197), (2203)

record types (2172), (2175)

valid data type (2196)

PC/IXF file

format (2169)

PC/IXF file import

data type-specific rules (2210)

general rules (2201)

with forcein (2223)

PC/IXF record type

application (2190)

column descriptor (2184)

data (2187)

header (2178)

table (2181)

pckcachesz

database configuration parameter (1721)

performance, improving (2009)

by reorganizing tables (2002)

phantom quiesce (1987)

PRECOMPILE PROGRAM (1934)

Prepare Unique Index Conversion to V5 Semantics (1476)

priv_mem_thresh

database manager configuration parameter (1796)

privileges

direct, defined (1655)

granting when creating a database (1615)

indirect, defined (1656)

PRUNE HISTORY (1983)

qualifier

precompile/bind option (1568), (1966)

QUERY CLIENT (1985)

query_heap_sz

database manager configuration parameter (1797)

queryopt

precompile/bind option (1569), (1967)

quiesce

phantom (1988)

QUIESCE TABLESPACES FOR TABLE (1986)

QUIT (1989)

read stability (RS)

changing (1608)

REBIND (1991)

Rebind all Packages (1455)

rec_his_retentn

database configuration parameter (1722)

reclen (1859), (1920)

RECONCILE (1993)

record length indicator (2173)

record type, PC/IXF

application (2191)

column descriptor (2185)

data (2188)

header (2179)

table (2182)

record types

PC/IXF (2171), (2176)

recovering a database (2034)

recovery

with roll forward (2041)

without roll forward (2035), (2036)

redirecting output (1529)

REDISTRIBUTE NODEGROUP (1994)

release

database configuration parameter (1724)

database manager configuration parameter (1798)

precompile/bind option (1570), (1968)

Release Container Tag (1478)

Remote Database Migration (1406)

remote filenames

LOAD (1901)

remote server

invoking stored procedure on (1876)

Remove Instance (1435)

REORGANIZE TABLE (1997)

REORGCHK (2003)

repeatable read (RR)

changing (1607)

RESET ADMIN CONFIGURATION (2011)

RESET DATABASE CONFIGURATION (2016)

RESET DATABASE MANAGER CONFIGURATION (2022)

RESET MONITOR (2024)

RESTART DATABASE (2027)

restbufsz

database manager configuration parameter (1799)

RESTORE DATABASE (2031)

restore_pending

database configuration parameter (1723)

restoring earlier versions of DB2 databases (2033)

resync_interval

database manager configuration parameter (1800)

REWIND TAPE (2037)

roll forward

enabling, when backing up (1540)

ROLLFORWARD DATABASE (2038)

rollfwd_pending

database configuration parameter (1725)

route_obj_name

database manager configuration parameter (1801)

rqrioblk

database manager configuration parameter (1802)

rules governing PC/IXF file import (2200), (2209)

RUNSTATS (2043)

sample ASC file (2233)

sample DEL file (2161)

schema

created when creating a database (1612)

SELECT statement

executing through the CLP (2123)

in EXPORT command (1633)

resolving ambiguous symbols in WHERE clause (1528)

semantics

forcein, code page (2217)

forcein, data type (2221)

forcein, general (2215)

seqdetect

database configuration parameter (1726)

SET CLIENT (2052)

SET RUNTIME DEGREE (2053)

SET TABLESPACE CONTAINERS (2054)

SET TAPE POSITION (2055)

Set up Windows NT Failover Utility (1449)

setting up document server (2245)

sheapthresh

database manager configuration parameter (1803)

SIGALRM signal (2060)

starting the database manager (2061)

SIGALRM signal, starting the database manager (2063)

SIGINT signal, starting database manager (2059)

SIGINT signal, starting the database manager (2062)

SOCKS node (1598)

softmax

database configuration parameter (1727)

sortheap

database configuration parameter (1728)

spm_log_file_sz

database manager configuration parameter (1805)

spm_log_path

database manager configuration parameter (1806)

spm_max_resync

database manager configuration parameter (1807)

spm_name

database manager configuration parameter (1804)

SQL NULL value

command line processor representation (1532)

SQL statements

accessing help (1497)

executing through the command line processor (CLP) (2117)

SQL92 Compliant SQL Statement Processor (1463)

sqlca

precompile option (1969)

SQLDA structure

calling server procedures that use, restrictions on (1877)

sqlerror

precompile/bind option (1571), (1970)

sqlflag

precompile option (1971)

sqlrules

precompile option (1972)

sqlstmtsz

database manager configuration parameter (1808)

sqlwarn

precompile/bind option (1572), (1973)

ss_logon

database manager configuration parameter (1809)

Start Control Center (1403)

START DATABASE MANAGER (2056)

Start DB2 (1465)

start_stop_time

database manager configuration parameter (1810)

starting a trace (1475)

stat_heap_sz

database configuration parameter (1729)

statistics

database (2047)

database manager (1833)

reorganizing indexes (2008)

REORGCHK (2004)

stmtheap

database configuration parameter (1730)

STOP DATABASE MANAGER (2064)

Stop DB2 (1467)

storage

physical (1998)

stored procedure

invoking (1875)

strdel

precompile/bind option (1573), (1974)

striptblanks (1860), (1921)

striptnulls (1861), (1922)

structure

delimited ASCII (DEL) file (2160)

non-delimited ASCII (ASC) file (2232)

svcename

database manager configuration parameter (1811)

syncpoint

precompile option (1975)

syntax

for command line processor SQL statements (2116)

for host variables not supported in command line processor (1531)

precompile option (1976)

syntax diagrams (2125)

sysadm_group

database manager configuration parameter (1812)

sysctrl_group

database manager configuration parameter (1813)

sysmaint_group

database manager configuration parameter (1814)

system commands (1391)

system database directory

uncataloging (2074)

System/370 IXF (2228)

contrasted with PC/IXF (2227)

table

exporting to a file (1630)

importing file to (1840)

naming conventions (2148)

reorganization, determining if required (2006)

statistics (2048)

table record, PC/IXF (2180)

table reorganization

command for (2000)

tape device (1538)

target

precompile option (1977)

TCP/IP node

uncataloging (2093)

TERMINATE (2068)

cautions on use of (2071)

termination (2070)

abnormal (2029)

normal (2067)

territory

database configuration parameter (1731)

text

precompile/bind option (1574), (1978)

tm_database

database manager configuration parameter (1815)

totalfreespace (1911)

tp_mon_name

database manager configuration parameter (1816)

tpname

database manager configuration parameter (1817)

Trace (1471)

tracefile (1416)

trust_allclnts

database manager configuration parameter (1818)

trust_clntauth

database manager configuration parameter (1819)

udf_mem_sz

database manager configuration parameter (1820)

UNCATALOG DATABASE (2073)

UNCATALOG DCS DATABASE (2081)

UNCATALOG NODE (2087)

UNCATALOG ODBC DATA SOURCE (2097)

uncataloging

database entries (2079)

host DCS database entries (2086)

system database directory (2075)

uncommitted read (UR)

changing (1609)

UPDATE ADMIN CONFIGURATION (2098)

Update Catalog to Support Version 5.2 (1480)

UPDATE CLI CONFIGURATION (2101)

UPDATE COMMAND OPTIONS (2102)

UPDATE DATABASE CONFIGURATION (2103)

UPDATE DATABASE MANAGER CONFIGURATION (2108)

Update Instances (1443)

UPDATE MONITOR SWITCHES (2111)

UPDATE RECOVERY HISTORY FILE (2115)

usedefaults (1855), (1912)

user

authorization (1651)

user_exit_status

database configuration parameter (1733)

userexit

database configuration parameter (1732)

util_heap_sz

database configuration parameter (1734)

utility file formats (2153)

valid PC/IXF data type (2194)

validate

precompile/bind option (1575), (1979)

variables

syntax for (2128)

version

precompile option (1980)

view

naming conventions (2149)

wchartype

precompile option (1981)

WHERE clause

resolving ambiguous symbols in SELECT statement (1527)

Work with ADSM Archived Images (1394)

workstation, remote

cataloging databases (1585)

removing catalog entries for databases from (2078)

uncataloging from local workstation (2094)

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

[ DB2 List of Books | Search the DB2 Books ]