Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    Unanswered: Capturing SQL for analysis

    I am very curious if and how it could 'capture' the SQL statements fired at my datamarts over a period of time.

    Using snapshot statements allows me to see them when they are executing, but how to store them for analysis?

    We are talking version 7.1. Workgroup edition here running on Windows NT
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141

    Re: Capturing SQL for analysis

    Why don't you use an event monitor?
    Give a look at www.db2click.com, "Tip of the month".
    Rodney Krick

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Capturing SQL for analysis

    There will be yet another tip on event monitors using pipes in the next couple of days time ..

    Cheers
    Sathyaram

    Originally posted by RKrick
    Why don't you use an event monitor?
    Give a look at www.db2click.com, "Tip of the month".
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    Re: Capturing SQL for analysis

    Originally posted by RKrick
    Why don't you use an event monitor?
    Give a look at www.db2click.com, "Tip of the month".
    Okay, in database manager configuration parameters DFT_MON_STMT is switched to 'on'.

    Can I (how?) collect information on SQL statements fired at the specific database with DB2 version 7, or is all of this just possible with version 8?
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Capturing SQL for analysis

    For event monitors to work, you do not have to switch on the monitor switch ....

    Event monitoring is available on V7 also ....

    On V8 there has been enhancements to event monitor, like writing the monitor records into a table .... IMHO, this is a perfromance killer when used in OLTP (many short transactions) ... DSS(few long transactions) workload will not make much difference ..

    Cheers
    Sathyaram

    Originally posted by blom0344
    Okay, in database manager configuration parameters DFT_MON_STMT is switched to 'on'.

    Can I (how?) collect information on SQL statements fired at the specific database with DB2 version 7, or is all of this just possible with version 8?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •