If you have existing isolated regions that were initialized but not enabled for region recovery, you can still enable them. You must first define the desired separate table spaces in the database, specify the table spaces for the region in Process Task Manager, and move the existing isolated region data into those table spaces.
Use the rdbConvertReg command in vwtool to convert an existing region so that it can be enabled for region recovery. rdbConvertReg first verifies that all the RDB Objects for that region are in the correct table spaces, and then separates region data located in Process Engine system tables into separate region level tables.
TIP Purge as many log entries as possible before running so that when moving existing data, you do not have to move all the records. For more information, see To purge events as part of the Process Analyzer backup procedure.
If you are upgrading from a prior release, all regions must be upgraded per the upgrade documentation before starting this procedure.
In vwtool, use the dbviews command to check the current database view names. Database view names should exist. If they do not exist, it is possible the regions were not completely upgraded when coming from a prior release. Complete the upgrade process before continuing.
The region should remain locked and unavailable for use until after Step 7.
At the prompt, enter the c (convert) option. For a hardcopy, choose Yes to save a file of the manifest.
At the prompt, to confirm that you want to convert the region, choose Yes. (NOTE The region data will not be converted until you move all the data into the correct table spaces.)
Once the verification passes, rdbConvertReg processes the Process Engine system tables as necessary to enable the region for recovery. See the example below.
In vwtool, set the correct region, then use the createDBViews command to recreate the database views. Select either the v or s options. The v option automatically creates the views and s creates a script you run manually from the RDBMS database tools.
Usage:
Vwtool –Y <Admin user name>+<Admin password>
vwtool: rdbConvertReg
Choice? ('c', 'l', 'e',, CR=exit): c
hardcopy?(y/n) cr=y
output file: <filename> Suggest manifestR22
NOTE The following example uses Microsoft SQL Server, and the term "filegroup" (From DB Filegroup, To DB Filegroup). For Oracle or DB2, these are called table spaces.
<vwtool:22>rdbConvertReg
Create :
c - Verify that all Process Engine region database objects are in the correct rdb location
Convert the region to be ready to set backup enabled.
Message will be displayed if all Process Engine database objects are
not in the correct location in the database.
NOTE: region must be locked in order to complete this step.
l - Just list current DB locations.
e - Exit.
Choice? ('c', 'l', 'e', CR=exit): c
Do you want a hardcopy? y/n: (CR=y)
Verify and convert for region 22
Please confirm that you want to convert region 22: y/n (CR=n)y
PE Reg 22 MSSQL 2005 Database Filegroups
Use the following list to move PE region 22 tables and indexes,
from current DB tablespace to new region defined tablespace.
Use database tools to move tables and indexes
to new DB filegroups
Table/Index name | From DB Filegroup | To New DB Filegroup |
VWQueue22_100 |
vwdata_fg |
--> vwdataR22 |
VWqwobnum22_100 | vwdata_fg |
--> vwdataR22 |
VWquniqid22_100 | vwdata_fg |
--> vwdataR22 |
VWqsort22_100 | vwdata_fg | --> vwdataR22 |
VWQueue22_101 |
vwdata_fg |
--> vwdataR22 |
VWqwobnum22_101 | vwdata_fg |
--> vwdataR22 |
VWquniqid22_101 | vwdata_fg |
--> vwdataR22 |
VWqsort22_101 | vwdata_fg | --> vwdataR22 |
VW_IND2 | vwdata_fg | --> vwdataR22 |
VWQueue22_102 |
vwdata_fg |
--> vwdataR22 |
VWqwobnum22_102 | vwdata_fg |
--> vwdataR22 |
VWquniqid22_102 | vwdata_fg |
--> vwdataR22 |
VWqsort22_102 | vwdata_fg | --> vwdataR22 |
VWQueue22_103 |
vwdata_fg |
--> vwdataR22 |
VWqwobnum22_103 | vwdata_fg |
--> vwdataR22 |
VWquniqid22_103 | vwdata_fg |
--> vwdataR22 |
VWqsort22_103 | vwdata_fg | --> vwdataR22 |
VWQueue22_104 |
vwdata_fg |
--> vwdataR22 |
VWqwobnum22_104 | vwdata_fg |
--> vwdataR22 |
VWquniqid22_104 | vwdata_fg |
--> vwdataR22 |
VWqsort22_104 | vwdata_fg | --> vwdataR22 |
VWQueue22_105 |
vwdata_fg |
--> vwdataR22 |
VWqwobnum22_105 | vwdata_fg |
--> vwdataR22 |
VWquniqid22_105 | vwdata_fg |
--> vwdataR22 |
VWqsort22_105 | vwdata_fg | --> vwdataR22 |
VW_IND3 | vwdata_fg | --> vwdataR22 |
VWQueue22_106 |
vwdata_fg |
--> vwdataR22 |
VWqwobnum22_106 | vwdata_fg |
--> vwdataR22 |
VWquniqid22_106 | vwdata_fg |
--> vwdataR22 |
VWqsort22_106 | vwdata_fg | --> vwdataR22 |
VW_IND4 | vwdata_fg | --> vwdataR22 |
VWRoster22_114 |
vwdata_fg |
--> vwdataR22 |
VWrwobnum22_114 | vwdata_fg |
--> vwdataR22 |
VWrwobtag22_114 | vwdata_fg |
--> vwdataR22 |
VW_IND5 | vwdata_fg | --> vwdataR22 |
VWLog22_115 | vwdata_fg |
--> vwdataR22 |
VWLogTime22_115 | vwdata_fg |
--> vwdataR22 |
VWEventTime22_115 | vwdata_fg |
--> vwdataR22 |
VWLogEvtWPId22_115 | vwdata_fg | --> vwdataR22 |
VWLogSequence22_115 | vwdata_fg |
--> vwdataR22 |
VW_IND6 | vwdata_fg | --> vwdataR22 |
Region 22 location verification complete, verification shows more tables to move.
Copy the tables as listed and rerun this option.
<vwtool:22>
Sample output after moving the data to the new tables and running rdbConvertReg the second time. With the data in the appropriate table spaces, verification is successful and the remaining data for Region 22 is split out of the Process Engine system tables and copied to the new table space.
<vwtool:1>reg 22
Current region is: 1
New region is: 22
<vwtool:22>rdbConvertReg
Create :
c - Verify that all PE region database objects are in the correct rdb location
Convert the region to be ready to set backup enabled.
Message will be displayed if all PE database objects are
not in the correct location in the database.
NOTE: region must be locked in order to complete this step.
l - Just list current DB locations.
e - Exit.
Choice? ('c', 'l', 'e', CR=exit): c
Do you want a hardcopy? y/n: (CR=y)
Verify and convert for region 22
Please confirm that you want to convert region 22: y/n (CR=n)y
PE Reg 22 MSSQL 2005 Database Filegroups.
Use the following list to move PE region 22 tables and indexes,
from current DB tablespace to new region defined tablespace.
Use database tools to move tables and indexes
to new DB filegroups
Table/Index name | From DB Filegroup | To New DB Filegroup |
Region 22 location verification complete, verification PASSED
Created table VWWobTimeOut22.
Created table VWNotify22.
Created table VWPAEventState22.
Created table VWPending22.
Created table VWIsolReg22.
Copied data for table VWIsolReg22.
Copied data for table VWWobTimeOut22.
Copied data for table VWNotify22.
Copied data for table VWPAEventState22.
Copied data for table VWPending22.
Deleted data in VWPending.
Deleted data for table VWWobTimeOut.
Deleted data for table VWNotify.
Deleted data for table VWPAEventState.
Region is set up for region backup enable for region # 22
Unlock region and continue with backup enable procedure.
<vwtool:22>
Usage:
vwtool –r 23 –Y <Admin user name>+<Admin password>
<vwtool:23>dbviews
Logical Name -------------- |
Database View -------------- |
Database Table -------------- |
Delay | VWVQ23_Delay001 | VWQueue23_100 |
Tracker | VWVQ23_Tracker001 | VWQueue23_101 |
Conductor | VWVQ23_Conductor001 | VWQueue23_102 |
CE_Operations | VWVQ23_CE_Operations001 | VWQueue23_103 |
InstructionSheetInterpreter | VWVQ23_InstructionSheetInt001 | VWQueue23_104 |
WSRequest | VWVQ23_WSRequest001 | VWQueue23_105 |
Inbox | VWVQ23_Inbox001 | VWQueue23_106 |
DefaultRoster | VWVR23_DefaultRoster001 | VWRoster23_114 |
DefaultEventLog | VWVL23_DefaultEventLog001 | VWLog23_115 |
Usage:
vwtool –r 23 –Y <Admin user name>+<Admin password>
<vwtool:23>createDBviews
Create :
s - Creates script file containing the SQL statements
required to create the DB views.
(Must run this SQL script in the database to create views.)
v - Create the views in the database.
Choice? ('s', 'v'): v
Recreating Local DB Views.
DROP VIEW VWVL23_DEFAULTEVENTLOG001
DROP VIEW VWVQ23_CE_OPERATIONS001
DROP VIEW VWVQ23_CONDUCTOR001
DROP VIEW VWVQ23_DELAY001
DROP VIEW VWVQ23_INBOX001
DROP VIEW VWVQ23_INSTRUCTIONSHEETINT001
DROP VIEW VWVQ23_TRACKER001
DROP VIEW VWVQ23_WSREQUEST001
DROP VIEW VWVR23_DEFAULTROSTER001
Create view VWVQ23_Delay001 for Delay
Create view VWVQ23_Tracker001 for Tracker
Create view VWVQ23_Conductor001 for Conductor
Create view VWVQ23_CE_Operations001 for CE_Operations
Create view VWVQ23_InstructionSheetInt001 for InstructionSheetInterpreter
Create view VWVQ23_WSRequest001 for WSRequest
Create view VWVQ23_Inbox001 for Inbox
Create view VWVR23_DefaultRoster001 for DefaultRoster
Create view VWVL23_DefaultEventLog001 for DefaultEventLog
Done.
<vwtool:23>