Results 1 to 5 of 5
  1. #1
    Join Date
    May 2017
    Posts
    5

    Unanswered: Num_ioservers parameter

    Hi everyone,

    I'm a newbie for DB2. I'm reading definition of num_ioservers parameter. But when i reading it, i could not understand a word "prefetchers".

    Anyone know what is prefetch ? I searched on Google but i still could not know what it is

    Please help me !

  2. #2
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    Study the DB2 documentation at the link below and the linked pages. Prefetching is a technique used by many different relational database engines.
    https://www.ibm.com/support/knowledg.../c0005396.html

  3. #3
    Join Date
    May 2017
    Posts
    5
    Quote Originally Posted by db2mor View Post
    Study the DB2 documentation at the link below and the linked pages. Prefetching is a technique used by many different relational database engines.
    https://www.ibm.com/support/knowledg.../c0005396.html
    Hi db2mor,

    Can you give me some examples about prefetch ?

  4. #4
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    consider using google for that purpose 'database prefetch' is such a well documented concept

  5. #5
    Join Date
    Aug 2016
    Posts
    55
    Provided Answers: 2
    refer this discussion about Aysnc and sync

    http://www.dbforums.com/showthread.p...vs-Synchronous

Posting Permissions

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