Entering content frame

This graphic is explained in the accompanying text DATASTATISTICS Locate the document in the library structure

Prerequisites

Log on to the database instance DEMODB.

Examples

You can use the system tableDATASTATISTICS to determine the following database information, among other things:

·        Displaying the fill level of the database instance

SELECT usablesize, usedsize, usedsizepercentage, datafull
  FROM SYSINFO.DATASTATISTICS

·        Displaying which part of the database instance is occupied with permanent and temporary data, respectively.

SELECT usedpermanentsize, usedtemporarysize
  FROM SYSINFO.DATASTATISTICS

 

Leaving content frame