You are here: Pega Platform database > Database administration and performance > Viewing and modifying schema information manually > Logging for Pega Cloud schema operations

Logging for Pega Cloud schema operations

Operations performed using the Schema Tools landing page can be logged to a separate file from the PegaRules log file. To enable logging to a separate file, add the following appender to the prlog4j2.xml file.

<RollingRandomAccessFile name="RollingRandomAccessFileDBOPERATIONS" fileName="${sys:pega.tmpdir}/PegaDBOPERATIONS.log" filePattern="${sys:pega.tmpdir}/PegaDBOPERATIONS-%d{MM-dd-yyyy}-%i.log.gz">
   <PatternLayout>
    <Pattern>%d [%20.20t] [%10.10X{pegathread}] [%20.20X{tenantid}] [%20.20X{app}] (%30.30c{3}) %-5p %X{stack} %X{userid} - %m%n</Pattern>
   </PatternLayout>
   <Policies>
     <TimeBasedTriggeringPolicy />
    <SizeBasedTriggeringPolicy size="250 MB"/>
   </Policies>
<DefaultRolloverStrategy max="20"/>
  </RollingRandomAccessFile>

<Logger name="SchemaDesignerLogger" level="info" additivity="false">
<AppenderRef ref="RollingRandomAccessFileDBOPERATIONS"/>
</Logger>

You can view the log file by clicking Designer Studio > System > Operations > Logs > Log Files > PegaDBOPERATIONS.