Restore of P98230

[ARJOHNSON]

I need to do a restore of P98230 -Work with Ojbect Management Activity Rules. Can this be done fairly easy (is it a standalone table)?
Appreciate any feed back !

Thanks so much!
Angie Johnson

System info:
- EnterpriseOne Xe, SP23_M1, Update 7
- iSeries model 550 V5R4, 3 main LPARS – AS01 (Prod), AS01CRP (Prototype), and AS01DEV (Development). Also have AS01CTL2 (controlling partition) and AS01HA (High Availability partition – running Data Mirror)

- Proc: AS01 (2.4), AS01CRP (1), AS01DEV (1), AS01CTL2 (.1), AS01HA (.5)
- Memory in Production LPAR: 20GB
- Total disk space: 632.9GB
- 16 fat clients (CNC and development), all other access via Citrix

- 3 data dictionaries:
a. Production – DD7333 library on AS01
b. Test – DDTEST library on AS01CRP (this test Data Dictionary is used by both Dev and Prototype pathcodes).
c. ESU – DDES7333 (we have a separate ESU pathcode and environment that has its own data dictionary. It gets copied from production before each ESU install and test.)

- 5 main environments:
a. PD7333 – production (AS01)
b. PY7333 – prototype (AS01CRP)
c. TS7333 – user testing (PY7333 pathcode) (AS01CRP)
d. DV7333 – development (AS01DEV)
e. ES7333 – ESU pathcode and environment (AS01CRP

 

[sashton]

Angie, I suppose it kinds of depends on what you are trying to accomplish here. The P98230 app touches a lot of tables, so again, depending on what you are trying to restore, you may need to look at more than one table. Looking at XREF, the following tables are touched by that app:

F98210 - OMW Log Header
F98223 - OMW Allowed Actions
F98224 - OMW Status Activity Rules
F98225 - OMW Transfer Activity Rules
F98226 - Source Management Access Configuration
F98227 - OMW Source Control Path Configuration
F98230 - OMW System Settings
F9829 - OMW Notification Subscriptions
F983051 - Versions List
F98800 - Process Master

If you just want to restore your allowed actions or transfer rules, than I think you are safe just restoring those respective tables. I personally wouldn't touch the F983051 and F98800 tables. Hope this helps some.

 

[ARJOHNSON]

Thanks for your response.
My Allowed Actions are OK. It's my Transfer activity Rules that needs restored.

 

[ARJOHNSON]

According to Oracle only the following two tables will need to be restored:

F98224 - OMW Status Activity Rules
F98225 - OMW Transfer Activity Rules

 

[peterbruce]

Angie,

I had a similar, if not the same requirement 3 years ago. I posted it on JDElist and got the information I needed. It may also be of use to you.

Click Here for my old thread - 106326