Can i exclude BBPCONT table from SRM TDMS refresh?

[Former Member]

Hi,

BBPCONT table is taking lot of time in Data selection phase , While reading details about this table it contacts attachments.

Let me know best possible way out.

V

[rajesh_kumar2 · Accepted solution]

Hi Vinay,

You should not exclude the table BBPCONT for a TDMS SRM copy.

This table would contain Document Contents in your system which is generally required from SRM perpective.

You need to optimize the data selection for this be referring to the link mentioned by Devipriya.

Additonally please note that this table contains LRAW field so it is bound to take time . So you need to be little patient here.

Thanks,
Rajesh

[Former Member · Accepted solution]

Thanks Rajesh for the explanation, this is what i was looking for. All i knew was this table contacts attachments.

[Former Member]

Hello Vinay,

Can you please open an OSS message in the component CA-TDM-BUS-SRM for us to look into the performance issue here.

Also have you enabled parallel data selection for this table so that the data selection will run with parallel jobs.

Refer: http://scn.sap.com/docs/DOC-49910

Thanks and regards,

Devipriya Supramanian

[Former Member]

Hi Devipriya, I have enabled parallel data selection for this table, hope to get it loaded faster now.

[Former Member]

Devipriya,

Can you suggest me other large tables in SRM other than

BBPCONT , STXL so that i can enable parallel data selection.

regards

Vinay

[Former Member]

Hello vinay,

It is not possible to tell bigger tables without looking into the system.If you feel that some object is taking a longer duration to perform data selection, then you can parallelize its selection. From this package run you will be having the runtimes of all the tables. You can take the objects for which the data selection has run the longest and then do the same in your future packages.

Regards,

Devipriya