Renaming a Database in Process Request Data Tables

When you copy a database or rename a database during an upgrade, if processes are Queued, Pending, or On Hold, they will cause data corruption. These processes will be listed in the SYSAUDIT in section (PRCSSCHED-18) Queued processes in PSPRCSPARMS and PSPRCSRQST, which contains a DBNAME different than that of the current database name.

After copying your database or renaming a database, bring down all process schedulers and run the application engine program MGRPRCSTBL .

This application engine program will:

  • Update the PSPRCSPARMS table with the new database name.

  • Update the PSPRCSRQST table with the new database name.