Instance
DB2 Instance Definition "An instance in DB2 for LUW is like a copy of the RDBMS including all the processes that run DB2 and memory (address spaces) associated with that instance of DB2 and some configuration parameters to control that instance". A DB2 instance includes memory areas – memory areas that contain all the memory areas for all of the databases. A DB2 instance includes processes/threads. Some processes/threads are associated with specific databases and even specific connections, but they are all tracked back to just one instance. A DB2 Instance also stores information specific to that instance, in the instance owner’s home directory, including: Node directory Database directory db2diag.log, db2 notification log, and dump files DBM configuration file db2nodes.cfg Instance=Memory+Process/Threads There could be multiple instances on a single server (development, production, testing) but it's highly unlikely that a server would have multiple...