IBM SG24-6320-00 manual Migrate the WebSphere Payment Manager database

Draft Document for Review July 28, 2004 7:33 pm 6320ch_migrating.fm

Note: When configuring these parameters pay special attention to these values, they must match to what you have configured in the commerce instance. Make sure that the commerce instance has properly configured the WebSphere Commerce Payments Web Server Hostname and ports values.

11.4.9 Migrate the WebSphere Payment Manager database

Before migrating the payments database there are some records that must be deleted from both payments and commerce databases. Connect to the commerce database and delete the obsolete payment methods from the PAYMTHD table. They are no longer supported.

1.On the database node connect to the commerce database by typing the following commands from a DB2 command line:

DB2 connect to <WC_db> using <db_user_id> using <db_user_password>

In our example:

DB2 connect to mall using dbusr01 using dbusr01pwd

2.Delete the obsolete payment methods:

db2 delete from paymthd where profilename in

('WCS51_SET_MIA',' WCS51_SET_Wallet',' WCS51_CyberCash')

3.Disconnect from the commerce database:

DB2 connect reset

Move to the WebSphere Commerce Payments Node and delete the keys from the ETKEY table. They will be recreated during the migration.

1.On the WebSphere Commerce Payments Node connect to the payments database by typing the following commands from a DB2 command line:

DB2 connect to <WCP_db>

In our example:

DB2 connect to payman

2.Delete the obsolete payment methods: db2 delete from ETKEY

3.Disconnect from the payments database:

DB2 connect reset

Now you can proceed with the payments database migration by following these steps:

Chapter 11. Migrating WebSphere Commerce components 227