Upgrading Lotus Connections Profiles to 1.0.2, take 2

I posted previously on how to update the Lotus Connections database schema from version 1.0.1 to 1.0.2.

Over on the Lotus Connections Forums, Henry Walther posted that he found the original files in the TDI directories. For others, here is the location of the files:

C:\Program Files\IBM\TDI\V6.1\tdisol\TDI\database\db2

I did a comparison between my version and this one and the EMPLOYEE columns are the same. Interestingly, the Lotus version does not include expanding the description and experience columns in the EMP_DRAFT table:

ALTER TABLE EMPINST.EMP_DRAFT
ALTER COLUMN PROF_DESCRIPTION SET DATA TYPE VARCHAR ( 4000 )
ALTER COLUMN PROF_EXPERIENCE SET DATA TYPE VARCHAR ( 4000 );

There are a couple of other useful files in the \TDI\database\db2 directory. Look for the runstats.bat batch file, which will help DB2 run faster on the Profiles tables.

Good find Henry!