Unanswered: Max applications & agent-OS process association
Hi. Whats the maximum limit to the number of applications to a specific database and in a particular instance(all databases inclusive). Can u give the details for both EE & EEE.
Also is there a way to find associate the database agents of a particular application to the OS processes?
Look at the db cfg parameter maxappls and maxuproc for the user(lsattr -El sys0). maxuproc is the max for instance owner. maxappls is the max at the db level. If you have multiple logicals on a physical, maxuproc must be atleast double maxappls.
As far as I know, you cannot associate agent processes with an application under the covers, ppid are the db2gds, which is the global daemon spawner whose ppid is db2sysc. Also it would not help to bring down any of the agents individually - this will bring the instance down.