Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Posts
    8

    Question Unanswered: Transactional count for instance

    Hi:

    I need to know hoy many transactions by day and by table in prodution instance i have.

    This in DB2 UDB v 8.1, on Windows 2003 server.

    Any script or suggestion wellcome.

    Thanks a lot.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    If by transactions you mean units of work, I don't believe it's possible, but you can see statistics of table access by running "db2pd -db dbname -tcbstats".
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2009
    Posts
    23
    select date(timestamp(AUDTIME)),count(distinct app_id)
    from dba.audit_checking
    where date(timestamp(AUDTIME)) > current date - 10 days
    group by date(timestamp(AUDTIME)) order by 1

    1 2
    ---------- -----------
    10/26/2009 21638
    10/27/2009 21249
    10/28/2009 20470
    10/29/2009 22510
    10/30/2009 20724
    10/31/2009 20629
    11/01/2009 21615
    11/02/2009 19768
    11/03/2009 21308
    11/04/2009 17538

    10 record(s) selected.


    select substr(object_schema||'.'||object_name,1,30),count (distinct app_id)
    from dba.audit_checking
    where date(timestamp(AUDTIME)) > current date - 10 days
    group by object_schema||'.'||object_name order by 1 fetch first 10 rows only

    1 2
    ------------------------------ -----------
    A.B 3
    A.C 1
    AAA.TEMP 17
    ADC.TEMP 17
    COABC.COATA10_URC 16
    COABC.COATZ10_URC 16
    COABC.COATZ30_URC 16
    CPE12345.LLLLMARKUP 17
    CPE12345.DDDBRIIDXREF 17

    10 record(s) selected.

  4. #4
    Join Date
    Aug 2007
    Posts
    8
    Thanks a lot for the answers

Tags for this Thread

Posting Permissions

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