To migrate a broker's database tables, submit the DB2 jobs shown in the table below. 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.
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 |