Migrating a broker's database tables on z/OS

Before you start

This task is part of the larger task, Configuring a migrated broker on z/OS. See the larger task to understand the context of this task and what you must do before you start this task.

To migrate a broker's database tables, submit the DB2 jobs shown in the following table. Each job is a member of the migrated broker's PDSE. Submit the jobs in the order specified and check that each job completes successfully before submitting the next. A job completes successfully if each step, other than the step BAD, has a return code of 00 and the step BAD has a return code of FLUSH.

You need the following authorities to run the DB2 jobs:
  • SYSADM or SYSCTRL DB2 authority
  • ALTER access to the migrated broker's PDSE (for jobs BIP$DBM1 and BIP$DB05)
  • READ and WRITE access to the migrated broker's directory and all its subdirectories (for job BIP$DBM2)
  • EXECUTE access to the directory, and all its subdirectories, where WebSphere Business Integration Message Broker is installed (for job BIP$DBM2)

The job BIP$DBM1 issues the SQL statements in the member BIPDBMG of the migrated broker's PDSE. These statements alter existing table spaces and create new table spaces. You might want to review and change the statements before submitting the job.

The job BIP$DB05 issues the SQL statement in the member BIPDBGR of the migrated broker's PDSE. As generated, this statement grants all users unlimited access to the broker database tables. You might want to review and change the statement before submitting the job.

Order of submission DB2 job Description
1 BIP$DBM1 Alters existing table spaces and creates new table spaces
2 BIP$DBM2 Migrates existing broker database tables and creates new broker database tables
3 BIP$DB05 Grants users authority to access the broker database tables
Related tasks
Configuring a migrated broker on z/OS
Creating the broker database