Quick Beginnings for DB2 Extended Enterprise Edition for UNIX

Index

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

Special Characters

$RAHBUFDIR (1902)

$RAHBUFNAME (1903)

$RAHCHECKBUF (1904)

$RAHENV (1913)

.INI file

db2cli.ini (1693)

ODBC (1697)

.rhosts file (1241), (1330)

Access Profile

creating (1821)

using (1819)

accessing data

through DB2 Connect (938)

through Net.Data or JDBC (943)

accessing multiple servers (895), (1523)

accessing servers

IPX/SPX (1554)

overview (1519)

TCP/IP (1531), (1541)

Administration Server

create (1673)

list (1670)

overview (917), (1662)

remove (1676), (1853)

start (1666), (1668), (1839)

stop (1841)

admintool command (1178), (1278)

ADSM

software requirements (1064)

agents

coordinating (1019)

pools (1024)

purpose (1017)

subagent (1021)

Alert Center (914)

APPC

client (1575)

server (1813)

software requirements (1055), (1094), (1109), (1118), (1153) , (1162)

support on AIX

SNA Server (1059)

support on OS/2

Communications Manager for OS/2 (1102)

Communications Server for OS/2 (1101)

support on Solaris

SunLink SNA (1058), (1125)

supported platforms (1056)

application development

using Net.Data or JDBC (946)

using ODBC (1684)

application programs

connecting to logical node (1707)

coordinator node (961)

migrating to DB2 Extended Enterprise Edition (964)

serviced by agents (1020)

authentication

client (1211), (1295), (1390), (1411), (1598) , (1649), (1940)

DCS (1212), (1296), (1391), (1599), (1650) , (1941)

server (1210), (1294), (1389), (1597), (1648) , (1778), (1939)

authority

levels (1397), (1579), (1594)

binding

utilities and applications (1681)

book

printing Postscript (1883), (1887)

related books (1878)

viewing online (1882), (1892)

C shell

DB2 Extended Enterprise Edition restriction (1728)

capacity

disk storage (977)

catalog node (984)

cataloging

databases (1357), (1548), (1549), (1569), (1570)

IPX/SPX node (1566), (1568), (1812)

TCP/IP node (1545), (1547), (1803)

CD-ROM

installing DB2 Client Applications Enablers (1408), (1412)

installing DB2 Software Developer's Kit (1414), (1422)

Client Application Enabler

installing (1419)

installing on OS/2 (1421)

installing on Windows 3.x (1435)

software requirements (1065)

Client Configuration Assistant

administering clients communications (1509)

and DB2 setup (1255), (1339), (1664)

changing privileges (1585)

client profiles (1510)

exporting (1825)

importing (1827)

using (1823)

discover (1830)

discovering databases (1511)

overview (933)

searching the network (1503), (1829)

setting configuration parameters (1769), (1835)

testing the database connection (1514)

using access profiles (1820)

client profile

exporting (1824)

importing (1826)

clients

configuring (1520)

default node for connection (1226), (1315)

installing (1416), (1420)

operating systems supported (884), (885), (892), (1418)

overview (886), (1409)

verifying the installation (1515)

CLP See using the command line processor (CLP)

column

long-field, partitioning key considerations (991)

Command Center

entering DB2 commands (1700), (1702)

entering SQL statements (1701), (1703)

overview (901), (905)

commands

admintool (1179), (1279), (1282)

alter table (1375)

connecting to logical node (1644), (1674), (1704)

custom (1471)

dasicrt (1251), (1299), (1665)

dasidrop (1678), (1852)

db2admin (1252), (1300), (1667), (1669), (1677) , (1840), (1851)

db2ckmig (1353), (1373)

db2icrt (1207), (1291), (1602)

db2idrop (1655), (1656), (1659), (1860), (1861) , (1864)

db2ilist (1605)

db2imigr (1368), (1388), (1394)

db2iupdt (1642), (1646)

db2licd (1366)

db2ln (1496)

db2rmln (1261), (1345)

db2set (1626), (1671), (1733), (1792)

db2start (1400), (1609), (1620)

db2stop (1362), (1617), (1658), (1846), (1863)

db2uiddl (1401)

db2_install (1267)

drop function (1376)

drop trigger (1377)

drop view (1378)

echo (1736), (1737)

groupadd (1283), (1477)

mkgroup (1182)

mkuser (1183)

mount (1474)

netstat -i (1175)

pkgadd (1466)

pkgrm (1871)

rlogin (1463)

scoadmin (1479), (1482)

set (1735)

smit (1185), (1189), (1195)

smit_install_remove (1869)

SYSADM (1180), (1280), (1398), (1478), (1480)

useradd (1481)

communication protocols

APPC (1060), (1072), (1077), (1089), (1106) , (1122), (1148), (1157), (1814)

IPX/SPX (1061), (1078), (1090), (1107), (1124) , (1131), (1139), (1149), (1158), (1556) , (1563), (1805)

Named Pipes (1091), (1140), (1150), (1159)

NetBIOS (1062), (1092), (1132), (1141), (1151) , (1160)

TCP/IP (1063), (1073), (1079), (1084), (1093) , (1108), (1123), (1133), (1142), (1152) , (1161), (1532), (1794)

configuring (1542)

communications

allocating port for node (1200), (1285)

configuring the client (1508), (1538), (1561)

configuring the server (1775), (1785)

enabling fast communication manager (1199), (1284)

managing (1524), (1780)

Client Configuration Assistant (1501)

Control Center (929), (1776)

fast communication manager (1012)

specifying name for host (1220), (1309)

supported protocols

IPX/SPX (1809)

TCP/IP (1536), (1559), (1797)

components

on UNIX operating systems (1165), (1166), (1952)

selecting (1164), (1951)

concurrency

improving with logical nodes (999)

configuration parameters

intra-parallel (1023)

maxagents (1025)

num_poolagents (1026)

setting DB2 (1413), (1591), (1712), (1768), (1781)

SYSADM_GROUP (1586)

configuring

APPC (1816)

IPX/SPX (1558), (1562)

ODBC driver (1690), (1691)

TCP/IP (1534), (1796)

configuring client communications

setting configuration parameters (1406), (1526), (1770)

using the Client Configuration Assistant (1507)

using the command line processor (1525), (1787)

configuring communications

overview (1530)

using Client Configuration Assistant (1502)

using Control Center (1771)

configuring server communications

setting DB2COMM (1788), (1822)

using the command line processor (1784)

using the Control Center (1774)

configuring servers (1772), (1782)

connecting to a database (1583)

connecting to the Internet using Net.Data (942), (948)

connections

default node (1228), (1317)

Control Center

components (912)

listener daemon requirements (906)

overview (898), (903)

controlling the rah command (1912)

coordinator agent

description (1018)

coordinator node

description (960)

cost-based query optimizer

description (962)

creating the sample database

using First Steps (1580)

using the command line processor (1581)

DAS considerations (1254), (1302)

dasiupdt command (1645), (1675)

database

authentication type (1379)

definition (952)

migration (1396)

naming rules (1962)

NFS restriction (1184)

partition (957)

database access

two-phase commit (897)

database administration tools

Control Center (899)

overview (902)

database alias (1551), (1572)

naming rules (1961)

database manager

definition (953)

starting (1623)

stopping (1618), (1847)

unlocking node configuration file with db2stop force (1235), (1324)

database objects

naming rules (1966)

database partition server

definition (955)

DB2 Client Application Enabler

accessing databases (894)

installing

Windows 3.x (1436)

Windows 95 (1425)

Windows NT (1426)

overview (887), (893), (1410)

platforms supported (890), (891)

DB2 Client Application Enablers CD-ROM

installing clients from (1415)

DB2 Connect

overview (882), (883), (939), (940)

DB2 Enterprise Edition

memory requirements (1036)

DB2 Extended Enterprise Edition

configuration planning (1035)

hardware configuration (968)

DB2 Installer See installation

DB2 libraries

creating links (1259), (1341), (1343)

DB2 server, definition (879)

DB2 Snapshot Monitor

overview (924)

db2 terminate command (1363)

DB2 Universal Database

components included

Client Configuration Assistant (932), (934)

Control Center (904), (910)

DB2 Client Application Enabler (889)

DB2 Performance Monitor (927)

DB2 Snapshot Monitor (923), (944)

Visual Explain (918), (920), (926)

DAS considerations (1253), (1301), (1663)

getting started (1576)

overview (911)

platforms supported (900)

software requirements (1043), (1054)

db2.ini file

environment keywords (1738)

db2cclst listener daemon (907)

db2ckmig command (1354), (1367)

db2cli.ini (1692)

DB2COMM (1791)

db2fcmdm daemon

description (1014)

db2icrt command (1208), (1209), (1292), (1293), (1484) , (1601), (1937)

db2idrop command (1654), (1660), (1859), (1865)

db2ilist command (1607)

db2imigr command (1370), (1393)

DB2INSTANCE (1630)

db2iupdt command (1647)

db2ln command (1492), (1497)

DB2NODE

connecting to logical node (1709)

overview (1000)

db2profile script (1491), (1493), (1719)

db2rmln command (1260), (1344)

db2set command (1643), (1672)

using (1734), (1793)

db2start command (1610)

db2stop command (1616), (1657), (1845), (1862)

db2uiddl command (1402)

db2_all (1895), (1898)

db2_call_stack (1900)

db2_kill (1899)

determining problems with rah (1915)

developing applications

using Net.Data or JDBC (947)

Discovery

administration configuration file (1256), (1340)

choosing a discovery method (1831)

client configuration (1661)

searching the network (1828)

setting Discovery parameters (1834)

disk requirements

client (1040)

server (1039)

Distributed Computing Environment

software requirements (1057), (1074), (1080), (1097), (1128)

documentation

related publications (1879)

dsh command

installing DB2 Extended Enterprise Edition with (1188)

eliminating duplicate entries from machine list (1911)

environment

setting variables for initialization (1718)

environment variables (1005)

DB2INSTANCE (1722), (1723), (1757)

db2instprof (1758)

DB2NODE

connecting to logical node (1708)

db2options (1730)

db2path (1759)

db2profile script (1449), (1715), (1720)

path (1726)

setting (1488), (1714)

error handling

log (1374)

migration (1371)

execs

db2uexit.exe (1381), (1384)

db2uext2.exe (1382), (1385)

Extended Enterprise Edition

C shell restriction (1729)

capacity (970)

making accessible (1237), (1326)

storage (969)

Extended Enterprise Edition configuration

logical nodes (996)

security for an instance (1002)

shared nothing definition (958)

failover

adding a database partition server (1945)

choosing a configuration (1934)

creating an instance (1938)

enabling on Solaris (1932)

hot standby configuration (1928)

implementing (1919)

mounting the home directory (1936)

mutual takeover configuration (1930)

removing a database partition server (1946)

running the setup program (1943)

selecting a logical host (1935)

Solstice HA 1.3 resources (1918)

fast communication manager (FCM)

db2fcmdm daemon (1013)

description (1011)

enabling (1201), (1286)

generating node numbers (1218), (1307)

specifying host name (1221), (1310)

files

db2systm (1652), (1653), (1857), (1858)

listing for an instance (1010)

filesets

choosing on AIX (1190), (1948)

choosing on HP-UX (1949)

choosing on Solaris (1950)

corresponding prerequisites (1953)

finding topics (1891)

fixed disks

hardware requirements (1041)

GB (gigabyte) (973)

gigabyte (GB) (972)

groups

creating (1276)

hardware requirements

fixed disk (1042)

help

See information (1874)

high availability support

Solaris (1921)

Solstice HA 1.3 (1917)

host

listing names and addresses (1172)

multiple TCP/IP interfaces (1229), (1318)

specifying name for communications (1219), (1308)

hosts.equiv file (1242), (1331)

IBMCATGROUP nodegroup (983)

IBMDEFAULTGROUP nodegroup (982)

IBMTEMPGROUP (985)

IBMTEMPGROUP nodegroup (979)

information

online help (1873)

ordering (1885)

overview (1872), (1875)

related publications (1876)

viewing online (1881), (1890)

initialization file, ODBC (1696)

installation

CID using SystemView LAN (1434)

clients

Macintosh (1499), (1500)

OS/2 (1423)

Windows 3.X (1438)

Windows 95 (1429)

Windows NT (1430)

creating links for DB2 libraries (1257)

DB2 clients

AIX (1168), (1439)

HP-UX (1440)

Macintosh (1498)

OS/2 (1424)

SCO OpenServer (1469)

SINIX (1465)

Solaris (1441)

Windows 3.1x (1437)

Windows 95 (1427)

Windows NT (1428)

DB2 server on UNIX systems

assigning groups and users (1177), (1275), (1476)

creating an instance (1206), (1483)

creating groups and users (1176), (1274), (1475)

creating links (1258), (1342), (1495)

creating the administration server (1250), (1298)

DB2 Product Library (1197), (1268)

DB2 Product Messages (1198), (1269)

removing DB2 products (1838)

setting the DB2 operating environment (1213), (1297), (1485), (1486), (1487) , (1600), (1942)

updating kernel components (1270), (1273), (1446), (1450), (1451) , (1452), (1453), (1468), (1472)

disk requirements (1444)

client (1037)

server (1038)

errors (1432)

log (1433)

memory requirements (1443)

client (1028)

server (1027)

mounting the CD-ROM (1454), (1455)

AIX (1456), (1457), (1888)

HP-UX (1458), (1459)

mount point (1442)

SGI Silicon Graphics IRIX (1473)

SINIX (1467), (1470)

Solaris (1460), (1461), (1889)

Netscape (1893)

remote (1462)

servers

AIX (1167)

HP-UX (1266)

UNIX installations

using installp (1170), (1186)

using SMIT (1169), (1191), (1196)

installing Extended Enterprise Edition

adding Micro Focus Library entry points (1246), (1335)

enabling FCM communications (1203), (1288)

making DB2 Extended Enterprise Edition accessible (1236), (1325)

preparations (1171)

setting environment variables (1716)

using dsh command (1187)

instance owner (1007)

instances

autostarting (1625)

creating (1464)

creating multiple (1596)

definition (1001), (1595)

listing (1606)

listing files in (1008)

multiple on one processor (1006)

naming restrictions (1445), (1603), (1972)

removing (1651), (1855), (1866)

setting operating environment (1627)

SPM instance creation (1856)

starting (1608)

stopping (1615), (1844), (1849), (1850)

updating (1641)

inter-operator parallelism (967)

IP address

specifying (1222), (1311)

IPX/SPX

client (1555)

configuring (1564)

server (1807)

software requirements (1095), (1111), (1127), (1134), (1143)

supported platforms (1565), (1810)

verifying the connection (1518), (1553), (1574)

issuing commands to multiple database partition servers (1894)

Java Database Connectivity (950)

Java, running programs (1699)

JDBC See Java Database Connectivity

JDBC, running programs (1698)

Journal (915)

kernel configuration parameters

updating (1271), (1447)

LANG environment variable (1957)

listener daemon (db2cclst) (908)

listing

files in an instance (1009)

logging off the system (1578)

logging on to the system (1577)

logical node

connecting to (1706)

default (1705)

improving concurrency (998)

purpose (993)

supported configurations (995)

logical port number

specifying (1224), (1313)

long-field columns

partitioning key considerations (992)

managing connections

client

overview (935), (1528)

using the Client Configuration Assistant (931), (1505)

using the command line processor (1527)

server

overview (936)

using the Client Configuration Assistant (1506)

using the Command Line Processor (1529), (1786)

managing databases using the Control Center (909)

managing server communications

overview (930)

manuals See book

memory requirements

client (1030)

estimating (1033)

recommended (1034)

server (1029)

messages

getting online help (1877)

Microsoft ODBC Driver Manager (1687)

Microsoft SNA Server

version required (1163)

migration

data (1364)

database (1386), (1395)

DB2 Version 2.x (1350), (1358)

db2chkmig (1372)

instance (1360), (1365), (1387), (1392)

of applications (965)

post-installation (1359), (1361)

post-migration

explain tables (1407)

rebinding packages (1404)

unique index conversion (1399)

updating database and database manager configuration (1405)

updating statistics (1403)

pre-migration (1352), (1356)

previous releases (1351)

user exit program (1380), (1383)

monitoring rah processes (1905)

multipartition nodegroup See nodegroup

name of machine

obtaining (1173)

naming rules

database (1963)

database alias (1964)

database objects (1965)

general (1960)

groups (1968)

instance names (1970)

password (1975)

userids (1967)

username (1431), (1969)

workstation name (nname) (1974)

National Language Support (NLS)

code set (1955), (1956)

codepage support (1954), (1958)

determining codepage (1959)

Net.Data (1100)

overview (945), (949)

NetBIOS

on the client (1096), (1135), (1144)

on the server (1779)

supports SEARCH discovery (1833)

network

machine address, obtaining (1174)

NLS See National Language Support (NLS)

node

assigning number (1216), (1305)

creating configuration file (1215), (1304)

default client connection (1227), (1316)

definition (954)

enabling FCM communications (1202), (1287)

FCM daemon (1015)

in the same instance (1004)

name generated by FCM (1217), (1306)

setting environment variables (1717)

specifying logical port number (1223), (1312)

system database directory restrictions (1243), (1332)

node configuration file

creating (1214), (1303)

editing (1233), (1322)

locked with database manager active (1232), (1321)

unlocking with db2stop force (1234), (1323)

nodegroup

IBMCATGROUP (981)

IBMDEFAULTGROUP (980)

multipartition nodegroup (978)

ODBC

odbc.ini file (1694)

odbcinst.ini file (1695)

registering the driver manager (1689)

running ODBC-enabled applications (1682)

running programs (1685)

odbcad32.exe (1686)

operating systems

client (888)

server (1417)

ordering related publications (1880), (1884)

parameters

setting kernel configuration (1272), (1448)

SYSADM_GROUP (1584), (1587)

partition

definition (956)

partitioning key

definition (988)

partitioning map

overview (989)

password

naming rules (1976)

overriding for remote users (1240), (1329)

Performance Monitor

using (919)

planning

DB2 configuration (1031)

DB2 Connect configuration (1032)

pools

agent (997)

port

allocating for communications (1205), (1290)

prefix sequences (1907)

printing postscript (1886)

privileges

required (1588)

product

components (1947)

descriptions (881)

overview (880)

profile registry

using (1713)

profile script

db2profile sample (1721)

programs

db2chkmig (1369)

protocols

APPC (1815)

IPX/SPX (1557), (1806)

TCP/IP (1533), (1799)

query

cost-based optimizer (963)

rah (1896), (1897)

RAHDOTFILES (1914)

RAHOSTFILE (1909)

RAHOSTLIST (1910)

RAHWAITTIME (1906)

registering

ODBC driver manager (1688)

registry values

db2account (1740)

db2clientcomm (1763)

db2codepage (1741)

DB2COMM (1790)

db2comm (1760), (1789)

db2country (1742)

db2dbdft (1743)

db2dirpathname (1762)

db2discoverytime (1744)

db2include (1746)

DB2INSTANCE (1724)

db2instdef (1747)

db2libpath (1748)

db2netreq (1745)

DB2OPTIONS (1732)

db2options (1731), (1749)

db2route (1764)

db2slogon (1750)

db2timeout (1751)

db2tracename (1752)

db2traceon (1753)

db2trcflush (1754)

db2trcsyserr (1755)

db2yield (1756)

dsmi_config (1765)

dsmi_dir (1766)

dsmi_log (1767)

general (1739)

setting (1711)

remote users

granting access to DB2 Extended Enterprise Edition (1239), (1328)

removing

administration server (1854)

product options (1837), (1867)

AIX (1868)

HP-UX (1870)

restoring product files, installation (1192)

restrictions

instance name (1604), (1971)

running applications

database client (1679)

ODBC considerations (1683)

running commands in parallel (1901)

sample database See creating the sample database

scaling the database system

definition (986)

script

db2cshrc (1263), (1265), (1347), (1349), (1490) , (1612), (1614), (1629), (1632), (1634) , (1636), (1638), (1640), (1843)

db2profile (1262), (1264), (1346), (1348), (1489) , (1494), (1611), (1613), (1628), (1631) , (1633), (1635), (1637), (1639), (1842)

Script Center (913)

SDK Kit See Software Developer's Kit

security

for an instance (1003)

making DB2 Extended Enterprise Edition accessible (1238), (1327)

service entry

defining (1204), (1289)

setting

environment variables (1710)

setting configuration parameters (1522), (1783)

setting up client communications

using the Client Configuration Assistant (1504)

using the command line processor (1521)

setting up server communications

using the command line processor (1777)

using the Control Center (1773)

shared-nothing configuration

definition (959)

storage (971)

SMP See symmetric multiprocessor architecture

snapshot monitoring considerations (922)

software bundles

overview (1193)

using to install software (1194)

Software Developer's Kit

overview (937)

software requirements

communication protocols (1045), (1047), (1051)

DB2 Client Application Enabler (1048), (1066), (1069), (1082), (1086) , (1103), (1112), (1115), (1119), (1129) , (1137), (1146), (1154)

DB2 Connect (1049), (1052)

DB2 SDK (1046), (1053), (1067), (1070), (1076) , (1083), (1087), (1104), (1113), (1116) , (1120), (1130), (1138), (1147), (1155)

DB2 Universal Database (1044), (1050)

Net.Data (1068), (1071), (1088), (1105), (1121) , (1156)

Solstice HA

components (1922)

disk set (1927)

failover detection (1920)

failover support (1916)

hadb2eee.setup program (1944)

hot standby configuration (1929)

logical host (1924)

mutual takeover configuration (1931)

private network (1925)

public networks (1926)

resources (1923)

setting up (1933)

specifying list of machines for rah (1908)

SQL

access plans

viewing using Visual Explain (925)

starting

database manager (1619), (1622), (1848)

DB2 (1621)

stopping

DB2 (1624)

subagent

function (1022)

switch name

specifying alternative (1231), (1320)

symbolic link

system database directory restriction (1248), (1337)

system intention file restriction (1247), (1336)

symmetric multiprocessor architecture (994)

SYSADM (1181), (1281)

privileges

controlling (1590)

SYSADM_GROUP parameter (1589)

SYSCTRL (1592)

SYSMAINT (1593)

system configuration

with DB2 Connect (941)

with DB2 Universal Database (896)

system database directory

node considerations (1244), (1333)

symbolic link restrictions (1245), (1334)

system environment variables

DB2INSTANCE (1725)

db2instance (1727)

system intention file

symbolic link restrictions (1249), (1338)

SystemView LAN (1098)

table

in multinode nodegroup (987)

in single-node nodegroup (990)

maximum size (976)

TB (terabyte) (975)

TCP/IP

client (1535)

configuring (1540)

multiple interfaces on a host (1230), (1319)

preventing socket collisions (1543), (1800)

resolving host address (1804)

server (1795)

set with db2set (1761)

setting up client-to-server (1539)

software requirements (1075), (1081), (1085), (1099), (1110) , (1114), (1117), (1126), (1136), (1145)

supported to host systems (951)

supports only one-phase commit (1836)

supports SEARCH discovery (1832)

troubleshooting (1544), (1801)

temporary table spaces See IBMTEMPGROUP

terabyte (TB) (974)

Tools Setting (916)

transparent parallelism (966)

user privileges See privileges

username

naming rules (1973)

users

creating (1277)

using the command line processor (CLP)

cataloging a database (1355), (1550), (1571)

cataloging a node (1546), (1567)

connecting to a database (1512), (1552), (1573), (1582)

updating the database manager configuration (1802), (1811), (1818)

verifying the connection (1513)

utilities

binding (1680)

verifying the connection

using the Client Configuration Assistant (1516)

using the command line processor

IPX/SPX (1560), (1808)

TCP/IP (1537), (1798), (1817)

verifying the installation

client (1517)

Visual Explain

overview (921), (928)

well-known address

description (1016)

specifying in node configuration file (1225), (1314)

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

[ DB2 List of Books | Search the DB2 Books ]