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 Z
Special Characters
  • !, shell command (1555)
  • \, line continuation character (1585)
    • A
  • abnormal termination
  • restart (2157)
  • access path
  • creating new (2178)
  • optimizing (2173)
  • action
  • precompile/bind option (1608), (2059)
  • ACTIVATE DATABASE (1596)
  • Add Database Partition Server to an Instance (1506)
  • add database wizard (2297)
  • ADD DATALINKS MANAGER (1597)
  • ADD NODE (1598)
  • admin configuration
  • file (1719)
  • network parameter values (2230)
  • resetting to default (2141)
  • sample (1718)
  • Administration Server (DAS)
  • configuration (1715)
  • creating (1425)
  • dropping (1426)
  • agentpri
  • database manager configuration parameter (1815)
  • agent_stack_sz
  • database manager configuration parameter (1814)
  • anyorder (2013)
  • APPC node
  • uncataloging (2220)
  • applheapsz
  • database configuration parameter (1736)
  • app_ctl_heap_sz
  • database configuration parameter (1735)
  • ASC, as an import file type (1925)
  • aslheapsz
  • database manager configuration parameter (1816)
  • ATTACH (1599)
  • Audit Facility Administrator Tool (1433)
  • audit_buf_sz
  • database configuration parameter (1737)
  • database manager configuration parameter (1817)
  • authentication
  • database manager configuration parameter (1818)
  • authorities and privileges
  • granted when creating a database (1683)
  • authority level
  • direct, defined (1724)
  • for creating databases, granting (1685)
  • indirect, defined (1725)
  • report (1723)
  • Autoloader (1434)
  • autorestart
  • database configuration parameter (1738)
  • avg_appls
  • database configuration parameter (1739)
    • B
  • backbufsz
  • database manager configuration parameter (1819)
  • BACKUP DATABASE (1601)
  • backup database wizard (2299)
  • backup_pending
  • database configuration parameter (1740)
  • Benchmark Tool (1436)
  • binarynumerics (2035)
  • BIND (1607)
  • to create new access path (2179)
  • Bind File Description Tool (1438)
  • bindfile
  • precompile option (2060)
  • binding
  • errors during (1682)
  • implicitly created schema (1643), (2110)
  • blocking
  • precompile/bind option (1609), (2061)
  • books (2269), (2282)
  • buffpage
  • database configuration parameter (1741)
    • C
  • CALL (1644)
  • CALL statement
  • executing through the CLP (2250), (2257)
  • case sensitivity (1587)
  • in naming conventions (2266)
  • CATALOG APPC NODE (1645)
  • CATALOG APPCLU NODE (1646)
  • CATALOG APPN NODE (1647)
  • CATALOG DATABASE (1648)
  • CATALOG DCS DATABASE (1652)
  • CATALOG GLOBAL DATABASE (1657)
  • CATALOG IPX/SPX NODE (1658)
  • CATALOG LDAP DATABASE (1659)
  • CATALOG LDAP NODE (1660)
  • CATALOG LOCAL NODE (1661)
  • CATALOG NAMED PIPE NODE (1662)
  • CATALOG NETBIOS NODE (1663)
  • CATALOG ODBC DATA SOURCE (1664)
  • CATALOG TCP/IP NODE (1665)
  • catalogcache_sz
  • database configuration parameter (1742)
  • cataloging
  • database (1650)
  • host database (1653)
  • catalog_noauth
  • database manager configuration parameter (1820)
  • CCSIDG
  • precompile/bind option (1610), (2062)
  • CCSIDM
  • precompile/bind option (1611), (2063)
  • CCSIDS
  • precompile/bind option (1612), (2064)
  • CHANGE DATABASE COMMENT (1668)
  • Change Database Partition Server Configuration (1504)
  • CHANGE ISOLATION LEVEL (1672)
  • characters, special
  • permitted in CLP commands (1588)
  • chardel (1706), (1959), (2043)
  • charsub
  • precompile/bind option (1613), (2065)
  • Check Backup (1451)
  • chngpgs_thresh
  • database configuration parameter (1743)
  • CLI configuration
  • sample (1730)
  • CLIPKG
  • precompile/bind option (1614)
  • CLOSE statement
  • executing through the CLP (2251)
  • cnulreqd
  • precompile/bind option (1615), (2066)
  • codepage (2028)
  • database configuration parameter (1744)
  • codeset
  • database configuration parameter (1745)
  • coldel (1707), (1960), (2044)
  • collection
  • precompile/bind option (1616), (2067)
  • command line processor
  • accessing databases through (1547)
  • accessing help (1557)
  • batch mode (1550)
  • command mode (1549)
  • description (1545)
  • interactive input mode (1548)
  • invoking (1546)
  • options (1560)
  • quitting (1552), (2118)
  • shell command (1554)
  • terminating (1553), (2198)
  • using (1577)
  • command syntax
  • interpreting (2263)
  • comm_bandwidth
  • database manager configuration parameter (1821)
  • compound (1940)
  • configuration, admin
  • resetting to default (2142)
  • sample (1717)
  • configuration, CLI
  • sample (1729)
  • configuration, database
  • resetting to default (2147)
  • sample (1733)
  • updating (2236)
  • configuration, database manager
  • sample (1812)
  • Configure LDAP Environment (1494)
  • configure multisite update wizard (2301)
  • connect
  • precompile option (2068)
  • CONNECT statement
  • database connection (1582)
  • executing through the CLP (2252)
  • Connectivity Configuration Export Tool (1445)
  • Connectivity Configuration Import Tool (1447)
  • conn_elapse
  • database manager configuration parameter (1822)
  • consistency
  • required for backup (1606)
  • continuation character, line
  • in command line processor (1584)
  • Control Center (1442)
  • Control Database (1443)
  • conventions, naming
  • for database manager objects (2265)
  • copyprotect
  • database configuration parameter (1746)
  • country
  • database configuration parameter (1747)
  • cpuspeed
  • database manager configuration parameter (1823)
  • CREATE DATABASE (1680)
  • create database wizard (2303)
  • Create Instance (1482)
  • Create Sample Database (1522)
  • create table space wizard (2307)
  • create table wizard (2305)
  • cursor stability (CS)
  • changing (1674)
    • D
  • DAS (Administration Server)
  • configuration (1716)
  • creating (1427)
  • dropping (1428)
  • data fragmentation
  • eliminating, by table reorganization (2130)
  • data integrity
  • maintaining, with isolation levels (1679)
  • data skew, redistributing data in nodegroup (2123)
  • database
  • cataloging (1649)
  • changing comments in directory (1669)
  • checking authorizations (1721)
  • connection, overview of (1579)
  • deleting, ensuring recovery with log files (1692)
  • exporting table to a file (1697)
  • home directory entry, definition of (1985)
  • implicit connection (1580)
  • importing file to table (1921)
  • indirect directory entry, definition of (1984)
  • information (1918)
  • loading file to table (2005)
  • migrating, command for (2056)
  • monitor, resetting (2154)
  • recovering (2168)
  • remote directory entry, definition of (1983)
  • removing (1691)
  • removing entries (uncataloging) (2206)
  • removing host DCS entries (2213)
  • reorganizing (2134)
  • restarting (2159)
  • restoring (rebuilding) (2161)
  • roll-forward recovery of (2169)
  • statistics (2175)
  • database access
  • starting database manager (1578)
  • database backup
  • history file (2112)
  • database configuration
  • network parameter values (2237)
  • resetting to default (2146)
  • sample (1734)
  • updating (2235)
  • Database Connection Services (DCS) directory
  • uncataloging entries (2211)
  • database directories
  • changing comments (1670)
  • definition of (1982)
  • sample content of (1981)
  • database manager
  • accessing from command prompt (1421)
  • instances of (1909)
  • monitor switches, checking (1906), (1912)
  • starting (2187)
  • statistics (1916)
  • stopping (2195)
  • system commands (1420)
  • database manager configuration
  • file (1903)
  • network parameter values (2240)
  • sample (1813)
  • database monitor
  • description (2244)
  • Database Movement Tool (1500)
  • Database Pre-migration Tool (1453)
  • Database System Monitor
  • database system monitor
  • GET DATABASE MANAGER MONITOR SWITCHES (1907)
  • GET MONITOR SWITCHES (1913)
  • GET SNAPSHOT (1917)
  • RESET MONITOR (2155)
  • UPDATE MONITOR SWITCHES (2245)
  • database_consistent
  • database configuration parameter (1748)
  • database_level
  • database configuration parameter (1749)
  • datalinks
  • database manager configuration parameter (1824)
  • dateformat (1949), (2029)
  • datesiso (1708), (1961), (2045)
  • datetime
  • precompile/bind option (1617), (2069)
  • db2
  • CMD description (1551)
  • command syntax (1556)
  • DB2 Administration Server (1423)
  • DB2 Connect
  • supported connections to other systems (1655)
  • DB2 Governor (1478)
  • DB2 Governor Log Query (1480)
  • DB2 Index Advisor (1431)
  • DB2 Interactive CLI (1455)
  • DB2 library
  • books (2268)
  • Information Center (2290)
  • language identifier for books (2273)
  • late-breaking information (2275)
  • online help (2283)
  • ordering printed books (2281)
  • printing PDF books (2278)
  • searching online information (2316)
  • setting up document server (2314)
  • structure of (2267)
  • viewing online information (2285)
  • wizards (2293)
  • DB2 Profile Registry Command (1524)
  • DB2 SQL Explain Tool (1472)
  • DB2 SQLJ Profile Customizer (1516)
  • DB2 SQLJ Profile Printer (1518)
  • DB2 Statistics and DDL Extraction Tool (1498)
  • use when importing PC/IXF files (1931)
  • db2admin (1424)
  • db2adutl (1430)
  • db2advis (1432)
  • db2atld (1435)
  • db2batch (1437)
  • db2bfd (1439)
  • db2cc (1441)
  • db2cdbcr (1444)
  • db2cfexp (1446)
  • db2cfimp (1448)
  • db2cidmg (1450)
  • db2ckbkp (1452)
  • db2ckmig (1454)
  • db2cli (1456)
  • db2cmd (1458)
  • db2dclgn (1460)
  • db2drdat (1462)
  • db2empfa (1465)
  • db2eva (1467)
  • db2evmon (1469)
  • db2exfmt (1471)
  • db2expln (1473)
  • db2flsn (1475)
  • db2fs (1477)
  • db2gov (1479)
  • db2govlg (1481)
  • db2icrt (1483)
  • db2idrop (1485)
  • db2ilist (1487)
  • db2imigr (1489)
  • db2ipxad (1491)
  • db2iupdt (1493)
  • db2ldcfg (1495)
  • db2licm (1497)
  • db2look (1499)
  • db2move (1501)
  • db2mscs (1503)
  • db2nchg (1505)
  • db2ncrt (1507)
  • db2ndrop (1509)
  • DB2OPTIONS
  • environment variable (1561)
  • db2perfc (1511)
  • db2perfi (1513)
  • db2perfr (1515)
  • db2profc (1517)
  • db2profp (1519)
  • db2rbind (1521)
  • db2sampl (1523)
  • db2set (1525)
  • db2sql92 (1527)
  • db2start (1529), (2186)
  • db2stop (1531), (2194)
  • db2sync (1533)
  • db2tbst (1535)
  • db2trc (1537)
  • db2uiddl (1542)
  • db2untag (1544)
  • dbheap
  • database configuration parameter (1750)
  • DEACTIVATE DATABASE (1686)
  • dec
  • precompile/bind option (1618), (2070)
  • decdel
  • precompile/bind option (1619), (2071)
  • Declaration Generator (1459)
  • DECLARE CURSOR statement
  • executing through the CLP (2253)
  • decplusblank (1709), (1962), (2046)
  • decpt (1710), (1963), (2047)
  • default
  • admin configuration, resetting to (2143)
  • database configuration, resetting to (2148)
  • deferred_prepare
  • precompile option (2072)
  • degree
  • precompile/bind option (1620), (2073)
  • delprioritychar (1964), (2048)
  • DEREGISTER (1687)
  • DESCRIBE (1688)
  • DETACH (1689)
  • device, tape (1603)
  • dftdbpath
  • database manager configuration parameter (1834)
  • dft_account_str
  • database manager configuration parameter (1825)
  • dft_client_adpt
  • database manager configuration parameter (1826)
  • dft_client_comm
  • database manager configuration parameter (1827)
  • dft_degree
  • database configuration parameter (1751)
  • dft_extent_sz
  • database configuration parameter (1752)
  • dft_loadrec_ses
  • database configuration parameter (1753)
  • dft_mon_bufpool
  • database manager configuration parameter (1828)
  • dft_mon_lock
  • database manager configuration parameter (1829)
  • dft_mon_sort
  • database manager configuration parameter (1830)
  • dft_mon_stmt
  • database manager configuration parameter (1831)
  • dft_mon_table
  • database manager configuration parameter (1832)
  • dft_mon_uow
  • database manager configuration parameter (1833)
  • dft_prefetch_sz
  • database configuration parameter (1754)
  • dft_queryopt
  • database configuration parameter (1755)
  • dft_refresh_age
  • database configuration parameter (1756)
  • dft_sqlmathwarn
  • database configuration parameter (1757)
  • diaglevel
  • database manager configuration parameter (1835)
  • diagpath
  • database manager configuration parameter (1836)
  • directories
  • Database Connection Services (DCS), uncataloging entries (2212)
  • database, changing comments (1671)
  • deleting entries (2219)
  • node, removing entries from (2227)
  • system database, removing (2209)
  • uncataloging (2205)
  • dir_cache
  • database manager configuration parameter (1837)
  • dir_obj_name
  • database configuration parameter (1758)
  • database manager configuration parameter (1838)
  • dir_path_name
  • database manager configuration parameter (1839)
  • dir_type
  • database manager configuration parameter (1840)
  • disconnect
  • precompile option (2074)
  • disconnecting
  • command line processor front-end and back-end processes (2201)
  • discover
  • database manager configuration parameter (1841)
  • discover_comm
  • database manager configuration parameter (1842)
  • discover_db
  • database configuration parameter (1759)
  • discover_inst
  • database manager configuration parameter (1843)
  • dlchktime
  • database configuration parameter (1765)
  • dldel (1711), (1965), (2049)
  • dl_expint
  • database configuration parameter (1760)
  • dl_num_copies
  • database configuration parameter (1761)
  • dl_time_drop
  • database configuration parameter (1762)
  • dl_token
  • database configuration parameter (1763)
  • dl_upper
  • database configuration parameter (1764)
  • dos_rqrioblk
  • database manager configuration parameter (1844)
  • DRDA Trace (1461)
  • drda_heap_sz
  • database manager configuration parameter (1845)
  • DROP DATABASE (1690)
  • Drop Database Partition Server from an Instance (1508)
  • DROP NODE VERIFY (1694)
  • dumpfile (2030)
  • dumping a trace to file (1538)
  • dynamicrules
  • precompile/bind option (1621), (2075)
    • E
  • ECHO (1695)
  • Enable Multi-page File Allocation (1464)
  • environment variables
  • auto-commit option (-c) (1564)
  • DB2OPTIONS (1562)
  • display DB2 interactive prompt option (-p) (1570)
  • display output option (-o) (1569)
  • display SQLCODE/SQLSTATE option (-e) (1565)
  • log commands in history file option (-l) (1567)
  • read from input file option (-f) (1566)
  • remove new line character option (-n) (1568)
  • save all output to file option (-z) (1576)
  • save to report file option (-r) (1571)
  • show SQLCA data option (-a) (1563)
  • show warning messages option (-w) (1575)
  • statement termination character option (-t) (1573)
  • stop execution on command error option (-s) (1572)
  • verbose output option (-v) (1574)
  • error messages
  • database configuration file (1810)
  • dropping remote database (1693)
  • during backup (1605)
  • invalid checksum, database configuration file (2150), (2238)
  • invalid checksum, database manager configuration file (2144), (2152), (2231), (2241)
  • estore_seg_sz
  • database configuration parameter (1766)
  • Event Analyzer (1466)
  • Event Monitor Productivity Tool (1468)
  • explain
  • bind option (1622), (2076)
  • Explain Table Format Tool (1470)
  • explsnap
  • precompile/bind option (1623), (2077)
  • EXPORT (1696)
  • exporting
  • database table to a file (1699)
  • file type modifiers for (1702)
    • F
  • fastparse (2014)
  • fcm_num;buffers
  • database manager configuration parameter (1847)
  • fcm_num_anchors
  • database manager configuration parameter (1846)
  • fcm_num_connect
  • database manager configuration parameter (1848)
  • fcm_num_rqb
  • database manager configuration parameter (1849)
  • federated
  • database manager configuration parameter (1850)
  • precompile/bind option (1624), (2078)
  • FETCH statement
  • executing through the CLP (2254)
  • file formats
  • for exporting table to file (1700)
  • for importing file to table (1926)
  • file type modifiers
  • export utility (1703)
  • import utility (1938)
  • load utility (2011)
  • fileserver
  • database manager configuration parameter (1851)
  • Find Log Sequence Number (1474)
  • First Steps (1476)
  • FORCE APPLICATION (1713)
  • forcein (1968), (2052)
  • funcpath
  • precompile/bind option (1625), (2079)
    • G
  • generatedignore (1941), (2015)
  • generatedmissing (1942), (2016)
  • generatedoverride (2017)
  • generic
  • precompile/bind option (1626), (2081)
  • GET ADMIN CONFIGURATION (1714)
  • GET AUTHORIZATIONS (1720)
  • GET CLI CONFIGURATION (1728)
  • GET CONNECTION STATE (1731)
  • GET DATABASE CONFIGURATION (1732)
  • GET DATABASE MANAGER CONFIGURATION (1811)
  • GET DATABASE MANAGER MONITOR SWITCHES (1904)
  • GET INSTANCE (1908)
  • Get IPX/SPX Internetwork Address (1490)
  • GET MONITOR SWITCHES (1910)
  • GET SNAPSHOT (1914)
  • effect on UPDATE MONITOR SWITCHES (2246)
  • Get Tablespace State (1534)
  • grant
  • bind option (1627)
  • grant_group
  • bind option (1628)
  • grant_user
  • bind option (1629)
    • H
  • HELP (1919)
  • host systems
  • cataloging databases located on (1654)
  • connections supported by DB2 Connect (1656)
  • removing DCS catalog entries (2214)
  • host variables
  • not supported in command line processor (1593)
  • HTML
  • sample programs (2272)
    • I
  • identityignore (1943), (2018)
  • identitymissing (1944), (2019)
  • identityoverride (2020)
  • implicit connection
  • database access (1581)
  • implieddecimal (1950), (2031)
  • IMPORT (1920)
  • importing
  • code page considerations (1930)
  • database access through DB2 Connect (1932)
  • DB2 Data Links Manager considerations (1936)
  • file to database table (1923)
  • file type modifiers for (1937)
  • PC/IXF file to table (1924)
  • PC/IXF, multiple-part files (1935)
  • restrictions (1934)
  • to a remote database (1927)
  • to a table or hierarchy that does not exist (1928)
  • to typed tables (1933)
  • index
  • reorganization (2136), (2139)
  • statistics (2174)
  • index wizard (2309)
  • indexfreespace (2021)
  • indexixf (1969)
  • indexrec
  • database configuration parameter (1767)
  • database manager configuration parameter (1852)
  • indexschema (1970)
  • indexsort
  • database configuration parameter (1768)
  • indoubt transaction field, description (1992)
  • Information Center (2291)
  • initdari_jvm
  • database manager configuration parameter (1853)
  • INITIALIZE TAPE (1972)
  • insert
  • precompile/bind option (1630), (2080)
  • installing
  • Netscape browser (2288)
  • intra_parallel
  • database manager configuration parameter (1854)
  • INVOKE STORED PROCEDURE (1973)
  • IPX/SPX node
  • uncataloging (2221)
  • ipx_socket
  • database manager configuration parameter (1855)
  • isolation
  • CHANGE ISOLATION LEVEL command (1673)
  • precompile/bind option (1631), (2082)
    • J
  • java_heap_sz
  • database manager configuration parameter (1856)
  • jdk11_path
  • database manager configuration parameter (1857)
    • K
  • keepblanks (1966), (2050)
  • keepdari
  • database manager configuration parameter (1858)
  • keywords
  • syntax for (2261)
    • L
  • langlevel
  • precompile option (2083)
  • language identifier
  • books (2274)
  • late-breaking information (2276)
  • level
  • precompile option (2084)
  • License Management Tool (1496)
  • line continuation character
  • in command line processor (1583)
  • LIST ACTIVE DATABASES (1977)
  • LIST APPLICATIONS (1978)
  • LIST COMMAND OPTIONS (1979)
  • LIST DATABASE DIRECTORY (1980)
  • LIST DATALINKS MANAGERS (1986)
  • LIST DCS APPLICATIONS (1987)
  • LIST DCS DIRECTORY (1988)
  • LIST DRDA INDOUBT TRANSACTIONS (1989)
  • LIST HISTORY (1990)
  • LIST INDOUBT TRANSACTIONS (1991)
  • List Instances (1486)
  • LIST NODE DIRECTORY (1993)
  • LIST NODEGROUPS (1994)
  • LIST NODES (1995)
  • LIST ODBC DATA SOURCES (1996)
  • LIST PACKAGES (1998)
  • LIST PACKAGES/TABLES (1997)
  • LIST TABLES (1999)
  • LIST TABLESPACE CONTAINERS (2000)
  • LIST TABLESPACES (2001)
  • LOAD (2002)
  • temporary files (2009)
  • LOAD (sqluload) (2003)
  • LOAD QUERY (2054)
  • loading
  • file to database table (2007)
  • file type modifiers for (2010)
  • lobsinfile (1705), (1945), (2022)
  • local node
  • uncataloging (2222)
  • locklist
  • database configuration parameter (1769)
  • locks
  • resetting maximum to default (2149)
  • locktimeout
  • database configuration parameter (1770)
  • log file
  • listing during roll forward (2171)
  • logbufsz
  • database configuration parameter (1771)
  • logfilsiz
  • database configuration parameter (1772)
  • loghead
  • database configuration parameter (1773)
  • logpath
  • database configuration parameter (1774)
  • logprimary
  • database configuration parameter (1775)
  • logretain
  • database configuration parameter (1776)
  • logsecond
  • database configuration parameter (1778)
  • log_retain_status
  • database configuration parameter (1777)
  • longerror
  • precompile option (2085)
    • M
  • maxagents
  • database manager configuration parameter (1864)
  • maxappls
  • database configuration parameter (1779)
  • maxcagents
  • database manager configuration parameter (1865)
  • maxdari
  • database manager configuration parameter (1866)
  • maxfilop
  • database configuration parameter (1780)
  • maxlocks
  • database configuration parameter (1781)
  • maxtotfilop
  • database manager configuration parameter (1867)
  • max_connretries
  • database manager configuration parameter (1859)
  • max_coordagents
  • database manager configuration parameter (1860)
  • max_idleagents (1876)
  • max_logicagents
  • database manager configuration parameter (1861)
  • max_rt_degree
  • database manager configuration parameter (1862)
  • max_time_diff
  • database manager configuration parameter (1863)
  • messages
  • accessing help text (1559)
  • precompile/bind option (1632), (2086)
  • metacharacters (1589)
  • MIGRATE DATABASE (2055)
  • Migrate Instance (1488)
  • mincommit
  • database configuration parameter (1782)
  • min_priv_mem
  • database manager configuration parameter (1868)
  • modifiers, file type
  • for export utility (1704)
  • for import utility (1939)
  • for load utility (2012)
  • monitoring databases (1905), (1911)
  • mon_heap_sz
  • database manager configuration parameter (1869)
  • moving data between databases (1929)
  • multipage_alloc
  • database configuration parameter (1783)
    • N
  • naming a binary file for output (1539)
  • naming conventions
  • for database manager objects (2264)
  • NetBIOS node
  • uncataloging (2223)
  • Netscape browser
  • installing (2289)
  • newlogpath
  • database configuration parameter (1784)
  • nname
  • database manager configuration parameter (1870)
  • no commit (NC)
  • changing (1675)
  • nochecklengths (1954), (1971), (2036), (2053)
  • node
  • directories, removing entries from (2226)
  • node, SOCKS (1667)
  • nodefaults (1947)
  • nodetype
  • database manager configuration parameter (1871)
  • nodoubledel (1712), (1967), (2051)
  • noeofchar (1951), (2034)
  • noheader (2023)
  • nolinemacro
  • precompile option (2087)
  • norowwarnings (2024)
  • notifylevel
  • database manager configuration parameter (1872)
  • no_type_id (1946)
  • NULL string
  • use in setting blanks (1586)
  • nullindchar (1955), (2037)
  • numdb
  • database manager configuration parameter (1877)
  • numsegs
  • database configuration parameter (1791)
  • num_db_backups
  • database configuration parameter (1785)
  • num_estore_segs
  • database configuration parameter (1786)
  • num_freqvalues
  • database configuration parameter (1787)
  • num_initagents
  • database manager configuration parameter (1873)
  • num_initdaris
  • database manager configuration parameter (1874)
  • num_iocleaners
  • database configuration parameter (1788)
  • num_ioservers
  • database configuration parameter (1789)
  • num_poolagents
  • database manager configuration parameter (1875)
  • num_quantiles
  • database configuration parameter (1790)
    • O
  • objectname
  • database manager configuration parameter (1878)
  • online help (2284)
  • online information
  • searching (2318)
  • viewing (2287)
  • Open DB2 Command Window (1457)
  • OPEN statement
  • executing through the CLP (2255)
  • optimization (2128)
  • optlevel
  • precompile option (2088)
  • output
  • precompile option (2089)
  • owner
  • precompile/bind option (1633), (2090)
    • P
  • package
  • force new access paths, after running statistics (2180)
  • precompile option (2091)
  • recreating (2120)
  • packeddecimal (2038)
  • pagefreespace (2025)
  • parameters
  • syntax for (2260)
  • password
  • changing through ATTACH (1600)
  • changing through CONNECT (2258)
  • pckcachesz
  • database configuration parameter (1792)
  • PDF (2279)
  • performance configuration wizard (2311)
  • Performance Counters Registration Utility (1512)
  • Performance Monitor Registration Tool (1514)
  • performance, improving (2138)
  • by reorganizing tables (2131)
  • phantom quiesce (2115)
  • PRECOMPILE PROGRAM (2057)
  • PREP command (PRECOMPILE PROGRAM) (2058)
  • Prepare Unique Index Conversion to V5 Semantics (1541)
  • preprocessor
  • precompile option (2092)
  • printing PDF books (2280)
  • privileges
  • direct, defined (1726)
  • indirect, defined (1727)
  • privileges and authorities
  • granted when creating a database (1684)
  • priv_mem_thresh
  • database manager configuration parameter (1879)
  • PRUNE HISTORY/LOGFILE (2111)
    • Q
  • qualifier
  • precompile/bind option (1634), (2093)
  • QUERY CLIENT (2113)
  • queryopt
  • precompile/bind option (1635), (2094)
  • query_heap_sz
  • database manager configuration parameter (1880)
  • quiesce
  • phantom (2116)
  • QUIESCE TABLESPACES FOR TABLE (2114)
  • QUIT (2117)
    • R
  • read stability (RS)
  • changing (1677)
  • REBIND (2119)
  • Rebind all Packages (1520)
  • reclen (1956), (2039)
  • RECONCILE (2121)
  • recovering a database (2163)
  • recovery
  • with roll forward (2170)
  • without roll forward (2164), (2165)
  • rec_his_retentn
  • database configuration parameter (1793)
  • redirecting output (1592)
  • REDISTRIBUTE NODEGROUP (2122)
  • REFRESH LDAP (2124)
  • REGISTER (2125)
  • release
  • database configuration parameter (1794)
  • database manager configuration parameter (1881)
  • precompile/bind option (1636), (2095)
  • Release Container Tag (1543)
  • release notes (2277)
  • Remote Database Migration (1449)
  • remote server
  • invoking stored procedure on (1975)
  • Remove Instance (1484)
  • REORGANIZE TABLE (2126)
  • REORGCHK (2132)
  • repeatable read (RR)
  • changing (1676)
  • RESET ADMIN CONFIGURATION (2140)
  • RESET DATABASE CONFIGURATION (2145)
  • RESET DATABASE MANAGER CONFIGURATION (2151)
  • Reset Database Performance Values (1510)
  • RESET MONITOR (2153)
  • RESTART DATABASE (2156)
  • restbufsz
  • database manager configuration parameter (1882)
  • RESTORE DATABASE (2160)
  • restore wizard (2313)
  • restore_pending
  • database configuration parameter (1795)
  • restoring earlier versions of DB2 databases (2162)
  • resync_interval
  • database manager configuration parameter (1883)
  • REWIND TAPE (2166)
  • roll forward
  • enabling, when backing up (1604)
  • ROLLFORWARD DATABASE (2167)
  • rollfwd_pending
  • database configuration parameter (1796)
  • route_obj_name
  • database manager configuration parameter (1884)
  • rqrioblk
  • database manager configuration parameter (1885)
  • RUNSTATS (2172)
    • S
  • sample programs
  • cross-platform (2271)
  • HTML (2270)
  • schema
  • created when creating a database (1681)
  • searching
  • online information (2292), (2317)
  • SELECT statement
  • executing through the CLP (2256)
  • in EXPORT command (1701)
  • resolving ambiguous symbols in WHERE clause (1591)
  • seqdetect
  • database configuration parameter (1797)
  • SET CLIENT (2181)
  • SET RUNTIME DEGREE (2182)
  • SET TABLESPACE CONTAINERS (2183)
  • SET TAPE POSITION (2184)
  • Set up Windows NT Failover Utility (1502)
  • setting up document server (2315)
  • sheapthresh
  • database manager configuration parameter (1886)
  • SIGALRM signal (2189)
  • starting the database manager (2190)
  • SIGALRM signal, starting the database manager (2192)
  • SIGINT signal, starting database manager (2188)
  • SIGINT signal, starting the database manager (2191)
  • SmartGuides
  • wizards (2294)
  • SOCKS node (1666)
  • softmax
  • database configuration parameter (1798)
  • sortheap
  • database configuration parameter (1799)
  • spm_log_file_sz
  • database manager configuration parameter (1887)
  • spm_log_path
  • database manager configuration parameter (1888)
  • spm_max_resync
  • database manager configuration parameter (1889)
  • spm_name
  • database manager configuration parameter (1890)
  • SQL NULL value
  • command line processor representation (1595)
  • SQL statements
  • accessing help (1558)
  • executing through the command line processor (CLP) (2249)
  • SQL92 Compliant SQL Statement Processor (1526)
  • sqlca
  • precompile option (2096)
  • SQLDA structure
  • calling server procedures that use, restrictions on (1976)
  • sqlerror
  • precompile/bind option (1637), (2097)
  • sqlflag
  • precompile option (2098)
  • sqlrules
  • precompile option (2099)
  • sqluload - Load (2004)
  • sqlwarn
  • precompile/bind option (1638), (2100)
  • ss_logon
  • database manager configuration parameter (1891)
  • Start Control Center (1440)
  • START DATABASE MANAGER (2185)
  • Start DB2 (1528)
  • Start DB2 Synchronizer (1532)
  • starting a trace (1540)
  • start_stop_time
  • database manager configuration parameter (1892)
  • statistics
  • database (2176)
  • database manager (1915)
  • reorganizing indexes (2137)
  • REORGCHK (2133)
  • stat_heap_sz
  • database configuration parameter (1800)
  • stmtheap
  • database configuration parameter (1801)
  • STOP DATABASE MANAGER (2193)
  • Stop DB2 (1530)
  • storage
  • physical (2127)
  • stored procedure
  • invoking (1974)
  • strdel
  • precompile/bind option (1639), (2101)
  • striptblanks (1957), (2040)
  • striptnulls (1958), (2041)
  • svcename
  • database manager configuration parameter (1893)
  • syncpoint
  • precompile option (2102)
  • syntax
  • for command line processor SQL statements (2248)
  • for host variables not supported in command line processor (1594)
  • precompile option (2103)
  • syntax diagrams (2259)
  • sysadm_group
  • database manager configuration parameter (1894)
  • sysctrl_group
  • database manager configuration parameter (1895)
  • sysmaint_group
  • database manager configuration parameter (1896)
  • system commands (1422)
  • system database directory
  • uncataloging (2203)
    • T
  • table
  • exporting to a file (1698)
  • importing file to (1922)
  • loading file to (2006)
  • reorganization, determining if required (2135)
  • statistics (2177)
  • table reorganization
  • command for (2129)
  • tape device (1602)
  • target
  • precompile option (2104)
  • TCP/IP node
  • uncataloging (2224)
  • temporary files
  • load utility (2008)
  • TERMINATE (2197)
  • cautions on use of (2200)
  • termination (2199)
  • abnormal (2158)
  • normal (2196)
  • territory
  • database configuration parameter (1802)
  • text
  • precompile/bind option (1640), (2105)
  • timeformat (1952), (2032)
  • timestampformat (1953), (2033)
  • tm_database
  • database manager configuration parameter (1897)
  • totalfreespace (2026)
  • tpname
  • database manager configuration parameter (1899)
  • tp_mon_name
  • database manager configuration parameter (1898)
  • Trace (1536)
  • tracefile (1463)
  • transform group
  • precompile/bind option (1641), (2106)
  • trust_allclnts
  • database manager configuration parameter (1900)
  • trust_clntauth
  • database manager configuration parameter (1901)
  • tsm_mgmtclass
  • database configuration parameter (1803)
  • tsm_nodename
  • database configuration parameter (1804)
  • tsm_owner
  • database configuration parameter (1805)
  • tsm_password
  • database configuration parameter (1806)
    • U
  • udf_mem_sz
  • database manager configuration parameter (1902)
  • UNCATALOG DATABASE (2202)
  • UNCATALOG DCS DATABASE (2210)
  • UNCATALOG LDAP DATABASE (2216)
  • UNCATALOG LDAP NODE (2217)
  • UNCATALOG NODE (2218)
  • UNCATALOG ODBC DATA SOURCE (2228)
  • uncataloging
  • database entries (2208)
  • host DCS database entries (2215)
  • system database directory (2204)
  • uncommitted read (UR)
  • changing (1678)
  • UPDATE ADMIN CONFIGURATION (2229)
  • UPDATE CLI CONFIGURATION (2232)
  • UPDATE COMMAND OPTIONS (2233)
  • UPDATE DATABASE CONFIGURATION (2234)
  • UPDATE DATABASE MANAGER CONFIGURATION (2239)
  • UPDATE HISTORY FILE (2247)
  • Update Instances (1492)
  • UPDATE LDAP NODE (2242)
  • UPDATE MONITOR SWITCHES (2243)
  • usedefaults (1948), (2027)
  • user
  • authorization (1722)
  • userexit
  • database configuration parameter (1807)
  • user_exit_status
  • database configuration parameter (1808)
  • util_heap_sz
  • database configuration parameter (1809)
    • V
  • validate
  • precompile/bind option (1642), (2107)
  • variables
  • syntax for (2262)
  • version
  • precompile option (2108)
  • viewing
  • online information (2286)
    • W
  • wchartype
  • precompile option (2109)
  • WHERE clause
  • resolving ambiguous symbols in SELECT statement (1590)
  • wizards
  • add database (2296)
  • backup database (2298)
  • completing tasks (2295)
  • configure multisite update (2300)
  • create database (2302)
  • create table (2304)
  • create table space (2306)
  • index (2308)
  • performance configuration (2310)
  • restore database (2312)
  • Work with TSM Archived Images (1429)
  • workstation, remote
  • cataloging databases (1651)
  • removing catalog entries for databases from (2207)
  • uncataloging from local workstation (2225)
    • Z
  • zoneddecimal (2042)

    • [ Top of Page | Previous Page ]