Performance Problem with SCUG

[Former Member]

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

[Former Member]

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

[Bernhard_SAP]

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