Filter
Top Products
This specifies the maximum number of open files, system-wide, to 32K.
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 -tvf audit_db2.sql >
audit_schema.log.
7. From the DB2 command window, run the Audit seed data script db2 -tvf audit_data.sql
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