Results 1 to 6 of 6
  1. #1
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    1,981
    Thanks
    3
    Thanked 9 Times in 8 Posts

    Default Transaction Delay - Adjustment?

    TSM Server 5.5

    ANR2997W The server log is 81 percent full. The server will delay transactions by 3 milliseconds.

    Is there an option to change the 81 percent?

  2. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,297
    Thanks
    2
    Thanked 137 Times in 135 Posts

    Default

    None that I know of.
    Ed

  3. #3

    Default

    More than likely there is a long running session(s) that is pinning the recovery log and when the backup db run not all the data in the recovery log are committed to the database.

    How big is the recovery log?

    Good Luck,
    Sias

  4. #4
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    1,981
    Thanks
    3
    Thanked 9 Times in 8 Posts

    Default

    Nothing bad was happening. Just alot of small file data had come in. Recovery log was up to 83%. My dbbackup trigger was 85%. I was hoping I could change the 81% threshold so I could keep my dbbackup trigger at 85%. No big deal. I dropped it back down to 80% so a backup occurs before the 81% when the server starts slowing down transaction processing.

  5. #5

    Default

    I did not think that there was a parameter that the value can be adjusted, take a look at this -

    http://publib.boulder.ibm.com/infoce...arnfullpercent

    -Sias

  6. #6
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    1,981
    Thanks
    3
    Thanked 9 Times in 8 Posts

    Default

    Thanks Sias. My LOGWARNFULLPERCENT is 70. According to the document, that is a warning that occurs every 2% increase after reaching the warning level. Just a warning. No transaction delays like the 81% ANR2997W message is.

Similar Threads

  1. Reuse Delay
    By alexsteele in forum TSM Operation
    Replies: 6
    Last Post: 11-09-2010, 03:31 PM
  2. Migration delay question
    By selac in forum Backup / Archive Discussion
    Replies: 5
    Last Post: 08-03-2009, 09:46 AM
  3. Introduce a Delay in a Script
    By David_FA in forum Scripting
    Replies: 5
    Last Post: 07-09-2007, 01:02 PM
  4. Why the delay when scanning files?
    By mkav in forum Performance Tuning
    Replies: 6
    Last Post: 11-07-2006, 03:58 PM
  5. Wait or Delay
    By sfcc in forum Scripting
    Replies: 1
    Last Post: 01-14-2004, 07:50 AM

Posting Permissions

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