The SQL compilation problem scenario can be simulated by a java program(SampleCompilationProblem_Literals.java)
available in "[tutorial-base-directory]/extras"
directory.
This program prepares and executes many SQL queries, which introduces many compilation at runtime on the server.
set PATH=<DB2 install path>java\jdk\bin;%PATH%
export PATH=<DB2 install path>/java/jdk/bin:$PATH
"[TE-directory]/tutorials/Workshops/MonitoringWorkshop/ProblemDetermination/SQLCompilation/extras"
directoryjavac SampleCompilationProblem_Literals.java
java SampleCompilationProblem_Literals <userid> <password> <hostname> <DB2_port_number>
'db2sampl'
UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
UPDATE DBM CFG USING DFT_MON_LOCK ON
UPDATE DBM CFG USING DFT_MON_SORT ON
UPDATE DBM CFG USING DFT_MON_STMT ON
UPDATE DBM CFG USING DFT_MON_TABLE ON
UPDATE DBM CFG USING DFT_MON_TIMESTAMP ON
UPDATE DBM CFG USING DFT_MON_UOW ON
ACTIVATE DATABASE SAMPLE