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
 

 

DB2 Tunning - BM BUFFER POOL MGR

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

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Wed Oct 01, 2008 5:19 pm    Post subject: DB2 Tunning - BM BUFFER POOL MGR
Reply with quote

I have created strobe report for db2 program tunning ...

Strobe report is poing to "BM BUFFER POOL MGR". While checking the location I got simple insert statment but inserting Huge(100000 records) row.

Q1) How I will tune Buffer pool?.. Please any good idea for tunning buffer pool in DB2 program..

Please advise on this?
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: Wed Oct 01, 2008 9:07 pm    Post subject:
Reply with quote

Hello,

There is not much you can do to tune 100000 inserts - that is going to take some amount of resource.

What you might do is schedule your processes so that high volume inserts are not done in the "peak" periods of online use, thereby causing less of an impact.
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 Pool Overflow in Mainframe ADABASE polymathtarun Java & MQSeries 4 Fri Jun 03, 2016 11:57 am
No new posts Buffer limit reached while handling h... rajendra kalepu COBOL Programming 32 Mon Mar 31, 2014 7:29 pm
No new posts Access to COBOL work file buffer in s... Lukasz.Wojtasiak PL/I & Assembler 5 Tue Apr 16, 2013 6:37 pm
No new posts How to refresh the shared pool / panel? enrico-sorichetti TSO/ISPF 7 Fri Sep 07, 2012 8:09 pm
No new posts Cobol Open Statement & VSAM Buffer kevodaly COBOL Programming 1 Thu Feb 02, 2012 1:07 am


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