Skip to Content
0

SAP DB2 TRANSFERRATE 0.060000 parameter

Jun 14, 2017 at 08:39 AM

32

avatar image

Hi,

For SAP with DB2 on AIX, The default settings for TRANSFERRATE and OVERHEAD are:
TRANSFERRATE 0.060000
OVERHEAD 7.500000

Is it supported to change these values, as these values are default.
What would be the best setting we still have to figure out, but I first want to know if it is supported at all before we go and fiddle with them.

Best regards,

Menno

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frank-Martin Haas
Jun 27, 2017 at 02:33 PM
0

Hi,

good question. I guess most customers stay with the DB2 default values of those parameters although in some cases they can have influence on the DB2 optimizer and access plans may change.

The default values of those parameters changed over time with different DB2 versions. Cutomers that have a long DB2 version history may have different parameter settings for different tablespaces. Automatic storage tablespaces usually inherit the parameters from the storage group they have been created in( https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0059252.html ). SWPM creates all storage groups with the DB2 default parameter settings.

Regards

Frank

Share
10 |10000 characters needed characters left characters exceeded