Results 1 to 2 of 2

Thread: What is db2lbm?

  1. #1
    Join Date
    Mar 2003
    Posts
    343

    Unanswered: What is db2lbm?

    db2 udb eee 7.2 fp 7 on aix 5.1

    See 10 of these processes running per logical partition

    db2lbm0 32
    db2lbm0 32
    db2lbm0 33
    db2lbm0 33
    db2lbm1 32
    db2lbm1 32
    db2lbm1 33
    db2lbm1 33
    db2lbm2 32
    db2lbm2 32
    db2lbm2 33
    db2lbm2 33
    db2lbm3 32
    db2lbm3 32
    db2lbm3 33
    db2lbm3 33
    db2lbm4 32
    db2lbm4 32
    db2lbm4 33
    db2lbm4 33

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: What is db2lbm?

    From a Developer Domain article :
    db2lbmX:

    LOAD buffer manipulator. The last character 'X' indicates one or more. Writes loaded data to the database and can be involved in async I/O. There is always one and often more depending on a heuristic. The heuristic is based on the number of CPUs on the system and the number of containers being written to.

    This "intelligent default" may be overridden by the DISK_PARALLELISM modifier to the LOAD command.

    We should make it clear that this Async I/O is not the async file I/O supported by some operating systems; it just means that we have separate processes writing the I/O. This means that other processes that are formatting the data are not tied up on I/O waits.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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