Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to load a table to bufferpool when system start?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Thu Mar 22, 2012 9:03 am    Post subject: How to load a table to bufferpool when system start?
Reply with quote

to decrease the time application spends on DB2 connection, I want to load a table to bufferpool at the point when system start, so that data fetch processing can become more faster for application.

Can I achieve this? and how?

Thanks.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 22, 2012 10:53 am    Post subject:
Reply with quote

Hello,

So run a process that reads the table. . .

Realizing that this will probably not accomplish what you want.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Thu Mar 22, 2012 3:15 pm    Post subject:
Reply with quote

hi, dick,
thanks for your recommendation.

but can you tell me why " this will probably not accomplish what you want." ?

thanks.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10292
Location: italy

PostPosted: Thu Mar 22, 2012 6:12 pm    Post subject: Reply to: How to load a table to bufferpool when system star
Reply with quote

the why can be found in the db2 manuals where it talks about buffer pool

POOL is the buzzword, the thing is not something dedicated to a single table,
is a dynamic container for all the tables/databases with the same buffer size
where the LRU buffers are flushed to satisfy new requests
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Mar 23, 2012 6:17 am    Post subject:
Reply with quote

Hello,

Also, when the table is read the first time by some query, it will be loaded into the "bufferpool". No "special" load is needed.

If there are no requests that cause the pool to be flushed, the info will still be "in core". As Enrico mentoned, new requests can cause the oldest in-core "stuff" to be flushed - which is how a database system should work.

If the table in queston is "hit" by most transactons, much of the data will remain in core. If this is seldom used, it will be flushed with regularity.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Fri Mar 23, 2012 8:39 am    Post subject:
Reply with quote

okay ,I got it.

as the table is most frequently used, I suppose it will not be paged out provided there is large enough pool size.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts How system know which REXX to excute? jackzhang75 CLIST & REXX 14 Thu Jul 06, 2017 1:09 am
No new posts How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us