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: 10211
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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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