Settings for DB13 => task => validate structure => where to maintain the options for parallel threads ...?

[behlau_carlos]

Hi SAP community,

we want to schedule the DB13 tasks validate structure.

When we run this tasks via BrTools, we have the option, to configure the amount for parallel threads.

As this tasks is executed via OS User SAPService[SID] and by default, you can't log-on on OS-Level to this user, we trying to schedule the task via DB13 transaction ...

Therefore we are looking for the options to change the threads from 1 to 4 (up to the CPU oracle can use ...).

For BrArchive and BrBackup, etc. the configuration is done in INIT[SID].SAP file ...

I was search this forum but didn't found any results so far, same in help.sap.com ...

Thanks for your help.

Best regards

Carlos Behlau

[former_member193518 · Accepted solution]

SAP note http://service.sap.com/sap/support/notes/204499

Suggests that the parameters in the init<sid>.sap are used by BRConnect.

Regards,

Darryl

[behlau_carlos · Accepted solution]

Hi Darryl,

thanks a lot for your help.

But I don't see any parameters by default delivered for parallel threads than I can maintain.

Can you please tell me what the parameter name for the INIT[SID].SAP file is, that needs to be updated?

Best regards

Carlos Behlau

[Former Member · Accepted solution]

Hi,

Please check the below note...

1235952 - Minor functional enhancements in BR*Tools (2)

Check which all thing can be done in parallel and how...

Thanks

Rishi Abrol

[former_member193518 · Accepted solution]

Hi Carlos,

The BR*Connect tool is used to perform the validation with command "-f stats".

Because of this, you need to look at the parameters for the "stats" function.

Looking at the manual you will need either the "stats_parallel_degree" or the "stats_dict_degree" parameters.

It is not very clear which, but I think "stats_parallel_degree" is what you need.

Here's the command help for BR*Connect in Netweaver 7.3:

stats_parallel_degree - SAP Database Guide: Oracle - SAP Library

This parameter defines the number of parallel threads for updating statistics with BRCONNECT update statistics. For example, you can set this parameter to the number of CPUs to speed up update statistics.

stats_parallel_degree = <number>

Default value: 1

stats_dict_degree - SAP Database Guide: Oracle - SAP Library

The "-d" option controls the parallelism:

• -g|-degree: defines the degree of parallelism used by DBSM_STATS for update statisticsSyntax: -g|-degree <number>|auto|default|nullDefault: nullThis setting is valid for all tables, for which there is no parallelism setting in stats_dbms_stats. However, note that the setting -f degree (see above), if used, takes precedence over the setting in stats_dbms_stats. You can also set a table-specific degree of parallelism using the table DBSTATC.
  • auto: auto degree
  • default: Oracle default degree
  • null: table degree

I do agree that it is a little unclear when going through the documentation.

But hopefully one of those parameters should solve the issue for you.

Regards,

Darryl

[behlau_carlos · Accepted solution]

Hi Darryl and Rishi,

perfect!

Thanks a lot for your help.

Still wondering why I didn't found it the first time in help.sap.com.

Best regards

Carlos Behlau

[former_member193518 · Accepted solution]

Yeah, I don't like the help.sap.com since they changed the format.
Can't find anything as quick as I used to.

regards,

Darryl