DB2 Version 9.7 for Linux, UNIX, and Windows

smallest_log_avail_node - Node with Least Available Log Space monitor element

This element is only returned for global snapshots and indicates the node with the least amount (in bytes) of available log space.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

Usage: Use this element, in conjunction with appl_id_oldest_xact, to ensure that adequate log space is available for the database. In a global snapshot, appl_id_oldest_xact, total_log_used, and total_log_available correspond to the values on this node.