Increase the limit of tables that can be read in a single pass. RFE 123712
Reading more 575 tables in a single pass results in the following error message:
ALAA464E LOAD table limit exceeded, storage
Explanation: You have exceeded the maximum limit
(approximately 600 tables) allowable in a single pass.
User response: Lower the number of tables to process
Request is to modify the architecture to remove this restriction or at least lift the limit.
The customer (Department of Human Services, Australia) uses Db2 LAT as a data transport mechanism, scraping the the Db2 log and effectively propagating data changes from a large number of tables to downstream applications. In times of high volumes (e.g. end of month) the job often falls over with the above message. The customer then needs to break up the job into smaller jobs as a workaround.
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions