| Author |
Message
|
| manoj |
 Posted: Fri Nov 22, 2002 8:48 pm Post subject: removing data from WF DB2 tables |
 |
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
Any body knows abt removing the WF data from the DB2 database. This would basically be killing all the process instances ,users,datasctructures etc. If i use the java API s it is taking too much time especially when i 've a large number of proess instances.
appreciate any ideas...
thx
-manoj
_________________
-manoj |
|
| Back to top |
|
 |
| jmac |
| Posted: Sat Nov 23, 2002 5:26 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Manoj:
If I understand what you are trying to do you can import FDL with the DELETE keyword.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| ucbus1 |
| Posted: Sat Nov 23, 2002 8:36 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
Please let me know, if you are trying to drop the whole WFTables or trying to delete say 5000 out of 10000 instances.If you are tying to do the whole WFTables then you may follow what John has mentioned.
I think you may overlay/recreate new FMCDB also. |
|
| Back to top |
|
|
| manoj |
| Posted: Wed Nov 27, 2002 10:26 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
John ,
i am not aware of using FDL Delete option to delete "running process instances " from WF runtime database. How's it possible ?
regds
_________________
-manoj |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Nov 27, 2002 10:42 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Manoj:
You can not delete an Instace with FDL... you can only use the Terminate API and then if necessary the Delete API.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| manoj |
| Posted: Wed Nov 27, 2002 10:57 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
that's the problem i 've, it takes lotoff time to delete all the process instances using the java APIs.
Are u aware of any database utility (may be part of MQWF) ?
_________________
-manoj |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Nov 27, 2002 10:59 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Manoj:
There is no utilitiy that I know of.
You could write a simple Java App that could do this for you.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| manoj |
| Posted: Wed Nov 27, 2002 11:11 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
i use java program only but it takes lotoff time.
any way thx john
_________________
-manoj |
|
| Back to top |
|
|
|
|
