Preparing to use the master data extract sample

Use this procedure to prepare your environment to use the master data extract sample jobs.

1. Extract the sample files from IBMInfoSphereMasterDataManagement_Samples_<version>.zip in the MDM installation home directory.
2. Go to the directory where you extracted the samples. The master data extract sample files are in the mdmsamples/mdm_integration/mdm_datastage/jars directory.
3. Run the following SQL command to update your MDM database.

   create table temp_recmtime_watermark(enttype varchar(10),min_recmtime timestamp,max_recmtime timestamp)
   insert into temp_recmtime_watermark(enttype,min_recmtime,max_recmtime) values ('enttype','2000-01-01 00:00:00.000000','2000-01-01 00:00:00.000000')
   insert into mpi_seqgen values(1,1,'A','maxaudrecno_memtype',0,1,'','');
   insert into mpi_seqgen values(1,1,'A','minaudrecno_memtype',0,1,'','');

   Note: The master data extract sample uses the default party model. If your implementation uses a different model, make sure that you update enttype and memtype in the SQL to reflect the settings in your model.
4. Open InfoSphere® DataStage® Designer Client and import the MDE_Person.dsx file from the opt/mdm_integration/mdm_datastage/MDE directory.