This specifies the maximum number of open files,
Database creation details
The following procedures provide detailed instructions on installing and creating the necessary DB2 databases for use with the Learning Management System:
Creating an Audit database
1.Copy the script files to the database server. The files required are: cr_db2db_audit.bat (for Windows) or cr_db2db_audit.sh (for UNIX→) and audit_db2.sql.
Note: The default location that the Installer places these files is \Program Files\IBM\lms\scripts. However if you plan to run the scripts from a DB2 command window, \Program Files\SQLLIB\bin is a more convenient location.
Note: When UNIX shell scripts are copied, they may need to be made executable by using the following
command: chmod +x *.sh
Note: When running the .bat files to create the Audit, LMM, and DS databases, you can edit each .bat file to run all of the other DB scripts automatically. This is done by removing the REM comments from within the file. Each of the 3 batch files allows this.
2.Log into the DB2 server using the DB2 administrator account. The database creation must happen on the actual database server. The script cannot be run from a database client machine. The cr_db2db_audit.bat (Windows) or cr_db2db_audit.sh (UNIX) scripts create a unicode. Your database administrator should review and edit this file for your environment.
3.If desired, edit the cr_db2db_audit.bat or cr_db2db_audit.sh file. Changes that might have to be made include specifying multiple database files, increasing file size, and increasing bufferpool size.
4.Open a DB2 command window and run the cr_db2db_audit.bat or cr_db2db_audit.sh file. For example, in Windows use the following command: cr_db2db_audit.bat > audit_db.log. For example, in UNIX use the following command: ./cr_db2db_audit.sh > audit_db.log. This step creates a database named “lsaudit”, and creates the buffer pools required for any Learning Management System schema.
5.If desired, edit the audit_db2.sql script.
6.From a DB2 command window, run the script with the following command: db2
7.From the DB2 command window, run the Audit seed data script db2
Creating the LMM database
1.Copy the script files to the database server. The files required are: cr_db2db_lmm.bat (for Windows) or cr_db2db_lmm.sh (for UNIX) and lmm_db2.sql.
Note: When UNIX shell scripts are copied, they may need to be made executable by using the following
command: chmod +x *.sh
2.Log into the DB2 server using the DB2 administrator account. Database creation must happen on the actual database server. This script cannot be run from a database client machine.
3.If desired, edit the cr_db2db_lmm.bat or cr_db2db_lmm.sh file. Changes that might have to be made include specifying multiple database files, increasing file size, and increasing bufferpool size - temporary and database tablespaces with a 16K blocksize, and bufferpools with a 16K blocksize. Your database administrator should review and edit this file for your environment.
40 IBM Lotus LMS Release 1 Installation Guide
