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
Next, run the following ConfigEngine commands
and the big one (it took 1 hour on my 320GB laptop hard drive and 11.5 mins with my 256GB SSD drive):
After you have finished, you must do a reorg on the newly created databases
My database names were:
- CUSTDB
- FEEDDB
- LIKEDB
- JCRDB
- COMMDB
- RELDB
db2 connect to {database}
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}
db2rbind {database name}
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