Restituisci
-
Titolo
Does the parameter 'SQL Archive Option' in the Spotlight on DB2 connections apply to version 9 -
Descrizione
Does the parameter SQL Archive Option in the Spotlight on DB2 connections apply to version 9 DB2 databases?
-
Risoluzione
Spotlight on DB2 does collect SQL in the SQL Acrhive, so please make sure that the SQL Archive is swicthed. For V9+ the DBM monitor switches must be on, not just the local copies. Also, the archive is filled with a query that will only catch statements in flight at the time of a refresh.
The way we test the SQL archive here is to execute static SQL without a commit. If the application is in the Apps Drilldown the statement should be in the archive.