Configuring Informix for Lotus Mashups (Linux): imc3Added by IBM on November 23, 2010 | Version 1 (Original)
|This topic describes how to configure Informix for Lotus® Mashups on a Linux platform.
This topic describes how to configure Informix for Lotus® Mashups on a Linux platform.
Before you begin
Before starting to configure Informix for Lotus Mashups, you must first install Mashup Center and the Informix database server. For instructions on installing Mashup Center, see ../com.ibm.help.mashups30.intro.doc/mash_intro_plan_install.html. For instructions on installing the Informix database server, see the IBM InfoSphere Informix documentation.
- To improve performance, open the Informix Informix_install_directory/etc/onconfig.database_server_name file, and edit the following parameters to match those on your system:
To prepare to create the database, modify the following files:
- DEF_TABLE_LOCKMODE ROW: The default setting for DEF_TABLE_LOCKMODE is PAGE. Change the page size of the database space to at least 8K to handle the column sizes in your tables. Changing the DEF_TABLE_LOCKMODE from PAGE to ROW helps reduce the chance of deadlocks.
- MULTIPROCESSOR: Change the value to 1 if you have more than one processor on your system.
- VPCLASS CPU,num=: Specify the number of processors you want to make available to Informix, and then reduce the number by one.
- LOGBUFF, PHYSBUFF, RESIDENT, SHMADD, and SHMVIRTSIZE: Modify these parameters, if needed.
- SBSPACENAME: Change the value to SBSPACENAME sbspace_name.
- SYSSBSPACENAME: Change the value to SYSSBSPACENAME sbspace_name.
- TAPEDEV: change the value to dev/null to turn off logical log backup if you do not have a backup tape device.
- Locate the Informix_install_directory/etc/profile file, and add the following lines to provide access to the root directory:
Locate the Informix_install_directory/etc/onconfig.std file, and update the DBSERVERNAME parameter with the name of your database server, for example demo_on.
Locate the Informix_install_directory/etc/sqlhosts file, and replace the demo_on onipcshm on_hostname on_servername line with the following line:
- export INFORMIXDIR=/opt/informix
- export PATH=\$PATH:\$INFORMIXDIR/bin
- export INFORMIXSERVER=demo_on
- export INFORMIXSQLHOSTS=\$INFORMIXDIR/etc/sqlhosts
- export LD_LIBRARY_PATH=\$INFORMIXDIR/lib:\$LD_LIBRARY_PATH
Locate the Informix_install_directory/etc/services file, and add the following line: service name Informix server port number, for example turbo 9091.
Open the Informix_install_directory/etc/onconfig.std file and set ROOTPATH to the following value: \$INFORMIXDIR/tmp/demo_on.rootdbs.
Log into the server as informix or sudo su - informix, change to the \$INFORMIXDIR/tmp/ directory, and run the following commands:
demo_on onsoctcp server host name or IP address server port number
For example, your new line may look something like the following line:
demo_on onsoctcp 188.8.131.52 9091
Remove any lines that begin with demo_se
, such as the demo_se seipcpip se_hostname sqlexec
Start the server by using the oninit -ivy command.
chmod 660 demo_on.rootdbs
Do the following steps to create the database dbspace file and run the required commands on the database server:
If the server is running, run the following command to bring the database down: onmode -kyu.
Run the following command to start the database: oninit -ivy.
Create a new database with the following settings:
- Create an empty file to use as the dbspace file. Name the file something similar to mashups_dat.000, and put it in the same directory as the other Informix data files, such as Informix_install_directory/tmp/.
- Log into the Informix server, change to the Informix_install_directory/tmp/ directory, and then run the following commands to change the file owner and group owner to your Informix user and grant 660 access rights on the file:
chmod 660 mashups_dat.000
- Run the following command to create adequate space in the database:
onspaces -c -d dbspace name -k 8 -p
path of dbspace file -o 0 -s size in kb
For example, your command might look similar to the following command:
onspaces -c -d mashup_dbsl -k 8 -p
Informix_install_directory/tmp/mashups_dat.000 -o 0 -s 400000
The page size value must be in multiples of two.
- Run the following commands to create another temporary sbspace:
chmod 660 mashups_blob_dat.000
- Run the following command to create enough space for the sbspace:
onspaces -c -S sbspace name -p
path of sbspace file -o 0 -s size in kb
For example, your command might look similar to the following command:
onspaces -c -S mashup_sbsl -p
Informix_install_directory/tmp/mashups_blob_dat.000 -o 0 -s 200000
- Run the following command to confirm that dbspace and sbspace are mounted by the Informix server: onstat -d. If the spaces are not loaded, run the commands from the previous steps above and check again.
Stop the Lotus Mashups server.
Do the following steps to configure Lotus Mashups:
- Provide a database name, for example MASHUPS.
- Change the database space to the value of the dbspace name file that you used above, for example mashups_dat.000.
- Change logging to one of the following values: Log, Buffered_log, or log_Mode_ansi.
Copy the files from MashupCenter_install_root/mm_profile/dbscripts/LotusMashups/informix/database_name to the remote server.
Do the following steps to create the Lotus Mashups tables on Informix:
- Open MashupCenter_install_root/Config/database_informix.properties, and specify JDBC as the connectivity information for the database and user, for example:
# Informix Dynamic Server configuration parameters
# User ID
# IDS Hostname
# IDS port number, for example 1526
informixPortNumber=database server port number
# IDS Server Name, for example ol_ids_1150
informixServerName=database server name
# IDS Database Name, for example MASHUPS
- Create the data source connection and configure Lotus Mashups to use the newly created database by changing to the MashupCenter_install_root/Config folder and running the following task on the command line: ./config.sh action-create-db-mashup-informix.
- Open a terminal.
- Run the oninit command to start the database server.
- Change to the directory with the database scripts.
- Run the following SQL scripts using the dbaccess database_name script_name command:
Do the following steps to test the connection and make sure everything is working as expected:
- To create tables, run the createTable.sql script.
- To grant access to the user, run the createGrant.sql script. Note that if you used the user informix to create the database and tables, then grant access is not needed.
Start the Lotus Mashups server.
- Open the WebSphere Application Server administrative console, and click Resources -> JDBC -> Data sources.
- Select the check box beside the new data source and test the connection.
Parent topic: Configuring Informix for Lotus Mashups: imc3
Now you have configured Informix for Lotus Mashups on a Linux platform. If you experience a problem performing the steps above, do the following steps to debug the issue:
- Run the ps -ef | grep oninit command to see if the oninit main process is already running. If the process is running, run the onmode -kyu command to stop it.
- If you experience any shared memory issues, run the ipcs command to see if any Informix processes are still running. Also run the ipcs -mp and cpuid commands to see if any processes such as oninint/dbaccess/ are attempting to access the server. Stop the processes, if necessary, and start the server again by running the oninit -ivy command.
- Open the Informix_install_directory/tmp/online.log file and check for server issues.