Quick Beginnings for DB2 Connect Enterprise Edition

Index

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

Special Characters

.INI file

db2cli.ini (1782)

ODBC (1786)

Access Profile

creating (1968)

using (1966)

accessing data

through Net.Data or JDBC (919)

accessing host servers

configuring communications

SNAPlus for HP-UX (1211)

SunLink SNA for Solaris (1271)

accessing multiple servers (1552)

accessing servers

IPX/SPX (1621)

Named Pipes (1563)

NetBIOS (1561), (1602)

overview (1548)

TCP/IP (1579), (1589)

accounting information

sending to DRDA server (1643)

Administration Server

create (1137), (1764)

list (1761)

overview (1753)

remove (1767)

setup (1115)

start (1757), (1759)

Administrator name

valid names (1103)

admintool command (1878), (1918), (1948)

APPC

APPCLLU registry value (1357)

client (1642)

CPI-C side information (1374)

server (1450)

setting up communications for SPM (1350)

software requirements (961), (1009), (1025), (1034), (1043) , (1079), (1087), (1096)

support on AIX

Bull SNA (1203)

SNA Server (1199), (1200), (1204), (1205)

support on HP-UX

SNAplusLink (1212)

support on OS/2

Communications Manager for OS/2 (1018), (1179)

Communications Server for OS/2 (1017), (1178), (1354)

support on Solaris

SunLink SNA (1050), (1272), (1309)

support on Windows NT

Communications Server for Windows NT (1186), (1190)

Communications Server for Windows NT SNA Client (1194)

IBM Communications Server for NT (1171)

IBM Communications Server for NT SNA Client (1172)

Microsoft SNA Client (1198)

Wall Data Rumba (1170)

APPCLLU registry value (1363)

APPL (1246), (1299)

application development

using Net.Data or JDBC (922)

using ODBC (1773)

application programs

binding (1105), (1267)

application requester

steps to configure SPM (1342), (1346)

application server

configuring (1214)

application types

supported (908)

applications

binding (1323)

AS/400

configuring (1219)

AS/400 access

overview (952)

authentication

client (1164), (1460), (1687), (1737), (1740) , (1891), (1928), (1958)

DCS (1165), (1688), (1738), (1741), (1892) , (1929), (1959)

server (1163), (1364), (1393), (1686), (1736) , (1739), (1890), (1927), (1957)

authority

levels (1653), (1671)

authorization IDs

naming rules (1884)

bidirectional CCSID support (2038)

bidirectional language support (2036)

bind files and package names (2065)

binding

utilities and applications (1266), (1772)

book

road map (903)

cataloging

databases (1573), (1574), (1596), (1597), (1615) , (1616), (1636), (1637)

IPX/SPX node (1449), (1633), (1635)

Named Pipe node (1570), (1572)

NetBIOS node (1440), (1612), (1613)

TCP/IP node (1424), (1593), (1595)

CCSIDs (2027)

CD-ROM

installing DB2 Client Applications Enablers (1457), (1461)

installing DB2 Software Developer's Kit (1463), (1471)

installing DB2 Universal Database (1099), (1102)

changing privileges (1667)

character substitution (2034)

CICS for AIX

additional PPC gateway migration steps (1375)

COBOL (1376)

Client Application Enabler

installing (1468)

installing on OS/2 (1470)

installing on Windows 3.x (1478)

software requirements (974)

Client Configuration Assistant

administering clients communications (1545)

and DB2 setup (1755)

changing privileges (1660)

client profiles (1546)

exporting (1972)

using (1970)

discover (1975)

discovering databases (1547)

overview (913), (1169)

searching the network (1539), (1974)

setting configuration parameters (1838), (1980)

using access profiles (1967)

client profile

exporting (1971)

clients

configuring (1549)

installing (1465), (1469)

operating systems supported (1467)

overview (1458)

CLP See using the command line processor (CLP)

code page conversion exceptions (2033)

code page conversions (2017)

code pages (2028)

Coded Character Set Identifier (CCSID) (2018)

Command Center

entering DB2 commands (1789), (1791)

entering SQL statements (1790), (1792)

commands

admintool (1879), (1919), (1949), (1952)

connecting to logical node (1732), (1765)

dasicrt (1756)

dasidrop (1769)

db2admin (1758), (1760), (1768)

db2icrt (1677), (1681), (1691), (1887), (1925) , (1954)

db2idrop (1746), (1747), (1750)

db2ilist (1335), (1694)

db2imigr (1162), (1168)

db2iupdt (1730), (1734)

db2licd (1150), (1154)

db2ln (1534)

db2rmln (1898), (1935), (1965)

db2set (1406), (1714), (1762), (1797)

db2stop (1149), (1712), (1749)

db2_install (1937)

echo (1799), (1801)

groupadd (1517), (1923), (1953)

mkgroup (1882)

mkuser (1883)

mount (1505)

required to start SPM (1359)

rlogin (1132), (1509)

SAM, to add users (1922)

SAM, to update kernel (1120), (1122), (1494), (1496), (1913)

set (1800)

smit (1864), (1866), (1872)

swinstall (1904), (1906), (1908)

SYSADM (1518), (1519), (1880), (1920), (1950)

useradd (1520), (1924)

communication protocols

APPC (962), (968), (970), (981), (986) , (992), (1004), (1022), (1031), (1047) , (1074), (1082), (1091), (1175), (1451)

IPX/SPX (963), (987), (993), (1005), (1023) , (1032), (1049), (1056), (1064), (1075) , (1083), (1092), (1442), (1623), (1630)

Named Pipes (1006), (1065), (1076), (1084), (1093) , (1409), (1564)

NetBIOS (964), (1007), (1057), (1066), (1077) , (1085), (1094), (1426), (1603)

TCP/IP (969), (982), (988), (994), (999) , (1008), (1024), (1033), (1048), (1058) , (1067), (1078), (1086), (1095), (1415) , (1580)

configuring (1590)

configuring for DRDA host access (1991)

communications (1208)

configuring the client (1544), (1569), (1586), (1609), (1628)

configuring the server (1390), (1400)

managing (1395), (1553)

Client Configuration Assistant (1537)

Control Center (1391)

supported protocols

IPX/SPX (1446)

Named Pipes (1411), (1567)

NetBIOS (1429), (1606)

TCP/IP (1418), (1584), (1626)

Communications Server

required for SPM (1327)

Communications Server for Windows NT

configuring manually (1183), (1187)

version required (1184), (1188)

Communications Server for Windows NT SNA Client

configuring manually (1191)

version required (1192)

components

on UNIX operating systems (2044)

selecting (2043)

configuration (1209), (1269)

configuration parameters

dft_account_str (1646)

kernel (1911)

setting DB2 (1396), (1462), (1666), (1795), (1837)

setting kernel (1118)

SYSADM_GROUP (1658), (1661)

configuring

APPC (1453)

for OS/2 (1176)

host communications

overview (1174)

IPX/SPX (1625), (1629)

Named Pipes (1410), (1566)

NetBIOS (1428), (1604)

ODBC driver (1779), (1780)

steps to configure SNAPlus (1254)

steps to configure SunLink SNA (1306), (1308), (1311)

TCP/IP (1417), (1582)

configuring client communications

setting configuration parameters (1555), (1839)

using the Client Configuration Assistant (1543)

using the command line processor (1554)

configuring communications

overview (1559)

using Client Configuration Assistant (1538)

using Control Center (1386)

configuring server communications

setting DB2COMM (1201), (1206), (1402), (1969)

using the command line processor (1399)

using the Control Center (1389)

configuring servers (1387), (1397)

connecting to a database (1655)

connecting to the Internet using Net.Data (918), (924)

connections to DRDA hosts

direct to DRDA host (933)

overview of scenarios (930)

through communications gateway (934), (1990), (1992)

Control Center

changing privileges (1668)

Control Point LU

cannot be the SPM LU (1352)

control point name (1225), (1276)

controller address (1240), (1292)

conversion (2029)

conversion exceptions (2032)

country code page support (2024)

CPI-C side information (1373)

creating

instances (1140), (1678), (1682)

creating links for the DB2 libraries, installation (1931)

dasiupdt command (1733), (1766)

data conversion

CCSIDs (2025)

code pages (2026)

data conversion exceptions (2031)

Data Source Setup tool

changing MVS password with (2012)

data types supported by DB2 Connect Version 5.2 (928)

database

naming rules (2048)

database alias (1576), (1599), (1618), (1639)

naming rules (2047)

database manager

starting (1705)

stopping (1707)

database objects

naming rules (2052)

DB2 Client Application Enabler

installing

Windows 3.x (1479)

Windows 95 (1473)

Windows NT (1474)

overview (1459)

DB2 Client Application Enablers CD-ROM

installing clients from (1464)

DB2 Connect

configuring on OS/2 (1177)

overview (907), (910)

supported application types (909)

DB2 Connect Enterprise Edition

configuring to accept APPC clients (1456)

host communications

OS/2 (954), (956)

Windows NT (967)

operating systems supported (953), (966)

remote client support

OS/2 (960), (973)

software requirements (965)

when to use (935)

DB2 Extended Enterprise Edition

disk requirements (940)

DB2 for MVS/ESA

updating system tables (1987), (1988)

DB2 Installer See installation

DB2 libraries

creating links (1896), (1933), (1961), (1963)

DB2 library

books (2001)

Information Center (2010)

language identifier for books (2002)

late breaking information (2003)

online help (2000)

ordering printed books (2009)

printing PostScript books (2008)

searching online books (2007)

setting up document server (2005)

SmartGuides (1999)

structure of (1998)

viewing online books (2004)

DB2 server, definition (902)

db2 terminate command (1151)

DB2 Universal Database

components included

Client Configuration Assistant (912), (914)

DB2 Snapshot Monitor (920)

DAS considerations (1754)

getting started (1650)

installing on OS/2 (1101)

DB2 Workgroup Edition

disk requirements (939)

db2.ini file

environment keywords (1804)

DB2ACCOUNT (1649)

db2cli.ini (1781)

DB2COMM (1405)

db2comm environment variable (1317)

DB2DMNBCKCTLR

registry value (1811)

db2icrt command (1522), (1680), (1684), (1690), (1888) , (1889), (1926), (1955), (1956)

db2idrop command (1745), (1751)

db2ilist command (1336), (1696)

db2imigr command (1167)

DB2INSTANCE (1699), (1718)

db2iupdt command (1735)

db2ln command (1530), (1535)

DB2NBADAPTERS (1432)

db2profile script (1529), (1531)

db2rmln command (1897), (1934), (1964)

db2set command (1731), (1763)

using (1407), (1798)

db2stop command (1711), (1748)

DCS directory (1263), (1320)

developing applications

using Net.Data or JDBC (923)

dft_account_str (1647)

Discovery

choosing a discovery method (1976)

client configuration (1752)

searching the network (1973)

setting Discovery parameters (1979)

disk requirements

client (944)

server (943)

Distributed Computing Environment

software requirements (959), (972), (983), (989), (995) , (1012), (1053)

Distributed Relational Database Architecture (DRDA)

connections

configuring TCP/IP (1993)

DLC profile name (1278)

double-byte characters (2035)

DRDA

listing indoubt transactions (1368)

resolving indoubt transactions (1369)

DRDA server

configuring (1213)

sending accounting information (1644)

DRDA1 Application Server

running with DRDA2 (1362)

specifying a non-SPM LU (1356)

SPM must use the default LU name (1361)

EDUs used by SPM (1380)

Encina

coexistence with SPM (1377)

special considerations (1371)

enhancements in DB2 Connect Version 5.2 (927)

environment variables

DB2INSTANCE (1675), (1700), (1825)

db2instprof (1826)

db2path (1827)

db2profile script (1490)

setting (1526)

execs

db2uexit.exe (1156), (1159)

db2uext2.exe (1157), (1160)

files

bind files (2064)

db2systm (1743), (1744)

list files (2063)

restoring (1901)

filesets

choosing on AIX (1867), (2040)

choosing on HP-UX (2041)

choosing on Solaris (2042)

corresponding prerequisites (2045)

fixed disks

hardware requirements (945)

groups

creating (1916), (1946)

hardware requirements

fixed disk (946)

host character sets (2019)

indoubt transactions

listing (1366)

resolving (1367)

information

road map (904)

initialization file, ODBC (1785)

installation

CID using SystemView LAN (1109), (1858)

clients

AIX (1482), (1861), (1899)

HP-UX (1483)

Macintosh (1536)

OS/2 (1098), (1472), (1481)

SCO OpenServer (1514)

SINIX (1511)

Solaris (1484)

Windows 3.x (1480)

Windows 95 (1475)

Windows NT (1476)

creating links for DB2 libraries (1894)

DB2 Installer (1130), (1685)

DB2 server on UNIX systems

assigning groups and users (1516), (1877), (1915), (1945)

creating an instance (1521), (1886)

creating groups and users (1515), (1876), (1914), (1944)

creating links (1533), (1895), (1932), (1962)

DB2 Product Library (1874), (1905), (1938)

DB2 Product Messages (1875), (1907), (1939)

restoring product files (1900)

setting the DB2 operating environment (1523), (1524), (1525), (1689), (1893) , (1930), (1960)

updating kernel components (1116), (1121), (1123), (1487), (1491) , (1492), (1493), (1495), (1497), (1498) , (1513), (1909), (1940), (1943)

disk requirements (1113)

client (941)

server (942)

errors (1107), (1856)

log (1108), (1857)

memory requirements (1112)

mounting the CD-ROM (1124), (1125), (1499), (1500)

AIX (1126), (1133), (1501), (1502)

HP-UX (1127), (1128), (1134), (1503), (1504)

mount point (1111), (1485)

SINIX (1512)

Solaris (1129), (1135), (1506), (1507)

remote (1131), (1508)

servers

AIX (1860)

HP-UX (1902), (1936)

OS/2 (1100)

unattended

OS/2 (1844), (1848)

Windows 3.x (1845)

Windows 95 (1853)

Windows NT (1854)

UNIX installations

using DB2 Installer (1138)

using installp (1863), (1865)

using SMIT (1862), (1868), (1873)

instances

autostarting (1713)

creating (1136), (1139), (1510), (1679), (1683)

creating multiple (1142), (1673)

creating the default (1674)

definition (1672)

listing (1695)

naming restrictions (1114), (1486), (1692), (2058)

removing (1742)

selecting (1697)

setting operating environment (1715)

SPM instance creation (1334)

starting (1703)

stopping (1704), (1710)

updating (1729)

IPX/SPX

client (1622)

configuring (1631)

server (1444)

software requirements (1010), (1027), (1036), (1052), (1059) , (1068)

supported platforms (1447), (1632)

verifying the connection (1578), (1601), (1620), (1641)

Java Support (926)

Java, running programs (1788)

JDBC See Java Support

JDBC, running programs (1787)

kernel configuration parameters

updating (1117), (1488), (1910), (1941)

LANG environment variable (2016), (2021)

language support (2013)

link station profile name (1237), (1289)

list files (2066)

local adapter address (1239), (1291)

local control point name (1244), (1294)

local LU alias (1232), (1284)

local LU name (1230), (1282)

LOCATION (MVS) (1251), (1303)

logging off the system (1652)

logging on to the system (1651)

Logical LAN Adapter Number (Lana Number)

default value (1436)

LU (1231), (1283)

LU 6.2 Syncpoint Manager

prerequisites (1326)

managing connections

client

overview (915), (1557)

using the Client Configuration Assistant (911), (1541)

using the command line processor (1556)

server

overview (916)

using the Client Configuration Assistant (1542)

using the Command Line Processor (1401), (1558)

manuals See book

memory requirements

estimating (938)

Microsoft ODBC Driver Manager (1776)

Microsoft SNA Client

configuring (1196)

version required (1197)

Microsoft SNA Server

version required (1097)

migration

data (1152)

DB2 Version 2.x (1143), (1145)

instance (1147), (1153), (1161), (1166)

post-installation (1146), (1148)

previous releases (1144)

user exit program (1155), (1158)

mode name (1228), (1236), (1280), (1288)

MODEENT (1229), (1281)

MVS

configuring (1215)

Named Pipes

client (1562)

configuring (1560)

server (1408)

software requirements (1013), (1071)

naming rules

authorization IDs (1885)

database (2049)

database alias (2050)

database objects (2051)

general (2046)

groups (2054)

instance names (2056)

password (2061)

userids (2053)

username (1104), (1477), (2055)

workstation name (nname) (2060)

National language support (2030)

National Language Support (NLS)

national language support (NLS)

bidirectional CCSID support (2037)

code set (2020)

codepage support (2022)

configuring (2014)

determining codepage (2023)

Nbf

network route required by DB2 (1438)

Net.Data (1016)

overview (921), (925)

NetBIOS

autostarting NetBIOS (1441)

on the client (1011), (1060), (1069), (1608), (1610)

on the server (1394), (1431)

supports SEARCH discovery (1978)

Netfinity Server (955), (1014)

network ID (1224), (1235), (1275), (1287)

network name (1223), (1234), (1274), (1286)

network route

setting to Nbf (1435), (1437)

network scenarios (931)

new data types supported by DB2 Connect Version 5.2 (929)

NLS See National Language Support (NLS)

node directory (1261), (1318)

ODBC

odbc.ini file (1783)

odbcinst.ini file (1784)

registering the driver manager (1778)

running ODBC-enabled applications

running programs (1774)

odbcad32.exe (1775)

operating systems

server (1466)

OS/400

commands

DSPNETA (1994)

DSPRDBDIRE (1997)

WRKLIND (1180), (1995)

WRKMODD (1181), (1996)

configuring (1218)

parameters

kernel configuration (1912)

setting kernel configuration (1119), (1489), (1942)

SYSADM_GROUP (1657), (1659), (1662)

partner CP name (1242), (1295)

partner LU name (1245), (1298)

password

changing on MVS (2011)

naming rules (2062)

planning

DB2 configuration (937)

DB2 Connect configuration (936)

privileges

required (1663)

product

components (1110), (1141), (2039)

descriptions (906)

overview (905)

product files, restoring (1903)

profile registry

using (1796)

protocols

APPC (1452)

IPX/SPX (1443), (1624)

Named Pipes (1413), (1565)

NetBIOS (1427), (1605)

TCP/IP (1420), (1581)

PU (1226), (1277)

RDB_NAME (VSE or VM) (1252), (1304)

registering

ODBC driver manager (1777)

registry value

DB2DMNBCKCTLR (1812)

registry values

DB2ACCOUNT (1645)

db2account (1648), (1806)

db2clientadpt (1832)

db2clientcomm (1831)

db2codepage (1807)

DB2COMM (1404)

db2comm (1202), (1207), (1403), (1828)

db2country (1808)

db2dbdft (1809)

db2dirpathname (1830)

db2discoverytime (1810)

db2include (1814)

DB2INSTDEF (1709)

db2instdef (1676), (1708), (1815)

db2libpath (1816)

DB2NBADAPTERS (1434)

db2nbadapters (1433)

db2netreq (1813)

db2options (1817)

db2route (1833)

db2slogon (1818)

db2timeout (1819)

db2tracename (1820)

db2traceon (1821)

db2trcflush (1822)

db2trcsyserr (1823)

db2yield (1824)

dsmi_config (1834)

dsmi_dir (1835)

dsmi_log (1836)

general (1805)

setting (1794)

relational database name (1249), (1301)

remote installation

OS/2 (1851)

Netfinity Server (1852)

remote link address (1238), (1290)

remote transaction program (1248), (1300)

response files

OS/2 (1847)

Windows 3.x (1846)

Windows 32-bit operating systems (1855)

restoring product files, installation (1869)

restrictions

instance name (1693), (2057)

running applications

database client (1770)

ODBC considerations

script

db2cshrc (1528), (1717), (1720), (1722), (1724) , (1726), (1728), (1803)

db2profile (1527), (1532), (1716), (1719), (1721) , (1723), (1725), (1727), (1802)

SDK Kit See Software Developer's Kit

selecting an instance (1698), (1706)

setting

environment variables (1793)

setting configuration parameters (1398), (1551)

setting up client communications

using the Client Configuration Assistant (1540)

using the command line processor (1550)

setting up document server (2006)

setting up server communications

using the command line processor (1392)

using the Control Center (1388)

SNA

configuring Communications Server for Windows NT manually (1185), (1189)

configuring Communications Server for Windows NT SNA Client manually (1193)

configuring Microsoft SNA Client manually on Windows (1195)

starting the SNAPlus subsystem (1258)

steps to configure SNAPlus (1253)

steps to configure SunLink SNA (1305), (1307), (1312)

snapconfig program (1256)

description (1310)

snapmanage (1260), (1316)

software bundles

overview (1870)

using to install software (1871)

Software Developer's Kit

overview (917)

software requirements

communication protocols (948), (950)

DB2 Client Application Enabler (975), (978), (997), (1001), (1019) , (1028), (1037), (1040), (1044), (1054) , (1062), (1072), (1080), (1088)

DB2 Connect (947), (949), (951)

DB2 SDK (976), (979), (985), (991), (998) , (1002), (1020), (1029), (1038), (1041) , (1045), (1055), (1063), (1073), (1081) , (1089)

Net.Data (977), (980), (1003), (1021), (1030) , (1046), (1090)

SPM_LOG_FILE_SIZE (1381)

SQL/DS

configuring (1220)

SSCP (1243), (1296)

starting the SNAplus subsystem (1259)

steps for configuration (1210), (1270)

steps to configure SNAplus (1255)

SunLink SNA subsystem

checking status (1315)

starting (1313)

stopping (1314)

symbolic destination name (1241), (1264), (1293), (1321)

Syncpoint Manager (SPM)

cannot use the CP name LU (1351)

coexistence with Encina (1378)

configuring manually (1349)

database naming rule (1339)

EDUs used by (1379)

enabling (1983)

if the TM database is remote (1338), (1344), (1347)

logging (1329), (1382)

memory utilization (1384)

migration (1370)

performance (1383)

prerequisites (958), (1325)

problem determination (1385)

registering the SPM LU (1355)

resolving indoubt transactions (1365)

restriction (1360)

setting the SPM_NAME (1328), (1353)

SQL30081N error on DRDA1 calls (1358)

stopping and starting (1341), (1345), (1348)

supercedes Encina PPC gateway function (1372)

SYSADM (1881), (1921), (1951)

privileges

controlling (1665)

SYSADM_GROUP parameter (1656), (1664)

SYSCTRL (1669)

SYSMAINT (1670)

system database directory (1262), (1319)

system environment variables

DB2INSTANCE (1701)

system management (1702)

target database name (1250), (1265), (1302), (1322)

TCP/IP

client (1583)

configuring (1588)

configuring DB2 for OS/390 for (1981)

configuring host connections (932), (1173), (1989)

preventing socket collisions (1421), (1591)

resolving host address (1425)

server (1416)

set with db2set (1829)

setting up client-to-server (1587)

software requirements (957), (971), (984), (990), (996) , (1000), (1015), (1026), (1035), (1039) , (1042), (1051), (1061), (1070)

supports SEARCH discovery (1977)

troubleshooting (1422), (1592)

territory (2015)

TM database

database naming rule (1340)

if remote from the SPM (1337), (1343)

token ring profile name (1227), (1279)

transaction manager

database (1331), (1332)

name must match database name and alias (1333)

unattended installation

OS/2 (1849)

Netfinity Server (1850)

Windows 32-bit operating systems

Server Management System (SMS) (1859)

user privileges See privileges

User Profile Management (UPM)

adding users (1842)

administering users (1840)

logon command (1841)

passwords (1843)

username

naming rules (2059)

users

creating (1917), (1947)

using the command line processor (CLP)

cataloging a database (1575), (1598), (1617), (1638)

cataloging a node (1571), (1594), (1614), (1634)

connecting to a database (1577), (1600), (1619), (1640), (1654)

updating the database manager configuration (1423), (1439), (1448), (1455), (1611)

utilities

binding (1106), (1268), (1324), (1771)

values for SNAplus (1257)

verifying the connection

using the command line processor

IPX/SPX (1445), (1627)

Named Pipes (1412), (1414), (1568)

NetBIOS (1430), (1607)

TCP/IP (1419), (1454), (1585)

configuring (1217)

VSE

configuring (1216)

VTAM

application name is Partner LU name (1247), (1297)

DB2 Connect uses independent LU (1182)

sample definitions (1982)

sample logon mode table entry (1986)

sample PU and LU definitions (1985)

SYNCLVL=SYNCPT (1330), (1984)

WRKLIND command (OS/400) (1221)

WRKMODD command (OS/400) (1222)

XID node ID (1233), (1273), (1285)

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

[ DB2 List of Books | Search the DB2 Books ]