Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Arrow Unanswered: How to check applications Isolation Level

    Is there anyway to find the isolation level of an application using snapshot or any other utility?

    DB2 UDB V8 on Windows

    dollar

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: How to check applications Isolation Level

    Originally posted by dollar489
    Is there anyway to find the isolation level of an application using snapshot or any other utility?

    DB2 UDB V8 on Windows

    dollar
    I think explain snapshot shows the effective isolation level of the statement in question.

  3. #3
    Join Date
    Sep 2002
    Posts
    456

    Re: How to check applications Isolation Level

    Actually, I am interested more in applications's isolation level. After issuing the command:

    db2 list applications

    I want to take an application from the list returned above and find out it's isolation level.

    dollar

    Originally posted by n_i
    I think explain snapshot shows the effective isolation level of the statement in question.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Individual SQL statements can override the isolation level in the SQL statement syntax.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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