topic Re: Performance Problem with SCUG in Application Development and Automation Discussions

Performance Problem with SCUG

Former Member — Fri, 24 Jul 2009 06:49:35 GMT

Hi,

The problem is, SCUG has started taking more time( almost 3 times of the average time ).

And it has been observed, CDpos_uid has increased rapidly during last 6-7 weeks, almost by 8 GB.

So can you please tell me,

1) what do the tables CDpos_uid, CDcls & CDhdr store?

2) how these tables get used while running SCUG?

3) what should be the strategy( for eg archiving ) for the above tables?

Thanks.

Regards,

Sachhidanand Rankhambe

Bernhard_SAP — Fri, 24 Jul 2009 09:48:39 GMT

Hi,

1) what do the tables CDpos_uid, CDcls & CDhdr store?

-->the standard change documents

2) how these tables get used while running SCUG?

-->change documents for roles are using standard change documents (so also the role assignements to users)

3) what should be the strategy( for eg archiving ) for the above tables?

-->depending on how often you need the chagnedocs the interval for archiving them shall be selected.

Please refer also to sap note 626345 regarding archiving.

b.rgds,

Bernhard