Configuring JDBC Data Sources | IBM G210-1784-00 manual

Image 5

IBM G210-1784-00 manual Configuring JDBC Data Sources, Configuring Environment Entries, Application Servers

Contents

Lotus Learning Management System R1 Installation GuideVersion March Disclaimer CopyrightsCopyright List of Trademarks Netscape and Netscape Navigator are registered trademarks of Netscape Communications Corporation in the United States and other countries Chapter 5 Installing the WebSphere Core ContentsChapter 6 Installing or Identifying the LDAP Directory Chapter 8 Installing the Delivery Server DS Application Files Chapter 12 Configuring Environment Entries Chapter 11 Configuring JDBC Data SourcesChapter 18 Post-Installation Tasks Chapter 10 Installing the Network Deployment ND Module Chapter 19 Special Installation Issues Appendix A LMS Performance and Fine-tuning InformationIndex Chapter 20 Removing the IBM Lotus Learning Management System vi IBM Lotus LMS Release 1 Installation Guide Chapter About the IBM Lotus Learning Management System What is the Learning Management System?Introduction Understanding the Learning Management System Architecture 2 IBM Lotus LMS Release 1 Installation Guide Relational database management system Chapter Learning Management System Requirements Time zone settingsDatabase server requirements Learning Management System server requirements Client software requirements Client hardware requirementsAudio and video requirements 4 IBM Lotus LMS Release 1 Installation Guide Packaging overview Chapter Learning Management System Installation Overview 2. Install the database server software An outline of the installation process3. Install WebSphere core 4. Install or identify the LDAP Directory 6. Install and/or configure logical database servers and schema 8. Configure JDBC data sources 7. Install the Network Deployment module optional9. Configure environment entries 10.Configure WebSphere Application Server security 13.Start the applications 14.Complete post-installation tasks 10 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 12 IBM Lotus LMS Release 1 Installation Guide Learning Management System Hardware requirements Chapter 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 Additional LDAP information and guidelines WebSphere Application Server and LDAP User filter strings Installer program information Chapter Installing the Learning Management System Server ApplicationINSTALLER Files Select 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 Content Management settings Select the Administrator settings Select the installation destination and complete the installation Starting the Learning Management System Server application 28 IBM Lotus LMS Release 1 Installation Guide Chapter Installing the Delivery Server DS Application Files 30 IBM Lotus LMS Release 1 Installation Guide Installing the Delivery Server application software Select the Learning Management System Server settings 32 IBM Lotus LMS Release 1 Installation Guide Select the Delivery Server settings Select the Web Server settings Select the Content Deployment settings for FTP deployment Select the System Administrator E-mail settings Select the Content Deployment settings for file system deployment 36 IBM Lotus LMS Release 1 Installation Guide Starting the Delivery Server application Database Creation Overview Chapter Installing and Configuring Database Servers and Schema Before you begin Installation Requirements The settings can be verified with these commands UPDATESOLARISKERNEL Creating the LMM database Database creation detailsCreating an Audit database Creating the DS databases Connecting the DB2 client to a remote databaseInstalling the DB2 client Verify the DB2 client UNIX only Configure JDBC db2 connect to databasealias user userid using password Catalog the remote databases3. Run the startup script INSTHOME/sqllib/db2profile db2 catalog database databasename as databasealias at node nodename Oracle database creation for the Learning Management System Installation requirementsCreating a Learning Management System schema Creating the DS schemas Creating an Audit schemaMS SQL Server database creation for the Learning Management System JDBC driver information Cisql -S servername -U sa -i crmssqldbaudit.sql auditdb.log JDBC Driver informationCisql -S servername -d auditdb -U sa -e -i auditmssql.sql audit.log Cisql -S servername -d auditdb -U sa -i auditdata.sql auditseed.log To 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 Data source overview Chapter Configuring JDBC Data Sources Defining the JDBC provider for a DB2 database Defining the JDBC provider 4. Click OK to continue 56 IBM Lotus LMS Release 1 Installation Guide 3. Click J2C Authentication Data Create the J2C Authentication Data EntriesDefining the JDBC data sources Defining the JDBC provider for a SQL Server database Create the data sources 13. Enter the following information 60 IBM Lotus LMS Release 1 Installation Guide Click Apply 16. Repeat this procedure for the two remaining databases 1. 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 3. Enter the provider details 4. Configure the Referenceable 5. 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 13. Set Value to true 14. Click OK17. Set Name to LMSFALSE 18. Set JNDI Name to LMSFALSE 19. Click OK 20. Click LMSFALSE 21. Click Custom Properties 22. Click New 70 IBM Lotus LMS Release 1 Installation Guide Chapter 13 Configuring WebSphere Application Server Security Chapter Configuring WebSphere Application Server Security 2. Click on the LDAP link. The LDAP User Registry page is displayed 16. Click Save 17. Click OK Enable WAS Global Security 1. Select the .ear file for deployment Chapter Deploying the Learning Management System Server Application 76 IBM Lotus LMS Release 1 Installation Guide 2. Prepare for application install 3. Provide options to perform the installation 78 IBM Lotus LMS Release 1 Installation Guide 4. Map resources references to resources 5. 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 Review 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 Starting the application and regenerating web server plug-in Chapter Deploying the Delivery Server DS Application 86 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 Windows example \HTTPINSTALLROOT\Apache -k restart Running the UpdaterUNIX example /HTTPINSTALLROOT/apachectl restart Regenerating the web server plug-in Chapter 17 Starting the Applications Configuring on-line help Chapter Post-Installation Tasks Deploying 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 # 5 # 6 - reboot Do NOT set initdefault to this id5initdefault Installing XVFB on AIXChange id5initdefault to id3initdefault ln -s /etc/init.d/xvfb /etc/rc3.d/S75xvfb Chapter 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 LDAP tuning guidelines Tuning LDAP performance Deferring the IsManager lookup Tuning database server performanceIndexing LDAP attributes Microsoft Windows 2000 servers Tuning TCP/IP settings on LMS serversTcpTimedWaitDelay MaxUserPort Linux servers tcpfintimeoutIBM AIX servers TcpNumConnections Sun Solaris servers Tuning HTTP serverstcptimewaitinterval tcpfinwait2flushinterval Tuning the Microsoft Internet Information Server IIS Tuning the Sun ONE Web server, Enterprise Edition - SolarisAdjusting the Active Threads parameter IIS permission properties MinSpareServers, MaxSpareServers, StartServers, and MaxClients Tuning the IBM HTTP ServerMaxPoolThreads and PoolThreadLimit parameter Timeout Tuning the IBM HTTP Server in WindowsMaxRequestsPerChild LoadModule and AddModule MaxKeepAliveRequests Checking for thread usage using IBM HTTP Server server-statusChecking for thread usage with the Windows 2000 Performance Monitor 114 IBM Lotus LMS Release 1 Installation Guide AfpaEnableHTTP Logging Adjusting JVM Heap size Adjusting the JVM parameter garbage collection threads Adjusting the JVM parameter to avoid class verificationAdjusting the Web container thread pool Enabling the JIT compiler Adjusting the Web container MaxKeepAliveRequests parameter Adjusting the Web container MaxKeepAliveConnections Adjusting the JDBC Data Source Connection Pool size Tuning the LMS applicationsAdjusting LMS logging Application Log MaxRecords and Minutes parameters LMS parameters Archiving the LMS log files Oracle PROCESSES Parameter Oracle server only Appendix A LMS Performance and Fine-tuning Information Index installing configuringregenerating WebSphere Core Printed in USA