17.00 - Calculating the Space for Checkpoints - Parallel Data Pump

Teradata® Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-3021-220K

The space for partial and complete checkpoints is calculated as follows:

  1. 32 statements per second translates to 1920 statements per minute.
  2. 1920 / 20 (the packing factor) = 93 partial checkpoints/minute
  3. Multiply by 15 (15 minute CP frequency) = 1395 partial checkpoint rows maximum.
  4. Each checkpoint row is 117 + (12 * 20) = 357 bytes so 498,015 bytes are in partial checkpoint rows.
  5. Given that the load takes just more than an hour, assume 5 checkpoints are written at 300 bytes each.
Now the grand total of space in the log table is: 2,400 + 498,015 + 1,500 = 517,980 bytes.