IBM
DB2
Universal
Database
Data
Warehouse
Edition
Getting
Started
Version
8.1.2
IBM
DB2
Universal
Database
Data
Warehouse
Edition
Getting
Started
Version
8.1.2
Note
Note:Beforeusingthisinformationandtheproductitsupports,readtheinformationin“Notices”onpage39.
FirstEdition(September2003)
ThiseditionappliestotheIBMDB2UniversalDatabaseDataWarehouseEnterpriseEditionandtheIBMDB2 UniversalDatabaseDataWarehouseStandardEditionproductsandtoallsubsequentreleasesandmodificationsuntil otherwiseindicatedinneweditions.
ThisdocumentcontainsproprietaryinformationofIBM.Itisprovidedunderalicenseagreementandisprotectedby copyrightlaw.Theinformationcontainedinthispublicationdoesnotincludeanyproductwarranties,andany statementsprovidedinthismanualshouldnotbeinterpretedassuch.
OrderpublicationsthroughyourIBMrepresentativeortheIBMbranchofficeservingyourlocalityorbycalling 1-800-879-2755intheUnitedStatesor1-800-IBM-4YOUinCanada.
Contents
Aboutthisbook. . . . . . . . . . . v
Whoshouldreadthisbook . . . v
Onlineinformation . . . v
Chapter1.ProductsintheDB2Data WarehouseEdition . . . . . . . . . 1
DB2UniversalDatabase . . . 2
DB2UDBEnterpriseServerEdition . . . 2
DB2UDBWorkgroupServerUnlimited Edition . . . 2
DB2CubeViews . . . 3
DB2IntelligentMiner . . . 3
DB2IntelligentMinerModeling. . . 4
DB2IntelligentMinerScoring . . . 4
DB2IntelligentMinerVisualization . . . 4
DB2OfficeConnect . . . 5
DB2QueryPatroller. . . 6
DB2WarehouseManager(ETLcomponent) . . 6
Warehousetransformers . . . 6
WarehouseETLagents . . . 7
DB2InformationIntegrator . . . 7
Relationalwrappers. . . 7
Chapter2.Businessintelligencedataflow scenarios . . . . . . . . . . . . . 9
DataflowscenarioforDB2DataWarehouse EnterpriseEdition . . . 9
DataflowscenarioforDB2DataWarehouse StandardEdition . . . 11
Chapter3.Overviewofhardwareand softwarerequirements . . . . . . . . 13
Chapter4.InstallingDB2DataWarehouse Editions . . . . . . . . . . . . . 15
InstallingDB2DataWarehouseEnterprise andStandardEditions . . . 15
Startingtheinstallation . . . 16
AppendixA.Specifichardwareand softwarerequirements . . . . . . . . 25 DB2UniversalDatabase . . . 25 DB2WarehouseManager . . . 27 DB2InformationIntegrator . . . 27 DB2CubeViews . . . 28 DB2QueryPatroller . . . 28 DB2IntelligentMiner. . . 30 DB2OfficeConnect . . . 33 Supportedlanguages . . . 34 AppendixB.Troubleshooting . . . . . 35
Logfilelocations . . . 37
Notices . . . . . . . . . . . . . 39
Trademarks . . . 41
Index . . . . . . . . . . . . . . 43
ContactingIBM . . . . . . . . . . 45
ProductInformation . . . 45
Commentsonthedocumentation . . . 46
About
this
book
TheIBM®DB2 UniversalDatabase™DataWarehouseEnterpriseEditionand
theIBM DB2UniversalDatabaseDataWarehouse StandardEditionaresuites ofproductsthatprovidepowerful warehousingandbusinessintelligence platforms.Youcanbuildand deployanalyticalapplicationsand solutionsto gaingreaterinsightintoyourenterprisedata.
Usethisbooktohelpyouplanfortheinstallationoftheproductsineither theDB2 DataWarehouseEnterpriseEditionortheDB2 DataWarehouse StandardEdition.(Botheditionsare hereafterreferredtoastheDB2Data WarehouseEdition.)For alistofproductsthatareincludedwitheachedition, seeChapter1,“ProductsintheDB2Data WarehouseEdition,”onpage1. Beforeyouinstall DB2DataWarehouse Edition,read thisbook.Then,read the prerequisiteinstallationrequirementsforeachproductthatyouwantto install.EachproductintheDB2Data WarehouseEditionsuiteincludesits owndocumentation.
Note: AlldocumentCDsarecontainedin theset ofCDslabeled
Documentation.
Who
should
read
this
book
Thisbookisforsystemadministratorswho installandconfigureeither edition oftheDB2DataWarehouseEdition.Youshouldbe familiarwitheachproduct thatyouwanttoinstall.Youshouldalsounderstanddatabases,clientand serverarchitectures,connectivity,and networking.
Online
information
Youcanalso usethefollowingWebsitestodownloadfixpacksand findmore information:
http://www.ibm.com/software/data/db2/datawarehouse/
ProvideslinkstoinformationaboutDB2DataWarehouse Editionand DB2WarehouseManager.
http://www.ibm.com/software/data/db2/udb/support.html
ProvideslinkstoDB2® UDBfixpacks,hintsand tips,frequently askedquestions,whitepapers,and Redbooks™.
http://www.ibm.com/software/data/support/
ProvideslinkstotechnicalsupportforIBM DB2information managementsoftwareproducts.
http://www.ibm.com/software/
Provideslinkstogeneralandspecific informationaboutIBMsoftware products.
http://www.ibm.com/software/data/pubs/
ProvideslinkstoinformationsourcesforDB2Universal Database
http://www.ibm.com/software/data/db2/db2md/
ProvideslinkstoinformationaboutDB2CubeViews.
http://www.ibm.com/software/data/iminer/
ProvidesinformationaboutDB2IntelligentMinerModeling,Scoring, andVisualization.
Chapter
1.
Products
in
the
DB2
Data
Warehouse
Edition
DB2DataWarehouse Editionisasuiteofproductsthatcombinesthestrength ofDB2UniversalDatabase(DB2UDB) withthepowerfulbusinessintelligence infrastructurefromIBM. DB2DataWarehouseEditionprovidesa
comprehensivebusinessintelligenceplatformwith everythingyour enterprise andpartnersneed todeployandbuildnext generationanalytic solutions.By usingDB2 DataWarehouseEdition,youcanbuilda completedata
warehousingsolutionthatincludesahighlyscalablerelationaldatabase, integratedinformation,businessintelligenceanalytics,and front-endfinancial analysistools.
Thefollowingproductsare providedinDB2DataWarehouse Enterprise Edition:
v IBMDB2Universal DatabaseEnterpriseServerEdition,Version8.1.2,which
includestheDB2Data PartitioningFeature,Version8.1.2
v IBMDB2CubeViews,Version8.1, whichincludesIBM DB2OfficeConnect
AnalyticsEdition
v IBMDB2IntelligentMiner
™Modeling,Version8.1
v IBMDB2IntelligentMiner Scoring,Version8.1
v IBMDB2IntelligentMiner Visualization,Version8.1
v
IBMDB2InformationIntegratorStandard Edition,Version8.1
v IBMDB2OfficeConnectEnterpriseWebEdition,Version4.0
v IBMDB2Query Patroller,Version8.1
v IBMDB2Warehouse ManagerStandardEdition,Version8.1.2
Thefollowingproductsare providedinDB2DataWarehouse Standard Edition:
v IBMDB2Universal DatabaseWorkgroup ServerUnlimitedEdition,Version
8.1.2
v IBMDB2CubeViews,Version8.1, whichincludesIBM DB2OfficeConnect
AnalyticsEdition
v IBMDB2OfficeConnectProfessionalWebEdition,Version4.0
v
IBMDB2IntelligentMiner Modeling,Version8.1
v IBMDB2IntelligentMiner Scoring,Version8.1
v IBMDB2IntelligentMiner Visualization,Version8.1
DB2DataWarehouse StandardEditiondoesnotinclude DB2Information IntegratorStandardEdition,DB2QueryPatroller,orDB2Warehouse Manager StandardEdition.
Thefollowingsectionsprovidea generaloverviewoftheproductsthatare includedintheEnterpriseandStandardeditionsofDB2 DataWarehouse Edition.
DB2
Universal
Database
DB2UDBEnterpriseServerEditionisincludedwith DB2DataWarehouse EnterpriseEdition,andDB2UDB WorkgroupServerUnlimitedEditionis includedwith DB2DataWarehouse StandardEdition
DB2
UDB
Enterprise
Server
Edition
DB2UDBEnterpriseServerEdition,Version8.1.2(DB2 UDBESE)with the DatabasePartitioning Featureisahighlyscalable,multi-userrelational databasemanagementsystem thatcanmanage datawarehousing,online analyticalprocessing(OLAP), onlinetransactionprocessing(OLTP),anddata mining.Youcanalso createandmanagepartitioneddatabase environments. Partitioneddatabasesystemscanmanage highvolumesofdatawith
near-linearscalabilitywhile providingbenefitssuchasincreasedperformance andhighavailability.Other featuresof DB2UDBESEinclude:
v Adatawarehouseserverandrelatedcomponents.
v
DB2Connect
™functionalityforaccessingdatastoredonmidrangeand
mainframedatabase systemssuchasDB2UDBforiSeries™or DB2UDBfor z/OS™.DB2UDBESEprovides supportforbothlocalandremote DB2 UDBclients.
v SatelliteadministrationcapabilitiesallowingDB2UDB ESEtoremotely
administerDB2 UDBdatabaseservers thatare configuredassatellites.
DB2
UDB
Workgroup
Server
Unlimited
Edition
DB2UDBWorkgroupServer UnlimitedEdition,Version8.1.2(DB2UDB WSUE)isafullfunction Web-enabledclientandserverrelationaldatabase managementsystem.YoucandeployDB2 UDBWSUEoverwidearea networks(WAN)orlocalareanetworks(LAN).Itincludesdatawarehousing capabilities,andit canbe administeredremotelyfroma satellitecontrol database.
DB2UDBWSUEprovidesanentry-level serverthatisintended primarilyfor smallbusinessanddepartmental computing.Itisfunctionallyequivalentto DB2UDBESEwith theexceptionthatthereisnointegratedzSeries™server connectivity(throughtheDB2Connectcomponent)andlimited extensibility (forexample,DB2UDBWSUEdoesnotsupport 64-bitcomputingorDB2 DataLinksFileManager).
DB2
Cube
Views
DB2CubeViews,Version8.1benefitsbusinessintelligenceusersthroughout anenterprisebydecreasingthedevelopmenttimethatisrequiredtodefine sharedOLAPmodels acrossmultiple tools.Withnew metadataobjectsand tooling,youcandefinecubestructuresafterthemetadataisimportedtothe DB2UDBcatalog.Thismetadatacanbe usedin otherbusinessintelligence tools.Becausethesharedcommon metadataincludesaggregationformulas andcalculations,youcanbenefitfromgreaterconsistencyofanalyticalresults acrossyour enterprise.
DB2DataWarehouse Editionincludesfeaturesthataredesignedspecifically toimprovetheusability andperformanceof businesspartnerbusiness intelligenceproducts.Data warehouseadministratorscanbuildoptimal structuresinDB2 UDBbasedontherecommendationsoftheDB2CubeViews OptimizationAdvisor,whichimproves theperformance ofOLAPqueriesthat aregeneratedbypartnertools.By usingthese businessanalysis toolswith DB2UDBmanagedtools,youreceivemore consistentqueryresults.Designers caneasilyimportcubeviewsandmappings fromDB2UDBratherthandefine thesame metadataseparatelyinotherpartnertoolsthatmight beusedinthe sameenterprise.
IBMDB2OfficeConnectAnalyticsEdition,a Microsoft® Excelplug-in,works
withDB2CubeViews todisplayandnavigatecubeviewsinDB2UDB.IBM DB2OfficeConnectAnalyticsEditionturnsyour Excelspreadsheetintoan OLAPtool.Itisincludedwith DB2CubeViews,notwiththeOfficeConnect WebEditions.Also,inthisrelease, IBMDB2OfficeConnectAnalyticsEdition doesnotshare thethin-clientWeb-basedarchitecture oftheOfficeConnect WebEditions.For moreinformationaboutothereditionsofDB2Office Connect,see“DB2OfficeConnect” onpage5.
Youmight seethephraseDB2MultidimensionalMetadataManagementinthe product.ThatphrasereferstoDB2CubeViews.
DB2
Intelligent
Miner
WithDB2IntelligentMiner,Version8.1,youcanembedmininganalyticsin businessintelligence,e-commerce,ortraditionalOLTPapplication programs. DB2IntelligentMinerincludesthefollowingcomponents:
v DB2IntelligentMinerModeling
v DB2IntelligentMinerScoring
v DB2IntelligentMinerVisualization
DB2
Intelligent
Miner
Modeling
Tounderstandunderlyingprocessesorbehaviorofyourenterprise,youcan buildminingmodels fromyourenterprisedata.Forexample,anassociation modeldescribesconsumerbehavior.Apredictivemodelisanequation orset ofrulesthatmakesitpossibletopredictanunseenorunmeasuredvalue from other,knownvalues.Youcanview modelswith DB2IntelligentMiner
Visualization.
DB2IntelligentMinerModelingisa processinwhichyoumake callstothe DB2UDBdataminingfunctions.Youcanbaseyourmodels ondatamining algorithmssuchasassociationsdiscovery,clustering,orclassification.
DB2
Intelligent
Miner
Scoring
DB2IntelligentMinerScoringenablesapplicationstoapplypredictivemodel markuplanguage(PMML) modelstolargedatabases, subsetsofdatabases,or singlerowsorcases.ThePMMLmodels canbe createdbyoneofthe
IntelligentMinerproductsorbyotherapplicationsandtoolsthatsupport PMMLmodels.
Scoringusesexistingdataminingmodelsand simplyappliesthesemodels to newdata.Forexample,youmight haveaclassificationmodelthatcontains rulesaboutestimatingthechurnriskfor customers.Giventheprofiledata abouta particularcustomer,thescoringfunction computesthechurnrisk.You cannow applythisfunction inrealtimetoasingle record,forexample,the customerwhocurrentlytalkstosomeoneinthecallcenter.
DB2
Intelligent
Miner
Visualization
DB2IntelligentMinerVisualizationprovidesJava™visualizerstoshowdata modelsina graphicalformat.Applicationscancallthevisualizerstopresent modelresults,oryoucandeploythevisualizers asappletsinaWebbrowser. Visualizationprovidesanalystswithvisualsummariesofdatafroma
database.Itcanalso beusedasamethodforunderstandingtheinformation thatisextractedbyusingotherdataminingmethods.Featuresthatare difficulttodetectbyscanningrowsand columnsindatabasesoftenbecome obviouswhenyouviewthemgraphically.
Note: Thebestwaytostart workingwithDB2IntelligentMiner isthrough a
tutorial.Thetutorialsare designedtoguidedataanalystsand
application designersthroughtheprocessof applyinginsightlearned fromdatamininganalysistoeverydayoperations.Thetutorialscan serveasdetailedguidesforprojectdesignbyidentifyingthesteps involved,andbyshowinghowtoobtainmaximumvalue fromthedata miningprocess.Applicationdeveloperscanusethesetutorials tohelp start thedevelopment processandtospeedthedeliverytimeof their
thevalueofdataminingtoline-of-businessmanagers. SeetheDB2 IntelligentMinertutorialWebpageat:
http://www7b.software.ibm.com/dmdd/library /tutorials/iminer/iminer.htm
ortheDB2IntelligentMinerhome pageat: http://www.ibm.com/software/data/iminer/ fortutorialoverviewsanddownloads.
DB2
Office
Connect
WithDB2OfficeConnect,youcanconnectyour Excelspreadsheetsto databasessothatyoucanretrieve,modify, andupdatethedatain your database.
TheDB2OfficeConnectclient,whichyoucanaccessafteryoucreateaDB2 OfficeConnectproject,turnsExcelintoaclientof aDB2OfficeConnect repository.YoucanusetheclienttoretrievethedatafromDB2OfficeConnect projectsandperform databaseoperations.
DB2OfficeConnectalso providesyouwith theabilityto: v
Createondemandreports thatchangeasthedatainthedatawarehouse
changes
v Performadhocqueries ofthewarehouse
v Sharedataanalysisacrossyourenterprisebyenabling Excelusersto
write-backanalysis resultstothedatawarehouse DB2OfficeConnectisavailableintwomaineditions:
v IBMDB2OfficeConnectEnterpriseWebEdition,whichisincludedwith
DB2DataWarehouse EnterpriseEdition
v IBMDB2OfficeConnectProfessionalWebEdition,whichisincludedwith
DB2DataWarehouse StandardEdition
BotheditionsofDB2OfficeConnectare functionallythesame.However, they arelicenseddifferently.
IBMDB2OfficeConnectAnalyticsEditionisavailable onlywith DB2Cube Views.FormoreinformationabouttheAnalyticsedition,see“DB2Cube Views”onpage3.
DB2
Query
Patroller
DB2QueryPatrollerenablesallqueriessubmittedtoDB2 UDBclients, analyzesthequeries,andthen dynamicallyprioritizesandschedulesthemfor processing.YoucanuseDB2QueryPatrollertodynamically controltheflow ofqueriestoyour DB2UDBdatabase.Youcan:
v Defineseparatequeryclassesforqueriesofdifferentsizestobettershare
systemresourcesamongqueriesand topreventsmallerqueriesfrombeing stalledbehindlargerones
v Givehighprioritytoqueries thataresubmittedbycertainuserssothat
thesequeriesrunsooner
v Automaticallyholdlargequeriessothattheycanbecanceledorscheduled
torunduring off-peakhours v
Trackandcancelrunaway queries
WithDB2QueryPatroller,youcanregulatethequeryworkloadofyour databasesothatsmallqueriesand high-priorityqueriescanrunpromptly, andyoucanensurethatyour systemresourcesareusedefficiently.In
addition,youcancollectandanalyzeinformationaboutcompletedqueriesto determinetrendsacrossqueries,heavyusers,andfrequentlyusedtablesand indexes.
DB2
Warehouse
Manager
(ETL
component)
DB2WarehouseManager(theETLcomponent)containscomponentsthat enhancethewarehousingextract, transform,andload (ETL)capabilitiesthat areprovidedbytheDB2 DataWarehouseCenter,whichisavailablewith DB2 UniversalDatabase.
TheDB2WarehouseManagerStandard Edition,whichisincludedwith DB2 DataWarehouseEnterpriseEdition,includesthefollowingcomponents: v DataWarehouse ETLtools
– Warehousetransformers
– WarehouseETLagents
Warehouse
transformers
Warehousetransformersarestored proceduresanduser-definedfunctionsthat youcanusetotransformdataina warehousestep.IntheDB2 Data
WarehouseCenter,youusestepstocreateandmaintaina warehouse.Steps controlhow dataistransformedintomeaningful businessinformation.You canusewarehousetransformersina steptoclean,invert,and pivotdata, generateprimary keysandperiodtables,andcalculatevariousstatistics.
Warehouse
ETL
agents
WarehouseETLagentsmanagetheflowofdatabetweenthedatasources and thetarget warehousesbytransferringdatafromthesourcedatabaseto the targetwarehouse.Agentsuseopendatabaseconnectivity (ODBC)driversor DB2CLI(call-levelinterface)tocommunicatewithdifferentdatabases.
DB2
Information
Integrator
DB2DataWarehouse EnterpriseEditionincludesalimited-uselicenseofIBM DB2InformationIntegrator StandardEditionwhichenablesDB2 Information IntegratorrelationalwrapperstobeusedtoaccessheterogeneousRDBMS sourceswiththeDB2Warehouse ManagerETLtool.TheseETLsources includeOracle,SQLServer,Teradata,and Sybase.
Relational
wrappers
IBMDB2InformationIntegratorStandard Editioncontains relational wrappers.RelationalwrappersenableaDB2 UDBfederatedsystemto integratedataacrossanenterprise. Therelationalwrappers areacomponent ofDB2InformationIntegratorthatisusedwith DB2UDBEnterpriseServer Edition.
InDB2 UniversalDatabase,Version8.1.2,relationalwrappers arerequiredif youwanttoaccessdatathatisstoredinOracle,Sybase, MicrosoftSQLServer, andTeradatadatasources.Accesstodatathatisstored inIBMdatabases (DB2UDBandInformix®)isbuiltintoDB2UDBforUNIX® andWindows®.
Chapter
2.
Business
intelligence
data
flow
scenarios
TheDB2DataWarehouse Editionisasuiteoftoolsthatcanhelpyougain insightsfromthedatathatyoucollectandanalyzefromyour enterprise.DB2 UDBprovidesthefoundationforyourenterprisedata.WithDB2 Warehouse ManagerStandardEdition,youcancollectand cleanseyour datasothatit canbe manipulatedandanalyzedbyotherbusinessintelligencetools,suchas IBMDB2IntelligentMinerand DB2CubeViews.
Data
flow
scenario
for
DB2
Data
Warehouse
Enterprise
Edition
Thefollowingscenariodescribes ahypotheticalflowofdatathroughthe productsof theDB2 DataWarehouseEnterpriseEdition.Inthisscenario,you startwith sourcedatain aDB2ornon-DB2database.Thegoalistoorganize andanalyzethedatafromyourenterprisesothatyoucanmake effective businessdecisions.
Table1.UsingtheDB2DataWarehouseEnterpriseEditiontoanalyzeyourdata
Action Tool Comments
Integratethedatafroma non-DB2databasetoa DB2database v DB2Information Integrator v DB2WarehouseManager
YoucanusewrappersfromDB2Information IntegratorwithDB2WarehouseManagerto importdatafromnon-DB2RDBMSsourcesfor ETL.
v Identifyyourrelational
datasourcetables
v DB2UDBEnterprise
ServerEdition
Youroperationaldatabasesourceisbuiltwith yourenterprisebusinesstransactions.Youcan usethatdataasasourceforyourdata warehouse.
v Cleansethedataand
createdatamarts v Viewasingledata
martormultipledata marttablesinanExcel spreadsheet
v DB2WarehouseManager
v DB2OfficeConnect
WithDB2OfficeConnect,youcanview warehousedatawithMicrosoftExcel spreadsheets.
v DefineOLAP-style
cubesandoptimize thequeriesissuedto thosecubes
v Viewcubemetadatain
anExcelspreadsheet
v DB2CubeViews
v IBMDB2OfficeConnect
AnalyticsEdition
YoucanstorecubemetadataintheDB2catalog withDB2CubeViews.WithIBMDB2Office ConnectAnalyticsEdition,whichisavailable onlywithDB2CubeViews,youcanviewDB2 virtualcubes(metadatacubes)fromExcel spreadsheetswithpivottableservices, includingdrill-down.
Table1.UsingtheDB2DataWarehouseEnterpriseEditiontoanalyzeyourdata (continued)
Action Tool Comments
v Createminingmodels
v Deployminingmodels
withscoring v Viewthemodels
v DB2IntelligentMiner Modeling v DB2IntelligentMiner Scoring v DB2IntelligentMiner Visualization
YoucanbuildapplicationsbyinvokingtheDB2 IntelligentMinerutilities,oryoucanusea partnerworkbenchtobuildmodelsand implementinDB2throughPMML.Youcan displaythemodelwithDB2IntelligentMiner VisualizationandinvokeDB2IntelligentMiner ScoringwithaSQLprocedurecallforreal-time analyticapplications.
YoucanuseDB2QueryPatrollerthroughoutthisdataflowtomanage relationalqueries.For example,forthedatawarehouse queries(ETLand OLAP),youcanautomaticallyadjustquerypriorityaccordingtouser, application,orresourceandimproveperformancethrough informationthat DB2QueryPatrollercollects.WithDB2 QueryPatroller,youcanalsocache queryresultsforreuse andanalyzecollectedstatisticstodeterminetrendsin queryruns.
ThefollowingillustrationsummarizesthedataflowscenarioforDB2 Data WarehouseEnterpriseEdition.
DB2 Office Connect Analytics DB2 Office Connect Enterprise Web DB2 Cube Views DB2 source data DB2 Query Patroller Non-DB2 database DB2 Warehouse Manager DB2 Information Integrator IM Modeling IM Scoring IM Visualization
IM: Intelligent Miner
Figure1.CollectingandanalyzingdatawiththeproductsintheDB2DataWarehouseEnterprise Edition
Data
flow
scenario
for
DB2
Data
Warehouse
Standard
Edition
Thefollowingscenariodescribes ahypotheticalflowofdatathroughthe productsof theDB2 DataWarehouseStandard Edition.Inthisscenario,you startwith sourcedatain aDB2ornon-DB2database.Thegoalistoorganize andanalyzethedatafromyourenterprisesothatyoucanmake effective businessdecisions.
Table2.UsingtheDB2DataWarehouseStandardEditiontoanalyzeyourdata
Action Tool Comments
v
Storeandbuildyour
relationaldatasource tables
v Viewrelationaldatain
anExcelspreadsheet v
DB2UDBWorkgroup
ServerUnlimitedEdition v IBMDB2OfficeConnect
ProfessionalWebEdition
Youroperationaldatabasesourceisbuiltwith yourenterprisebusinesstransactions.Youcan sendthatsourcedatatothedatawarehouse.
v Extractthedataand
createdatamarts v Viewasingledata
martormultipledata marttablesinthe sameExcel spreadsheet
v DataWarehouseCenter
v IBMDB2OfficeConnect
ProfessionalWebEdition
TheDataWarehouseCenterisincludedwith DB2UDBWorkgroupServerUnlimitedEdition. Thedatawarehouseordatamartholds
transformeddatathatiseithercleanedor summarizedthroughcalculationswiththe metadata.Datawarehousinghelpsyousort throughvastamountsofdatabygroupingit intomeaningfulunitsthatmakesensefroma businesspointofview.
v DefineOLAP-style
cubesandoptimize thequeriesissuedto thosecubes
v Viewcubemetadatain
anExcelspreadsheet
v DB2CubeViews
v IBMDB2OfficeConnect
AnalyticsEdition
YoucanstorecubemetadataintheDB2catalog withDB2CubeViews.
v Createmodels
v Deploythemodels
withscoring v
Viewthemodels
v DB2IntelligentMiner Modeling v DB2IntelligentMiner Scoring v DB2IntelligentMiner Visualization
YoucanuseDB2IntelligentMinerModeling utilitiestodevelopanalyticmodelsbasedon dataforclusteringandtreeclassification,which canthenbeprocessedbyDB2IntelligentMiner Scoring.Youcanviewtheresultoftheanalysis byusingDB2IntelligentMinerVisualization. Thisresultcanbecomparedtotheresultof anotherruntohelpyoumakeeffective businessdecisions.
Thefollowingillustrationsummarizeshowyoumightusetheproductsinthe DB2DataWarehouse StandardEditiontocollectandanalyzeyour enterprise data.
DB2 Office Connect Analytics DB2 Office Connect Professional Web DB2 Cube Views DB2 source data DB2 Warehouse Center IM Modeling IM Scoring IM Visualization
IM: Intelligent Miner
Figure2.CollectingandanalyzingdatawiththeproductsintheDB2DataWarehouseStandard Edition
Chapter
3.
Overview
of
hardware
and
software
requirements
Thissectiondescribes theminimumhardwareand softwarerequirementsthat youneedtoinstall DB2DataWarehouse Edition.For alistofdetailed
requirements,includingspecificinformationabouttheminimummemoryand diskspacerequirementsforeachproduct,seeAppendixA,“Specific hardware andsoftwarerequirements,”onpage25.
DB2DataWarehouse Editionissupportedonthefollowingoperatingsystems: v AIX5 (32-bit)
v LinuxforIntel(32-bit)
v Solarisversions 8and 9(32-bit)
v Windows2000(32-bit)
v WindowsServer 2003(32–bit)
v WindowsXPProfessional(32-bit)
Table3.OperatingsystemrequirementsforDB2DataWarehouseEdition
AIX5 32-bit Linuxfor Intel32-bit Solaris versions8 and932-bit Windows 200032-bit Windows XPand Windows Server2003 32-bit DB2UDBESE X X X X X2 DB2UDB WSUE X X X X X DB2Cube Views X X X X DB2Intelligent Miner Modeling, Scoring, Visualization X X X X X DB2Office Connect1 X X IBMDB2Query Patroller X X X X X DB2Warehouse Manager X X X X X
Table3.OperatingsystemrequirementsforDB2DataWarehouseEdition (continued) AIX5 32-bit Linuxfor Intel32-bit Solaris versions8 and932-bit Windows 200032-bit Windows XPand Windows Server2003 32-bit DB2 Information Integrator X X X X X
1TouseanyeditionofDB2OfficeConnect,youmust installMicrosoft®
Excel™.For moreinformationaboutsupportedversions ofExcel,see“DB2 OfficeConnect” onpage33.
2OnlyDB2 Clientapplications(e.g.AdminClient)aresupportedonWindows
Chapter
4.
Installing
DB2
Data
Warehouse
Editions
Thissectiondescribes howtoinstall theproductsfromtheDB2Data
WarehouseEnterpriseEditionand theDB2 DataWarehouseStandard Edition.
Installing
DB2
Data
Warehouse
Enterprise
and
Standard
Editions
Beforeyouinstall theproductsintheDB2Data WarehouseEnterpriseEdition ortheDB2 DataWarehouseStandard Edition,read thehardwareandsoftware requirementsinthis book(AppendixA,“Specific hardwareandsoftware requirements,”onpage25)and thedocumentationforeachproduct. Refertothefollowingproductinstallationnotesbefore youstart the installation:
v ForDB2CubeViews, ifyouwanttoviewcubedatain anExcel
spreadsheet,youmust installIBMDB2 OfficeConnectAnalyticsEdition, whichisincludedwithDB2 CubeViews.IBMDB2OfficeConnectAnalytics Editionisnotpartoftheintegratedinstallation,however,andmustbe installedandconfiguredseparately.
v DB2CubeViewsispresentlynotsupportedonWindowsXPorWindows
Server2003.
v IfyoualreadyhaveDB2installedatFixPak3 orhigher,youmust first
downloadFixPak 3orhigherimagesbefore startingtheinstallationprocess. v
IfyoualreadyhaveDB2installedonyoursystem,theDWEinstall program
stopsallDB2processestoinstallotherproducts.Verifythatnooneis activelyusingthedatabasesonyour serverbeforestartingtheDWE installation.
v TheFixPak2+installationonWindowsisnotsilentduetotheDWEinstall
programlimitations.
v Afteryouhaveinstalledall products,downloadandinstall allavailable
PTFs.
v ForDB2Data WarehouseEnterpriseEditioncustomers, DB2Enterprise
ServerEditionincludesapartitioningfeature.Ifyouwantto runDB2on multiplepartitions,installDB2 manuallyonall participatingservers.See theQuickBeginningsforDB2Serversbookfordetailsoninstallingpartitions. Aftercompletingtheseinstalls,usetheDWEinstallprogramtosilently installtheremainingproductsonyourinstanceowningserver.Oncethe installationiscomplete,verifythatallpartitionserversare atthesame FixPaklevel.
Starting
the
installation
ToinstalltheDB2DataWarehouse EnterpriseEditionortheDB2Data WarehouseStandardEdition,followthese steps:
1. IfDB2Version8.1isinstalled,youmust firstdownloadFixPak2and
FixPak2+,install FixPak2and thenproceed.IfDB2version8.1.1(FixPak 1)isinstalled,youmustfirst downloadFixPak 2andFixPak 2+,install FixPak2and thenproceed.
Youcandownloadandinstall FixPak2fromthefollowingWebsite: http://www.ibm.com/cgi-bin/db2www/data/db2/udb
/winos2unix/support/download.d2w/report
YoucandownloadFixPak2+fromthefollowingWebsite: http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb /winos2unix/support/newsletter.d2w/n20030620
2. OnUNIXsystems, extract(unzipanduntar)theFixPakarchivedimage
toalocationonyourharddrive.OnAIXandSolarisonly,someofthe installationCDscontaina compressedfile.Thisfilemustbeextractedto yourharddriveduring installation.Makesure youhaveanavailable partitionthathasatleast2 gigabytesoffreespaceavailable.
3. InserttheDB2 UDBDataWarehouseEdition-IntegratedInstallCDinyour
CDROMdrive.
4. GotothedrivethatcontainstheCDtolocatetheinstallationsetupfile
foryouroperatingsystem.For Windows,double-clicksetup.exetostart theinstallation.
ForUNIX,runtheDWEinstallprogrambytypingthefollowingata commandprompt:
<cd-location>/<osname>setup
Forexample,iftheCDislocatedin/cdromandtheoperatingsystemis AIX,type:
/cdrom/aixsetup
wherecdromisthedirectorywhereyoumountedtheCD.
6. ForWindowsonly,theAutorunDisablementwindowappears ifAutorun
iscurrentlyactive.Selectthecheck boxtoturnAutorunoff,andthen clickNext.Yoursystemrebootsautomatically.
Note: SaveyourworkinotheropenapplicationsbeforeyouclickNext.
Figure3.AutorunDisablementwindow
7. Selecttheproductyouare licensedtoinstall.
.
Theremainingstepsassumethatyouare installingtheDB2Data
WarehouseEnterpriseEdition.TheinstallationwindowsintheDB2Data WarehouseStandardEditionmight differslightly.Youcaninstallthe serverortheclient onbothEnterpriseandStandard Editions.The installationwindowsmight alsodifferslightlydependingonyour operatingsystem.
8. Selectaninstallationtype.Inthefollowingexample,theserver
installationisselected.Afteryouselecttheeditiontoinstall,clickNext.
Figure5.Componentselectionwindow
9. Licenseagreementsfortheproductscontainedintheeditionthatyou
selectedappear.Afteryouhavereadtheproductlicenses,clickthe
LicenseAcceptancetab. Youmust acceptthelicenseagreementtermsfor alloftheproductsbeforeyoucango tothenextstep.ClickNext.
10. Theproductstobeinstalledarenowlisted.See Chapter1,“Products in
theDB2 DataWarehouseEdition,”onpage1 foradescriptionofthe productsincludedintheDB2DataWarehouse EnterpriseEditionandthe DB2DataWarehouse StandardEdition.Click Next.
Note: RegardingtheDataWarehouse Servercheckbox, theserveronly
runsonWindowsandAIX.For datawarehousesonother
platforms,theWarehouseServer mustbe installedonWindows or AIX.
Figure7.Productsavailableforinstallation
Thenextfewwindowsask youtoidentifythelocationoftheinstallation mediafortheproductstobeinstalled.Thewindowsdiffer slightly dependingonwhetheryouselecttoinstall theserverortheclient.Allof theinstallationmedia locationwindowsare similartothefollowing exampletakenfromtheDB2Data WarehouseEnterpriseEditionclient installation.
11. IntheDB2InstanceOwnerInformationwindow(theservereditionis
showninthefollowinggraphic)youmustenterauser nameand password.Formoreinformationaboutthenamingofusersand passwords,seetheQuickBeginnings forDB2ServersGuide.
AlsoonWindows,inthenextfewwindowsyouareprompted forthe installlocationsforDB2and IntelligentMinerModeling,Scoring,and Visualization.
Note: OnUNIX,therearetwoadditionalwindows,AdministratorUser
InformationandFencedUserInformation. Bothwindowscontain username,password,andgroup namefields.Eachuser andgroup namemustbedifferentacrossthesewindows.
Figure9.DB2InstanceOwnerInformationwindow
12. IntheAIXand Solarisinstallation,thefollowingadditionalwindow
appears.SomeoftheinstallationCDscontainacompressedfilethatmust beextracted.Selectthelocationwhere youwanttheinstallationdisk imagesuncompressed.
Youare promptedtoinsertCDswhenitisnecessarytoinstalleachprogram. Whenthefinalprogramhasbeeninstalled,awindow opensstatingthatthe installationiscomplete.
Appendix
A.
Specific
hardware
and
software
requirements
Thissectiondescribes thespecificsystemrequirementsforeachproductinthe DB2DataWarehouse Editionsuiteofproducts.
IfyoursystemmeetstheinstallationrequirementsforDB2UDBEnterprise ServerEdition,Version8.1.2,thenyour systemlikelymeetsthesystem requirementsforinstallingallof theproductsintheDB2Data Warehouse EnterpriseEdition.Similarly,ifyour systemmeetstheinstallation
requirementsforDB2 UDBWorkgroupServer UnlimitedEdition,Version 8.1.2,then yoursystemlikelymeetsthesystemrequirementsforinstallingall oftheproductsintheDB2Data WarehouseStandardEdition.
Foradditionalinformationaboutthesoftwareandhardwarerequirementsfor theproductsintheeacheditionoftheDB2DataWarehouse Edition,seethe documentationforeachproduct.
TodownloadFixPak2+, gotothefollowingWebsite: http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb /winos2unix/support/newsletter.d2w/n20030620
DB2
Universal
Database
Thissectiondescribes thesystemrequirementsforDB2UDBEnterpriseServer Edition,Version8.1.2andDB2UDB WorkgroupServerUnlimitedEdition, Version8.1.2
Table4.SystemrequirementsforDB2UDBEnterpriseServerEdition,Version8.1and DB2UDBWorkgroupServerUnlimitedEdition,Version8.1
Operatingsystem Software Hardware
AIX5.1.0(32-bit) Maintenancelevel2,orlater, andAPARsIY31254,IY32217, IY32905,IY33023,and IY29345
FortheDB2UDBWorkgroup ServerUnlimitedEdition,a Pentiumcentralprocessingunit (CPU),orhigher
AIX5.2.0(32-bit) FortheDB2UDBWorkgroup
ServerUnlimitedEdition,a Pentiumcentralprocessingunit (CPU),orhigher
Table4.SystemrequirementsforDB2UDBEnterpriseServerEdition,Version8.1and DB2UDBWorkgroupServerUnlimitedEdition,Version8.1 (continued)
Operatingsystem Software Hardware
Linux(32-bit) RedHatAdvancedServer2.1, RedHat7.3,RedHat7.2, RedHat8.0;SLES8,SLES7, SuSE7.3,SuSE8Pro,SuSE 8.1Pro;SCOLinux4.0 (poweredbyUnitedLinux 1.0);TurbolinuxEnterprise Server8.0,Turbolinux EnterpriseServer7.0;United Linux1.0
ForDB2UDBonLinuxsystems, IntelItanium,orhigher,isrequired. ForDB2UDBproductsrunningon Intelsystems,aPentiumCPU,or higher.ForAMDsystems,anAMD AthlonCPUisrequired.
Linux Thevalidationstatusfornew Linuxkernelsand
distributionsisfrequently updated.Toobtainthe currentinformationfor supportedLinuxsoftware levels,goto
http://www.ibm.com/software/ data/db2/linux/validate Solaris,Version8
(32-bit)
″Recommended&Security Patches″pluspatches 108921-12and108940-24 from:
http://sunsolve.sun.com
CPUspriortoUltraSparcarenot supported.
Solaris,Version9 (32-bit)
CPUspriortoUltraSparcarenot supported.
Windows2000 Professional,StandardServer, AdvancedServer,and DatacenterServers.Service Pack2isrequiredfor Windowsterminalserver.
ForDB2UDBproductsrunningon Intelsystems,aPentiumCPU,or higher.ForAMDsystems,anAMD AthlonCPUisrequired.
WindowsXP, Windows.NET, WindowsServer 2003
ForDB2UDBESE,Windows 2000andWindows.NET (32-bitand64-bit)are supported.WindowsXPis supportedonlyfor developmentandtest purposes.ForDB2UDB WorkgroupServerUnlimited Edition,WindowsXP,and Windows.NET(32-bit)are supported.
ForDB2UDBon64-bitWindows, IntelItanium,orhigher,isrequired. ForDB2UDBproductsrunningon Intelsystems,aPentiumCPU,or higherisrequired.ForAMD systems,anAMDAthlonCPUis required.
FormoreinformationabouthardwareandsoftwarerequirementsforDB2 UniversalDatabase,Version8.1.2,seeQuickBeginningsforDB2UDB servers, QuickBeginningsforDB2UDB Clients,andtheInstallationandConfiguration Supplement.
DB2
Warehouse
Manager
Thissectiondescribes thesystemrequirementsforDB2WarehouseManager StandardEdition,Version8.1.2.
DB2WarehouseManagerrequiresa systemcapableofrunningDB2Universal Database.Warehouseagentsare availableforthefollowingoperatingsystems: v Windows2000(32-bit)
v
WindowsXP(32-bit)
v WindowsServer 2003(32-bit)
v AIXVersion5 (32-bit)
v LinuxforIntel(32-bit)
v SolarisV7,V8,V9 (32-bit)
TorunDB2Warehouse Managerontheseoperatingsystems,thesystem requirementsare thesame asforDB2 UDBEnterpriseServerEdition,Version 8.1.2.Thewarehouse servermust beinstalledonWindowsorAIXoperating systems.
Formoreinformationabouttheinstallationrequirementsfor DB2Warehouse ManagerStandardEdition,Version8.1.2,seetheInstallationGuide.
DB2
Information
Integrator
Thissectiondescribes thesystemrequirementsforIBMDB2Information IntegratorStandardEdition,Version8.1.2.
DB2InformationIntegrator issupportedonthefollowingoperatingsystems: v AIXVersion5 (32-bit)
v LinuxforIntel(32-bit)
v Windows2000(32-bit)
v
WindowsXP(32-bit)
v SolarisVersions8 and9 (32-bit)
Teradatadatasourcesare notsupportedonLinuxforIntelorSolaris operatingsystems.
DB2InformationIntegrator requiresDB2UDBEnterpriseServerEdition, Version8.1.2orlater.
Thememoryanddiskspacerequirementsfor installingDB2 Information Integratorvarydependingonyourconfiguration. Formoreinformationabout memoryandspacerequirements,seetheInstallationGuideforIBMDB2 InformationIntegrator,Version8.1.
DB2
Cube
Views
Thissectiondescribes thesystemrequirementsforDB2CubeViews,Version 8.1.
DB2CubeViewssupportsthefollowingoperatingsystems: v LinuxRedHat(kernel2.4.18/ glibc2.2.93-5)32-bit
v
LinuxSuSE8.0(kernel2.4.18/glibc2.2.5)32-bit
v Windows2000(32-bit)
v AIXVersion5 (32bit)
v SolarisVersions8 and9 (32-bit)
DB2CubeViewsrunsonDB2Universal Database,Version8.1withFixPak2+. ThediskspacerequiredforDB2CubeViews dependsonthethetypeof installationthatyouchoose.However, thememorythatyouallocateforyour editionof DB2UniversalDatabaseisenoughforDB2CubeViews.
Formoreinformationaboutinstallationrequirements,seetheDB2Cube ViewsSetupandUser’sGuide.
DB2
Query
Patroller
Thissectiondescribes thesystemrequirementsforDB2QueryPatroller, Version8.1, clientandserver.
DB2QueryPatrollercanbedeployed onasystemthathasDB2Universal Database.
Table5.SystemrequirementsforaDB2QueryPatrollerserver
OperatingSystem Software Hardware
AIX5.1.0(32-bit) Maintenancelevel2orlater, APARsIY22844,IY31254, IY32217,IY32905,IY29345,and IY33023
IBMRISC/6000,eServerpSeries; 256MBofRAMminimum memoryrequirement LinuxforIntel Forthelatestinformationon
supportedLinuxdistribution andkernellevels,goto http://www.ibm.com/db2/ linux/validate
Intel32-bit;256MBofRAM minimummemoryrequirement
Table5.SystemrequirementsforaDB2QueryPatrollerserver (continued)
OperatingSystem Software Hardware
Solaris,Version8 (32-bit)
″Recommended&Security Patches″pluspatches 108921-12,108940-24, 108434-03,and108528-12
SolarisUltraSPARC-based computer;256MBofRAM minimummemoryrequirement Solaris,Version9
(32-bit)
SolarisUltraSPARC-based computer;256MBofRAM minimummemoryrequirement Windows2000,
andWindows Server2003 (32-bit)
ForWindows2000,Service Pack2isrequiredfor WindowsTerminalServer
For32-bitQueryPatrollerservers, aPentiumorPentiumcompatible processorisrequired;256MBof RAMminimummemory requirement
Inaddition,your systemmustmeet thefollowingsoftwarerequirementsfora DB2QueryPatrollerserver:
v
DB2UDBEnterpriseServerEdition(Version8.1.2orlater)mustbe installed
toinstallDB2 QueryPatrollerserver.
v YouneedaJava RuntimeEnvironment(JRE)Version1.3.1torunDB2
QueryPatrollerserver,theDB2 QueryPatrollerJava-basedtools(suchas theQueryPatrollerCenter),andtocreateand runJavaapplications, includingstored proceduresanduser-definedfunctions.
v Netscape6.2orMicrosoftInternetExplorer 5.5isrequiredto viewthe
onlineinstallationhelp.
Thefollowingtabledescribestheoperatingsystem,software,andhardware requirementsforDB2 QueryPatrollerclienttools:
Table6.SystemrequirementsforDB2QueryPatrollerclienttools
OperatingSystem Software Hardware
AIX AIXVersion4.3.3.78orlater IBMRISC/6000,eServerpSeries;an additional64MBofRAMonyour systemadministrationworkstation LinuxforIntel Forthelatestinformationon
supportedLinuxdistribution andkernellevels,goto http://www.ibm.com/db2/ linux/validate
Intel32-bit;anadditional64MBof RAMonyoursystem
administrationworkstation
Solaris,Version 2.7orlater
SUNWlibC SolarisUltraSPARC-based
computer;anadditional64MBof RAMonyoursystem
administrationworkstation
Table6.SystemrequirementsforDB2QueryPatrollerclienttools (continued)
OperatingSystem Software Hardware
Windows2000 Anadditional64MBofRAMon
yoursystemadministration workstation
WindowsXP (32-bit),Windows Server2003 (32-bit)
ADB2UDBproduct(Version 8.1.1orlater),JavaRuntime Environment(JRE)Version 1.3.1,Netscape6.2or MicrosoftInternetExplorer 5.5
APentiumorPentiumcompatible processor;anadditional64MBof RAMonyoursystem
administrationworkstation
Inaddition,your systemmustmeet thefollowingsoftwarerequirementsfor DB2QueryPatrollerclienttools:
v ADB2UDBproduct(Version8.1orlater)mustbe installedonthe
computeryouinstall theDB2QueryPatrollerclienttools.Thefollowing productsareappropriateprerequisites:
– AnyDB2UDB clientproduct(forexample,DB2UDB run-timeclientor
DB2UDBApplicationDevelopmentclient).
– AnyDB2UDB Connectproduct(forexample,DB2UDB Connect
PersonalEditionor DB2UDBConnectEnterpriseServerEdition). – AnyDB2UDB serverproduct(forexample,DB2UDB EnterpriseServer
EditionorDB2 UDBWorkgroupServer UnlimitedEdition).
v YouneedJavaRuntime Environment(JRE)Version1.3.1to runtheDB2
QueryPatrollerJava-basedtools,suchastheQueryPatrollerCenter,andto createandrunJavaapplications,includingstoredproceduresand
user-definedfunctions. v
Netscape6.2orMicrosoftInternet Explorer5.5isrequiredtoviewthe
onlineinstallationhelp.
Formoreinformationabouttheinstallationrequirementsfor DB2Query Patroller,seetheDB2QueryPatrollerGuide:Installation,Administration,and Usage.
DB2
Intelligent
Miner
Thissectiondescribes thesystemrequirementsforDB2IntelligentMiner Modeling,DB2IntelligentMinerScoring,andDB2IntelligentMiner Visualization.
Formoreinformationaboutinstallationrequirements,seeDB2Intelligent MinerScoringAdministrationandProgrammingforDB2 andAdministrationand
Note: ThereareserveralmandatoryPTFsforDB2IntelligentMiner products.
PleaseseethefollowingWebsiteformoreinformation: www.ibm.com/software/data/iminer/modeling/support.html andsearchforthetitle″OverviewofrecommendedIntelligentMiner V8.1PTFs″.
Table7.SystemrequirementsforDB2IntelligentMinerModeling,Version8.1
OperatingSystem Software Hardware
AIX,Linux, Solaris,Windows 2000,Windows XP,Windows Server2003 DB2UniversalDatabase, Version7.2FixPak7,orDB2 UniversalDatabase,Version8.1
Anycomputercapableof runningtheoperatingsystem; 256MBofRAMminimum
AIX AIXVersion4.3.3orhigher 60MBofadditionaldiskspace Linux Linuxwithkernel2.2.18or
higher;glibcVersion2.1.1or higher;RedhatPackage Manager(RPM)
45MBofadditionaldiskspace
Solaris SolarisVersion7orhigher 65MBofadditionaldiskspace Windows2000,
WindowsXP, WindowsServer 2003
Windows2000ServicePack2 orhigher,WindowsXP,or WindowsServer2003.
90MBofadditionaldisk 100MBofadditionaldiskspace toinstallDB2IntelligentMiner Scoring,DB2IntelligentMiner ScoringJavaBeans,andDB2 IntelligentMinerModeling
Formoreinformationaboutinstallationrequirements,seeDB2Intelligent MinerModelingAdministrationand Programming.
Table8.SystemrequirementsforDB2IntelligentMinerScoring,Version8.1
Operatingsystem Software Hardware
AIX,Linux, Solaris,Windows 2000,Windows XP,Windows Server2003 DB2UniversalDatabase, Version7.2FixPak7,orDB2 UniversalDatabase,Version8.1
Anycomputercapableof runningtheoperatingsystem; 256MBofRAMminimum
AIX AIXVersion4.3.3orhigher 60MBofadditionaldiskspacein the/usrfilesystem
Table8.SystemrequirementsforDB2IntelligentMinerScoring,Version 8.1 (continued)
Operatingsystem Software Hardware
Linux Linuxwithkernel2.2.18or higher,andglibcVersion2.1.1 orlater,RedhatPackage Manager(RPM)
60MBofadditionaldiskspace
Solaris SolarisVersion2.7orlater. Makesurethatpatches 109147-09,108434-02,and 108435-02areinstalled.
60MBofadditionaldiskspacein the/optfilesystem
Windows2000, WindowsXP, WindowsServer 2003
Windows2000ServicePack2 orlater,WindowsXP,or WindowsServer2003.ForDB2 IntelligentMinerScoringJava Beans:JDK1.3orlater
80MBofadditionaldiskspaceto installDB2IntelligentMiner ScoringorDB2IntelligentMiner ScoringJavaBeans;100MBof additionaldiskspacetoinstall DB2IntelligentMinerScoring, DB2IntelligentMinerScoring JavaBeans,andDB2Intelligent MinerModeling
Table9.SystemrequirementsforDB2IntelligentMinerVisualization,Version8.1
OperatingSystem Software Hardware
AIX,Linux, Solaris,Windows 2000,Windows XP,Windows Server2003
Anycomputercapableofrunning theoperatingsystem;128MBof RAMminimum
AIX JavaRuntimeEnvironment:
JRE1.3.1orlater,AIX Version4.3.3orhigher
10MBofadditionaldiskspace
Linux JavaRuntimeEnvironment:
JRE1.3.1orlater,Linuxwith kernel2.2.18orhigher; RedhatPackageManager (RPM)
10MBofadditionaldiskspace
Solaris JavaRuntimeEnvironment: JRE1.3.1orlater,Solaris Version7orhigher
15MBofadditionaldiskspace
Windows2000, WindowsXP, WindowsServer 2003
Windows2000ServicePack2 orhigher,WindowsXP,or WindowsServer2003
Formoreinformationabouttheinstallationrequirementsfor DB2Intelligent MinerVisualization,seeUsing theIntelligentMinerVisualizers.
DB2
Office
Connect
Thissectiondescribes thesystemrequirementsforIBMDB2OfficeConnect EnterpriseWebEdition,Version4.0and IBMDB2OfficeConnectProfessional WebEdition,Version4.0
DB2OfficeConnectiscompatiblewiththefollowingdatabaseservers: v IBMInformixOnlineServer,Version5.xorlater
v
IBMInformixDynamic Server,Version7.31 orlater
v IBMInformixDynamic Server,Version9.3orlater
v
IBMInformixExtendedParallelServer (XPS)8.40
v IBMInformixRed BrickDecisionServer,Version6.20
v IBMInformixStandard Engine7.25orlater
v IBMDB2Universal Databasefor z/OS
v IBMDB27.2FixPak5 orlater
v MicrosoftAccess97and later
v Oracle8.1
v SybaseSQLServer 11.9.2
DB2OfficeConnectsupportsthefollowingWindowsoperatingsystems: v Windows2000(Server andProfessional),with ServicePack 1orlater
v
WindowsXP
ThecomputeronwhichyouinstalltheDB2OfficeConnectproductsrequires: v MicrosoftExcel,Version97orlater,with ServicePack 1orlater
v InternetExplorer,Version5.5withServicePack 1orlater
v MicrosoftDataAccessComponents(ADO),Version2.5withServicePack2
orlater(includedwith theOfficeConnectinstall)
v IfyouconnecttoanIBM DB2server,IBMDB2Client7.01.0041orlaterand
FixPak5 orlatermust beinstalledonyourlocalcomputer. v
Aharddrivewith150MB availablefora typicalinstallation(or100MB for
aminimalinstallation)
Formoreinformationaboutinstallationrequirements,seetheDB2Office ConnectInstallationNotes.
Supported
languages
DB2DataWarehouse Editionisprovidedinseverallanguageswith some variationinlanguagesupport bycomponentproduct.For specificinformation onlanguagesupport,seethedocumentationforeachproductintheDB2Data WarehouseEdition.Thefollowinglanguages aresupportedfor mostofthe productsin theDB2Data WarehouseEdition:
v English v French v German v Korean v Japanese v Spanish v BrazilianPortuguese v Italian v TraditionalChinese
NotethatDB2Query PatrollerdoesnotsupportBrazilian Portuguese,Italian, Spanish,andTraditionalChinese.Also,DB2 UniversalDatabaseWorkgroup ServerUnlimitedEditiondoesnotsupport Spanish.
Appendix
B.
Troubleshooting
Thissectiondescribes restrictionsand possibleproblemsthatyoumight encounterwhenyouinstalltheproductsintheDB2 DataWarehouse EnterpriseEditionortheDB2DataWarehouse StandardEdition.
Cannotinstall DB2UDBEnterpriseServerEditionon theinstance-owning Windowsserverpriorto settingupa domainserver
ForWindowsservers,youmustset upandconfigureActive Directory (systemsetupfora domainserver)beforeyouinstallDB2UDB EnterpriseServer Edition.Otherwise,youcannotselectthe multipartitionoption.
Cannotinstall DB2UDBWorkgroupServerUnlimitedEditionon additionalpartitioned servers(notaninstance-owningserver)
Youmust installDB2UDB WorkgroupServerUnlimitedEditiononall participatingservers.
Remoteoperationsfail afterinstallingtheOracle9i clientfortheDB2 InformationIntegrator(onLinux)relationalwrappers
Remoteoperationsfailwhenthey usetheOracle9iclientandNET8 wrapperona federatedserveronLinux.Youmusteditthegenclntsh scriptbeforeorafter thefederatedserverissetuptoaccessOracle datasources. Toeditthescript,seethefollowingtopicsintheDB2 InformationIntegrator InformationCenter:EditingtheOracle genclntsh scriptbeforethefederatedserverissetuptoaccessOracledatasourcesor
Editingthe Oraclegenclntshscriptafter thefederatedserverissetupto accessOracledatasources.YoucanseethesetopicsinPDF(portable diskformat)intheDB2InformationIntegratorInstallationGuide.For thelatestupdatestotheDB2InformationIntegratorinformation,see theAddendum totheDB2 InformationIntegrator™ReleaseNotes,Version
8.1.
Re-initializingthecontroldatabaseforDB2WarehouseManagerStandard Edition
Youmust re-initializethecontroldatabase afteryouinstallFixPak2+ forDB2UDB,Version8.1.2.Otherwise,youcannotconnecttothe controldatabase.
DB2UDBEnterpriseServerEditiondoesnotstartaftercreating multipartitionedservers onSolaris andLinux
IfDB2UDBEnterpriseServerEditiondoesnotstart onSolarisand Linux,youmightneedtoupdatethe.rhostsfiletoincludetheserver nameandinstance nameforeachnoderegardlessofwhetherallthe
nodesareonthesameserver.Youmust includemultipleentriesofthe sameserverandinstancenameinthe.rhostsfile.
DB2UDBEnterpriseServerEditionfreezeswithoutanyerrormessages whencreatingadatabase
Unlikeotherplatforms,whenyouaddpartitionsornodeson Windows,youmust usethedb2ncrtcommandifyoualreadyhave databasesonthesystem.ThiscommandworksonWindowsonly.Do notupdatedb2nodes.cfgfilemanuallylikeyouwouldforother operatingsystems.Updatingthis filemightappeartowork,butthe databasecreationwillfail.
DB2UDBEnterpriseServerEditionfailswhenconnectingtoOracletables
DB2UDBEnterpriseServerEditionfailswhenaccessingOracle tables onOracle 9ionLinuxRed Hat8, HP,andSolaris.ThisisanOracle defect.YoumustmodifytheOraclescript andbuilda newlibraryfile. Seethedocumentationforfederatedserversabouthow tobuildanew library.
TheData WarehouseCenterfailsafterdefininga DB2UDBEnterprise ServerEditionWindows source
Youmight see this message:DWC07180E-The warehouse server
encountered an unexpected error while receiving a start response from an agent process. RC=7180 RC2=9117. You might need to create asoftlinkforIWH2AGNT.Ifthereisnosoftlink,thewarehouseserver andtheagentdaemonmightnotstart.
YoumustinstallIntelligent Minerscoringmanually
IfyouareinstallingonSunSolaris,andmust installIntelligentMiner scoringmanually,dothefollowing:
1. Createa symboliclinkfrom/opt/IBMdb2/V7.2totheDB2
versionthatyouhaveinstalled.Forexample,if youhaveinstalled DB2V8.1, typethefollowingcommands:
mkdir/opt/IBMdb2 cd/opt/IBMdb2
ln -s /opt/IBM/db2/V8.1 V7.2
2. InstallIntelligentMiner scoring.
3. Apply PTF22668.
4. Removethesymboliclink.For example,ifyouhaveinstalledDB2
V8.1,type thefollowingcommands:
rm /opt/IBMdb2/V7.2 rmdir /opt/IBMdb2
Log
file
locations
IfyouhavedifficultyinstallingIBMDB2Universal DatabaseData Warehouse EnterpriseEditionorIBMDB2 UniversalDatabaseDataWarehouseStandard Edition,youcanview logfilestohelpyoutoisolatetheproblem.
OnWindows,thefollowinglogfilesarelocatedinthe%TEMP%directory: Table10.Logfilelocations
Component Logfilelocation
DB2UDBEnterpriseServerEdition,DB2 UDBWorkgroupServerUnlimitedEdition
db2inst.log
DB2HTMLDocumentation db2doc.log
DB2UDBAdministrationClient db2adm.log
DB2UDBRuntimeClient db2rt.log
IBMDB2WarehouseManager wminst.log
IBMDB2InformationIntegratorStandard Edition
iiinst.log
IBMDB2CubeViews cvinst.log
IBMDB2QueryPatroller qpinst.log
Thedb2wi.logfilemightalso containadditionalinstallationinformation. Performasearchonyour systemtolocatethisfile.
OnUNIX,inthedefaulttempdirectory(usually/tmp),refertothe db2setup.logfileforall DB2productsinstallationinformation.The informationinthislogisappendedtothedb2setup.hisfile.
Note: IntelligentMinerinstallations donotcreatelogs.However,youcan
reviewtheret.txtfileinthetempdirectoryforsomeinstallation information.
Notices
Thisinformationwasdevelopedforproductsandservices offeredinthe U.S.A.
IBMmaynotoffertheproducts,services,orfeaturesdiscussedinthis documentinothercountries.Consultyour localIBMrepresentativefor
informationontheproductsandservices currentlyavailable inyourarea.Any referencetoanIBMproduct, program,orserviceisnotintendedtostateor implythatonlythatIBM product,program,orservicemaybe used.Any functionallyequivalentproduct,program,orservicethatdoesnotinfringe anyIBMintellectual propertyrightmaybeusedinstead.However,it isthe user’sresponsibilitytoevaluateandverifytheoperationofanynon-IBM product,program,orservice.
IBMmayhavepatentsorpending patentapplicationscoveringsubjectmatter describedinthisdocument.Thefurnishingofthis documentdoesnotgive youanylicensetothese patents.Youcansend licenseinquiries, inwriting,to: IBMDirectorofLicensing
IBMCorporation NorthCastleDrive Armonk,NY10504-1785 U.S.A.
Forlicenseinquiriesregardingdouble-byte(DBCS)information,contactthe IBMIntellectualPropertyDepartmentinyour countryorsend inquiries,in writing,to:
IBMWorldTradeAsiaCorporation Licensing
2-31Roppongi3-chome,Minato-ku Tokyo106, Japan
Thefollowing paragraphdoesnotapplyto theUnited Kingdomorany othercountry wheresuchprovisionsareinconsistentwithlocal law:
INTERNATIONALBUSINESSMACHINESCORPORATIONPROVIDES THIS
PUBLICATION“ASIS” WITHOUTWARRANTYOFANYKIND,EITHER EXPRESSORIMPLIED,INCLUDING,BUTNOT LIMITEDTO,THE
IMPLIEDWARRANTIESOFNON-INFRINGEMENT,MERCHANTABILITY
ORFITNESSFORAPARTICULARPURPOSE.Somestatesdo notallow disclaimerofexpressorimpliedwarrantiesin certaintransactions,therefore, thisstatementmaynotapply toyou.
Thisinformationcouldinclude technicalinaccuraciesortypographicalerrors. Changesareperiodically madetotheinformationherein;thesechangeswill beincorporatedinneweditionsofthepublication.IBMmaymake
improvementsand/orchanges intheproduct(s)and/or theprogram(s) describedinthispublicationat anytimewithoutnotice.
IBMmayuseordistributeanyof theinformationyousupplyinanyway it believesappropriatewithoutincurringanyobligationtoyou.
Licenseesofthisprogramwhowishtohaveinformationaboutitforthe purposeofenabling:(i) theexchangeof informationbetweenindependently createdprogramsandotherprograms(includingthisone)and(ii)themutual useoftheinformationwhichhasbeen exchanged,shouldcontact:
IBMCorporation J46A/G4
555BaileyAvenue SanJose,CA95141-1003 U.S.A.
Suchinformationmaybeavailable,subjecttoappropriatetermsand conditions,includingin somecases,paymentofa fee.
Thelicensedprogramdescribedinthis informationandalllicensedmaterial availableforitare providedbyIBM undertermsoftheIBMCustomer Agreement,IBM InternationalProgramLicenseAgreement,oranyequivalent agreementbetweenus.
Informationconcerning non-IBMproductswas obtainedfromthesuppliersof thoseproducts,their publishedannouncementsorotherpubliclyavailable sources.IBMhasnottestedthoseproductsandcannotconfirmtheaccuracy ofperformance,compatibilityoranyotherclaimsrelatedtonon-IBM products.Questionsonthecapabilitiesofnon-IBMproductsshouldbe addressedtothesuppliersof thoseproducts.
Thisinformationcontainsexamples ofdataandreportsusedindailybusiness operations.Toillustratethemascompletelyaspossible,theexamplesinclude thenamesofindividuals, companies,brands,and products.Allofthese namesarefictitiousandanysimilaritytothenamesandaddressesusedbyan actualbusinessenterpriseisentirelycoincidental.
Anyperformance datacontainedhereinwasdeterminedinacontrolled environment.Therefore,theresultsobtainedinotheroperatingenvironments mayvarysignificantly.Somemeasurementsmayhavebeen madeon
development-levelsystemsandthereisnoguaranteethatthesemeasurements willbe thesame ongenerallyavailable systems.Furthermore,some
measurementmayhavebeen estimatedthrough extrapolation.Actualresults mayvary.Usersofthis documentshouldverify theapplicabledatafortheir specificenvironment.
Informationconcerning non-IBMproductswas obtainedfromthesuppliersof thoseproducts,theirpublished announcementsorotherpubliclyavailable sources.IBMhasnottestedthoseproductsandcannotconfirmtheaccuracy ofperformance,compatibilityoranyotherclaimsrelatedtonon-IBM products.Questionsonthecapabilitiesofnon-IBMproductsshouldbe addressedtothesuppliersof thoseproducts.
Ifyouareviewingthis informationsoftcopy,thephotographsand color illustrationsmaynotappear.
Trademarks
ThefollowingtermsaretrademarksofInternationalBusiness Machines CorporationintheUnitedStates,othercountries,orboth:
AIX AIX5L DB2 DB2Connect DB2UniversalDatabase eServer IBM Informix IntelligentMiner iSeries OS/400 pSeries RedBrick RISCSystem/6000 z/OS zSeries
Thefollowingtermsaretrademarksorregisteredtrademarksofother companies:
Microsoft,Windows,WindowsNT,and theWindows logoaretrademarksof MicrosoftcorporationintheUnitedStates,othercountries,orboth.
JavaorallJava-basedtrademarksandlogos,and Solarisaretrademarksof SunMicrosystems, Inc.intheUnitedStates, othercountries,or both.
UNIXisa registeredtrademarkofTheOpenGroupintheUnitedStatesand othercountries.
ActionMedia,LANDesk,MMX,Pentium andProSharearetrademarksofIntel CorporationintheUnitedStates,othercountries,orboth.
Othercompany,product,orservicenamesmaybetrademarksorservice marksofothers.
Index
D
dataflowscenarios 9 DB2CubeViews
description 3 hardwareandsoftware
requirements 28 DB2DataWarehouseEdition
description 1
DB2DataWarehouseEnterprise Edition
hardwareandsoftware requirements 25 installing 15
DB2DataWarehouseStandard Edition
hardwareandsoftware requirements 25 installing 15
DB2InformationIntegrator description 7
hardwareandsoftware requirements 27 DB2IntelligentMiner
description 3 hardwareandsoftware
requirements 30
DB2IntelligentMinerModeling description 4
DB2IntelligentMinerScoring description 4
DB2IntelligentMinerVisualization description 4
DB2OfficeConnect hardwareandsoftware
requirements 33 DB2QueryPatroller
description 6 hardwareandsoftware
requirements 28
DB2UDBEnterpriseServerEdition description 2
DB2UDBWorkgroupServer UnlimitedEdition
description 2 DB2UniversalDatabase
hardwareandsoftware requirements 25
DB2WarehouseManager hardwareandsoftware
requirements 27
DB2WarehouseManagerStandard Edition
description 6 description
DB2CubeViews 3
DB2DataWarehouseEdition 1 DB2InformationIntegrator 7 DB2IntelligentMiner 3 DB2IntelligentMiner
Modeling 4
DB2IntelligentMinerScoring 4 DB2IntelligentMiner
Visualization 4 DB2QueryPatroller 6 DB2UDBEnterpriseServer
Edition 2
DB2UDBWorkgroupServer UnlimitedEdition 2 DB2WarehouseManager
StandardEdition 6 IBMDB2OfficeConnect
AnalyticsEdition 3 IBMDB2OfficeConnect
EnterpriseWebEdition 5 IBMDB2OfficeConnect
ProfessionalWebEdition 5 relationalwrappers 7 warehouseETLagents 7 warehousetransformers 6
H
hardware
requirementsoverview 13 hardwareandsoftware
requirements 25 DB2CubeViews 28
DB2DataWarehouseEnterprise Edition 25
DB2DataWarehouseStandard Edition 25 DB2InformationIntegrator 27 DB2IntelligentMiner 30 DB2OfficeConnect 33 DB2QueryPatroller 28 DB2UniversalDatabase 25 DB2WarehouseManager 27
I
IBMDB2OfficeConnectAnalytics Edition
description 3
IBMDB2OfficeConnectEnterprise WebEdition
description 5
IBMDB2OfficeConnectProfessional WebEdition
description 5 installing
DB2DataWarehouseEnterprise Edition 15
DB2DataWarehouseStandard Edition 15
L
logfilelocations 37
R
Relationalwrappers description 7 requirementsoverview
hardwareandsoftware 13
S
software
requirementsoverview 13 softwarerequirements
Seehardwareandsoftware requirements 25 startingtheinstallation 16
T
troubleshooting 35
W
WarehouseETLagents description 7 Warehousetransformers
description 6
Contacting
IBM
Ifyouhaveatechnicalproblem,pleasereview andcarryouttheactions suggestedbytheproductdocumentationbeforecontactingDB2Data WarehouseEditionCustomerSupport.Thisguidesuggestsinformationthat youcangathertohelp DB2DataWarehouse EditionCustomer Supportto serveyoubetter.
ForinformationortoorderanyoftheDB2 DataWarehouseEditionproducts, contactanIBM representativeatalocalbranchofficeorcontact any
authorizedIBMsoftwareremarketer.
Ifyoulivein theU.S.A.,youcancallone ofthefollowingnumbers: v 1-800-IBM-SERVforcustomersupport
v 1-888-426-4343tolearnaboutavailableserviceoptions
Product
Information
Ifyoulivein theU.S.A.,then youcancalloneofthefollowingnumbers: v 1-800-IBM-CALL(1-800-426-2255)or1-800-3IBM-OS2(1-800-342-6672)to
orderproductsorgetgeneralinformation. v
1-800-879-2755toorderpublications.
http://www.ibm.com/software/data/db2/udb
TheDB2UniversalDatabaseWebpagesprovidecurrentinformation aboutnews, productdescriptions,educationschedules,and more.
http://www.elink.ibmlink.ibm.com/public/applications/
publications/cgibin/pbi.cgiTheInternationalPublicationsordering Websiteprovides informationabouthow toorderbooks.
http://www.ibm.com/education/certify/
TheProfessionalCertificationProgramfromtheIBM Website providescertificationtest informationfor avarietyofIBMproducts.
Note: Insomecountries,IBM-authorizeddealersshouldcontacttheirdealer
supportstructure insteadoftheIBMSupportCenter.
Comments
on
the
documentation
Yourfeedback helpsIBMtoprovidequalityinformation.Pleasesend any commentsthatyouhaveaboutthisbookorotherDB2Data Warehouse Editiondocumentation.Youcanuseanyofthefollowingmethodstoprovide comments:
v Sendyourcommentsusingtheonlinereaders’commentform at
www.ibm.com/software/data/rcf.
v Sendyourcommentsbyelectronicmail(e-mail)[email protected].
Besuretoinclude thenameoftheproduct,theversionnumberofthe product,andthenameandpartnumber ofthebook(if applicable).Ifyou arecommenting onspecific text,pleaseincludethelocationofthetext(for example,atitle, atablenumber,ora pagenumber).
