Creating a WebSphere Commerce instance Version 8 on Linux System

Creating a WebSphere Commerce instance

JAVA Considerations

1.Verify that the WebSphere Application Server default SDK level is set to 1.7:
Go To WAS_installdir/bin Folder then run below command
/opt/IBM/WebSphere/AppServer/bin/managesdk.sh -getNewProfileDefault
2. If the default SDK level is not 1.7, then run the following command to set to version 1.7.
/opt/IBM/WebSphere/AppServer/bin/managesdk.sh -setNewProfileDefault -sdkName 1.7_64


Referrence: https://www.ibm.com/support/knowledgecenter/en/SSZLC2_8.0.0/com.ibm.commerce.install.doc/tasks/tig_part_create_instances.htm
--------------------------------------------------
--------------------------------------------------
2. Database considerations during WebSphere Commerce instance creation

You can create a DB2 database and all of its associated table containers manually.
a) Create a database.
db2 "CREATE DATABASE database USING CODESET UTF-8 TERRITORY US"
db2 "ALTER BUFFERPOOL IBMDEFAULTBP DEFERRED SIZE 10000 AUTOMATIC"

b) Create buffer pools and table spaces. These values are to be used by the WebSphere Commerce schema objects to optimize performance. You can use the following recommendations, or customize the values.
db2 "CREATE BUFFERPOOL BUFF8K DEFERRED SIZE 5000 AUTOMATIC PAGESIZE 8 K"
db2 "CREATE BUFFERPOOL BUFF16K DEFERRED SIZE 5000 AUTOMATIC PAGESIZE 16 K"
db2 "CREATE BUFFERPOOL BUFF32K DEFERRED SIZE 2500 AUTOMATIC PAGESIZE 32 K"

db2 "CREATE REGULAR TABLESPACE TAB8K PAGESIZE 8 K BUFFERPOOL BUFF8K"
db2 "CREATE REGULAR TABLESPACE TAB16K PAGESIZE 16 K BUFFERPOOL BUFF16K"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE TEMPSYS8K PAGESIZE 8 K BUFFERPOOL BUFF8K"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE TEMPSYS16K PAGESIZE 16 K BUFFERPOOL BUFF16K"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE TEMPSYS32K PAGESIZE 32 K BUFFERPOOL BUFF32K"

c) Tune the database configuration and database manager configuration. Use the settings in the following example as minimum guidelines:
db2 "UPDATE DATABASE CONFIGURATION FOR database USING LOCKLIST 2400 AUTOMATIC"
db2 "UPDATE DATABASE CONFIGURATION FOR database USING INDEXREC RESTART"
db2 "UPDATE DATABASE CONFIGURATION FOR database USING LOGFILSIZ 1000"
db2 "UPDATE DATABASE CONFIGURATION FOR database USING LOGPRIMARY 12"
db2 "UPDATE DATABASE CONFIGURATION FOR database USING LOGSECOND 10"
db2 "UPDATE DATABASE CONFIGURATION FOR database USING PCKCACHESZ 4096 AUTOMATIC"
db2 "UPDATE DATABASE CONFIGURATION FOR database USING CATALOGCACHE_SZ 4096"
db2 "UPDATE DATABASE CONFIGURATION FOR database USING LOCKTIMEOUT 45"

db2set DB2_WORKLOAD=WC
db2set DB2BIDI=yes
db2 "UPDATE DBM CFG USING CPUSPEED -1"copy to clipboard
where database is the database name.
Referrence: https://www.ibm.com/support/knowledgecenter/SSZLC2_8.0.0/com.ibm.commerce.install.doc/tasks/tigDB2createmanually.htm?view=embed
----------------------------------------------
----------------------------------------------