If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > What is db2lbm?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-23-04, 14:05
cchattoraj cchattoraj is offline
Registered User
 
Join Date: Mar 2003
Posts: 343
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
Reply With Quote
  #2 (permalink)  
Old 01-25-04, 18:05
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On