cancel
Showing results for 
Search instead for 
Did you mean: 

Buffer Question

bpdown
Level 4

Version 7.5.3 (Windows)

Hello friends, 

I am having very slow backup speeds for some of my backup jobs.

Activity monitor tells -

info bphbd (pid=35416) wrote first buffer (size=4068)

info bphbd (pid=35416) wrote first buffer (size=3988)

info bphbd (pid=35416) wrote first buffer (size=5666)

info bphbd (pid=35416) wrote first buffer (size=5767)

Other jobs tell - 

info bphbd (pid=35416) wrote first buffer (size=269884)

It is only happen for two of my clients. Can someone please help? 

3 REPLIES 3

bpdown
Level 4

Thank you kindly Marianne, 

Slow backup are from Teradata. Can tuning my buffer sizes help?

Marianne
Level 6
Partner    VIP    Accredited Certified

I have no experience whatsoever with Teradata.
No idea what settings/tuning parameters are available for Teradata... 
The fact that bphdb is reporting the small sizes tells me that it is controlled by the source - Teradata.
Try to search the web for Teradata buffer tuning?
e.g. http://developer.teradata.com/doc/connectivity/tdnetdp/13.11/webhelp/ResponseBufferSize.html

Don't know if tuning NBU buffers will help. No harm in trying. 
Ensure that bptm log folder exists on media server to monitor effects before and after changes.