Professional Web Applications Themes

Asynchronous index reads - IBM DB2

Version 7 fixpack 9, aix 5.1 In our database we have a table that that has a dedicated bufferpool for the data, and another for indexes. Actually we have three of these combinations and they all behave the same. Taken from a bufferpool snapshot: Index buffer pool: Asynchronous pool index page reads = 147089 Asynchronous read requests = 0 ????????? Data buffer pool: Asynchronous pool data page reads = 6270775 Asynchronous read requests = 98078 How can I have so many asynchronous reads taking place for the bufferpool that contains the indexes without DB2 logging the read requests, but is ...

  1. #1

    Default Asynchronous index reads

    Version 7 fixpack 9, aix 5.1

    In our database we have a table that that has a dedicated bufferpool
    for the data, and another for indexes. Actually we have three of
    these combinations and they all behave the same.

    Taken from a bufferpool snapshot:

    Index buffer pool:
    Asynchronous pool index page reads = 147089
    Asynchronous read requests = 0 ?????????

    Data buffer pool:
    Asynchronous pool data page reads = 6270775
    Asynchronous read requests = 98078

    How can I have so many asynchronous reads taking place for the
    bufferpool that contains the indexes without DB2 logging the read
    requests, but is logging them for the data?

    Thanks!
    Leo
    Leo Guest

  2. #2

    Default Re: Asynchronous index reads

    Hey Leo,

    There is a APAR out for this: IY42366. Fixed in FP10.

    "Leo" <net> wrote in message
    news:google.com... 


    Erik Guest

  3. #3

    Default Re: Asynchronous index reads


    "Erik Hendrix" <com> wrote in message
    news:teranews.com... 
    I would install FP10a. FP10 has some problems that are fixed in 10a.


    Mark Guest

Similar Threads

  1. Slow SQL reads after update
    By bmyers in forum Coldfusion Database Access
    Replies: 3
    Last Post: November 3rd, 08:45 PM
  2. Reads as CMYK but is Gray
    By jeffkr@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: May 31st, 08:56 PM
  3. Question on split reads...
    By Rajesh Kapur in forum Informix
    Replies: 0
    Last Post: September 17th, 09:57 PM
  4. USB floppy that reads LD floppies
    By JWolf6589 in forum Mac Applications & Software
    Replies: 1
    Last Post: June 29th, 02:54 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