Results 1 to 8 of 8

Thread: isolation level

  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    Unanswered: isolation level

    now it is my turn, to ask a question
    db2 luw 9.5 fp8 on Plinux
    dynamic sql coming in from hibernate
    we can see the package being used = SYSSH200 and default isolation is CS for this package
    Is it possible to see, what is the current isolation level of this agent/applid.
    as it might be possible that some connection string does specify isolation level
    as we can see many lock escalation in diag file
    I did execute a snapshot - used db2pd, but could not see this info
    any hint would be welcome - thanks for all update
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  2. #2
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    WLM_GET_ACTIVITY_DETAILS table function can be used to identify isolation level used by application. See the following link for additional details.

    WLM_GET_ACTIVITY_DETAILS table function - Return detailed information about a specific activity

    Note: DB2 Performance optimization (optional) feature is required to use workload manager.

    Satya...

  3. #3
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    did you try the CURRENT ISOLATION special register in V9.X ?

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2pd -activestatements

    does provide this info.

    ---
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    thanks for the update
    any idea how to translate : EffISO=1 to isolation level ?
    (current isolation is for within an active user, it can not be executed for another user..)
    thanks for all update
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    found in another post :
    0 - Repeatable Read
    1 - Cursor stability
    2 - Uncommited Read
    3 - Read stability
    thanks..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

Posting Permissions

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