B2B DX Truncate Events Command
infa/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>./repoutil.sh -c truncateEvents -l “jdbc:informatica:oracle://oracdevinfa:1521;Servicename=infa” -u B2BDX -p password -t dx
19:09:18 INFO Default system locale: English
Are you sure you want to truncate ‘events’ from the repository, as well as the document store (YES/NO)? YES
19:09:32 INFO Executing command [TruncateEventsAction]
19:09:32 INFO Found version [9.6.1.0 – 620] for [DX_REPOSITORY]
19:09:33 INFO Truncating table: EVENT
19:09:34 INFO Truncating table: DX_EVENT_BLOBS
19:09:35 INFO Truncating table: DX_DOCSTORE_FILES
19:09:35 INFO Truncating table: DX_DOCSTORE_HISTORY
19:09:35 INFO Truncating table: MONITOR_USER_EVENT
19:09:35 INFO Truncating table: EVENT_HISTORY
19:09:36 INFO Truncating table: EVENT_EVENT_PROPERTIES
19:09:36 INFO Truncating table: DX_CORRELATION
19:09:36 INFO Truncating table: DX_CORRELATION
19:09:36 INFO Truncating table: DX_SAVEPOINT
19:09:37 INFO Truncating table: DX_SAVEPOINT_PROPERTIES
19:09:37 INFO Truncating table: DX_EVENT_EXTENSIONS
19:09:37 INFO Truncating table: DX_EVENT_EXTENSIONS
19:09:37 INFO Truncating table: DX_EVENT_EXTENSIONS
19:09:37 INFO Truncating table: DX_SUBSCRIPTION_EXT_LIST
19:09:38 INFO Cleaning document store located at: /b2bprdshr/B2BDataExchange901
19:09:38 INFO Finished command [TruncateEventsAction]
infa/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>