Kurt,
The best recommendation that I can give is going to be to do the following:
1. Export your Library from the Proc Auto UI. If you have a large amount of content, I would suggest exporting (using absolute path) in small sections. If the export is too large, it will not import and we don't want that.I beleive 250mg is the upper limit for an import.
2. Stop the Proc Auto orchestrator service
3. Take a complete backup of the current database
4. Assuming SQL Server - run a reinstall of CA Proc Auto starting with disk1. If this is an Oracle DB, you will need to create the schemas before the reinstall.
5. When you get to the database section, create the 3 new DBs, Pam_Lib, Pam_Runtime, Pam_Reports for instance
6. Complete the reinstall and start the orchestrator service
7. Import your exported library content
8. Stop the orchestrator service again
9. At this point in the new databases, you will see the tables. You should be able to export the data from the original tables, and import this to the new tables. It's going to be time consuming, but this is also assuming that you need to maintain the current runtime database. You should only need to do this for the tables in the runtime DB. As you have imported your content, you won't need to worry about the Library. If you use the Proc Auto BIRT reporting, you will need to do the same with the reporting tables.
10. Start the orchestrator service a final time and verify functionality.
This assumes you require to maintain your runtime database. If this is only a test system, or a pre-production system, stop at step 7 to keep this clean moving it into production.
If this is production, step 3 is the most important part of all of this as it is your safety net.
~Jenn