LIMIT
The LIMIT option defines the limit on the number of rows that BMC AMI Unload selects from each table or partition of the table space.
Related topics
The default is LIMIT 0 (no limit). You may specify any limit value up to the maximum positive value in a binary fullword (2147483647). If BMC AMI Unload reaches the specified limit, it ends normally.
When unloading from a partitioned table space using DIRECT YES, LIMIT functions for each parallel partition reader. Specifying LIMIT 10 with 10 partitions will unload 100 records.
When unloading from a partitioned table space using DIRECT NO, LIMIT functions as if the table space were non-partitioned. Specifying LIMIT 10 will unload the first 10 rows returned by Db2.
When unloading using UNLOAD TABLESPACE from a table space with multiple tables, the limit you specify applies to each table. If you specify LIMIT n and there are three tables, up to 3n rows will be unloaded.