The invention relates to managing a plurality of subsystems of a process plant. The process plant is controlled using a Distributed Control System (DCS) with a plurality of databases distributed within the process plant, wherein each database comprises information corresponding to at least one subsystem of the plurality of subsystems. The method comprises receiving a query at a human machine interface of the DCS, wherein the query is of a predetermined type and is associated with at least one of an operation and health of a subsystem. The method further comprises identifying at a server of the DCS, a database comprising information corresponding to the subsystem. Furthermore, the method comprises processing the query based on the information corresponding to the subsystem. In addition, the method comprises utilizing the DCS to control the operation of the subsystem by controlling process parameters of the process in one or more subsystems.