Health Center SQL procedures

The Health Center is implemented upon several DB2 for i SQL procedures.

IBM® i users can call the Health Center SQL procedures directly.

QSYS2.Health_Database_Overview ()
The QSYS2.Health_Database_Overview() procedure returns counts of all the different types of DB2 for i objects within the target schema or schemas. The counts are broken down by object type and subtype.
QSYS2.Health_Activity ()
The QSYS2.Health _Activity () procedure returns summary counts of database and SQL operations over a set of objects within one or more schemas.
QSYS2.Health_Design_Limits ()
The QSYS2.Health_Design_Limits () procedure returns detailed counts of design limits over a set of objects within one or more schemas. Design limits correspond to architectural constructs, such as ‘Maximum number of columns in a table or view'.
QSYS2.Health_Size_Limits ()
The QSYS2.Health_Size_Limits () procedure returns detailed size information for database objects within one or more schemas. Size limits help you understand trends towards reaching a database limit such as ‘Maximum size of the data in a table partition'.
QSYS2.Health_Environmental_Limits ()
The QSYS2.Health_Environmental_Limits() procedure returns detail on the top 10 jobs on the system, for different SQL or application limits. The jobs do not have to be in existence. The top 10 information is maintained within DB2 for i and gets reset when the machine is IPLed, the IASP is varied ON, or when the QSYS2.Reset_Environmental_Limits() procedure is called.
QSYS2.Reset_Environmental_Limits ()
The QSYS2.Reset_Environmental_Limits () procedure clears out the environment limit cache for the database. If IASPs are being used, this procedure clears the environment limit cache for the IASP within which it is called.

Parent topic: DB2 for IBM i – Health Center