Home  Easy-Code   Forum    Updater 


Not signed in (Sign In)
    • CommentAuthorbrother2
    • CommentTimeApr 9th 2012
     
    1. Run the following db2 command to capture the dynamic sqls by enabling class 31 along with 318 IFCID events and write the ouput to the destination SMF,
    START TRACE(P) CLASS(31) IFCID(318) DEST(SMF)
    2. Create the table DSN_STATEMENT_CACHE_TABLE and run the below statement to capture the queries,
    EXPLAIN STMTCACHE ALL
    • CommentAuthorbrother2
    • CommentTimeApr 9th 2012
     
    IBM optim query tuner provide GUI from which we can directly enable, disable and refresh the dynamic capturing using simple button clicks which will execute the required commands in the back-end.