When there is a hung client process that does not terminate and prevents the database from shutting down, this would also cause the BI to grow. The following Articles offer troubleshooting suggestions to avoid this situation in future:
Option 1: Force the database to shutdownTo force a database shutdown immediately, from a different shell where the DLC and PATH are correctly set, run a new PROSHUTwith the -F option:
$ proshut -F dbname
Option 2: Kill the hanging client process.1. If a PROMON session can still access the database, find the process ID of the client process and kill the process.
- Run PROMON to find the user ID
promon dbname > R&D >Option 1 (Status Displays) > Option 4 (Processes/Clients) > Option 1 (All Processes).
- Run PROMON to find the PID of the User
promon dbname > Option 1 (User Control) > Option 2 (Match a user number)
kill -9 <PID>
Once this is done, the next time the database has started it will go through normal crash recovery, provided sufficient BI file space and AI file space (if after-imaging is enabled) are available.