Saturday, September 16, 2017

B2B DX Truncate Events Command


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>>