JDBC driver information, Creating the DS schemas | IBM G210-1784-00

Image 52

IBM G210-1784-00 manual MS SQL Server database creation for the Learning Management System, JDBC driver information

Contents

Installation Guide Lotus Learning Management System R1Version March Copyrights DisclaimerCopyright List of Trademarks Netscape and Netscape Navigator are registered trademarks of Netscape Communications Corporation in the United States and other countries Contents Chapter 5 Installing the WebSphere CoreChapter 6 Installing or Identifying the LDAP Directory Chapter 8 Installing the Delivery Server DS Application Files Chapter 11 Configuring JDBC Data Sources Chapter 12 Configuring Environment EntriesChapter 18 Post-Installation Tasks Chapter 10 Installing the Network Deployment ND Module Appendix A LMS Performance and Fine-tuning Information Chapter 19 Special Installation IssuesIndex Chapter 20 Removing the IBM Lotus Learning Management System vi IBM Lotus LMS Release 1 Installation Guide What is the Learning Management System? Chapter About the IBM Lotus Learning Management SystemIntroduction Understanding the Learning Management System Architecture Relational database management system 2 IBM Lotus LMS Release 1 Installation Guide Time zone settings Chapter Learning Management System RequirementsDatabase server requirements Learning Management System server requirements Client hardware requirements Client software requirementsAudio and video requirements 4 IBM Lotus LMS Release 1 Installation Guide Chapter Learning Management System Installation Overview Packaging overview An outline of the installation process 2. Install the database server software3. Install WebSphere core 4. Install or identify the LDAP Directory 6. Install and/or configure logical database servers and schema 7. Install the Network Deployment module optional 8. Configure JDBC data sources9. Configure environment entries 10.Configure WebSphere Application Server security 14.Complete post-installation tasks 13.Start the applications 10 IBM Lotus LMS Release 1 Installation Guide Allocating server responsibilities Chapter Identifying Learning Management System Hardware AssetsCreating a new database or upgrading an existing database Learning Management System Hardware requirements 12 IBM Lotus LMS Release 1 Installation Guide 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 Installing the IBM Directory Server LDAP Directory an example Chapter Installing or Identifying the LDAP DirectoryInstallation Steps 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 guidelines Chapter Installing the Learning Management System Server Application Installer program informationINSTALLER Files Select the Learning Management System features to install Installing the Learning Management System Server application softwareSelect the correct LDAP settings and test the LDAP connection Select the Learning Management System Server settings 24 IBM Lotus LMS Release 1 Installation Guide Select the Administrator settings Select the Content Management 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 Installing the Delivery Server application software 30 IBM Lotus LMS Release 1 Installation Guide Select the Learning Management System Server settings Select the Delivery Server settings 32 IBM Lotus LMS Release 1 Installation Guide Select 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 settings Starting the Delivery Server application 36 IBM Lotus LMS Release 1 Installation Guide Chapter Installing and Configuring Database Servers and Schema Database Creation Overview Installation Requirements Before you begin UPDATESOLARISKERNEL The settings can be verified with these commands Creating an Audit database Database creation detailsCreating the LMM database Installing the DB2 client Connecting the DB2 client to a remote databaseCreating the DS databases Configure JDBC Verify the DB2 client UNIX only Catalog the remote databases db2 connect to databasealias user userid using password3. Run the startup script INSTHOME/sqllib/db2profile db2 catalog database databasename as databasealias at node nodename Creating a Learning Management System schema Installation requirementsOracle database creation for the Learning Management System Creating an Audit schema Creating the DS schemasMS SQL Server database creation for the Learning Management System JDBC driver information JDBC Driver information Cisql -S servername -U sa -i crmssqldbaudit.sql auditdb.logCisql -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 Chapter Configuring JDBC Data Sources Data source overview Defining the JDBC provider Defining the JDBC provider for a DB2 database 4. Click OK to continue 56 IBM Lotus LMS Release 1 Installation Guide Create the J2C Authentication Data Entries 3. Click J2C Authentication DataDefining the JDBC data sources Defining the JDBC provider for a SQL Server database Create 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 Guide 1. Go to Data Sources 2. Click on the desired dbname URL jdbcoraclethin@server.acme.com1521name Configuring an environment entry for the log file location Chapter Configuring Environment Entries1. Create the Resource Environment Provider 64 IBM Lotus LMS Release 1 Installation Guide 2. Enter the provider informationb. Click OK. A new provider appears in the list of defined providers 4. Configure the Referenceable 3. Enter the provider details 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 13. Set Value to true 14. Click OK 15. Click the Resource Env Entries link in the trail 16. Click New17. 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 Configuring WebSphere Application Server Security Chapter 13 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 Chapter Deploying the Learning Management System Server Application 1. Select the .ear file for deployment 2. Prepare for application install 76 IBM Lotus LMS Release 1 Installation Guide 3. Provide options to perform the installation 4. Map resources references to resources 78 IBM Lotus LMS Release 1 Installation Guide 5. Map resource env environment entry references to resources 7. Map modules to application servers 6. Map virtual hosts to web modules80 IBM Lotus LMS Release 1 Installation Guide 8. Map security roles to users/groups 82 IBM Lotus LMS Release 1 Installation Guide 9. View summary and confirmation informationReview them and if they are correct, click Finish to continue 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-in 86 IBM Lotus LMS Release 1 Installation Guide Chapter 88 IBM Lotus LMS Release 1 Installation Guide Starting the Learning Management System Server application Chapter Starting the ApplicationsStarting the Delivery Server application Running the Updater Windows example \HTTPINSTALLROOT\Apache -k restartUNIX example /HTTPINSTALLROOT/apachectl restart Regenerating the web server plug-in Chapter 17 Starting the Applications Chapter Post-Installation Tasks Configuring on-line help Installing the Command Line Import Utility CLIMP Installing the Authoring ToolDeploying the Offline Learning Client Installing XVFB on Linux Installing XVFB on UNIX platforms to enable reportingMigrating LearningSpace data If you dont have this file, proceed with step 3. Extract the file with the following commands5. Change the run-level to 3 by doing the following Installing XVFB on AIX # 5 # 6 - reboot Do NOT set initdefault to this id5initdefaultChange 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 SSL with the Learning Management System Chapter Special Installation IssuesUsing the Directory Server Web Administration Interface with Linux 100 IBM Lotus LMS Release 1 Installation Guide Chapter Removing the IBM Lotus Learning Management System Removing the installed Learning Management System filesRemoving the Learning, DS, and Audit databases 102 IBM Lotus LMS Release 1 Installation Guide Installing static files for the Learning Server user interface Appendix A LMS Performance and Fine-tuning InformationMoving static LMS elements to the Web Server Installing static files for the Delivery Server user interface Tuning LDAP performance LDAP tuning guidelines Indexing LDAP attributes Tuning database server performanceDeferring the IsManager lookup Tuning TCP/IP settings on LMS servers Microsoft Windows 2000 serversTcpTimedWaitDelay MaxUserPort tcpfintimeout Linux serversIBM AIX servers TcpNumConnections Tuning HTTP servers Sun Solaris serverstcptimewaitinterval tcpfinwait2flushinterval Tuning the Sun ONE Web server, Enterprise Edition - Solaris Tuning the Microsoft Internet Information Server IISAdjusting the Active Threads parameter IIS permission properties MaxPoolThreads and PoolThreadLimit parameter Tuning the IBM HTTP ServerMinSpareServers, MaxSpareServers, StartServers, and MaxClients Tuning the IBM HTTP Server in Windows TimeoutMaxRequestsPerChild LoadModule and AddModule Checking for thread usage with the Windows 2000 Performance Monitor Checking for thread usage using IBM HTTP Server server-statusMaxKeepAliveRequests HTTP Logging AfpaEnable114 IBM Lotus LMS Release 1 Installation Guide Adjusting JVM Heap size Adjusting the JVM parameter to avoid class verification Adjusting the JVM parameter garbage collection threadsAdjusting the Web container thread pool Enabling the JIT compiler Adjusting the Web container MaxKeepAliveConnections Adjusting the Web container MaxKeepAliveRequests parameter Tuning the LMS applications Adjusting the JDBC Data Source Connection Pool sizeAdjusting LMS logging Application Log Archiving the LMS log files MaxRecords and Minutes parameters LMS parameters Oracle PROCESSES Parameter Oracle server only Appendix A LMS Performance and Fine-tuning Information Index configuring installingregenerating WebSphere Core Printed in USA