| Author |
Message
|
| emiranda |
 Posted: Thu May 19, 2005 5:11 am Post subject: [SOLVED]Cleanup Server tables |
 |
|
Disciple
Joined: 21 Nov 2002
Posts: 196
Location: Dublin, Ireland
|
Hi all,
I want to delete all processes (runing, starting, terminating, in-errorr, etc) from my runtime database (DB2). Wich tables should I delete?
Cheers
Ed |
|
| Back to top |
|
 |
| vennela |
| Posted: Thu May 19, 2005 5:36 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
You should not delete tables.
What you can do is write a small java program to do that. |
|
| Back to top |
|
|
| emiranda |
| Posted: Thu May 19, 2005 5:47 am Post subject: |
|
|
Disciple
Joined: 21 Nov 2002
Posts: 196
Location: Dublin, Ireland
|
No time to that...
I don't want to delete the tables, just clean them up. |
|
| Back to top |
|
|
| vennela |
| Posted: Thu May 19, 2005 5:51 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Export the entire runtime fdl.
Delete the configuration/runtime DB.
Recreate the configuration.
Import the FDL.
Table information is not documented. |
|
| Back to top |
|
|
| emiranda |
| Posted: Thu May 19, 2005 6:01 am Post subject: |
|
|
Disciple
Joined: 21 Nov 2002
Posts: 196
Location: Dublin, Ireland
|
| It was what I fisrt thought but I was a bit affraid. Is there no harm in the configuration doing that? |
|
| Back to top |
|
|
| jmac |
| Posted: Thu May 19, 2005 7:15 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| emiranda wrote: |
| It was what I fisrt thought but I was a bit affraid. Is there no harm in the configuration doing that? |
No harm... unless you get paid by the hour  .... Seriously, this is the fastest way to accomplish what you want to do. I am assuming here that you want to have the same Process Models, Staff, and Data Structures, etc... in short everything in the RTDB... EXCEPT the Instances that are running
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| emiranda |
| Posted: Thu May 19, 2005 7:57 am Post subject: |
|
|
Disciple
Joined: 21 Nov 2002
Posts: 196
Location: Dublin, Ireland
|
That's right...
I'll try that.
Thank you all.
_________________
Warm Regards,
EM |
|
| Back to top |
|
|
|
|
