Quick Beginnings for DB2 Universal Database for UNIX

Index

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

Special Characters

.INI file

db2cli.ini (1255)

ODBC (1259)

Access Profile

creating (1493)

using (1491)

accessing data

through DB2 Connect (699)

through Net.Data or JDBC (704)

accessing multiple servers (659), (1074)

accessing servers

IPX/SPX (1105)

overview (1070)

TCP/IP (1082), (1092)

Administration Server

create (907), (1235)

list (1232)

overview (678), (1224)

remove (1238), (1521)

setup (885)

start (1228), (1230), (1509)

stop (1511)

admintool command (1328), (1368), (1398), (1427)

ADSM

software requirements (754)

Alert Center (675)

APPC

client (1126)

server (1485)

software requirements (745), (790), (805), (814), (823) , (858), (866), (875)

support on AIX

SNA Server (749)

support on OS/2

Communications Manager for OS/2 (798)

Communications Server for OS/2 (797)

support on Solaris

SunLink SNA (748), (830)

supported platforms (746)

application development

using Net.Data or JDBC (707)

using ODBC (1246)

authentication

client (955), (976), (1157), (1208), (1211) , (1341), (1378), (1408), (1436)

DCS (956), (1158), (1209), (1212), (1342) , (1379), (1409), (1437)

server (954), (1156), (1207), (1210), (1340) , (1377), (1407), (1435), (1451)

authority

levels (962), (1130), (1148)

authorization IDs

naming rules (1334)

binding

utilities and applications (1243)

cataloging

databases (921), (1099), (1100), (1120), (1121)

IPX/SPX node (1117), (1119), (1484)

TCP/IP node (1096), (1098), (1475)

CD-ROM

installing DB2 Client Applications Enablers (973), (977)

installing DB2 Software Developer's Kit (979), (995)

Client Application Enabler

installing (984)

installing on OS/2 (994)

installing on Windows 3.x (991)

software requirements (755)

Client Configuration Assistant

administering clients communications (1060)

and DB2 setup (1226)

changing privileges (1136)

client profiles (1061)

exporting (1497)

using (1495)

discover (1500)

discovering databases (1062)

overview (694)

searching the network (1054), (1499)

setting configuration parameters (1308), (1505)

testing the database connection (1065)

using access profiles (1492)

client profile

exporting (1496)

clients

configuring (1071)

installing (981), (985)

operating systems supported (648), (649), (656), (983)

overview (650), (974)

verifying the installation (1066)

CLP See using the command line processor (CLP)

Command Center

entering DB2 commands (1262), (1264)

entering SQL statements (1263), (1265)

overview (665), (669)

commands

admintool (1329), (1369), (1399), (1402), (1428) , (1431)

alter table (940)

connecting to logical node (1203), (1236)

dasicrt (1227)

dasidrop (1240)

db2admin (1229), (1231), (1239), (1510)

db2ckmig (917), (938)

db2icrt (1151), (1161), (1337), (1375), (1404) , (1433)

db2idrop (1217), (1218), (1221), (1528), (1529) , (1532)

db2ilist (1164)

db2imigr (933), (953), (959)

db2iupdt (1201), (1205)

db2licd (927), (931)

db2ln (1049)

db2rmln (1348), (1385), (1415), (1443)

db2set (1185), (1233), (1270), (1464)

db2start (965), (1168), (1179)

db2stop (926), (1176), (1220), (1516), (1531)

db2uiddl (966)

db2_install (1387), (1417)

drop function (941)

drop trigger (942)

drop view (943)

echo (1272), (1274)

groupadd (1032), (1373), (1403), (1432)

mkgroup (1332)

mkuser (1333)

mount (1020)

pkgrm (1541), (1543)

rlogin (902), (1024)

SAM, to add users (1372)

SAM, to update kernel (890), (892), (1009), (1011), (1363) , (1420), (1422)

set (1273)

smit (1314), (1316), (1322)

smit_install_remove (1537)

swinstall (1354), (1356), (1358)

swremove (1539)

SYSADM (963), (1033), (1034), (1330), (1370) , (1400), (1429)

useradd (1035), (1374)

communication protocols

APPC (750), (762), (767), (773), (785) , (802), (811), (827), (853), (861) , (870), (1486)

IPX/SPX (751), (768), (774), (786), (803) , (812), (829), (836), (844), (854) , (862), (871), (1107), (1114), (1477)

Named Pipes (787), (845), (855), (863), (872)

NetBIOS (752), (788), (837), (846), (856) , (864), (873)

TCP/IP (753), (763), (769), (775), (780) , (789), (804), (813), (828), (838) , (847), (857), (865), (874), (1083) , (1466)

configuring (1093)

communications

configuring the client (1059), (1089), (1112)

configuring the server (1448), (1458)

managing (1075), (1453)

Client Configuration Assistant (1052)

Control Center (690), (1449)

supported protocols

IPX/SPX (1481)

TCP/IP (1087), (1110), (1469)

components

on UNIX operating systems (878), (879), (1562)

selecting (877), (1561)

configuration parameters

kernel (1361)

setting DB2 (978), (1142), (1268), (1307), (1454)

setting kernel (888)

SYSADM_GROUP (1137)

configuring

APPC (1488)

IPX/SPX (1109), (1113)

ODBC driver (1252), (1253)

TCP/IP (1085), (1468)

configuring client communications

setting configuration parameters (971), (1077), (1309)

using the Client Configuration Assistant (1058)

using the command line processor (1076)

configuring communications

overview (1081)

using Client Configuration Assistant (1053)

using Control Center (1444)

configuring server communications

setting DB2COMM (1460), (1494)

using the command line processor (1457)

using the Control Center (1447)

configuring servers (1445), (1455)

connecting to a database (1134)

connecting to the Internet using Net.Data (703), (709)

Control Center

components (673)

overview (662), (667)

creating

instances (910), (1152)

creating links for the DB2 libraries, installation (1381), (1439)

creating the sample database

using First Steps (1131)

using the command line processor (1132)

dasiupdt command (1204), (1237)

database

authentication type (944)

migration (961)

naming rules (1572)

database access

two-phase commit (661)

database administration tools

Control Center (663)

overview (666)

database alias (1102), (1123)

naming rules (1571)

database manager

starting (1182)

stopping (1177), (1517)

database objects

naming rules (1576)

DB2 Client Application Enabler

accessing databases (658)

installing

Windows 3.x (992)

Windows 95 (986)

Windows NT (987)

overview (651), (657), (975)

platforms supported (654), (655)

DB2 Client Application Enablers CD-ROM

installing clients from (980)

DB2 Connect

overview (646), (647), (700), (701)

DB2 Enterprise Edition

configuration planning (722)

memory requirements (723)

DB2 Extended Enterprise Edition

disk requirements (726)

DB2 Installer See installation

DB2 libraries

creating links (1346), (1383), (1411), (1413), (1441)

DB2 library

books (1547)

Information Center (1556)

language identifier for books (1548)

late breaking information (1549)

online help (1546)

ordering printed books (1555)

printing PostScript books (1554)

searching online books (1553)

setting up document server (1551)

SmartGuides (1545)

structure of (1544)

viewing online books (1550)

DB2 server, definition (643)

DB2 Snapshot Monitor

overview (685)

db2 terminate command (928)

DB2 Universal Database

components included

Client Configuration Assistant (693), (695)

Control Center (668), (671)

DB2 Client Application Enabler (653)

DB2 Performance Monitor (688)

DB2 Snapshot Monitor (684), (705)

Visual Explain (679), (681), (687)

DAS considerations (1225)

getting started (1127)

overview (672)

platforms supported (664)

software requirements (733), (744)

DB2 Workgroup Edition

configuration planning (721)

disk requirements (725)

memory requirements (720)

db2.ini file

environment keywords (1277)

db2ckmig command (918), (932)

db2cli.ini (1254)

DB2COMM (1463)

db2icrt command (1037), (1154), (1160), (1338), (1339) , (1376), (1405), (1406), (1434)

db2idrop command (1216), (1222), (1527), (1533)

db2ilist command (1166)

db2imigr command (935), (958)

DB2INSTANCE (1189)

db2iupdt command (1206)

db2ln command (1045), (1050)

db2profile script (1044), (1046)

db2rmln command (1347), (1384), (1414), (1442)

db2set command (1202), (1234)

using (1271), (1465)

db2start command (1169)

db2stop command (1175), (1219), (1515), (1530)

db2uiddl command (967)

developing applications

using Net.Data or JDBC (708)

Discovery

choosing a discovery method (1501)

client configuration (1223)

searching the network (1498)

setting Discovery parameters (1504)

disk requirements

client (730)

server (729)

Distributed Computing Environment

software requirements (747), (764), (770), (776), (793) , (833)

environment variables

DB2INSTANCE (1296)

db2instprof (1297)

db2path (1298)

db2profile script (1005)

setting (1041)

error handling

log (939)

migration (936)

execs

db2uexit.exe (946), (949)

db2uext2.exe (947), (950)

files

db2systm (1214), (1215), (1525), (1526)

restoring (1351)

filesets

choosing on AIX (1317), (1558)

choosing on HP-UX (1559)

choosing on Solaris (1560)

corresponding prerequisites (1563)

fixed disks

hardware requirements (731)

groups

creating (1366), (1396), (1425)

hardware requirements

fixed disk (732)

initialization file, ODBC (1258)

installation

clients

AIX (997), (1311), (1349), (1416)

HP-UX (998)

Macintosh (1051)

OS/2 (996)

SCO OpenServer (1029)

SINIX (1026)

Solaris (999)

Windows 3.x (993)

Windows 95 (988)

Windows NT (989)

creating links for DB2 libraries (1344)

DB2 Installer (900), (1155)

DB2 server on UNIX systems

assigning groups and users (1031), (1327), (1365), (1395), (1424)

creating an instance (1036), (1336)

creating groups and users (1030), (1326), (1364), (1394), (1423)

creating links (1048), (1345), (1382), (1412), (1440)

DB2 Product Library (1324), (1355), (1388), (1418)

DB2 Product Messages (1325), (1357), (1389), (1419)

removing DB2 products (1508)

restoring product files (1350)

setting the DB2 operating environment (1038), (1039), (1040), (1159), (1343) , (1380), (1410), (1438)

updating kernel components (886), (891), (893), (1002), (1006) , (1007), (1008), (1010), (1012), (1013) , (1028), (1359), (1390), (1393), (1421)

disk requirements (883)

client (727)

server (728)

memory requirements (882)

client (713)

server (712)

mounting the CD-ROM (894), (895), (1014), (1015)

AIX (896), (903), (1016), (1017)

HP-UX (897), (898), (904), (1018), (1019)

mount point (880), (1000)

SINIX (1027)

Solaris (899), (905), (1021), (1022)

remote (901), (1023)

servers

AIX (1310)

HP-UX (1352), (1386)

UNIX installations

using DB2 Installer (908)

using installp (1313), (1315)

using SMIT (1312), (1318), (1323)

instances

autostarting (1184)

creating (906), (909), (1025), (1153)

creating multiple (912), (1150)

definition (1149)

listing (1165)

naming restrictions (884), (1001), (1162), (1582)

removing (1213), (1523), (1534)

setting operating environment (1186)

SPM instance creation (1524)

starting (1167)

stopping (1174), (1514), (1519), (1520)

updating (1200)

IPX/SPX

client (1106)

configuring (1115)

server (1479)

software requirements (791), (807), (816), (832), (839) , (848)

supported platforms (1116), (1482)

verifying the connection (1069), (1104), (1125)

Java Support (711)

Java, running programs (1261)

JDBC See Java Support

JDBC, running programs (1260)

Journal (676)

kernel configuration parameters

updating (887), (1003), (1360), (1391)

LANG environment variable (1567)

licensing

concurrent users (1144)

counting (1143)

upgrading from Try and Buy (1145)

logging off the system (1129)

logging on to the system (1128)

managing connections

client

overview (696), (1079)

using the Client Configuration Assistant (692), (1056)

using the command line processor (1078)

server

overview (697)

using the Client Configuration Assistant (1057)

using the Command Line Processor (1080), (1459)

managing databases using the Control Center (670)

managing server communications

overview (691)

memory requirements

client (715)

estimating (718)

recommended (719)

server (714)

Micro Focus COBOL

adding entry points to library (913)

Microsoft ODBC Driver Manager (1249)

Microsoft SNA Server

version required (876)

migration

data (929)

database (951), (960)

DB2 Version 2.x (914), (922)

db2chkmig (937)

instance (924), (930), (952), (957)

post-installation (923), (925)

post-migration

explain tables (972)

rebinding packages (969)

unique index conversion (964)

updating database and database manager configuration (970)

updating statistics (968)

pre-migration (916), (920)

previous releases (915)

user exit program (945), (948)

naming rules

authorization IDs (1335)

database (1573)

database alias (1574)

database objects (1575)

general (1570)

groups (1578)

instance names (1580)

password (1585)

userids (1577)

username (990), (1579)

workstation name (nname) (1584)

National Language Support (NLS)

code set (1565), (1566)

codepage support (1564), (1568)

determining codepage (1569)

Net.Data (796)

overview (706), (710)

NetBIOS

on the client (792), (840), (849)

on the server (1452)

supports SEARCH discovery (1503)

Netfinity Server (794)

NLS See National Language Support (NLS)

ODBC

odbc.ini file (1256)

odbcinst.ini file (1257)

registering the driver manager (1251)

running ODBC-enabled applications (1244)

running programs (1247)

odbcad32.exe (1248)

operating systems

client (652)

server (982)

parameters

kernel configuration (1362)

setting kernel configuration (889), (1004), (1392)

SYSADM_GROUP (1135), (1138)

password

naming rules (1586)

Performance Monitor

using (680)

planning

DB2 configuration (716), (724)

DB2 Connect configuration (717)

privileges

required (1139)

product

components (881), (911), (1557)

descriptions (645)

overview (644)

product files, restoring (1353)

profile registry

using (1269)

programs

db2chkmig (934)

protocols

APPC (1487)

IPX/SPX (1108), (1478)

TCP/IP (1084), (1471)

registering

ODBC driver manager (1250)

registry values

db2account (1279)

db2clientcomm (1302)

db2codepage (1280)

DB2COMM (1462)

db2comm (1299), (1461)

db2country (1281)

db2dbdft (1282)

db2dirpathname (1301)

db2discoverytime (1283)

db2include (1285)

db2instdef (1286)

db2libpath (1287)

db2netreq (1284)

db2options (1288)

db2route (1303)

db2slogon (1289)

db2timeout (1290)

db2tracename (1291)

db2traceon (1292)

db2trcflush (1293)

db2trcsyserr (1294)

db2yield (1295)

dsmi_config (1304)

dsmi_dir (1305)

dsmi_log (1306)

general (1278)

setting (1267)

removing

administration server (1522)

product options (1507), (1535)

AIX (1536)

HP-UX (1538), (1540), (1542)

restoring product files, installation (1319)

restrictions

instance name (1163), (1581)

running applications

database client (1241)

ODBC considerations (1245)

sample database See creating the sample database

script

db2cshrc (1043), (1171), (1173), (1188), (1191) , (1193), (1195), (1197), (1199), (1276) , (1513)

db2profile (1042), (1047), (1170), (1172), (1187) , (1190), (1192), (1194), (1196), (1198) , (1275), (1512)

Script Center (674)

SDK Kit See Software Developer's Kit

setting

environment variables (1266)

setting configuration parameters (1073), (1456)

setting up client communications

using the Client Configuration Assistant (1055)

using the command line processor (1072)

setting up document server (1552)

setting up server communications

using the command line processor (1450)

using the Control Center (1446)

snapshot monitoring considerations (683)

software bundles

overview (1320)

using to install software (1321)

Software Developer's Kit

overview (698)

software requirements

communication protocols (735), (737), (741)

DB2 Client Application Enabler (738), (756), (759), (778), (782) , (799), (808), (817), (820), (824) , (834), (842), (851), (859), (867)

DB2 Connect (739), (742)

DB2 SDK (736), (743), (757), (760), (766) , (772), (779), (783), (800), (809) , (818), (821), (825), (835), (843) , (852), (860), (868)

DB2 Universal Database (734), (740)

Net.Data (758), (761), (784), (801), (810) , (826), (869)

SQL

access plans

viewing using Visual Explain (686)

starting

database manager (1178), (1181), (1518)

DB2 (1180)

stopping

DB2 (1183)

SYSADM (1331), (1371), (1401), (1430)

privileges

controlling (1141)

SYSADM_GROUP parameter (1140)

SYSCTRL (1146)

SYSMAINT (1147)

system configuration

with DB2 Connect (702)

with DB2 Universal Database (660)

TCP/IP

client (1086)

configuring (1091)

preventing socket collisions (1094), (1472)

resolving host address (1476)

server (1467)

set with db2set (1300)

setting up client-to-server (1090)

software requirements (765), (771), (777), (781), (795) , (806), (815), (819), (822), (831) , (841), (850)

supports only one-phase commit (1506)

supports SEARCH discovery (1502)

troubleshooting (1095), (1473)

Tools Setting (677)

user privileges See privileges

username

naming rules (1583)

users

creating (1367), (1397), (1426)

using the command line processor (CLP)

cataloging a database (919), (1101), (1122)

cataloging a node (1097), (1118)

connecting to a database (1063), (1103), (1124), (1133)

updating the database manager configuration (1474), (1483), (1490)

verifying the connection (1064)

utilities

binding (1242)

verifying the connection

using the Client Configuration Assistant (1067)

using the command line processor

IPX/SPX (1111), (1480)

TCP/IP (1088), (1470), (1489)

verifying the installation

client (1068)

Visual Explain

overview (682), (689)

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

[ DB2 List of Books | Search the DB2 Books ]