Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Application Snapshot - What info can help ?

    Hi all,

    We are having crash on the production server. This is a Gaming server.

    We tried all except the application snapshot and Dynamic SQL. I will try to catch the snapshot info every 5 minutes and analyze it in real time.

    Which columns from Snapshot_APPL and Snapshot_STATEMENT will be useful for my scenario below.

    The server starts to saturate on disk C drive and SWAP partition I drive.
    The disk activity goes very high between 2:45am and 3:30 am this results in locks and applications being thrown away. Finally the system crashes and applications give up, and, disk activity starts to decline.

    My manager is highly qualified in system management professional. he suggests that some DB operations might be responsible for it, he wants me to identify which agents (applications) give rise to disk activity.

    Noticed that CPu remains normal during this crash. ( below 15%)
    Please help me know what might be causing and what info from snapshots should I look for.

    I decided to watch it happening in real time.

    Thanks for expected guidance

    DBFinder

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You are experiencing SWAP activity, which to me means that you are experiencing memory issues. What DB2 version are you using? I take it you are on windows since you mention drive C. Is it 32 or 64 bit? How much memory?

    Andy

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    DB2 v9.1.3 WSE 64 bit

    Windows 2003 Server Standard 64 bit with 16GB memory and High speed Raid

    The issue only started from 19 May.
    Last edited by DBFinder; 06-20-09 at 12:57.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What are you DBM and DB configuration parameters?

    Andy

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Files attached
    Attached Files Attached Files

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Check you mempools and memsets and see if you find anything.

    Andy

  7. #7
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    We have reduced few bufferpools.
    We are currently experiencing same issue. (right now)

    I am trying to stop automatic rrunstats. Is there any command to stop or pause runstats.

    Thanks
    DBFinder

Posting Permissions

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