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 (1453)

\, line continuation character (1481)

abnormal termination

restart (2019)

access path

creating new (2040)

optimizing (2035)

action

precompile/bind option (1504), (1924)

ACTIVATE DATABASE (1492)

ADD DATALINKS MANAGER (1493)

ADD NODE (1494)

admin configuration

file (1609)

network parameter values (2092)

resetting to default (2003)

sample (1608)

Administering Satellites Guide and Reference (2153)

Administration Guide (2133)

Administrative API Reference (2134)

adsm_mgmtclass

database configuration parameter (1625)

adsm_nodename

database configuration parameter (1626)

adsm_owner

database configuration parameter (1627)

adsm_password

database configuration parameter (1628)

agentpri

database manager configuration parameter (1702)

agent_stack_sz

database manager configuration parameter (1701)

anyorder (1889)

APPC node

uncataloging (2082)

APPC, CPI-C and SNA Sense Codes (2136)

applheapsz

database configuration parameter (1630)

Application Building Guide (2135)

Application Development Guide (2137)

app_ctl_heap_sz

database configuration parameter (1629)

ASC, as an import file type (1811)

aslheapsz

database manager configuration parameter (1703)

ATTACH (1495)

Audit Facility Administrator Tool (1339)

audit_buf_sz

database manager configuration parameter (1704)

authentication

database manager configuration parameter (1705)

authorities and privileges

granted when creating a database (1575)

authority level

direct, defined (1614)

for creating databases, granting (1577)

indirect, defined (1615)

report (1613)

Autoloader (1340)

autorestart

database configuration parameter (1631)

avg_appls

database configuration parameter (1632)

backbufsz

database manager configuration parameter (1706)

BACKUP DATABASE (1497)

backup_pending

database configuration parameter (1633)

Benchmark Tool (1342)

binarynumerics (1902)

BIND (1503)

to create new access path (2041)

Bind File Description Tool (1344)

bindfile

precompile option (1925)

binding

errors during (1574)

implicitly created schema (1536), (1972)

blocking

precompile/bind option (1505), (1926)

buffpage

database configuration parameter (1634)

CALL statement

executing through the CLP (2112), (2119)

case sensitivity (1483)

in naming conventions (2128)

CATALOG APPC NODE (1537)

CATALOG APPCLU NODE (1538)

CATALOG APPN NODE (1539)

CATALOG DATABASE (1540)

CATALOG DCS DATABASE (1544)

CATALOG GLOBAL DATABASE (1549)

CATALOG IPX/SPX NODE (1550)

CATALOG LDAP DATABASE (1551)

CATALOG LDAP NODE (1552)

CATALOG LOCAL NODE (1553)

CATALOG NAMED PIPE NODE (1554)

CATALOG NETBIOS NODE (1555)

CATALOG ODBC DATA SOURCE (1556)

CATALOG TCP/IP NODE (1557)

catalogcache_sz

database configuration parameter (1635)

cataloging

database (1542)

host database (1545)

catalog_noauth

database manager configuration parameter (1707)

CCSIDG

precompile/bind option (1506), (1927)

CCSIDM

precompile/bind option (1507), (1928)

CCSIDS

precompile/bind option (1508), (1929)

CHANGE DATABASE COMMENT (1560)

CHANGE ISOLATION LEVEL (1564)

characters, special

permitted in CLP commands (1484)

chardel (1598), (1838), (1909)

charsub

precompile/bind option (1509), (1930)

chngpgs_thresh

database configuration parameter (1636)

CLI configuration

sample (1620)

CLI Guide and Reference (2138)

CLOSE statement

executing through the CLP (2113)

cnulreqd

precompile/bind option (1510), (1931)

codepage (1898)

database configuration parameter (1637)

codeset

database configuration parameter (1638)

coldel (1599), (1839), (1910)

collection

precompile/bind option (1511), (1932)

command line processor

accessing databases through (1445)

accessing help (1455)

batch mode (1448)

command mode (1447)

description (1443)

interactive input mode (1446)

invoking (1444)

quitting (1450), (1980)

shell command (1452)

terminating (1451), (2060)

using (1473)

Command Reference (2139)

command syntax

interpreting (2125)

comm_bandwidth

database manager configuration parameter (1708)

compound (1826)

configuration, admin

resetting to default (2004)

sample (1607)

configuration, CLI

sample (1619)

configuration, database

resetting to default (2009)

sample (1623)

updating (2098)

configuration, database manager

sample (1699)

connect

precompile option (1933)

CONNECT statement

database connection (1478)

executing through the CLP (2114)

Connectivity Configuration Export Tool (1349)

Connectivity Configuration Import Tool (1351)

Connectivity Supplement (2143)

conn_elapse

database manager configuration parameter (1709)

consistency

required for backup (1502)

continuation character, line

in command line processor (1480)

Control Center (1348)

conventions, naming

for database manager objects (2127)

copyprotect

database configuration parameter (1639)

country

database configuration parameter (1640)

cpuspeed

database manager configuration parameter (1710)

CREATE DATABASE (1572)

Create Instance (1382)

Create Sample Database (1416)

cursor stability (CS)

changing (1566)

data fragmentation

eliminating, by table reorganization (1992)

data integrity

maintaining, with isolation levels (1571)

Data Movement Utilities Guide and Reference (2140)

data skew, redistributing data in nodegroup (1985)

database

cataloging (1541)

changing comments in directory (1561)

checking authorizations (1611)

connection, overview of (1475)

deleting, ensuring recovery with log files (1584)

exporting table to a file (1589)

home directory entry, definition of (1863)

implicit connection (1476)

importing file to table (1807)

indirect directory entry, definition of (1862)

information (1804)

loading file to table (1881)

migrating, command for (1921)

monitor, resetting (2016)

recovering (2030)

remote directory entry, definition of (1861)

removing (1583)

removing entries (uncataloging) (2068)

removing host DCS entries (2075)

reorganizing (1996)

restarting (2021)

restoring (rebuilding) (2023)

roll-forward recovery of (2031)

statistics (2037)

database access

starting database manager (1474)

database backup

history file (1974)

database configuration

network parameter values (2099)

resetting to default (2008)

sample (1624)

updating (2097)

Database Connection Services (DCS) directory

uncataloging entries (2073)

database directories

changing comments (1562)

definition of (1860)

sample content of (1859)

database manager

accessing from command prompt (1331)

instances of (1795)

monitor switches, checking (1792), (1798)

starting (2049)

statistics (1802)

stopping (2057)

system commands (1330)

database manager configuration

file (1789)

network parameter values (2102)

sample (1700)

database monitor

description (2106)

Database Movement Tool (1400)

Database Pre-migration Tool (1355)

Database System Monitor

database system monitor

GET DATABASE MANAGER MONITOR SWITCHES (1793)

GET MONITOR SWITCHES (1799)

GET SNAPSHOT (1803)

RESET MONITOR (2017)

UPDATE MONITOR SWITCHES (2107)

database_consistent

database configuration parameter (1641)

database_level

database configuration parameter (1642)

datalinks

database manager configuration parameter (1711)

datesiso (1600), (1840), (1911)

datetime

precompile/bind option (1512), (1934)

db2

CMD description (1449)

command syntax (1454)

DB2 Administration Server (1333)

DB2 Connect

supported connections to other systems (1547)

DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings (2160)

DB2 Connect Enterprise Edition for UNIX Quick Beginnings (2161)

DB2 Connect Personal Edition Quick Beginnings (2141)

DB2 Connect User's Guide (2142)

DB2 Data Links Manager for AIX Quick Beginnings (2162)

DB2 Data Links Manager for Windows NT Quick Beginnings (2163)

DB2 Enterprise - Extended Edition for UNIX Quick Beginnings (2158)

DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings (2159)

DB2 Governor (1378)

DB2 Governor Log Query (1380)

DB2 Index Advisor (1337)

DB2 Interactive CLI (1357)

DB2 library

books (2132)

Information Center (2170)

language identifier for books (2167)

late-breaking information (2168)

online help (2131)

ordering printed books (2175)

printing PostScript books (2174)

searching online information (2173)

setting up document server (2171)

SmartGuides (2130)

structure of (2129)

viewing online information (2169)

DB2 Personal Edition Quick Beginnings (2154)

DB2 Profile Registry Command (1418)

DB2 Query Patroller Administration Guide (2164)

DB2 Query Patroller Installation Guide (2165)

DB2 Query Patroller User's Guide (2166)

DB2 Set Synchronization Session (1420)

DB2 SQL Explain Tool (1374)

DB2 SQLJ Profile Customizer (1410)

DB2 SQLJ Profile Printer (1412)

DB2 Statistics Extraction Tool (1396)

use when importing PC/IXF files (1817)

db2admin (1334)

db2adutl (1336)

db2advis (1338)

db2atld (1341)

db2batch (1343)

db2bfd (1345)

db2cc (1347)

db2cfexp (1350)

db2cfimp (1352)

db2cidmg (1354)

db2ckmig (1356)

db2cli (1358)

db2cmd (1360)

db2dclgn (1362)

db2drdat (1364)

db2empfa (1367)

db2eva (1369)

db2evmon (1371)

db2exfmt (1373)

db2expln (1375)

db2flsn (1377)

db2gov (1379)

db2govlg (1381)

db2icrt (1383)

db2idrop (1385)

db2ilist (1387)

db2imigr (1389)

db2ipxad (1391)

db2iupdt (1393)

db2licm (1395)

db2look (1397)

db2migdr (1399)

db2move (1401)

db2mscs (1403)

DB2OPTIONS

environment variable (1458)

db2perfc (1405)

db2perfi (1407)

db2perfr (1409)

db2profc (1411)

db2profp (1413)

db2rbind (1415)

db2sampl (1417)

db2set (1419)

db2setss (1421)

db2sql92 (1423)

db2start (1425), (2048)

db2stop (1427), (2056)

db2sync (1429)

db2tbst (1431)

db2trc (1433)

db2uiddl (1438)

db2untag (1440)

db2vexp (1442)

dbheap

database configuration parameter (1643)

DEACTIVATE DATABASE (1578)

dec

precompile/bind option (1513), (1935)

decdel

precompile/bind option (1514), (1936)

Declaration Generator (1361)

DECLARE CURSOR statement

executing through the CLP (2115)

decplusblank (1601), (1841), (1912)

decpt (1602), (1842), (1913)

default

admin configuration, resetting to (2005)

database configuration, resetting to (2010)

deferred_prepare

precompile option (1937)

degree

precompile/bind option (1515), (1938)

delprioritychar (1843), (1914)

DEREGISTER (1579)

DESCRIBE (1580)

DETACH (1581)

device, tape (1499)

dftdbpath

database manager configuration parameter (1721)

dft_account_str

database manager configuration parameter (1712)

dft_client_adpt

database manager configuration parameter (1713)

dft_client_comm

database manager configuration parameter (1714)

dft_degree

database configuration parameter (1644)

dft_extent_sz

database configuration parameter (1645)

dft_loadrec_ses

database configuration parameter (1646)

dft_mon_bufpool

database manager configuration parameter (1715)

dft_mon_lock

database manager configuration parameter (1716)

dft_mon_sort

database manager configuration parameter (1717)

dft_mon_stmt

database manager configuration parameter (1718)

dft_mon_table

database manager configuration parameter (1719)

dft_mon_uow

database manager configuration parameter (1720)

dft_prefetch_sz

database configuration parameter (1647)

dft_queryopt

database configuration parameter (1648)

diaglevel

database manager configuration parameter (1722)

diagpath

database manager configuration parameter (1723)

directories

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

database, changing comments (1563)

deleting entries (2081)

node, removing entries from (2089)

system database, removing (2071)

uncataloging (2067)

dir_cache

database manager configuration parameter (1724)

dir_obj_name

database configuration parameter (1649)

database manager configuration parameter (1725)

dir_path_name

database manager configuration parameter (1726)

dir_type

database manager configuration parameter (1727)

disconnect

precompile option (1939)

disconnecting

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

discover

database manager configuration parameter (1728)

discover_comm

database manager configuration parameter (1729)

discover_db

database configuration parameter (1650)

discover_inst

database manager configuration parameter (1730)

dlchktime

database configuration parameter (1656)

dldel (1603), (1844), (1915)

dl_expint

database configuration parameter (1651)

dl_num_copies

database configuration parameter (1652)

dl_time_drop

database configuration parameter (1653)

dl_token

database configuration parameter (1654)

dl_upper

database configuration parameter (1655)

dos_rqrioblk

database manager configuration parameter (1731)

DRDA Trace (1363)

drda_heap_sz

database manager configuration parameter (1732)

DROP DATABASE (1582)

DROP NODE VERIFY (1586)

dumpfile (1899)

dumping a trace to file (1434)

Dynamic Visual Explain (1441)

dynamicrules

precompile/bind option (1516), (1940)

ECHO (1587)

Enable Multi-page File Allocation (1366)

environment variables

auto-commit option (-c) (1461)

DB2OPTIONS (1459)

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

display output option (-o) (1465)

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

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

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

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

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

show SQLCA data option (-a) (1460)

show warning messages option (-w) (1471)

statement termination character option (-t) (1469)

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

verbose output option (-v) (1470)

error messages

database configuration file (1697)

dropping remote database (1585)

during backup (1501)

invalid checksum, database configuration file (2012), (2100)

invalid checksum, database manager configuration file (2006), (2014), (2093), (2103)

estore_seg_sz

database configuration parameter (1657)

Event Analyzer (1368)

Event Monitor Productivity Tool (1370)

explain

bind option (1517), (1941)

Explain Table Format Tool (1372)

explsnap

precompile/bind option (1518), (1942)

EXPORT (1588)

exporting

database table to a file (1591)

file type modifiers for (1594)

fastparse (1890)

fcm_num;buffers

database manager configuration parameter (1734)

fcm_num_anchors

database manager configuration parameter (1733)

fcm_num_connect

database manager configuration parameter (1735)

fcm_num_rqb

database manager configuration parameter (1736)

federated

database manager configuration parameter (1737)

FETCH statement

executing through the CLP (2116)

file formats

for exporting table to file (1592)

for importing file to table (1812)

file type modifiers

export utility (1595)

import utility (1824)

load utility (1887)

fileserver

database manager configuration parameter (1738)

Find Log Sequence Number (1376)

FORCE APPLICATION (1605)

forcein (1846), (1917)

funcpath

precompile/bind option (1519), (1943)

generic

precompile/bind option (1520), (1945)

GET ADMIN CONFIGURATION (1606)

GET AUTHORIZATIONS (1610)

GET CLI CONFIGURATION (1618)

GET CONNECTION STATE (1621)

GET DATABASE CONFIGURATION (1622)

GET DATABASE MANAGER CONFIGURATION (1698)

GET DATABASE MANAGER MONITOR SWITCHES (1790)

GET INSTANCE (1794)

Get IPX/SPX Internetwork Address (1390)

GET MONITOR SWITCHES (1796)

GET SNAPSHOT (1800)

effect on UPDATE MONITOR SWITCHES (2108)

Get Tablespace State (1430)

Glossary (2144)

grant

bind option (1521)

grant_group

bind option (1522)

grant_user

bind option (1523)

HELP (1805)

host systems

cataloging databases located on (1546)

connections supported by DB2 Connect (1548)

removing DCS catalog entries (2076)

host variables

not supported in command line processor (1489)

implicit connection

database access (1477)

implieddecimal (1831), (1900)

IMPORT (1806)

importing

code page considerations (1816)

database access through DB2 Connect (1818)

DB2 Data Links Manager considerations (1822)

file to database table (1809)

file type modifiers for (1823)

PC/IXF file to table (1810)

PC/IXF, multiple-part files (1821)

restrictions (1820)

to a remote database (1813)

to a table or hierarchy that does not exist (1814)

to typed tables (1819)

index

reorganization (1998), (2001)

statistics (2036)

indexfreespace (1891)

indexixf (1847)

indexrec

database configuration parameter (1658)

database manager configuration parameter (1739)

indexschema (1848)

indexsort

database configuration parameter (1659)

indoubt transaction field, description (1870)

initdari_jvm

database manager configuration parameter (1740)

INITIALIZE TAPE (1850)

insert

precompile/bind option (1524), (1944)

Installation and Configuration Supplement (2145)

intra_parallel

database manager configuration parameter (1741)

INVOKE STORED PROCEDURE (1851)

IPX/SPX node

uncataloging (2083)

ipx_socket

database manager configuration parameter (1742)

isolation

CHANGE ISOLATION LEVEL command (1565)

precompile/bind option (1525), (1946)

java_heap_sz

database manager configuration parameter (1743)

jdk11_path

database manager configuration parameter (1744)

keepdari

database manager configuration parameter (1745)

keywords

syntax for (2123)

langlevel

precompile option (1947)

level

precompile option (1948)

License Management Tool (1394)

line continuation character

in command line processor (1479)

LIST ACTIVE DATABASES (1855)

LIST APPLICATIONS (1856)

LIST COMMAND OPTIONS (1857)

LIST DATABASE DIRECTORY (1858)

LIST DATALINKS MANAGERS (1867)

LIST DCS APPLICATIONS (1864)

LIST DCS DIRECTORY (1865)

LIST DRDA INDOUBT TRANSACTIONS (1866)

LIST HISTORY (1868)

LIST INDOUBT TRANSACTIONS (1869)

List Instances (1386)

LIST NODE DIRECTORY (1871)

LIST NODEGROUPS (1872)

LIST NODES (1873)

LIST ODBC DATA SOURCES (1874)

LIST PACKAGES/TABLES (1875)

LIST TABLESPACE CONTAINERS (1876)

LIST TABLESPACES (1877)

LOAD (1878)

temporary files (1885)

LOAD (sqluload) (1879)

LOAD QUERY (1919)

file to database table (1883)

file type modifiers for (1886)

lobsinfile (1597), (1827), (1892)

Local Database Directory Migration (1398)

local node

uncataloging (2084)

locklist

database configuration parameter (1660)

locks

resetting maximum to default (2011)

locktimeout

database configuration parameter (1661)

log file

listing during roll forward (2033)

logbufsz

database configuration parameter (1662)

logfilsiz

database configuration parameter (1663)

loghead

database configuration parameter (1664)

logpath

database configuration parameter (1665)

logprimary

database configuration parameter (1666)

logretain

database configuration parameter (1667)

logsecond

database configuration parameter (1669)

log_retain_status

database configuration parameter (1668)

maxagents

database manager configuration parameter (1750)

maxappls

database configuration parameter (1670)

maxcagents

database manager configuration parameter (1751)

maxdari

database manager configuration parameter (1752)

maxfilop

database configuration parameter (1671)

maxlocks

database configuration parameter (1672)

maxtotfilop

database manager configuration parameter (1753)

max_connretries

database manager configuration parameter (1746)

max_coordagents

database manager configuration parameter (1747)

max_idleagents (1762)

max_rt_degree

database manager configuration parameter (1748)

max_time_diff

database manager configuration parameter (1749)

Message Reference (2146)

messages

accessing help text (1457)

precompile/bind option (1526), (1949)

metacharacters (1485)

MIGRATE DATABASE (1920)

Migrate Instance (1388)

mincommit

database configuration parameter (1673)

min_priv_mem

database manager configuration parameter (1754)

modifiers, file type

for export utility (1596)

for import utility (1825)

for load utility (1888)

monitoring databases (1791), (1797)

mon_heap_sz

database manager configuration parameter (1755)

moving data between databases (1815)

multipage_alloc

database configuration parameter (1674)

naming a binary file for output (1435)

naming conventions

for database manager objects (2126)

NetBIOS node

uncataloging (2085)

newlogpath

database configuration parameter (1675)

nname

database manager configuration parameter (1756)

no commit (NC)

changing (1567)

nochecklengths (1833), (1849), (1903), (1918)

node

directories, removing entries from (2088)

node, SOCKS (1559)

nodefaults (1829)

nodetype

database manager configuration parameter (1757)

nodoubledel (1604), (1845), (1916)

noeofchar (1832), (1901)

noheader (1893)

nolinemacro

precompile option (1950)

norowwarnings (1894)

notifylevel

database manager configuration parameter (1758)

no_type_id (1828)

NULL string

use in setting blanks (1482)

nullindchar (1834), (1904)

numdb

database manager configuration parameter (1763)

numsegs

database configuration parameter (1682)

num_db_backups

database configuration parameter (1676)

num_estore_segs

database configuration parameter (1677)

num_freqvalues

database configuration parameter (1678)

num_initagents

database manager configuration parameter (1759)

num_initdaris

database manager configuration parameter (1760)

num_iocleaners

database configuration parameter (1679)

num_ioservers

database configuration parameter (1680)

num_poolagents

database manager configuration parameter (1761)

num_quantiles

database configuration parameter (1681)

objectname

database manager configuration parameter (1764)

Open DB2 Command Window (1359)

OPEN statement

executing through the CLP (2117)

optimization (1990)

optlevel

precompile option (1951)

output

precompile option (1952)

owner

precompile/bind option (1527), (1953)

package

force new access paths, after running statistics (2042)

precompile option (1954)

recreating (1982)

packeddecimal (1905)

pagefreespace (1895)

parameters

syntax for (2122)

password

changing through ATTACH (1496)

changing through CONNECT (2120)

pckcachesz

database configuration parameter (1683)

Performance Counters Registration Utility (1406)

Performance Monitor Registration Tool (1408)

performance, improving (2000)

by reorganizing tables (1993)

phantom quiesce (1977)

PRECOMPILE PROGRAM (1922)

PREP command (PRECOMPILE PROGRAM) (1923)

Prepare Unique Index Conversion to V5 Semantics (1437)

preprocessor

precompile option (1955)

privileges

direct, defined (1616)

indirect, defined (1617)

privileges and authorities

granted when creating a database (1576)

priv_mem_thresh

database manager configuration parameter (1765)

PRUNE HISTORY/LOGFILE (1973)

qualifier

precompile/bind option (1528), (1956)

QUERY CLIENT (1975)

queryopt

precompile/bind option (1529), (1957)

query_heap_sz

database manager configuration parameter (1766)

Quick Beginnings for OS/2 (2155)

Quick Beginnings for UNIX (2156)

Quick Beginnings for Windows NT (2157)

quiesce

phantom (1978)

QUIESCE TABLESPACES FOR TABLE (1976)

QUIT (1979)

read stability (RS)

changing (1569)

REBIND (1981)

Rebind all Packages (1414)

reclen (1835), (1906)

RECONCILE (1983)

recovering a database (2025)

recovery

with roll forward (2032)

without roll forward (2026), (2027)

rec_his_retentn

database configuration parameter (1684)

redirecting output (1488)

REDISTRIBUTE NODEGROUP (1984)

REFRESH LDAP (1986)

release

database configuration parameter (1685)

database manager configuration parameter (1767)

precompile/bind option (1530), (1958)

Release Container Tag (1439)

Remote Database Migration (1353)

remote server

invoking stored procedure on (1853)

Remove Instance (1384)

REORGANIZE TABLE (1988)

REORGCHK (1994)

repeatable read (RR)

changing (1568)

Replication Guide and Reference (2147)

RESET ADMIN CONFIGURATION (2002)

RESET DATABASE CONFIGURATION (2007)

RESET DATABASE MANAGER CONFIGURATION (2013)

Reset Database Performance Values (1404)

RESET MONITOR (2015)

RESTART DATABASE (2018)

restbufsz

database manager configuration parameter (1768)

RESTORE DATABASE (2022)

restore_pending

database configuration parameter (1686)

restoring earlier versions of DB2 databases (2024)

resync_interval

database manager configuration parameter (1769)

REWIND TAPE (2028)

roll forward

enabling, when backing up (1500)

ROLLFORWARD DATABASE (2029)

rollfwd_pending

database configuration parameter (1687)

route_obj_name

database manager configuration parameter (1770)

rqrioblk

database manager configuration parameter (1771)

RUNSTATS (2034)

schema

created when creating a database (1573)

SELECT statement

executing through the CLP (2118)

in EXPORT command (1593)

resolving ambiguous symbols in WHERE clause (1487)

seqdetect

database configuration parameter (1688)

SET CLIENT (2043)

SET RUNTIME DEGREE (2044)

SET TABLESPACE CONTAINERS (2045)

SET TAPE POSITION (2046)

Set up Windows NT Failover Utility (1402)

setting up document server (2172)

sheapthresh

database manager configuration parameter (1772)

SIGALRM signal (2051)

starting the database manager (2052)

SIGALRM signal, starting the database manager (2054)

SIGINT signal, starting database manager (2050)

SIGINT signal, starting the database manager (2053)

SOCKS node (1558)

softmax

database configuration parameter (1689)

sortheap

database configuration parameter (1690)

spm_log_file_sz

database manager configuration parameter (1774)

spm_log_path

database manager configuration parameter (1775)

spm_max_resync

database manager configuration parameter (1776)

spm_name

database manager configuration parameter (1773)

SQL Getting Started (2148)

SQL NULL value

command line processor representation (1491)

SQL Reference (2149)

SQL statements

accessing help (1456)

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

SQL92 Compliant SQL Statement Processor (1422)

sqlca

precompile option (1959)

SQLDA structure

calling server procedures that use, restrictions on (1854)

sqlerror

precompile/bind option (1531), (1960)

sqlflag

precompile option (1961)

sqlrules

precompile option (1962)

sqluload - Load (1880)

sqlwarn

precompile/bind option (1532), (1963)

ss_logon

database manager configuration parameter (1777)

Start Control Center (1346)

START DATABASE MANAGER (2047)

Start DB2 (1424)

Start DB2 Synchronizer (1428)

starting a trace (1436)

start_stop_time

database manager configuration parameter (1778)

statistics

database (2038)

database manager (1801)

reorganizing indexes (1999)

REORGCHK (1995)

stat_heap_sz

database configuration parameter (1691)

stmtheap

database configuration parameter (1692)

STOP DATABASE MANAGER (2055)

Stop DB2 (1426)

storage

physical (1989)

stored procedure

invoking (1852)

strdel

precompile/bind option (1533), (1964)

striptblanks (1836), (1907)

striptnulls (1837), (1908)

svcename

database manager configuration parameter (1779)

syncpoint

precompile option (1965)

syntax

for command line processor SQL statements (2110)

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

precompile option (1966)

syntax diagrams (2121)

sysadm_group

database manager configuration parameter (1780)

sysctrl_group

database manager configuration parameter (1781)

sysmaint_group

database manager configuration parameter (1782)

system commands (1332)

system database directory

uncataloging (2065)

System Monitor Guide and Reference (2150)

table

exporting to a file (1590)

importing file to (1808)

loading file to (1882)

reorganization, determining if required (1997)

statistics (2039)

table reorganization

command for (1991)

tape device (1498)

target

precompile option (1967)

TCP/IP node

uncataloging (2086)

temporary files

LOAD (1884)

TERMINATE (2059)

cautions on use of (2062)

termination (2061)

abnormal (2020)

normal (2058)

territory

database configuration parameter (1693)

text

precompile/bind option (1534), (1968)

tm_database

database manager configuration parameter (1783)

totalfreespace (1896)

tpname

database manager configuration parameter (1785)

tp_mon_name

database manager configuration parameter (1784)

Trace (1432)

tracefile (1365)

Troubleshooting Guide (2151)

trust_allclnts

database manager configuration parameter (1786)

trust_clntauth

database manager configuration parameter (1787)

udf_mem_sz

database manager configuration parameter (1788)

UNCATALOG DATABASE (2064)

UNCATALOG DCS DATABASE (2072)

UNCATALOG LDAP DATABASE (2078)

UNCATALOG LDAP NODE (2079)

UNCATALOG NODE (2080)

UNCATALOG ODBC DATA SOURCE (2090)

uncataloging

database entries (2070)

host DCS database entries (2077)

system database directory (2066)

uncommitted read (UR)

changing (1570)

UPDATE ADMIN CONFIGURATION (2091)

UPDATE CLI CONFIGURATION (2094)

UPDATE COMMAND OPTIONS (2095)

UPDATE DATABASE CONFIGURATION (2096)

UPDATE DATABASE MANAGER CONFIGURATION (2101)

Update Instances (1392)

UPDATE LDAP NODE (2104)

UPDATE MONITOR SWITCHES (2105)

UPDATE RECOVERY HISTORY FILE (2109)

usedefaults (1830), (1897)

user

authorization (1612)

userexit

database configuration parameter (1694)

user_exit_status

database configuration parameter (1695)

util_heap_sz

database configuration parameter (1696)

validate

precompile/bind option (1535), (1969)

variables

syntax for (2124)

version

precompile option (1970)

wchartype

precompile option (1971)

What's New (2152)

WHERE clause

resolving ambiguous symbols in SELECT statement (1486)

Work with ADSM Archived Images (1335)

workstation, remote

cataloging databases (1543)

removing catalog entries for databases from (2069)

uncataloging from local workstation (2087)

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

[ DB2 List of Books | Search the DB2 Books ]