Commandline Purge in AS11

Posted by Dheeraj Kumar on Oracle Blogs See other posts from Oracle Blogs or by Dheeraj Kumar
Published on Thu, 20 May 2010 18:51:42 +0530 Indexed on 2010/05/20 13:32 UTC
Read the original article Hit count: 362

Filed under:

AS11 - B2B offering consists of numerous features that have been made available via commandline approach. Most of these are supplement to the already available User Interface based approach. One such is purging of runtime data.

The commandline purge option enables the users to purge the runtime data, based on various criteria. This is an ANT based command, provides the flexibility to selectively set the criteria to purge the runtime data.

Providing the command line option also enables the administrator to purge in bulk, without visiting the B2B UI, which can also be used for automation purpose

By default archival is turned on for purge activity. As a pre-requisite, the respective folder needs to be configured in database with the proper permission. When no filename is provided for archived data, the sysdate will be considered for filename.

Below are the various options to purge the runtime data


Option

ANT option

 

Message state

-Dmsgstate

 

Date range

-Dfromdate,  -Dtodate

Format : dd/mm/yyyy hh:mm AM/PM

Trading partner

-Dtp

 

Direction

-Ddirection

 

Message Type

-Dmsgtype

 

Agreement Name

-Dagreement

 

IdType/ value

-Didtype,  -Didvalue

 

Archive

-Darchive

True/false

By default true

Archive file name

-Darchivename

File name (optional), will be used when archive is set to true.


Note: When using -Darchivename the value must be a unique file name. An existing file name used with -Darchivename throws an exception


Below are the few of ant commands and various options.

 

Purge based on date range and message state:


ant -f ant-b2b-util.xml b2bpurge -Dmode=RT -Dfromdate="19/12/2009 1:04 AM" -Dtodate="19/12/2009 1:05 AM" -Dmsgstate=MSG_COMPLETE -Darchivename="filename.dmp"

 


Purge based on direction:

ant -f ant-b2b-util.xml b2bpurge -Dmode=RT -Ddirection="OUTBOUND"



Purge based on agreement Name:

ant -f ant-b2b-util.xml b2bpurge -Dmode=RT -Dagreement="agreement_name"


Purge based on Trading partner Name:


ant -f ant-b2b-util.xml b2bpurge -Dmode=RT -Dtp=GlobalChips


Purge based on Message State:


ant -f ant-b2b-util.xml b2bpurge -Dmode=RT -Dmsgstate="MSG_COMPLETE"



ant -f ant-b2b-util.xml b2bpurge -Dmode=RT -Ddirection="OUTBOUND" -Dmsgstate="MSG_COMPLETE"




© Oracle Blogs or respective owner