IBM Books

Command Reference


Appendix F. Contacting IBM

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:

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

Index

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
  • !, shell command (1384)
  • \, line continuation character (1412)
  • A
  • abnormal termination
  • restart (1884)
  • access path
  • creating new (1905)
  • optimizing (1900)
  • action
  • precompile/bind option (1433), (1796)
  • ACTIVATE DATABASE (1423)
  • ADD NODE (1424)
  • admin configuration
  • file (1535)
  • network parameter values (1954)
  • resetting to default (1868)
  • sample (1534)
  • adsm_mgmtclass
  • database configuration parameter (1548)
  • adsm_nodename
  • database configuration parameter (1549)
  • adsm_owner
  • database configuration parameter (1550)
  • adsm_password
  • database configuration parameter (1551)
  • agent_stack_sz
  • database manager configuration parameter (1619)
  • agentpri
  • database manager configuration parameter (1620)
  • alias
  • naming conventions (1989)
  • anyorder (1769)
  • app_ctl_heap_sz
  • database configuration parameter (1552)
  • APPC node
  • uncataloging (1944)
  • applheapsz
  • database configuration parameter (1553)
  • application record, PC/IXF (2038)
  • ASC data type descriptions (2084)
  • ASC file
  • format (2080)
  • sample (2083)
  • ASC, as an import file type (1718)
  • aslheapsz
  • database manager configuration parameter (1621)
  • ATTACH (1425)
  • authentication
  • database manager configuration parameter (1622)
  • authentication ID
  • naming conventions (2001)
  • authorities
  • granting when creating a database (1503)
  • authority level
  • direct, defined (1540)
  • for creating databases, granting (1505)
  • indirect, defined (1541)
  • report (1539)
  • Autoloader (1299)
  • autorestart
  • database configuration parameter (1554)
  • avg_appls
  • database configuration parameter (1555)
  • 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 ]