Wednesday 4 November 2009

Setting up DB2 for Portal on ubuntu 9.10 karmic

Thought it may be a good idea to jot down the steps you need to set up DB2 for Portal.

Install Portal and check it works corretly (I installed 6.1.0.0)
Next install DB2 as a standalone

now edit the following files for database access
/ConfigEngine/properties/wkplc.properties
/ConfigEngine/properties/wkplc_comp.properties
/ConfigEngine/properties/wkplc_dbtype.properties

Next, run the following ConfigEngine commands
sudo /ConfigEngine.sh create-database
sudo /ConfigEngine.sh setup-database
sudo /ConfigEngine.sh validate-database-driver
sudo /ConfigEngine.sh validate-database-connection
and the big one (it took 1 hour on my 320GB laptop hard drive and 11.5 mins with my 256GB SSD drive):
sudo /ConfigEngine.sh database-transfer

After you have finished, you must do a reorg on the newly created databases

My database names were:
  • CUSTDB
  • FEEDDB
  • LIKEDB
  • JCRDB
  • COMMDB
  • RELDB
For each database, connect first as the instance owner:

db2 connect to {database} user {db admin user} using {db admin password}
db2 reorgchk update statistics on table all > {database}.out

Now check {database}.out for each line with an asterisk, note the table name and then run:
db2 reorg table {tablename}

To finish off:
db2 terminate
db2rbind {database name} -l db2rbind.out -u {db admin user} -p {db admin password}

Ensure you do this for all the Portal databases. Then start portal.

Portal will now use DB2 and you should see some major performance gains

No comments:

Post a Comment