Performance Monitoring & Troubleshooting Flashcards

Which IICS tool allows administrators to replay a failed job from the point of failure without reprocessing successfully completed records?

Answer: Recovery run using persistent session state

Persistent session state (recovery) allows a failed mapping to resume from the last committed checkpoint rather than restarting from the beginning.

A mapping uses a parameterized SQL override in the Source transformation. Where should parameter values be defined to ensure they resolve at runtime in IICS?

Answer: In a Parameter file or Mapping task parameter configuration

Parameter files or the Mapping task's parameter configuration panel are the correct runtime resolution points for parameterized SQL overrides.

When should you use 'Test Run' mode in an IICS Mapping task rather than a full execution?

Answer: To validate mapping logic against a limited row sample without writing to the target

Test Run mode executes the mapping with a configurable row limit and does not commit data to the target, making it safe for logic validation.

Which metric in IICS session statistics BEST indicates that a Lookup transformation is causing a performance bottleneck?

Answer: High 'lookup cache hit' ratio near 0%

A near-zero cache hit ratio means every lookup row misses the cache and queries the source, causing repeated round trips and slow performance.

In IICS, what is the recommended approach when a mapping must process a 500 GB flat file within a tight SLA window?

Answer: Split the file into equal chunks and process with multiple parallel mapping runs

Partitioning the file and running parallel mapping instances is the standard approach to achieving high throughput for very large flat files in IICS.

A Secure Agent upgrade caused an existing mapping to fail with a 'transformation not supported in this runtime' error. What is the FIRST corrective action?

Answer: Review the IICS release notes for deprecated features and update the mapping accordingly

Release notes document deprecated or changed transformation behavior between versions; reviewing them first identifies whether a mapping update is needed.

Which configuration in IICS allows a mapping to automatically retry failed rows and write them to a separate error table for later review?

Answer: Mapping-level exception handling with a Router to an error target

Adding a Router transformation that directs transformation errors to a dedicated error target table is the standard pattern for capturing and isolating failed rows.