IBM SG24-6320-00 manual Database migration batch script, Create NEW Master Catalogue

6320ax02.fm			Draft Document for Review July 28, 2004 7:33 pm
-- CREATE NEW MASTER CATALOGUE
insert	into	catalog values (10002,-2000,'Master Catalog','Master Catalog');
insert	into	catalogdsc values (10002,-1,'Master Catalog',NULL,NULL,NULL,NULL);

insert into catgroup values ((select max(catgroup_id) from catgroup)+1,-2000,'Master Category',0,NULL,NULL,NULL,NULL);

insert into catgrpdesc (catgroup_id,language_id,name,published,shortdescription) values((select max(catgroup_id) from catgroup),-1,'Master Category',1,'Master Category description');

insert into cattogrp values (10002,(select max(catgroup_id) from catgroup));

insert into storecat values (10001,10001); insert into storecat values (10002,10001);

insert into storecgrp values (10001,(select max(catgroup_id) from catgroup));

-- ADD ALL CATENTRIES INTO ABOVE CATGROUP

insert into catgpenrel(catgroup_id, catalog_id, catentry_id, rule, sequence) select (select max(catgroup_id) from catgroup), 10002, catentry_id, '-', 0.0 from catentry where catentry_id <> 0;

-- UPDATE KEYS FOR CATALOG,CATGROUP

update keys set counter=(select max(counter) from keys where tablename='catalog')+1 where tablename='catalog';

update keys set counter=(select max(counter) from keys where tablename='catgroup')+1 where tablename='catgroup';

Database migration batch script

The script migration.bat migrated the database. This script takes the following parameters:

1.Database name

2.DB user id

3.DB password

4.Log directory

5.Instance name

The script has the following behavior:

1.Set parameters as local variables

2.Call WebSphere Commerce V5.6s config_env.bat to set environment variables

3.Call pre.migration.bat to prepare the database

264Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide