Professional Web Applications Themes

Troubleshooting performance problem - Informix

Hi everybody 1) Does Informix-Online Ver 5.11.HC1 supports multi-threading ? 2) With the above version which has limited tools/utility, how can I go about to troubleshoot slow respond from SELECT command ? This Informix is running under HP-UX 11. 3) What does the output below tells us ? Why there are so many of sharers waiting for 1 piece of buffer ? Where went wrong ? Thank you. Buffers (Access) address owner flags pagenum memaddr nslots pgflgs sharers waiter c2e4d604 0 100 3072f5 c3c4c800 1 90 c23184f4 0 c2e4ec94 0 100 30704b c3c72800 1 90 c23192d4 0 c2e51a98 0 100 ...

  1. #1

    Default Troubleshooting performance problem

    Hi everybody

    1) Does Informix-Online Ver 5.11.HC1 supports multi-threading ?
    2) With the above version which has limited tools/utility, how can I go about
    to troubleshoot slow respond from SELECT command ? This Informix is running
    under HP-UX 11.
    3) What does the output below tells us ? Why there are so many of sharers
    waiting for 1 piece of buffer ? Where went wrong ? Thank you.

    Buffers (Access)
    address owner flags pagenum memaddr nslots pgflgs sharers waiter
    c2e4d604 0 100 3072f5 c3c4c800 1 90 c23184f4 0
    c2e4ec94 0 100 30704b c3c72800 1 90 c23192d4 0
    c2e51a98 0 100 322967 c3cc0000 39 b0 c23183cc 0
    c2e6315c 0 0 307053 c3e95800 6 2001 0 0
    c2e695b4 0 100 307b6e c3f3e800 52 90 c231df24 0
    c2e88efc 0 0 307bdc c4291800 41 90 0 0
    c2e8e728 0 100 307b39 c4326000 39 90 c2318054 0
    c2ee4304 0 100 30839a c4c2c800 46 90 c2319aec 0
    c2f554c4 0 0 307b4f c5814800 39 90 0 0
    c3067634 0 100 307b72 c74ee800 52 90 c2317f2c 0
    c3076154 0 100 307b3a c767a800 36 90 c23184f4 0
    c307832c 0 100 308301 c76b3800 39 30 c2319aec 0
    c307d3a0 0 0 307b66 c773b000 50 90 0 0
    c3172ab0 0 0 307bb0 c9111000 48 90 0 0
    c3174600 0 0 307bcd c913f000 64 90 0 0
    c3195080 0 100 307b30 c94af000 45 30 c23177a8 0
    c23179f8 0
    c2317b20 0
    c2317c48 0
    c2317cdc 0
    c2318054 0
    c23180e8 0
    c2318460 0
    c231861c 0
    c23187d8 0
    c231a1dc 0
    c231b3c8 0
    c231ba24 0

    c231bd9c 0
    c231ce60 0
    c231dcd4 0
    c231de90 0
    c231df24 0
    c231dfb8 0
    c231e0e0 0
    c231e580 0
    c231e614 0
    c31b96f8 0 0 30be54 c9884000 30 1 0 0
    1356 modified, 60000 total, 65536 hash buckets, 2048 buffer size
    kh teoh Guest

  2. #2

    Default Re: Troubleshooting performance problem

    From the tbstat -u, may I know what other value does the "wait" column
    represents beside resources from latch (tbstat -s) & lock (tbstat -k)
    ? Does it represents shared buffer as well(tbstat -b) ?
    kh teoh Guest

Similar Threads

  1. Performance problem
    By Uli Link in forum Macromedia Flex General Discussion
    Replies: 4
    Last Post: April 28th, 12:33 AM
  2. IDS Performance problem
    By jpp in forum Informix
    Replies: 3
    Last Post: October 3rd, 01:00 PM
  3. Replies: 2
    Last Post: August 15th, 07:26 PM
  4. solaris/x86 performance problem
    By Bob Palowoda in forum Sun Solaris
    Replies: 2
    Last Post: July 10th, 10:57 PM
  5. WebService Performance Problem
    By Nikolay S in forum ASP.NET Web Services
    Replies: 2
    Last Post: July 9th, 11:38 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139