Installation and Configuration Supplement
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
A
Access Profile
creating
(979)
using
(977)
accessing DB2 servers
configuring communications
IBM eNetwork Communication Server V5 for AIX
(1121)
IBM Personal Communications for Windows 32-Bit Operating Systems
(1101)
SNAplus2 for HP-UX
(1128)
SunLink SNA PU 2.1 for Solaris
(1134)
accessing host servers
configuring communications
IBM eNetwork Communication Server V5 for AIX
(1408)
IBM Personal Communications for Windows 32-Bit Operating Systems
(1113), (1389), (1401)
SNA API Client
(1105), (1393)
SNAplus2 for HP-UX
(1415)
SunLink SNA PU 2.1 for Solaris
(1421)
accessing multiple servers
(988)
accessing servers
IPX/SPX
(1053)
Named Pipes
(999)
NetBIOS
(997), (1035)
overview
(984)
TCP/IP
(1013), (1023), (1321), (1331)
Administering Satellites Guide and Reference
(1706)
Administration Guide
(1686)
Administrative API Reference
(1687)
admintool command
(1499), (1535), (1561)
APPC
APPCLLU registry value
(1456)
server
(1217)
setting up communications for SPM
(1449)
software requirements
(884), (914), (923)
support on AIX
Bull SNA
(1125), (1412)
support on HP-UX
SNAplusLink
(1102), (1106), (1114), (1122), (1129)
, (1135), (1390), (1394), (1402), (1409)
, (1416), (1422)
support on OS/2
Communications Manager for OS/2
(893), (1098), (1233), (1386)
Communications Server for OS/2
(892), (1097), (1232), (1385), (1453)
support on Solaris
SunLink SNA
(903)
support on Windows NT
Communications Server for Windows NT SNA Client
(1110), (1398)
Microsoft SNA Client
(1118)
verifying the connection
(1152)
APPC, CPI-C and SNA Sense Codes
(1689)
APPCLLU registry value
(1462)
APPENDAPINAME, keyword
(1255)
APPL
(1363)
Application Building Guide
(1688)
application development
using ODBC
(1239)
Application Development Guide
(1690)
application requester
steps to configure SPM
(1446)
application server
configuring
(1353)
AS/400
configuring
(1358)
ASYNCENABLE, keyword
(1256)
Asynchronous ODBC, enabling
(1257)
authentication
server
(1160)
authorization IDs
naming rules
(1505)
B
binding
utilities and applications
(1236)
BITDATA, keyword
(1258)
C
cataloging
APPC node
(1144), (1146), (1431), (1433)
databases
(1009), (1010), (1030), (1031), (1048)
, (1049), (1068), (1069), (1147), (1148)
, (1338), (1340), (1341), (1434), (1436)
, (1437)
IPX/SPX node
(1065), (1067), (1216)
Named Pipe node
(1006), (1008)
NetBIOS node
(1045), (1046), (1207)
nodes
in a federated environment
(1592)
TCP/IP node
(1027), (1029), (1191), (1335), (1337)
CD-ROM
installing DB2 Software Developer's Kit
(936)
installing DB2 Universal Database
(939)
CLI Guide and Reference
(1691)
Client Configuration Assistant
administering clients communications
(975)
changing privileges
(1663)
client profiles
(976)
exporting
(983)
using
(981)
searching the network
(969)
using access profiles
(978)
client profile
exporting
(982)
clients
configuring
(985)
installing
(926)
CLISCHEMA, keyword
(1259)
Command Center
entering DB2 commands
(1657)
entering SQL statements
(1658)
Command Reference
(1692)
commands
admintool
(1500), (1536), (1562), (1565)
db2icrt
(1508), (1542), (1567)
db2imigr
(1678), (1681)
db2licd
(1676)
db2rmln
(1514), (1548), (1573)
db2set
(1173)
db2_install
(1550)
groupadd
(1540), (1566)
mkgroup
(1503)
mkuser
(1504)
mount
(962)
required to start SPM
(1458)
rlogin
(966)
SAM, to add users
(1539)
SAM, to update kernel
(1530)
smit
(1485), (1487), (1493)
swinstall
(1520), (1522), (1524), (1525)
SYSADM
(1501), (1537), (1563)
useradd
(1541)
communication protocols
APPC
(860), (865), (871), (879), (900)
, (909), (918), (1073), (1094), (1218)
, (1229), (1346), (1382)
IPX/SPX
(866), (872), (880), (902), (910)
, (919), (1055), (1062), (1209)
Named Pipes
(881), (911), (920), (1000), (1176)
NetBIOS
(882), (912), (921), (1036), (1193)
TCP/IP
(861), (867), (873), (883), (901)
, (913), (922), (1014), (1182), (1322)
configuring
(1024), (1332)
communications
configuring the client
(974), (1005), (1020), (1042), (1060)
, (1077), (1328), (1350)
configuring the server
(1157), (1167)
managing
(989), (1162)
Client Configuration Assistant
(967)
Control Center
(1158)
supported protocols
APPC
(1075), (1348)
IPX/SPX
(1213)
Named Pipes
(1003), (1178)
NetBIOS
(1039), (1196)
TCP/IP
(1018), (1058), (1185), (1326)
Communications Server
required for SPM
(1442)
Communications Server for Windows NT SNA Client
configuring manually
(1107), (1395)
version required
(1108), (1396)
components
on UNIX operating systems
(1579)
selecting
(1578)
configuration
(1099), (1103), (1111), (1119), (1126)
, (1132), (1387), (1391), (1399), (1406)
, (1413), (1419)
configuration parameters
kernel
(1528)
setting DB2
(1163), (1669)
SYSADM_GROUP
(1661), (1664)
configuring
APPC
(1074), (1220), (1347)
for OS/2
(1095), (1230), (1383)
IPX/SPX
(1057), (1061)
Named Pipes
(1002), (1177)
NetBIOS
(1037), (1195)
ODBC driver
(1245), (1246)
steps to configure SNAPlus
(1124), (1131), (1137), (1411), (1418)
, (1424)
steps to configure SunLink SNA
(1138), (1425)
TCP/IP
(1016), (1184), (1324)
configuring client communications
setting configuration parameters
(991)
using the Client Configuration Assistant
(973)
using the command line processor
(990)
configuring communications
overview
(995)
using Client Configuration Assistant
(968)
using Control Center
(1153)
configuring server communications
setting DB2COMM
(980), (1169)
using the command line processor
(1166)
using the Control Center
(1156)
configuring servers
(1154), (1164)
Connectivity Supplement
(1696)
CONNECTNODE, keyword
(1261)
CONNECTTYPE, keyword
(1264)
Control Point LU
cannot be the SPM LU
(1451), (1464), (1467)
control point name
(1088), (1222), (1376)
CREATE NICKNAME statement
for DB2 family data sources
(1613)
for Oracle data sources
(1651)
CREATE SERVER statement
for DB2 family data sources
(1605)
for Oracle data sources
(1641)
CREATE USER MAPPING statement
for DB2 family data sources
(1609)
for Oracle data sources
(1647)
CREATE WRAPPER statement
for DB2 family data sources
(1597)
for Oracle data sources
(1632)
creating links for the DB2 libraries, installation
(1544)
CURRENTFUNCTIONPATH, keyword
(1265)
CURRENTPACKAGESET, keyword
(1266)
CURRENTREFRESHAGE, keyword
(1267)
CURRENTSCHEMA, keyword
(1270)
CURRENTSQLID, keyword
(1272)
CURSORHOLD, keyword
(1273)
D
Data Movement Utilities Guide and Reference
(1693)
database
naming rules
(1737)
database alias
(1339), (1343), (1435), (1439)
naming rules
(1736)
database objects
naming rules
(1741)
DB2 client
installing
(925)
Windows 9x
(927)
Windows NT
(928)
installing on OS/2
(935)
software requirements
(853)
DB2 Connect
configuring on OS/2
(1096), (1231), (1384)
DB2 Connect Enterprise Edition
configuring to accept APPC clients
(1228)
DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings
(1713)
DB2 Connect Enterprise Edition for UNIX Quick Beginnings
(1714)
DB2 Connect Personal Edition Quick Beginnings
(1694)
DB2 Connect User's Guide
(1695)
DB2 Data Links Manager for AIX Quick Beginnings
(1715)
DB2 Data Links Manager for Windows NT Quick Beginnings
(1716)
DB2 Enterprise - Extended Edition
disk requirements
(836)
DB2 Enterprise - Extended Edition for UNIX Quick Beginnings
(1711)
DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings
(1712)
DB2 family data sources in a federated system
cataloging nodes
(1591)
creating nicknames
(1611)
creating server mappings
(1603)
creating user mappings
(1607)
creating wrappers
(1595)
setting DB2_DJ_COMM
(1599)
verifying connections
(1614)
DB2 libraries
creating links
(1512), (1546), (1569), (1571)
DB2 library
books
(1685)
Information Center
(1723)
language identifier for books
(1720)
late-breaking information
(1721)
online help
(1684)
ordering printed books
(1728)
printing PostScript books
(1727)
searching online information
(1726)
setting up document server
(1724)
SmartGuides
(1683)
structure of
(1682)
viewing online information
(1722)
DB2 Personal Edition Quick Beginnings
(1707)
DB2 Query Patroller Administration Guide
(1717)
DB2 Query Patroller Installation Guide
(1718)
DB2 Query Patroller User's Guide
(1719)
db2 terminate command
(1673)
DB2 Universal Database
software requirements
(843)
DB2 Workgroup Edition
disk requirements
(835)
db2cli.ini
(1247)
DB2COMM
(1172)
DB2CONNECTVERSION, keyword
(1274)
DB2DEGREE, keyword
(1275)
DB2DJ.ini file
(1624)
db2djlink.sh script
(1621)
DB2ESTIMATE, keyword
(1277)
DB2EXPLAIN, keyword
(1278)
db2icrt command
(1509), (1543), (1568)
db2imigr command
(1680)
DB2NBADAPTERS
(1199)
DB2NODE
(1262)
DB2OPTIMIZATION, keyword
(1279)
db2rmln command
(1513), (1547), (1572)
db2set command
using
(1174)
DB2_DJ_COMM environment variable
setting for DB2 family data sources
(1600)
setting for Oracle data sources
(1637)
DBALIAS, keyword
(1280)
DBNAME, keyword
(1281)
DEFAULTPROCLIBRARY, keyword
(1283)
DEFERREDPREPARE, keyword
(1284)
DISABLEMULTITHREAD, keyword
(1285)
disk requirements
client
(840)
server
(839)
Distributed Computing Environment
software requirements
(862), (868), (874), (887), (906)
DRDA
listing indoubt transactions
(1472)
resolving indoubt transactions
(1473)
DRDA server
configuring
(1352)
DRDA1 Application Server
running with DRDA2
(1461)
specifying a non-SPM LU
(1455)
SPM must use the default LU name
(1460)
E
EARLYCLOSE, keyword
(1286)
environment variables
db2profile script
(950)
setting for DB2 family data sources
(1601)
setting for Oracle data sources
(1623)
F
federated database system
data sources, supported
(1585)
DB2 family data sources
cataloging nodes
(1590)
creating nicknames
(1610)
creating server mappings
(1602)
creating user mappings
(1606)
creating wrappers
(1594)
setting DB2_DJ_COMM
(1598)
installation considerations
(1586), (1615)
Oracle data sources
creating nicknames
(1648)
creating server mappings
(1638)
creating user mappings
(1644)
creating wrappers
(1629)
setting DB2_DJ_COMM
(1635)
overview
(1584)
files
restoring
(1517)
filesets
choosing on AIX
(1488), (1575)
choosing on HP-UX
(1576)
choosing on Solaris
(1577)
fixed disks
hardware requirements
(841)
G
Glossary
(1697)
GRANTEELIST, keyword
(1287)
GRANTORLIST, keyword
(1288)
GRAPHIC, keyword
(1289)
groups
creating
(1533), (1559)
H
hardware requirements
fixed disk
(842)
I
IGNOREWARNINGS, keyword
(1290)
IGNOREWARNLIST, keyword
(1291)
IN DATABASE command
(1282)
indoubt transactions
listing
(1470)
resolving
(1471)
initialization file, ODBC
(1251)
installation
CID using SystemView LAN
(934), (943)
clients
AIX
(944), (1482), (1515)
HP-UX
(945)
OS/2
(937), (938)
Solaris
(946)
Windows 9x
(929)
Windows NT
(930)
creating links for DB2 libraries
(1510)
DB2 server on UNIX systems
assigning groups and users
(1498), (1532), (1558)
creating an instance
(1507)
creating groups and users
(1497), (1531), (1557)
creating links
(1511), (1545), (1570)
DB2 Product Library
(1495), (1521), (1551)
DB2 Product Messages
(1496), (1523), (1552)
restoring product files
(1516)
updating kernel components
(947), (951), (952), (953), (954)
, (1526), (1553), (1556)
disk requirements
client
(837)
server
(838)
distributed join option
(1587), (1616)
errors
(932), (941)
federated database system considerations
(1588), (1617)
log
(933), (942)
memory requirements
client
(828)
server
(827)
mounting the CD-ROM
(955), (956)
AIX
(957), (958)
HP-UX
(959), (960), (961)
Solaris
(963), (964)
remote
(965)
servers
AIX
(1481)
HP-UX
(1518), (1549)
OS/2
(940)
unattended
OS/2
(1580)
Windows 3.x
(1581)
UNIX installations
using installp
(1484), (1486)
using SMIT
(1483), (1489), (1494)
Installation and Configuration Supplement
(1698)
instances
naming restrictions
(1747)
IPX/SPX
client
(1054)
configuring
(1063)
server
(1211)
software requirements
(885), (905)
supported platforms
(1064), (1214)
verifying the connection
(1034), (1052), (1072), (1151), (1345)
J
Java, running programs
(1254)
JDBC, running programs
(1253)
K
KEEPCONNECT, keyword
(1292)
KEEPSTATEMENT, keyword
(1293)
kernel configuration parameters
updating
(948), (1527), (1554)
L
LANG environment variable
(1732)
LOBMAXCOLUMNSIZE, keyword
(1294)
local adapter address
(1087), (1375)
local control point name
(1082), (1365)
local LU name
(1090), (1224), (1378)
LOCATION NAME (MVS, OS/390)
(1370)
Logical LAN Adapter Number (Lana Number)
default value
(1203)
LONGDATACOMPAT, keyword
(1295)
LU
(1091), (1225), (1379)
LU 6.2 Syncpoint Manager
prerequisites
(1441)
M
managing connections
client
overview
(993)
using the Client Configuration Assistant
(971)
using the command line processor
(992)
server
using the Client Configuration Assistant
(972)
using the Command Line Processor
(994), (1168)
MAXCONN, keyword
(1296)
memory requirements
client
(830)
estimating
(833)
recommended
(834)
server
(829)
Message Reference
(1699)
Microsoft ODBC Driver Manager
(1242)
Microsoft SNA Client
configuring
(1116), (1404)
version required
(1117), (1405)
Microsoft SNA Server
version required
(924)
migration
data
(1674)
DB2 Version 2.x
(1670)
instance
(1675), (1677), (1679)
post-installation
(1671), (1672)
mode name
(1085), (1226), (1372)
MODE, keyword
(1297)
MODEENT
(1227), (1373)
MULTICONNECT, keyword
(1298)
MVS
configuring
(1354)
N
Named Pipes
client
(998)
configuring
(996)
server
(1175)
software requirements
(888)
naming rules
authorization IDs
(1506)
database
(1738)
database alias
(1739)
database objects
(1740)
general
(1735)
groups
(1743)
instance names
(1745)
password
(1750)
userids
(1742)
username
(931), (1744)
workstation name (nname)
(1749)
National Language Support (NLS)
code set
(1730), (1731)
codepage support
(1729), (1733)
determining codepage
(1734)
Oracle code page options
(1654)
Nbf
network route required by DB2
(1205)
Net.Data
(891)
net8 wrapper
(1634)
NetBIOS
autostarting NetBIOS
(1208)
on the client
(886), (1041), (1043)
on the server
(1161), (1198)
Netfinity Server
(889)
network ID
(1080), (1361)
network name
(1079), (1360)
network route
setting to Nbf
(1202), (1204)
nicknames
for DB2 family data sources
(1612)
for Oracle data sources
(1650)
nodes
cataloging in a federated environment
(1593)
O
ODBC
catalog for DB2 Connect
(1260)
odbc.ini file
(1249)
odbcinst.ini file
(1250)
registering the driver manager
(1244)
running ODBC-enabled applications
(1237)
running programs
(1240)
odbcad32.exe
(1241)
optimize for N rows
configuration keyword
(1300)
OPTIMIZEFORNROWS, keyword
(1299)
OPTIMIZESQLCOLUMNS, keyword
(1301)
Oracle data sources
code page options
(1655)
creating nicknames
(1649)
creating server mappings
(1639)
creating user mappings
(1645)
creating wrappers
(1630)
installing client software
(1619)
linking to client libraries
(1620)
setting DB2_DJ_COMM
(1636)
setting environment variables
(1622)
tnsnames.ora file
(1643), (1653)
verifying connections
(1656)
ORACLE_BASE
(1626)
ORACLE_HOME
(1625)
ORA_NLS
(1627)
OS/400
configuring
(1357)
P
Parallelism, Setting degree of
(1276)
parameters
FEDERATED
(1589), (1618)
kernel configuration
(1529)
setting kernel configuration
(949), (1555)
SYSADM_GROUP
(1660), (1662), (1665)
partner LU name
(1081), (1362)
partner node name
(1366)
password
naming rules
(1751)
PATCH1, keyword
(1302)
PATCH2, keyword
(1303)
planning
DB2 configuration
(831)
DB2 Connect configuration
(832)
POPUPMESSAGE, keyword
(1304)
privileges
required
(1666)
product
components
(1574)
product files, restoring
(1519)
protocols
APPC
(1078), (1219), (1351)
IPX/SPX
(1056), (1210)
Named Pipes
(1001), (1180)
NetBIOS
(1038), (1194)
TCP/IP
(1015), (1187), (1323)
PU
(1089), (1223), (1377)
PWD, keyword
(1305)
Q
Quick Beginnings for OS/2
(1708)
Quick Beginnings for UNIX
(1709)
Quick Beginnings for Windows NT
(1710)
R
RDB_NAME (VSE or VM)
(1371)
REFRESH DEFERRED
(1268)
REFRESH IMMEDIATE
(1269)
registering
ODBC driver manager
(1243)
registry values
db2comm
(1170), (1171)
db2nbadapters
(1200), (1201)
relational database name
(1083), (1368)
remote link address
(1086), (1374)
remote transaction program
(1093), (1381)
Replication Guide and Reference
(1700)
response files
OS/2
(1583)
Windows 3.x
(1582)
restoring product files, installation
(1490)
restrictions
instance name
(1746)
running applications
database client
(1234)
ODBC considerations
(1238)
S
SCHEMALIST, keyword
(1306)
server mappings
for DB2 family data sources
(1604)
for Oracle data sources
(1640)
SET CURRENT SCHEMA
(1271)
setting configuration parameters
(987), (1165)
setting up client communications
using the Client Configuration Assistant
(970)
using the command line processor
(986)
setting up document server
(1725)
setting up server communications
using the command line processor
(1159)
using the Control Center
(1155)
SNA
configuring Communications Server for Windows NT SNA Client manually
(1109), (1397)
configuring Microsoft SNA Client manually on Windows
(1115), (1403)
steps to configure SNAPlus
(1123), (1130), (1136), (1410), (1417)
, (1423)
steps to configure SunLink SNA
(1139), (1426)
snapmanage
(1143), (1430)
software bundles
overview
(1491)
using to install software
(1492)
software requirements
communication protocols
(845), (847), (851)
DB2 client
(848), (854), (857), (876), (894)
, (897), (907), (915)
DB2 Connect
(849), (850), (852)
DB2 Software Developer's Kit
(846), (855), (858), (864), (870)
, (877), (895), (898), (908), (916)
DB2 Universal Database
(844)
Net.Data
(856), (859), (878), (899), (917)
SPM_LOG_FILE_SIZE
(1475)
SQL Getting Started
(1701)
SQL Reference
(1702)
SQL/DS
configuring
(1359)
sqlnet wrapper
(1633)
SQLSTATEFILTER, keyword
(1307)
SSCP
(1367)
steps for configuration
(1100), (1104), (1112), (1120), (1127)
, (1133), (1388), (1392), (1400), (1407)
, (1414), (1420)
SunLink SNA subsystem
checking status
(1142), (1429)
starting
(1140), (1427)
stopping
(1141), (1428)
symbolic destination name
(1092), (1380)
Syncpoint Manager (SPM)
cannot use the CP name LU
(1450), (1463), (1466)
configuring manually
(1448)
logging
(1444), (1476)
memory utilization
(1478)
migration
(1474)
performance
(1477)
prerequisites
(1440)
problem determination
(1479)
registering the SPM LU
(1454)
resolving indoubt transactions
(1469)
restriction
(1459)
setting the SPM_NAME
(1443), (1452), (1465), (1468)
SQL30081N error on DRDA1 calls
(1457)
stopping and starting
(1447)
SYNCPOINT, keyword
(1308)
SYSADM
(1502), (1538), (1564)
privileges
controlling
(1668)
SYSADM_GROUP parameter
(1659), (1667)
SYSSCHEMA, keyword
(1309)
System Monitor Guide and Reference
(1703)
T
TABLETYPE, keyword
(1310)
target database name
(1084), (1369)
target logical node
(1263)
TCP/IP
client
(1017), (1325)
configuring
(1022), (1330)
preventing socket collisions
(1025), (1188), (1333)
resolving host address
(1192)
server
(1183)
setting up client-to-server
(1021), (1329)
software requirements
(863), (869), (875), (890), (896)
, (904)
supports only one-phase commit
(1480)
troubleshooting
(1026), (1189), (1334)
TEMPDIR, keyword
(1311)
tnsnames.ora file
(1642), (1652)
TNS_ADMIN
(1628)
TRACE, keyword
(1312)
TRACECOMM, keyword
(1313)
TRACEFILENAME, keyword
(1314)
TRACEFLUSH, keyword
(1315)
TRACEPATHNAME, keyword
(1316)
transaction manager
database
(1445)
Troubleshooting Guide
(1704)
TXNISOLATION, keyword
(1317)
U
UID, keyword
(1318)
UNDERSCORE, keyword
(1319)
user mappings
for DB2 family data sources
(1608)
for Oracle data sources
(1646)
username
naming rules
(1748)
users
creating
(1534), (1560)
using the command line processor (CLP)
cataloging a database
(1011), (1032), (1050), (1070), (1149)
, (1342), (1438)
cataloging a node
(1007), (1028), (1047), (1066), (1145)
, (1336), (1432)
connecting to a database
(1012), (1033), (1051), (1071), (1150)
, (1344)
updating the database manager configuration
(1044), (1190), (1206), (1215)
utilities
binding
(1235)
V
verifying the connection
using the command line processor
APPC
(1076), (1349)
IPX/SPX
(1059), (1212)
Named Pipes
(1004), (1179), (1181)
NetBIOS
(1040), (1197)
TCP/IP
(1019), (1186), (1221), (1327)
VM
configuring
(1356)
VSE
configuring
(1355)
VTAM
application name is Partner LU name
(1364)
W
WARNINGLIST, keyword
(1320)
What's New
(1705)
wrappers
for DB2 family data sources
(1596)
for Oracle data sources
(1631)
[ Top of Page | Previous Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]