OLAP Setup and User's Guide

Index

A B C D E F G H I K L M N O P Q R S T U V W Y
A
  • AccountsType (1440)
  • active connections, viewing (1285)
  • add database wizard (1536)
  • add-on modules, DB2 OLAP Server
  • Allocations Manager (1034), (1110)
  • Application Programming Interface (1029), (1105)
  • Currency Conversion (1028), (1104)
  • Objects (1032), (1108)
  • Partitioning (1033), (1109)
  • Spreadsheet Toolkit (1030), (1106)
  • SQL Interface (1027), (1103)
  • Web Gateway (1031), (1107)
  • ADMINSPACE parameter (1329), (1342)
  • Agent window
  • using in AIX, Solaris Operating Environment, and HP-UX (1168)
  • using in Windows (1093)
  • AIX
  • Multi-Threaded Environment (1015)
  • alias ID table (1296)
  • alias ID view
  • about (1483)
  • description (1297)
  • querying with SQL (1489)
  • using (1485)
  • alias table name (1447)
  • AliasIdViewName (1408)
  • AliasTableName (1487)
  • allocating space, database log file (1232)
  • Allocations Manager, add-on (1036), (1112)
  • anchor dimension
  • about (1264)
  • and restructuring (1247)
  • choosing (1270)
  • identifying (1268)
  • setting (1273)
  • viewing (1280)
  • anchor member
  • columns (1468)
  • anchor member columns (1460)
  • application
  • automating startup on Windows (1077)
  • Essbase (988)
  • maintaining (1204)
  • specifying in rsm.cfg file (1327)
  • SQL (1001)
  • Application Manager (985), (986)
  • Application Programming Interface, add-on (1038), (1114)
  • AppName (1403)
  • ARBORPATH
  • environment setting for AIX, Solaris Operating Environment, and HP-UX (1140)
  • environment variable for Windows (1067)
  • authentication, Information Catalog Manager (1188)
  • authority, granting (1215)
    • B
  • back up database wizard (1538)
  • backing up and restoring data (1254)
  • books (967), (1508), (1521)
  • buffer pool sizes, setting (1237)
    • C
  • CalcEquation (1438)
  • calculating the database (1384)
  • calculation process, partly multithreaded (1368)
  • commit block parameter, setting (1227)
  • communications protocols, supported (1019)
  • Company name, parameter
  • for AIX, Solaris Operating Environment, and HP-UX (1153)
  • for Windows (1072)
  • components of Starter Kit (1049), (1123)
  • compression, ignored settings (1266)
  • configuration file rsm.cfg (1321)
  • configure multisite update wizard (1540)
  • configuring DB2 OLAP Server (1319)
  • correcting problems (1259)
  • create database wizard (1542)
  • create table space wizard (1546)
  • create table wizard (1544)
  • creating and deleting a relational database (1216)
  • creating multidimensional databases, overview (1263)
  • creating OLAP applications, overview (1262)
  • cshrc file for AIX, Solaris Operating Environment, and HP-UX (1141)
  • cube catalog view
  • accessing with SQL (1410)
  • contents (1401)
  • name (1399)
  • using (1398)
  • cube table (1294)
  • cube view
  • contents (1416)
  • description (1295)
  • name (1414)
  • querying name with SQL (1426)
  • using (1412)
  • cube, relational (997)
  • CubeName (1404)
  • CubeViewName (1405)
  • Currency Conversion, add-on (1037), (1113)
  • CurrencyMemberName (1442)
  • cursor stability, isolation level (1348)
  • customization, Information Catalog Manager (1197)
    • D
  • data
  • backing up and restoring (1256)
  • ensuring integrity (1239)
  • loading (1288)
  • relational (972)
  • data warehouse (1318)
  • database
  • buffer pool size, setting (1236)
  • calculating (1385)
  • creating and deleting (1219)
  • loading data (1287)
  • multidimensional (993)
  • outline (1298)
  • recovery (1241)
  • relational (995)
  • reorganizing a relational (1253)
  • restructuring an multidimensional (1244)
  • settings, changing (1223)
  • storage differences (1290)
  • database log file (1229)
  • allocating space (1231)
  • managing size (1224)
  • database logon ID, relational (1209)
  • database settings, changing (1222)
  • databasename parameter (1324)
  • DB 2 OLAP Starter Kitt
  • stopping on Windows (1080)
  • DB2
  • supported RDBMS (1012)
  • tuning (1372)
  • DB2 library
  • books (1507)
  • Information Center (1529)
  • language identifier for books (1512)
  • late-breaking information (1514)
  • online help (1522)
  • ordering printed books (1520)
  • printing PDF books (1517)
  • searching online information (1555)
  • setting up document server (1553)
  • structure of (1506)
  • viewing online information (1524)
  • wizards (1532)
  • DB2 OLAP Integration Server
  • connecting to servers and relational data sources (1055), (1128)
  • creating an OLAP metadata catalog (1058), (1130)
  • environment variables (1139)
  • installing (1054), (1127)
  • introducing (971)
  • publications (965)
  • server directory structure (1064), (1136)
  • using to load data (1082)
  • using to load data for AIX, Solaris Operating Environment, and HP-UX (1149)
  • DB2 OLAP Server
  • advantages (973)
  • allocating memory (1380)
  • automating startup on Windows (1075)
  • components (974)
  • configuration (1320)
  • enhancing performance (1363)
  • installing on AIX, Solaris Operating Environment, and HP-UX (1097)
  • installing on Windows (1020)
  • introducing (969)
  • License Enablement (1087), (1163)
  • publications (963)
  • queries (1390)
  • starting on AIX, Solaris Operating Environment, and HP-UX (1150)
  • starting on Windows (1070)
  • stopping on AIX, Solaris Operating Environment, and HP-UX (1158)
  • stopping on Windows (1079)
  • upgrading (1084), (1161)
  • views (1394)
  • DB2 OLAP Starter Kit
  • components (1124)
  • installing (1121)
  • installing tutorial (1048), (1126)
  • introducing (970)
  • loading data (1081)
  • loading data for AIX, Solaris Operating Environment, and HP-UX (1148)
  • publications (964)
  • stopping on AIX, Solaris Operating Environment, and HP-UX (1157)
  • upgrading (1086), (1162)
  • defragmenting, relational database (1250)
  • deleting a relational database (1217)
  • dense dimensions
  • fact and key tables (1245)
  • searching for (1272)
  • dimension columns
  • fact view contents (1459)
  • LRO view contents (1495)
  • star view
  • contents (1467)
  • dimension table
  • adding relational attribute columns (1315)
  • description (1306)
  • dimension view
  • contents (1430)
  • description (1307)
  • name (1428)
  • querying member names with SQL (1451)
  • querying name with SQL (1449)
  • dimension, limitations (1274)
  • DimensionId (1422)
  • DimensionName (1418)
  • dimensions, limitations (1265)
  • DimensionTag (1421)
  • DimensionType (1420)
  • DimensionViewName (1423)
  • directory structure
  • DB2 OLAP Server (1044), (1120)
  • OLAP Integration Server (1065), (1137)
  • documentation (968)
  • dual storage manager (1276)
    • E
  • environment variables
  • for database clients (1063), (1135)
  • manually updating for Windows (1066)
  • updating for AIX, Solaris Operating Environment, and HP-UX (1138)
  • Essbase application
  • defined (987)
  • extractor utilities in Information Catalog Manager (1172)
    • F
  • fact table
  • description (1301)
  • sample (1269)
  • tuning for performance (1376)
  • fact view
  • contents (1457)
  • description (1302)
  • name (1455)
  • querying with SQL, UNIX and Windows NT (1461)
  • using (1453)
  • FACTS parameter (1331), (1344)
  • FactViewName (1406)
  • file parameters, rsm.cfg (1336)
  • FINDEX parameter (1333), (1359)
    • G
  • generation table (1310)
  • GenerationName (1444)
  • GenerationNumber (1443)
  • granting authority (1214)
    • H
  • Handle (1498)
  • hardware
  • enhancing performance (1365)
  • hardware requirements (1005)
  • high water number, viewing (1282)
  • HP-UX
  • Multi-Threaded Environment (1017)
  • HTML
  • sample programs (1511)
    • I
  • ID, relational database logon (1211)
  • improving performance (1221)
  • index wizard (1548)
  • information catalog
  • extractors (1173)
  • samples (1174)
  • verifying (1200)
  • information catalog initialization utility (1175)
  • Information Catalog Manager for the Web
  • and Websphere IBM HTTP Web server (1189), (1192)
  • customization (1199)
  • description (1177)
  • installing (1185), (1191), (1194), (1196)
  • prerequisites (1180)
  • security considerations (1186)
  • software requirements (1181)
  • Information Catalog Manager software requirements (1178)
  • Information Catalog Manager Tools (1176)
  • Information Center (1530)
  • installing
  • Netscape browser (1527)
  • installing DB2 OLAP Server
  • add-on features available (1026), (1102)
  • communications protocols (1018)
  • getting started (1002)
  • hardware requirements (1004)
  • information needed before starting (1024), (1101)
  • installation steps for DB2 OLAP Server on AIX, Solaris Operating Environment, and HP-UX (1119)
  • installation steps for Windows (1043)
  • on AIX, Solaris Operating Environment, and HP-UX (1098)
  • on Windows (1021)
  • software requirements (1007)
  • supported RDBMS (1009)
  • upgrading (1083), (1159)
  • installing DB2 OLAP Starter Kit
  • installation steps for Windows (1051)
  • installing (1122)
  • on Windows (1046)
  • upgrading (1085), (1160)
  • installing Information Catalog Manager for the Web (1195)
  • installing, license key built during (1023), (1100)
  • integrity of data (1238)
  • ISHOME
  • environment variable for Windows (1068)
  • isolating and correcting problems (1258)
  • isolation levels
  • cursor stability (1349)
  • read stability (1353)
  • repeatable read (1355)
  • uncommitted read (1351)
  • ISOLATION parameter (1347)
    • K
  • kernel (978)
  • key table (1300)
  • KEYSPACE parameter (1343)
  • KINDEX parameter (1334), (1361)
    • L
  • language identifier
  • books (1513)
  • late-breaking information (1515)
  • LD_LIBRARY_PATH variable on Solaris Operating Environment (1145)
  • LeftSiblingRelId (1436)
  • level table (1311)
  • LevelName (1446)
  • LevelNumber (1445)
  • LIBPATH variable on AIX (1144)
  • library path variable (1143)
  • License Enablement, DB2 OLAP Server (1088), (1164)
  • license key, how created (1022), (1099)
  • Linked Reporting Object (LRO) view
  • contents (1493)
  • querying with SQL (1504)
  • using (1491)
  • loading data (1289), (1383)
  • locks, contention for (1373)
  • log file
  • database, allocating space (1233)
  • managing size (1225)
  • log file in DB2 (1230)
  • logon ID, relational database (1210)
  • LRO table (1304)
  • LRO view (1305)
  • LROViewName (1409)
    • M
  • MAXPOOLCONNECTIONS parameter (1356)
  • MDSM (Multidimensional Storage Manager) (980)
  • MemberName
  • dimension view contents (1432)
  • user-defined attribute view (1480)
  • members
  • deleting from dimensions (1249)
  • in dimensions (1271)
  • memory, allocating (1379)
  • metadata catalog
  • about (1060), (1132)
  • creating (1061), (1134)
  • metaoutline, defined (989)
  • model, defined (990)
  • multi-threaded environments (1013)
  • multidimensional database
  • defined (992)
  • restructuring (1243)
  • multidimensional data (991)
  • multidimensional database
  • creating (1293)
  • overview (1261)
  • Multidimensional Storage Manager (979), (1277)
    • N
  • Netscape browser
  • installing (1528)
  • NoCurrencyConv (1441)
  • NOTE (1503)
  • number of blocks fixed, viewing (1281)
    • O
  • OBJDESC (1502)
  • Objects, add-on (1041), (1117)
  • OBJNAME (1501)
  • OBJTYPE (1497)
  • ODBC driver
  • on AIX, Solaris Operating Environment, and HP-UX (1165)
  • on Windows (1089)
  • OLAP application
  • creating (1292)
  • OLAP application
  • overview (1260)
  • OLAP engine (975)
  • OLAP Integration Server
  • see DB2 OLAP Integration Server (1056)
  • OLAP metadata catalog
  • about (1059), (1131)
  • creating (1062), (1133)
  • OLAP security system (1206)
  • online help (1523)
  • online information
  • searching (1557)
  • viewing (1526)
  • operations, managing server
  • commands for AIX, Solaris Operating Environment, and HP-UX (1170)
  • commands for Windows (1095)
  • OS/390
  • FINDEX parameter (1360)
  • KINDEX parameter (1362)
  • outline, database (1299)
    • P
  • parameters, rsm.cfg file (1337)
  • ParentRelId (1435)
  • PARTITIONING parameter (1332), (1358)
  • Partitioning, add-on (1042), (1118)
  • password, OLAP (1213)
  • PATH
  • environment variable for Windows (1069)
  • PDF (1518)
  • percent wasted, viewing (1283)
  • performance configuration wizard (1550)
  • performance, enhancing
  • allocating memory (1381)
  • by changing database settings (1220)
  • by managing the size of the database log file (1226)
  • calculating the database (1386)
  • configuring DB2 OLAP Server (1377)
  • hardware (1364)
  • loading data (1382)
  • tuning DB2 (1371)
  • tuning for queries (1387)
  • Using RUNSTATS utility (1391)
  • Windows NT (1370)
  • Perl interpreter and Information Catalog Manager (1183)
  • pool size, viewing (1286)
  • post-installation customization (1198)
  • printing PDF books (1519)
  • profile file, AIX, and HP-UX (1142)
  • publications (966)
    • Q
  • queries (1369), (1388)
    • R
  • RATCOLUMNNAME (1473)
  • RATCOLUMNSIZE (1475)
  • RATCOLUMNTYPE (1474)
  • RATViewName (1425)
  • RDBMS
  • installing separately (1025)
  • RDBMS, supported
  • DB2 Common Server (1011)
  • DB2 Universal Database (1010)
  • RDB_NAME parameter (1325), (1338)
  • RDB_PASSWORD parameter (1340)
  • RDB_USERID parameter (1339)
  • read stability, isolation level (1352)
  • recovering databases (1240)
  • RelAliasTableName (1488)
  • relational attribute table
  • description (1312)
  • relational attribute view
  • accessing with SQL (1476)
  • description (1313)
  • name and contents (1472)
  • relational attributes
  • adding columns to dimension tables (1314)
  • adding values to columns (1316)
  • column name in dimension table (1448)
  • removing values from columns (1317)
  • relational cube (996)
  • relational database
  • creating and deleting (1218)
  • defined (994)
  • logon ID (1208)
  • managing (1205)
  • reorganizing (defragmenting) (1252)
  • Relational Storage Manager (976), (1278)
  • RelDimensionName (1419)
  • release notes (1516)
  • RelMemberID (1434)
  • RelMemberName (1433)
  • renaming dimensions (1248)
  • reorganizing, relational database (1251)
  • repeatable read, isolation level (1354)
  • restore wizard (1552)
  • restoring data from backup (1255)
  • restructuring an multidimensional database (1242)
  • rows per block, viewing (1284)
  • RSM (Relational Storage Manager) (977)
  • rsm.cfg file
  • application section (1326)
  • database section (1328)
  • editing (1322)
  • parameters (1335)
  • RSM section (1323)
  • run-time considerations (1389)
  • run-time parameters, viewing (1279)
  • RUNSTATS utility, using on a new multidimensional database (1392)
    • S
  • sample information catalog, verifying (1203)
  • sample programs
  • cross-platform (1510)
  • HTML (1509)
  • schema, star (999)
  • searching
  • online information (1531), (1556)
  • security considerations, Information Catalog Manager (1187)
  • security system, OLAP (1207)
  • server operations, managing
  • commands for AIX, Solaris Operating Environment, and HP-UX (1169)
  • commands for Windows (1094)
  • Set Path command, for AIX, Solaris Operating Environment, and HP-UX (1147)
  • setting up document server (1554)
  • setting up ODBC drivers
  • IBM (1091), (1167)
  • Merant (1092)
  • shared multiprocessor (SMP) (1367)
  • SHLIB_PATH variable on HP-UX (1146)
  • SmartGuides
  • wizards (1533)
  • software requirements (1008)
  • Information Catalog Manager components (1179)
  • Information Catalog Manager for the Web (1182)
  • Solaris Operating Environment
  • Multi-Threaded Environment (1016)
  • sparse dimensions
  • fact and key tables (1246)
  • loading data (1267)
  • Spreadsheet Toolkit, add-on (1039), (1115)
  • SQL application
  • creating (1393)
  • defined (1000)
  • SQL Interface
  • on AIX, Solaris Operating Environment, and HP-UX (1166)
  • on Windows (1090)
  • SQL Interface, add-on (1035), (1111)
  • SQL scripts
  • to create catalogs and tables (1057), (1129)
  • star schema
  • defined (998)
  • tables and views (981)
  • star view
  • contents (1465)
  • description (1303)
  • name (1463)
  • querying with SQL, UNIX and Windows NT (1469)
  • using (1454)
  • STARTCONNECTIONS parameters (1357)
  • Starter Kit
  • components (1050)
  • installing (1045)
  • Starter Kit tutorial
  • creating the OLAP sample (1053)
  • using (1052)
  • startup
  • in background for AIX, Solaris Operating Environment, and HP-UX (1156)
  • in foreground for AIX, Solaris Operating Environment, and HP-UX (1152)
  • on AIX, Solaris Operating Environment, and HP-UX (1151)
  • startup for Windows
  • applications, automatic startup (1078)
  • DB2 OLAP server (1071)
  • server, automatic startup (1076)
  • StarViewName (1407)
  • status (1437)
  • storage differences, database (1291)
  • storage manager (1275)
  • STOREOPTION (1496)
  • supervisor ID (1212)
  • supported hardware (1003)
  • supported software (1006)
  • synchronization point settings (1228)
  • system administration
  • commands for AIX, Solaris Operating Environment, and HP-UX (1171)
  • commands for Windows (1096)
  • System password, parameter
  • for AIX, Solaris Operating Environment, and HP-UX (1155)
  • for Windows (1074)
    • T
  • table spaces
  • temporary (1374)
  • using (1235)
  • tables, star schema (982)
  • TABLESPACE parameter (1330), (1341)
  • terminology (984)
  • testing the sample information catalog (1201)
  • threads
  • performance tuning (1366)
  • requirements (1014)
  • TRACEFILESIZE parameter (1346)
  • TRACELEVEL parameter (1345)
  • troubleshooting (1257)
  • tuning
  • DB2 Universal Database (1375)
  • DB2 OLAP Server (1378)
  • tutorial
  • installing with Starter Kit (1047), (1125)
    • U
  • UDA (1481)
  • UDAViewName (1424)
  • UnarySymbol (1439)
  • uncommitted read, isolation level (1350)
  • UPDATEDATE (1500)
  • user-defined attribute (UDA)
  • defined (1558)
  • user-defined attribute table
  • description (1308)
  • user-defined attribute view (1482)
  • description (1309)
  • using (1478)
  • USERNAME (1499)
  • using table spaces (1234)
    • V
  • verifying the sample information catalog (1202)
  • view
  • alias ID view, querying with SQL (1490)
  • alias ID, about (1484)
  • cube catalog view
  • accessing with SQL (1411)
  • contents (1402)
  • name (1400)
  • cube catalog view, about (1397)
  • cube view
  • contents (1417)
  • name (1415)
  • using (1413)
  • cube viewquerying name with SQL
  • querying name with SQL (1427)
  • dimension view
  • contents (1431)
  • name (1429)
  • querying member names with SQL (1452)
  • querying name with SQL (1450)
  • fact view
  • contents (1458)
  • name (1456)
  • querying with SQL on UNIX and Windows NT (1462)
  • Linked Reporting Object (LRO) view
  • contents (1494)
  • querying with SQL (1505)
  • using (1492)
  • naming scheme (1396)
  • relational attribute view (1471)
  • accessing with SQL (1477)
  • SQL applications (1395)
  • star schema (983)
  • star view
  • contents (1466)
  • name (1464)
  • querying with SQL on UNIX and Windows NT (1470)
  • user-defined attribute view (1479)
  • using the alias ID view (1486)
  • viewing
  • online information (1525)
    • W
  • Web components, Information Catalog Manager (1184)
  • Web Gateway, add-on (1040), (1116)
  • Websphere IBM HTTP Web server (1190), (1193)
  • wizard
  • restore database (1551)
  • wizards
  • add database (1535)
  • back up database (1537)
  • completing tasks (1534)
  • configure multisite update (1539)
  • create database (1541)
  • create table (1543)
  • create table space (1545)
  • index (1547)
  • performance configuration (1549)
    • Y
  • Your name, parameter
  • for AIX, Solaris Operating Environment, and HP-UX (1154)
  • for Windows (1073)

    • [ Top of Page | Previous Page | Next Page ]