Bank of America Corporation
Database work file storage limit facility

Abstract:

Some aspects as disclosed herein are directed to, for example, a system and method of configuring one or more configurable database work file limits and performing one or more actions in response to reaching or approaching the work file limits. The method may comprise determining, by a computing device, a user identifier associated with a user and an application identifier associated with an application. The computing device may determine, based on the user identifier and the application identifier, a workfile storage usage threshold associated with the user and the application. The computing device may determine whether a workfile storage usage associated with the user and the application approaches or exceeds the workfile storage usage limit. In response to determining that the workfile storage usage associated with the user and the application approaches or exceeds the workfile storage usage limit, the method may comprise determining a database language statement associated with the workfile storage usage approaching or exceeding the workfile storage usage limit and/or generating a notification comprising the database language statement and the workfile storage usage associated with the user and the application.