(Chris Eaton) Here are a few scripts to check on the health of your page cleaners and prefetchers. Prefetchers are processes in DB2 that read data pages from disk into the bufferpool in advance of the DB2 agents with the hope that it prevents an agent from having to wait on I/O. There are many forms
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help