IBM Support

Using twinit to recreate databases in Teamworks 7.0.x and WebSphere Lombardi Edition

Question & Answer


Question

How do you recreate databases in Teamworks 7.0.x and WebSphere Lombardi Edition?

Answer

If you need to recreate your databases in Teamworks 7.0.x and WebSphere Lombardi Edition, you can use the twinit tool located in the following directory:

...\Teamworks_home_folder\twinit\

Use the steps in this document with the twinit tool to recreate the databases. You do not have to drop the entire databases and recreate them unlike previous versions of Teamworks.

On AIX, HP-UX, Linux, and Solaris operating systems, use the twinit.sh script with the same syntax.



For the Process Center/Server:
  1. Stop your Process Center / Process Server
  2. Clean the Process Center / Process Server using the following command:
    twinit.cmd cleanProcDB
  3. Rebuild the Process Center / Process Server using the following commands:
    twinit.cmd createStructureProcDB
    twinit.cmd initializeProcDB
  4. Import the SystemData
    twinit.cmd importSystemData
  5. Create the stored procedure for the Process Server using the following command:
    twinit.cmd createProcedurePS


For the Performance Data Warehouse:
  1. Stop your Performance Data Warehouse.
  2. Clean the Performance database using the following command:
    twinit.cmd cleanPerfDB
  3. Rebuild the Performance database using the following commands:
    twinit.cmd createStructurePerfDB
    twinit.cmd initializePerfDB


For both Process Center / Process Server and Performance Data Warehouse:
  1. Stop both Process Center / Process Server and Performance Data Warehouse.
  2. Clean both databases using the following command:
    twinit.cmd cleanDB
  3. Rebuild the databases and import SystemData using the following command:
    twinit.cmd bootstrap

[{"Product":{"code":"SSFPRP","label":"WebSphere Lombardi Edition"},"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Component":"Documentation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.2;7.1;7.0.1","Edition":""}]

Historical Number

KL551

Document Information

Modified date:
15 June 2018

UID

swg21497392