What is ODBC_BLOCKSIZE variable used for and how to configure it?

Document ID : KB000047290
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

What is ODBC_BLOCKSIZE variable used for and how to configure it? 

 

Environment:  

CA Service Desk Manager (SDM) r12.9, r14.1 running with CA Business Objects (BOXI) r3.x, r4.x.

Note this applies for users running CA Business Objects only, for the time BOXI is GA as per SAP.

 

Answer: 

ODBC BLOCKS settings are used to make ODBC to return the information to SDM faster.

This only applies to the way in which records are fetched from DB for ODBC (reporting) purposes. This is not needed/not impacts regular SDM functionality. 

It is defaulted to 50 and is configurable via pdm_options_mgr utility.

CA recommends setting it to 1000: 

@NX_ODBC_BLOCKSIZE=1000

The value 1000 could be set to much higher value too, there is no hard and soft recommendation from CA yet.

It is a balance that you may have to hit based on your environment/reports etc, but you can start with this value.

To install this option you should run:

pdm_options_mgr -c -s ODBC_BLOCKSIZE -v 1000 -a pdm_option.inst
pdm_options_mgr -c -s ODBC_BLOCKSIZE -v 1000 -a pdm_option.inst -t 

This requires SDM to be recycled to take effect.

 

Additional Information:

For environments running SDM in Advanced Availability architecture refer to:

TEC1788456 - Best Practice for PDM_OPTIONS_MGR Changes in a Service Desk Manager (SDM) Advanced Availability (AA) Installation 

 

For environments running SDM in Conventional architecture, proceed as follows in each SDM server:

TEC612988 - Best Practice when doing Changes to NX.ENV: using the 'pdm_options_mgr' command