Command Reference
This section lists ways you can get more information from
IBM.
If you have a technical problem, please take the time to review and carry
out the actions suggested by the Troubleshooting
Guide before contacting DB2 Customer Support. Depending on the nature of your
problem or concern, this guide will suggest information you can gather to help
us to serve you better.
For information or to order any of the DB2 Universal Database products
contact an IBM representative at a local branch office or contact any
authorized IBM software remarketer.
Telephone
If you live in the U.S.A., call one of the following numbers:
- 1-800-237-5511 to learn about available service options.
- 1-800-IBM-CALL (1-800-426-2255) or 1-800-3IBM-OS2 (1-800-342-6672) to
order products or get general information.
- 1-800-879-2755 to order publications.
For information on how to contact IBM outside of the United States, see
Appendix A of the IBM Software Support Handbook. You can access this document
by selecting the "Roadmap to IBM Support" item at:
http://www.ibm.com/support/.
Note that in some countries, IBM-authorized dealers should contact
their dealer support structure instead of the IBM Support Center.
- World Wide Web
- http://www.software.ibm.com/data/
http://www.software.ibm.com/data/db2/library/
The DB2 World Wide Web pages provide current DB2 information about news,
product descriptions, education schedules, and more. The DB2 Product and
Service Technical Library provides access to frequently asked questions,
fixes, books, and up-to-date DB2 technical information. (Note
that this information may be in English only.)
- Anonymous FTP Sites
- ftp.software.ibm.com
Log on as anonymous. In the directory /ps/products/db2, you can find
demos, fixes, information, and tools concerning DB2 and many related products.
- Internet Newsgroups
- comp.databases.ibm-db2, bit.listserv.db2-l
These newsgroups are available for users to discuss their experiences with
DB2 products.
- CompuServe
- GO IBMDB2 to access the IBM DB2 Family forums
All DB2 products are supported through these forums.
To find out about the IBM Professional Certification Program for DB2
Universal Database, go to
http://www.software.ibm.com/data/db2/db2tech/db2cert.html
|
Special Characters
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
Special Characters
A
B
backbufsz
database manager configuration parameter
(1623)
BACKUP DATABASE
(1426)
backup_pending
database configuration parameter
(1556)
Benchmark Tool
(1301)
binarynumerics
(1782)
BIND
(1432)
to create new access path
(1906)
Bind File Description Tool
(1303)
bindfile
precompile option
(1797)
binding
defaults
(1465)
errors during
(1502)
implicitly created schema
(1466), (1841)
blocking
precompile/bind option
(1434), (1798)
buffpage
database configuration parameter
(1557)
C
case sensitivity
(1414)
in naming conventions
(1983)
CATALOG APPC NODE
(1468)
CATALOG APPCLU NODE
(1469)
CATALOG APPN NODE
(1470)
CATALOG DATABASE
(1471)
CATALOG DCS DATABASE
(1475)
CATALOG GLOBAL DATABASE
(1480)
CATALOG IPX/SPX NODE
(1481)
CATALOG LOCAL NODE
(1482)
CATALOG NAMED PIPE NODE
(1483)
CATALOG NETBIOS NODE
(1484)
CATALOG ODBC DATA SOURCE
(1485)
CATALOG TCP/IP NODE
(1486)
catalogcache_sz
database configuration parameter
(1558)
cataloging
database
(1473)
host database
(1476)
CCSIDG
precompile/bind option
(1435), (1799)
CCSIDM
precompile/bind option
(1436), (1800)
CCSIDS
precompile/bind option
(1437), (1801)
CHANGE DATABASE COMMENT
(1489)
CHANGE ISOLATION LEVEL
(1493)
character string delimiter
(2012)
characters, special
permitted in CLP commands
(1415)
chardel
(1526), (1733), (1788)
charsub
precompile/bind option
(1438), (1802)
chngpgs_thresh
database configuration parameter
(1559)
CLOSE statement
executing through the CLP
(1972)
cnulreqd
bind option
(1439)
codepage
(1778)
database configuration parameter
(1560)
codeset
database configuration parameter
(1561)
coldel
(1527), (1734), (1789)
collection
precompile/bind option
(1440), (1803)
column
naming conventions
(1996)
column descriptor record, PC/IXF
(2032)
column values, invalid
(2056)
columns, incompatible
(2054)
command line processor
accessing databases through
(1376)
accessing help
(1386)
batch mode
(1379)
command mode
(1378)
description
(1374)
interactive input mode
(1377)
invoking
(1375)
quitting
(1381), (1847)
shell command
(1383)
terminating
(1382), (1924)
using
(1404)
command syntax
interpreting
(1978)
compound
(1726)
configuration, admin
resetting to default
(1869)
sample
(1533)
configuration, database
resetting to default
(1874)
sample
(1546)
updating
(1959)
configuration, database manager
sample
(1617)
conn_elapse
database manager configuration parameter
(1624)
connect
precompile option
(1804)
CONNECT statement
database connection
(1409)
consistency
required for backup
(1431)
continuation character, line
in command line processor
(1411)
Control Center
(1307)
conventions, naming
for aliases
(1987)
for authentication IDs
(2000)
for columns
(1993)
for database manager objects
(1981)
for databases
(1986)
for tables
(1994)
for views
(1995)
in SNA
(1982)
copyprotect
database configuration parameter
(1562)
country
database configuration parameter
(1563)
cpuspeed
database manager configuration parameter
(1625)
CREATE DATABASE
(1500)
Create Instance
(1331)
Create Sample Database
(1349)
cursor stability (CS)
changing
(1494)
D
Data Declustering Tool
(1353)
data fragmentation
eliminating, by table reorganization
(1857)
data integrity
maintaining, with isolation levels
(1499)
data record, PC/IXF
(2035)
data skew, redistributing data in nodegroup
(1851)
data type descriptions
ASC
(2085)
DEL
(2015)
PC/IXF
(2048)
data types
PC/IXF
(2042)
database
cataloging
(1472)
changing comments in directory
(1490)
checking authorizations
(1537)
connection, overview of
(1406)
deleting, ensuring recovery with log files
(1512)
exporting table to a file
(1518)
home directory entry, definition of
(1753)
implicit connection
(1407)
importing file to table
(1715)
indirect directory entry, definition of
(1752)
information
(1712)
migrating, command for
(1794)
monitor, resetting
(1881)
naming conventions
(1988)
recovering
(1895)
remote directory entry, definition of
(1751)
removing
(1511)
removing entries (uncataloging)
(1932)
removing host DCS entries
(1939)
reorganizing
(1861)
restarting
(1886)
restoring (rebuilding)
(1888)
roll-forward recovery of
(1896)
statistics
(1902)
database access
starting database manager
(1405)
database backup
history file
(1843)
database configuration
network parameter values
(1960)
resetting to default
(1873)
sample
(1547)
updating
(1958)
Database Connection Services (DCS) directory
uncataloging entries
(1937)
database directories
changing comments
(1491)
definition of
(1750)
sample content of
(1749)
database manager
accessing from command prompt
(1295)
instances of
(1703)
monitor switches, checking
(1700), (1706)
starting
(1913)
statistics
(1710)
stopping
(1921)
system commands
(1294)
database manager configuration
file
(1697)
network parameter values
(1963)
sample
(1618)
database monitor
description
(1966)
Database Pre-migration Tool
(1310)
Database System Monitor
database system monitor
GET DATABASE MANAGER MONITOR SWITCHES
(1701)
GET MONITOR SWITCHES
(1707)
GET SNAPSHOT
(1711)
RESET MONITOR
(1882)
UPDATE MONITOR SWITCHES
(1967)
database_consistent
database configuration parameter
(1564)
database_level
database configuration parameter
(1565)
datesiso
(1528)
datetime
precompile/bind option
(1441), (1805)
db2
CMD description
(1380)
command syntax
(1385)
DB2 Administration Server
(1297)
DB2 Governor
(1329)
DB2 Governor Log Query
(1330)
DB2 Interactive CLI
(1312)
DB2 Profile Registry Command
(1351)
DB2 SQL Explain Tool
(1327)
DB2 Statistics Extraction Tool
(1343)
db2admin
(1298)
db2autold
(1300)
db2batch
(1302)
db2bfd
(1304)
db2cc
(1306)
db2cidmg
(1309)
db2ckmig
(1311)
db2cli
(1313)
db2cmd
(1315)
db2drdat
(1317)
db2empfa
(1320)
db2eva
(1322)
db2evmon
(1324)
db2exfmt
(1326)
db2expln
(1328)
db2icrt
(1332)
db2idrop
(1334)
db2ilist
(1336)
db2imigr
(1338)
db2ipxad
(1340)
db2iupdt
(1342)
db2look
(1344)
db2migdr
(1346)
DB2OPTIONS
environment variable
(1389)
db2rbind
(1348)
db2sampl
(1350)
db2set
(1352)
db2split
(1354)
db2sql92
(1356)
db2start
(1358), (1912)
db2stop
(1360), (1920)
db2tbst
(1362)
db2trc
(1364)
db2uiddl
(1369)
db2untag
(1371)
db2vexp
(1373)
dbheap
database configuration parameter
(1566)
DEACTIVATE DATABASE
(1506)
dec
precompile/bind option
(1442), (1806)
decdel
precompile/bind option
(1443), (1807)
DECLARE CURSOR statement
executing through the CLP
decplusblank
(1529)
decpt
(1530), (1735), (1790)
default
admin configuration, resetting to
(1870)
database configuration, resetting to
(1875)
deferred_prepare
precompile option
(1808)
degree
precompile/bind option
(1444), (1809)
DEL data type descriptions
(2014)
DEL file
format
(2008)
sample
(2011)
delimited ASCII (DEL) file format
(2006)
delimiter
character string
(2013)
DEREGISTER
(1507)
DESCRIBE
(1508)
DETACH
(1509)
device, tape
(1428)
dft_account_str
database manager configuration parameter
(1626)
dft_client_adpt
database manager configuration parameter
(1627)
dft_client_comm
database manager configuration parameter
(1628)
dft_degree
database configuration parameter
(1567)
dft_extent_sz
database configuration parameter
(1568)
dft_loadrec_ses
database configuration parameter
(1569)
dft_mon_bufpool
database manager configuration parameter
(1629)
dft_mon_lock
database manager configuration parameter
(1630)
dft_mon_sort
database manager configuration parameter
(1631)
dft_mon_stmt
database manager configuration parameter
(1632)
dft_mon_table
database manager configuration parameter
(1633)
dft_mon_uow
database manager configuration parameter
(1634)
dft_prefetch_sz
database configuration parameter
(1570)
dft_queryopt
database configuration parameter
(1571)
dftdbpath
database manager configuration parameter
(1635)
diaglevel
database manager configuration parameter
(1636)
diagpath
database manager configuration parameter
(1637)
differences between PC/IXF and System/370 IXF
(2074)
dir_cache
database manager configuration parameter
(1638)
dir_obj_name
database configuration parameter
(1572)
database manager configuration parameter
(1639)
dir_path_name
database manager configuration parameter
(1640)
dir_type
database manager configuration parameter
(1641)
directories
Database Connection Services (DCS), uncataloging entries
(1938)
database, changing comments
(1492)
deleting entries
(1943)
node, removing entries from
(1951)
system database, removing
(1935)
uncataloging
(1931)
disconnect
precompile option
(1810)
disconnecting
command line processor front-end and back-end processes
(1927)
discover
database manager configuration parameter
(1642)
discover_comm
database manager configuration parameter
(1643)
discover_db
database configuration parameter
(1573)
discover_inst
database manager configuration parameter
(1644)
Distributed Database Connection Services (DDCS)
supported connections to other systems
(1478)
dlchktime
database configuration parameter
(1574)
dos_rqrioblk
database manager configuration parameter
(1645)
DRDA Trace
(1316)
drda_heap_sz
database manager configuration parameter
(1646)
DROP DATABASE
(1510)
DROP NODE VERIFY
(1514)
dumpfile
(1779)
dumping a trace to file
(1365)
Dynamic Visual Explain
(1372)
dynamicrules
precompile/bind option
(1445), (1811)
E
ECHO
(1515)
Enable Multi-page File Allocation
(1319)
environment variables
auto-commit option (-c)
(1392)
DB2OPTIONS
(1390)
display DB2 interactive prompt option (-p)
(1397)
display output option (-o)
(1396)
display SQLCODE/SQLSTATE option (-e)
(1393)
log commands in history file option (-l)
(1395)
read from input file option (-f)
(1394)
save all output to file option (-z)
(1403)
save to report file option (-r)
(1398)
show SQLCA data option (-a)
(1391)
show warning messages option (-w)
(1402)
statement termination character option (-t)
(1400)
stop execution on command error option (-s)
(1399)
verbose output option (-v)
(1401)
error messages
database configuration file
(1615)
dropping remote database
(1513)
during backup
(1430)
during binding
(1467)
invalid checksum, database configuration file
(1877), (1961)
invalid checksum, database manager configuration file
(1871), (1879), (1955), (1964)
estore_seg_sz
database configuration parameter
(1575)
Event Analyzer
(1321)
Event Monitor Productivity Tool
(1323)
example
forcein
(2068)
explain
bind option
(1446), (1812)
Explain Table Format Tool
(1325)
explsnap
precompile/bind option
(1447), (1813)
EXPORT
(1516)
export utility file formats
(2003)
exporting
(1517)
choosing file formats for
(1523)
database table to a file
(1520)
to PC/IXF format
(1524)
F
fastparse
(1770)
fcm_num_anchors
database manager configuration parameter
(1647)
fcm_num_connect
database manager configuration parameter
(1649)
fcm_num_rqb
database manager configuration parameter
(1650)
fcm_num;buffers
database manager configuration parameter
(1648)
FETCH statement
executing through the CLP
file format
delimited ASCII (DEL)
(2007)
non-delimited ASCII (ASC)
(2079)
PC version of IXF (PC/IXF)
(2017)
file formats
for exporting table to file
(1521)
for importing file to table
(1719)
fileserver
database manager configuration parameter
(1651)
FORCE APPLICATION
(1531)
forcein
(1736), (1791)
code page semantics
(2065)
data type semantics
(2069)
example
(2067)
general semantics
(2063)
option
(2061)
summary of PC/IXF file import with
(2071)
funcpath
precompile/bind option
(1448), (1814)
G
generic
bind option
(1449)
GET ADMIN CONFIGURATION
(1532)
GET AUTHORIZATIONS
(1536)
GET CONNECTION STATE
(1544)
GET DATABASE CONFIGURATION
(1545)
GET DATABASE MANAGER CONFIGURATION
(1616)
GET DATABASE MANAGER MONITOR SWITCHES
(1698)
GET INSTANCE
(1702)
Get IPX/SPX Internetwork Address
(1339)
GET MONITOR SWITCHES
(1704)
GET SNAPSHOT
(1708)
effect on UPDATE MONITOR SWITCHES
(1968)
Get Tablespace State
(1361)
grant
bind option
(1450)
grant_group
bind option
(1451)
grant_user
bind option
(1452)
H
header record, PC/IXF
(2026)
HELP
(1713)
host systems
cataloging databases located on
(1477)
connections supported by DDCS
(1479)
removing DCS catalog entries
(1940)
host variables
not supported in command line processor
(1420)
I
implicit connection
database access
(1408)
implieddecimal
(1728), (1780)
IMPORT
(1714)
import
of PC/IXF files, with forcein
(2073)
import of PC/IXF files
data type-specific rules
(2060)
general rules
(2051)
import utility file formats
(2004)
importing
choosing file formats for
(1723)
database access through DDCS
(1724)
DEL files
(1721)
file to database table
(1717)
PC/IXF file to table
(1720)
PC/IXF, multiple-part files
(1725)
WSF files
(1722)
incompatible columns
(2053)
index
reorganization
(1863), (1866)
statistics
(1901)
indexixf
(1737)
indexrec
database configuration parameter
(1576)
database manager configuration parameter
(1652)
indexschema
(1738)
indexsort
database configuration parameter
(1577)
indicator
record length
(2023)
indoubt transaction field, description
(1758)
INITIALIZE TAPE
(1739)
insert
precompile/bind option
(1453), (1815)
Integration Exchange Format (IXF)
(2019)
intra_parallel
database manager configuration parameter
(1653)
invalid PC/IXF column values
(2055)
invalid PC/IXF data type
(2044)
INVOKE STORED PROCEDURE
(1740)
ipx_socket
database manager configuration parameter
(1654)
IPX/SPX node
uncataloging
(1945)
isolation
precompile/bind option
(1454), (1816)
K
keepdari
database manager configuration parameter
(1655)
keywords
syntax for
(1976)
L
langlevel
precompile option
(1817)
level
precompile option
(1818)
line continuation character
in command line processor
(1410)
LIST ACTIVE DATABASES
(1744)
LIST APPLICATIONS
(1745)
LIST BACKUP/HISTORY
(1746)
LIST COMMAND OPTIONS
(1747)
LIST DATABASE DIRECTORY
(1748)
LIST DCS APPLICATIONS
(1754)
LIST DCS DIRECTORY
(1755)
LIST DRDA INDOUBT TRANSACTIONS
(1756)
LIST INDOUBT TRANSACTIONS
(1757)
List Instances
(1335)
LIST NODE DIRECTORY
(1759)
LIST NODEGROUPS
(1760)
LIST NODES
(1761)
LIST ODBC DATA SOURCES
(1762)
LIST PACKAGES/TABLES
(1763)
LIST TABLESPACE CONTAINERS
(1764)
LIST TABLESPACES
(1765)
LOAD
(1766)
remote filenames
(1768)
LOAD QUERY
(1792)
load utility file formats
(2005)
lobsinfile
(1525), (1727), (1771)
Local Database Directory Migration
(1345)
local node
uncataloging
(1946)
locklist
database configuration parameter
(1578)
locks
resetting maximum to default
(1876)
locktimeout
database configuration parameter
(1579)
log file
listing during roll forward
(1898)
log_retain_status
database configuration parameter
(1586)
logbufsz
database configuration parameter
(1580)
logfilsiz
database configuration parameter
(1581)
loghead
database configuration parameter
(1582)
logpath
database configuration parameter
(1583)
logprimary
database configuration parameter
(1584)
logretain
database configuration parameter
(1585)
logsecond
database configuration parameter
(1587)
M
max_connretries
database manager configuration parameter
(1656)
max_coordagents
database manager configuration parameter
(1657)
max_idleagents
(1670)
max_rt_degree
database manager configuration parameter
(1658)
max_time_diff
database manager configuration parameter
(1659)
maxagents
database manager configuration parameter
(1660)
maxappls
database configuration parameter
(1588)
maxcagents
database manager configuration parameter
(1661)
maxdari
database manager configuration parameter
(1662)
maxfilop
database configuration parameter
(1589)
maxlocks
database configuration parameter
(1590)
maxtotfilop
database manager configuration parameter
(1663)
messages
accessing help text
(1388)
precompile/bind option
(1455), (1819)
metacharacters
(1416)
MIGRATE DATABASE
(1793)
Migrate Instance
(1337)
min_priv_mem
database manager configuration parameter
(1664)
mincommit
database configuration parameter
(1591)
mon_heap_sz
database manager configuration parameter
(1665)
monitoring databases
(1699), (1705)
multipage_alloc
database configuration parameter
(1592)
N
naming a binary file for output
(1366)
naming conventions
for aliases
(1985)
for authentication IDs
(1999)
for columns
(1990)
for database manager objects
(1979)
for databases
(1984)
for tables
(1991)
for views
(1992)
in SNA
(1980)
NetBIOS node
uncataloging
(1947)
newlogpath
database configuration parameter
(1593)
nextactive
database configuration parameter
(1594)
nname
database manager configuration parameter
(1666)
no commit (NC)
changing
(1495)
node
directories, removing entries from
(1950)
node, SOCKS
(1488)
nodefaults
(1772)
nodetype
database manager configuration parameter
(1667)
noeofchar
(1729), (1781)
noheader
(1773)
nolinemacro
precompile option
(1820)
non-delimited ASCII (ASC) file format
(2078)
norowwarnings
(1774)
NULL string
use in setting blanks
(1413)
nullindchar
(1783)
num_estore_segs
database configuration parameter
(1595)
num_freqvalues
database configuration parameter
(1596)
num_initagents
database manager configuration parameter
(1668)
num_iocleaners
database configuration parameter
(1597)
num_ioservers
database configuration parameter
(1598)
num_poolagents
database manager configuration parameter
(1669)
num_quantiles
database configuration parameter
(1599)
numdb
database manager configuration parameter
(1671)
numsegs
database configuration parameter
(1600)
O
objectname
database manager configuration parameter
(1672)
Open DB2 Command Window
(1314)
OPEN statement
executing through the CLP
optimization
(1855)
option
forcein
(2062)
optlevel
precompile option
(1821)
output
precompile option
(1822)
owner
precompile/bind option
(1456), (1823)
P
package
precompile option
(1824)
recreating
(1849)
packeddecimal
(1784)
pagefreespace
(1775)
parameters
syntax for
(1975)
PC version of IXF (PC/IXF) file format
(2016)
PC/IXF
contrasted with System/370 IXF
(2075)
data type descriptions
(2047)
data types
(2041)
invalid column values
(2057)
invalid data type
(2046), (2052)
record types
(2021), (2024)
valid data type
(2045)
PC/IXF file
format
(2018)
PC/IXF file import
data type-specific rules
(2059)
general rules
(2050)
with forcein
(2072)
PC/IXF record type
application
(2039)
column descriptor
(2033)
data
(2036)
header
(2027)
table
(2030)
pckcachesz
database configuration parameter
(1601)
performance, improving
(1865)
by reorganizing tables
(1858)
PRECOMPILE PROGRAM
(1795)
Prepare Unique Index Conversion to V5 Semantics
(1368)
priv_mem_thresh
database manager configuration parameter
(1673)
privileges
direct, defined
(1542)
granting when creating a database
(1504)
indirect, defined
(1543)
PRUNE HISTORY
(1842)
Q
qualifier
precompile/bind option
(1457), (1825)
QUERY CLIENT
(1844)
query_heap_sz
database manager configuration parameter
(1674)
queryopt
precompile/bind option
(1458), (1826)
QUIESCE TABLESPACES FOR TABLE
(1845)
QUIT
(1846)
R
read stability (RS)
changing
(1497)
REBIND
(1848)
Rebind all Packages
(1347)
rec_his_retentn
database configuration parameter
(1602)
reclen
(1730), (1785)
record length indicator
(2022)
record type, PC/IXF
application
(2040)
column descriptor
(2034)
data
(2037)
header
(2028)
table
(2031)
record types
PC/IXF
(2020), (2025)
recovering a database
(1890)
recovery
with roll forward
(1897)
without roll forward
(1891), (1892)
redirecting output
(1419)
REDISTRIBUTE NODEGROUP
(1850)
REGISTER
(1852)
release
database configuration parameter
(1604)
database manager configuration parameter
(1675)
precompile/bind option
(1459), (1827)
Release Container Tag
(1370)
Remote Database Migration
(1308)
remote filenames
LOAD
(1767)
remote server
invoking stored procedure on
(1742)
Remove Instance
(1333)
REORGANIZE TABLE
(1853)
REORGCHK
(1859)
repeatable read (RR)
changing
(1496)
RESET ADMIN CONFIGURATION
(1867)
RESET DATABASE CONFIGURATION
(1872)
RESET DATABASE MANAGER CONFIGURATION
(1878)
RESET MONITOR
(1880)
RESTART DATABASE
(1883)
restbufsz
database manager configuration parameter
(1676)
RESTORE DATABASE
(1887)
restore_pending
database configuration parameter
(1603)
restoring earlier versions of DB2 databases
(1889)
resync_interval
database manager configuration parameter
(1677)
REWIND TAPE
(1893)
roll forward
enabling, when backing up
(1429)
ROLLFORWARD DATABASE
(1894)
rollfwd_pending
database configuration parameter
(1605)
route_obj_name
database manager configuration parameter
(1678)
rqrioblk
database manager configuration parameter
(1679)
rules governing PC/IXF file import
(2049), (2058)
RUNSTATS
(1899)
S
sample ASC file
(2082)
sample DEL file
(2010)
schema
created when creating a database
(1501)
SELECT statement
executing through the CLP
(1973)
in EXPORT command
(1522)
resolving ambiguous symbols in WHERE clause
(1418)
semantics
forcein, code page
(2066)
forcein, data type
(2070)
forcein, general
(2064)
seqdetect
database configuration parameter
(1606)
SET CLIENT
(1907)
SET RUNTIME DEGREE
(1908)
SET TABLESPACE CONTAINERS
(1909)
SET TAPE POSITION
(1910)
sheapthresh
database manager configuration parameter
(1680)
SIGALRM signal
(1915)
starting the database manager
(1916)
SIGALRM signal, starting the database manager
(1918)
SIGINT signal, starting database manager
(1914)
SIGINT signal, starting the database manager
(1917)
SOCKS node
(1487)
softmax
database configuration parameter
(1607)
sortheap
database configuration parameter
(1608)
spm_log_file_sz
database manager configuration parameter
(1682)
spm_max_resync
database manager configuration parameter
(1683)
spm_name
database manager configuration parameter
(1681)
SQL NULL value
command line processor representation
(1422)
SQL statements
accessing help
(1387)
executing through the CLP
(1971)
SQL92 Compliant SQL Statement Processor
(1355)
sqlca
precompile option
(1828)
SQLDA structure
calling server procedures that use, restrictions on
(1743)
sqlerror
precompile/bind option
(1460), (1829)
sqlflag
precompile option
(1830)
sqlrules
precompile option
(1831)
sqlstmtsz
database manager configuration parameter
(1684)
sqlwarn
precompile/bind option
(1461), (1832)
ss_logon
database manager configuration parameter
(1685)
Start Control Center
(1305)
START DATABASE MANAGER
(1911)
Start DB2
(1357)
start_stop_time
database manager configuration parameter
(1686)
starting a trace
(1367)
stat_heap_sz
database configuration parameter
(1609)
statistics
database
(1903)
database manager
(1709)
reorganizing indexes
(1864)
REORGCHK
(1860)
stmtheap
database configuration parameter
(1610)
STOP DATABASE MANAGER
(1919)
Stop DB2
(1359)
storage
physical
(1854)
stored procedure
invoking
(1741)
strdel
precompile/bind option
(1462), (1833)
striptblanks
(1731), (1786)
striptnulls
(1732), (1787)
structure
delimited ASCII (DEL) file
(2009)
non-delimited ASCII (ASC) file
(2081)
svcename
database manager configuration parameter
(1687)
syncpoint
precompile option
(1834)
syntax
for command line processor SQL statements
(1970)
for host variables not supported in command line processor
(1421)
precompile option
(1835)
syntax diagrams
(1974)
sysadm_group
database manager configuration parameter
(1688)
sysctrl_group
database manager configuration parameter
(1689)
sysmaint_group
database manager configuration parameter
(1690)
system commands
(1296)
system database directory
uncataloging
(1929)
System/370 IXF
(2077)
contrasted with PC/IXF
(2076)
T
table
exporting to a file
(1519)
importing file to
(1716)
naming conventions
(1997)
reorganization, determining if required
(1862)
statistics
(1904)
table record, PC/IXF
(2029)
table reorganization
command for
(1856)
tape device
(1427)
target
precompile option
(1836)
TCP/IP node
uncataloging
(1948)
TERMINATE
(1923)
cautions on use of
(1926)
termination
(1925)
abnormal
(1885)
normal
(1922)
territory
database configuration parameter
(1611)
text
precompile/bind option
(1463), (1837)
tm_database
database manager configuration parameter
(1691)
totalfreespace
(1776)
tp_mon_name
database manager configuration parameter
(1692)
tpname
database manager configuration parameter
(1693)
Trace
(1363)
tracefile
(1318)
trust_allclnts
database manager configuration parameter
(1694)
trust_clnauth
database manager configuration parameter
(1695)
U
udf_mem_sz
database manager configuration parameter
(1696)
UNCATALOG DATABASE
(1928)
UNCATALOG DCS DATABASE
(1936)
UNCATALOG NODE
(1942)
UNCATALOG ODBC DATA SOURCE
(1952)
uncataloging
database entries
(1934)
host DCS database entries
(1941)
system database directory
(1930)
uncommitted read (UR)
changing
(1498)
UPDATE ADMIN CONFIGURATION
(1953)
UPDATE COMMAND OPTIONS
(1956)
UPDATE DATABASE CONFIGURATION
(1957)
UPDATE DATABASE MANAGER CONFIGURATION
(1962)
Update Instances
(1341)
UPDATE MONITOR SWITCHES
(1965)
UPDATE RECOVERY HISTORY FILE
(1969)
usedefaults
(1777)
user
authorization
(1538)
user_exit_status
database configuration parameter
(1613)
userexit
database configuration parameter
(1612)
util_heap_sz
database configuration parameter
(1614)
utility file formats
(2002)
V
valid PC/IXF data type
(2043)
validate
precompile/bind option
(1464), (1838)
variables
syntax for
(1977)
version
precompile option
(1839)
view
naming conventions
(1998)
W
wchartype
precompile option
(1840)
WHERE clause
resolving ambiguous symbols in SELECT statement
(1417)
workstation, remote
cataloging databases
(1474)
removing catalog entries for databases from
(1933)
uncataloging from local workstation
(1949)
[ Top of Page | Previous Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]