DB Unload causes WP error| Time-out occurred ... waiting for buffer latch

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

When running the db unload to unload/reorg a very large amount of objects, the Automic system slows down or even comes to a halt.  The WP logs show something similar to:

U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '42000', 'Time-out occurred while waiting for buffer latch type 2 for page (1:254343200), database ID 5.'
U00011801 Error in Server routine 'UCDS_R ', Server: 'AUTOMIC#WP001' AE system: 'AUTOMIC'.
U00015006 System forced memory trace dump.

Cause

This is caused by too low of disk I/O on database disk

Resolution

This issue was caused by a blocked session in the database due to low I/O on the disk.  When the unload was run, this issue occurred and brought the system to very slow performance.  Stopping the unload took some time, but resolved the issue.

A DBA should be able to review this issue and provide guidance on I/O needed on the disk.  This happens especially in cloud environments on lower-end specs of database servers.