Axis RightFax 8.5 Installationsanleitung PDF herunterladen (Seite 90)

13-14

The transmission purge process accepts the following arguments:

Age in days (required): the age of the transmissions that you want to purge.

If you have no idea of how many transmissions you have that are older than 30 days (for example),

you can do the following query:

sql> select count(*) from i_transmission where sysdate-create_date >

30;

Total Minutes (defaults to 60): The maximum number of minutes you would like the total purge

process to take. After processing a set of rows, the procedure will check the total time. If it exceeds

the inputted time, the process will wrap up the existing task, and stop. This is helpful if you have a

tight time schedule in which you can perform this task.

Batch size (default 5000): Limits the number of transmission records that should be processed at a

time. The smaller your rollback segment, the lower this number should be set. If you get a rollback

segment error, rerun the process with a lower batch size specified.

The transmission purge process deletes records from the following tables:

I_TRANSMISSION

I_TRANSMISSION_ACK

I_TRANSMISSION_PGROUP

I_TRANSMISSION_REFNUM

I_TRANSMISSION_REPORT

I_TRANSACTION

I_TRANSACTION_ACK

I_TRANSACTION_DETAIL

I_TRANSACTION_REFNUM

I_LOG

I_LOG_DETAIL

Examples:

exec domainman.transmission_purge(90,30,1000);

deletes all transmission records (for above tables) that are older than 90 days except tender. The

process would run for 30 minutes and would process 1000 records at a time.

Note: Transmission_purge is an expensive operation. It should be run during off-peak

hours.

Manually Purge Problem Records

If you also want to purge the PROBLEM table:

1. Log into SQL*Plus as glogowner. (glogowner/{password}@{tnsname})

2. sql> exec partit.purge_partit_tables(90); to purge all database records in this table older than

90 days.

Partitioned Tables

Because Oracle Transportation Management contains several integration and logging tables that can

become quite large very quickly, these tables have been partitioned to allow for quick purges of older

data. By partitioning the tables, a particular partition (segment) can be truncated, instead of records

being individually deleted, which is inefficient for large amounts of data.

1 2 ... 85 86 87 88 89 90 91 92 93 94 95 ... 105 106

Keine Kommentare

Axis RightFax 8.5 Installationsanleitung Seite 90