Manuals / IBM / Personal Care / Hearing Aid

IBM G210-1784-00 manual Click OK to continue, Configuring JDBC Data Sources

Models: G210-1784-00

1 131

Download 131 pages 28.82 Kb

Page 62

4.Click OK to continue.

4.Click OK to continue.

5.At the Configuration - General Properties screen for the JDBC Provider, note the value in the Classpath field and click OK to continue.

Chapter 11: Configuring JDBC Data Sources 55

Image 62

IBM G210-1784-00 manual Click OK to continue, Configuring JDBC Data Sources

Contents

Version Installation GuideLotus Learning Management System R1 MarchCopyright CopyrightsDisclaimer List of TrademarksNetscape and Netscape Navigator are registered trademarks of Netscape Communications Corporation in the United States and other countries Chapter 6 Installing or Identifying the LDAP Directory ContentsChapter 5 Installing the WebSphere Core Chapter 8 Installing the Delivery Server DS Application FilesChapter 18 Post-Installation Tasks Chapter 11 Configuring JDBC Data SourcesChapter 12 Configuring Environment Entries Chapter 10 Installing the Network Deployment ND ModuleIndex Appendix A LMS Performance and Fine-tuning InformationChapter 19 Special Installation Issues Chapter 20 Removing the IBM Lotus Learning Management Systemvi IBM Lotus LMS Release 1 Installation Guide Introduction What is the Learning Management System?Chapter About the IBM Lotus Learning Management System Understanding the Learning Management System ArchitectureRelational database management system 2 IBM Lotus LMS Release 1 Installation GuideDatabase server requirements Time zone settingsChapter Learning Management System Requirements Learning Management System server requirementsAudio and video requirements Client hardware requirementsClient software requirements 4 IBM Lotus LMS Release 1 Installation GuideChapter Learning Management System Installation Overview Packaging overview3. Install WebSphere core An outline of the installation process2. Install the database server software 4. Install or identify the LDAP Directory6. Install and/or configure logical database servers and schema 9. Configure environment entries 7. Install the Network Deployment module optional8. Configure JDBC data sources 10.Configure WebSphere Application Server security14.Complete post-installation tasks 13.Start the applications10 IBM Lotus LMS Release 1 Installation Guide Creating a new database or upgrading an existing database Chapter Identifying Learning Management System Hardware AssetsAllocating server responsibilities Learning Management System Hardware requirements 12 IBM Lotus LMS Release 1 Installation GuideChapter Installing the WebSphere Core Enabling SSO in WebSphere Expand the Security panel on the left side 16 IBM Lotus LMS Release 1 Installation Guide Installation Steps Chapter Installing or Identifying the LDAP DirectoryInstalling the IBM Directory Server LDAP Directory an example Directory Configuration Steps 6. Logoff from the administrative interface by doing the following WebSphere Application Server and LDAP User filter strings Additional LDAP information and guidelinesINSTALLER Chapter Installing the Learning Management System Server ApplicationInstaller program information FilesSelect the correct LDAP settings and test the LDAP connection Installing the Learning Management System Server application softwareSelect the Learning Management System features to install Select the Learning Management System Server settings 24 IBM Lotus LMS Release 1 Installation Guide Select the Administrator settings Select the Content Management settingsSelect the installation destination and complete the installation Starting the Learning Management System Server application 28 IBM Lotus LMS Release 1 Installation Guide INSTALLER Chapter Installing the Delivery Server DS Application FilesInstaller program information PLATFORMSelect the correct LDAP settings and test the LDAP connection Installing the Delivery Server application softwareSelect the Learning Management System features to install 30 IBM Lotus LMS Release 1 Installation GuideSelect the Learning Management System Server settings Select the Delivery Server settings 32 IBM Lotus LMS Release 1 Installation GuideSelect the Web Server settings Select the Content Deployment settings for FTP deployment Select the Content Deployment settings for file system deployment Select the System Administrator E-mail settings36 IBM Lotus LMS Release 1 Installation Guide Starting the Delivery Server applicationSelect the installation destination and complete the installation Chapter Installing and Configuring Database Servers and Schema Database Creation OverviewInstallation Requirements Before you beginUPDATESOLARISKERNEL The settings can be verified with these commandsCreating the LMM database Database creation detailsCreating an Audit database Creating the DS databases Connecting the DB2 client to a remote databaseInstalling the DB2 client Configure JDBC Verify the DB2 client UNIX only3. Run the startup script INSTHOME/sqllib/db2profile Catalog the remote databasesdb2 connect to databasealias user userid using password db2 catalog database databasename as databasealias at node nodenameOracle database creation for the Learning Management System Installation requirementsCreating a Learning Management System schema Database creation detailsMS SQL Server database creation for the Learning Management System Creating an Audit schemaCreating the DS schemas JDBC driver informationCisql -S servername -d auditdb -U sa -e -i auditmssql.sql audit.log JDBC Driver informationCisql -S servername -U sa -i crmssqldbaudit.sql auditdb.log Cisql -S servername -d auditdb -U sa -i auditdata.sql auditseed.logTo meet the need for UNIX script files for DB2 that accomplish the same thing that the provided DB2 DOS batch files do, .sh scripts have been provided. There is one script for each database. These files should be read and edited before executing them 48 IBM Lotus LMS Release 1 Installation Guide Chapter Installing the Network Deployment ND Module 50 IBM Lotus LMS Release 1 Installation Guide Additional guidelines regarding the use of ND 52 IBM Lotus LMS Release 1 Installation Guide Chapter Configuring JDBC Data Sources Data source overviewDefining the JDBC provider Defining the JDBC provider for a DB2 databaseChapter 11 Configuring JDBC Data Sources 4. Click OK to continue56 IBM Lotus LMS Release 1 Installation Guide Defining the JDBC data sources Create the J2C Authentication Data Entries3. Click J2C Authentication Data Defining the JDBC provider for a SQL Server databaseCreate the data sources 13. Enter the following information Click Apply 16. Repeat this procedure for the two remaining databases 60 IBM Lotus LMS Release 1 Installation Guide1. Go to Data Sources 2. Click on the desired dbname URL jdbcoraclethin@server.acme.com1521name 1. Create the Resource Environment Provider Chapter Configuring Environment EntriesConfiguring an environment entry for the log file location b. Click OK. A new provider appears in the list of defined providers 2. Enter the provider information64 IBM Lotus LMS Release 1 Installation Guide 4. Configure the Referenceable 3. Enter the provider details5. Configure the Resource Environment entries c. Click New to go to the page to define an entry. Enter LMSLOG as both the name and JNDI name for the new entry f. Click OK to complete this entry and its properties 15. Click the Resource Env Entries link in the trail 16. Click New Chapter 12 Configuring Environment Entries13. Set Value to true 14. Click OK 17. Set Name to LMSFALSE 18. Set JNDI Name to LMSFALSE 19. Click OK70 IBM Lotus LMS Release 1 Installation Guide Chapter Configuring WebSphere Application Server Security Chapter 13 Configuring WebSphere Application Server Security2. Click on the LDAP link. The LDAP User Registry page is displayed 16. Click Save 17. Click OK Enable WAS Global Security Chapter Deploying the Learning Management System Server Application 1. Select the .ear file for deployment2. Prepare for application install 76 IBM Lotus LMS Release 1 Installation Guide3. Provide options to perform the installation 4. Map resources references to resources 78 IBM Lotus LMS Release 1 Installation Guide5. Map resource env environment entry references to resources 80 IBM Lotus LMS Release 1 Installation Guide 6. Map virtual hosts to web modules7. Map modules to application servers 8. Map security roles to users/groups Chapter 14 Deploying the LMS Server ApplicationReview them and if they are correct, click Finish to continue 9. View summary and confirmation information82 IBM Lotus LMS Release 1 Installation Guide 10.Starting the application and regenerating web server plug-in 84 IBM Lotus LMS Release 1 Installation Guide Chapter Deploying the Delivery Server DS Application Starting the application and regenerating web server plug-in86 IBM Lotus LMS Release 1 Installation Guide Chapter 88 IBM Lotus LMS Release 1 Installation Guide Starting the Delivery Server application Chapter Starting the ApplicationsStarting the Learning Management System Server application UNIX example /HTTPINSTALLROOT/apachectl restart Running the UpdaterWindows example \HTTPINSTALLROOT\Apache -k restart Regenerating the web server plug-inChapter 17 Starting the Applications Chapter Post-Installation Tasks Configuring on-line helpDeploying the Offline Learning Client Installing the Authoring ToolInstalling the Command Line Import Utility CLIMP Migrating LearningSpace data Installing XVFB on UNIX platforms to enable reportingInstalling XVFB on Linux 5. Change the run-level to 3 by doing the following 3. Extract the file with the following commandsIf you dont have this file, proceed with step Change id5initdefault to id3initdefault Installing XVFB on AIX# 5 # 6 - reboot Do NOT set initdefault to this id5initdefault ln -s /etc/init.d/xvfb /etc/rc3.d/S75xvfbChapter 18 Post-Installation Tasks 98 IBM Lotus LMS Release 1 Installation Guide Using the Directory Server Web Administration Interface with Linux Chapter Special Installation IssuesUsing SSL with the Learning Management System 100 IBM Lotus LMS Release 1 Installation Guide Removing the Learning, DS, and Audit databases Removing the installed Learning Management System filesChapter Removing the IBM Lotus Learning Management System 102 IBM Lotus LMS Release 1 Installation Guide Moving static LMS elements to the Web Server Appendix A LMS Performance and Fine-tuning InformationInstalling static files for the Learning Server user interface Installing static files for the Delivery Server user interface Tuning LDAP performance LDAP tuning guidelinesDeferring the IsManager lookup Tuning database server performanceIndexing LDAP attributes Microsoft Windows 2000 servers Tuning TCP/IP settings on LMS serversTcpTimedWaitDelay MaxUserPortIBM AIX servers tcpfintimeoutLinux servers TcpNumConnectionstcptimewaitinterval Tuning HTTP serversSun Solaris servers tcpfinwait2flushintervalAdjusting the Active Threads parameter Tuning the Sun ONE Web server, Enterprise Edition - SolarisTuning the Microsoft Internet Information Server IIS IIS permission propertiesMinSpareServers, MaxSpareServers, StartServers, and MaxClients Tuning the IBM HTTP ServerMaxPoolThreads and PoolThreadLimit parameter MaxRequestsPerChild Tuning the IBM HTTP Server in WindowsTimeout LoadModule and AddModuleMaxKeepAliveRequests Checking for thread usage using IBM HTTP Server server-statusChecking for thread usage with the Windows 2000 Performance Monitor MaxRequestsPerChild114 IBM Lotus LMS Release 1 Installation Guide AfpaEnableHTTP Logging Adjusting JVM Heap size Adjusting the Web container thread pool Adjusting the JVM parameter to avoid class verificationAdjusting the JVM parameter garbage collection threads Enabling the JIT compilerAdjusting the Web container MaxKeepAliveConnections Adjusting the Web container MaxKeepAliveRequests parameterAdjusting LMS logging Tuning the LMS applicationsAdjusting the JDBC Data Source Connection Pool size Application LogArchiving the LMS log files MaxRecords and Minutes parameters LMS parametersOracle PROCESSES Parameter Oracle server only Appendix A LMS Performance and Fine-tuning Information Index installing configuringinstalling regeneratingPrinted in USA