Cleaning BC_SLD_CHANGELOG

[gustavo_prado]

Hi experts,

I want to create a script to delete obsolete entries of table BC_SLD_CHANGELOG from my PI. The conventional method (through SLD - Administration), is very slow.

What i need to know is how the column TSTAMP is stored, considering that we are on oracle 11. This information will be useful for the date filtering.

SQL> desc sapsr3db.bc_sld_changelog;

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

APPL                                      NOT NULL NVARCHAR2(1)

NA_KEY                                    NOT NULL NUMBER(10)

TSTAMP                                    NOT NULL NVARCHAR2(17)

COUNTER                                   NOT NULL NUMBER(10)

CLASS_HASH                                NOT NULL NUMBER(10)

CLASS_HANDLE                              NOT NULL NUMBER(10)

OBJNAME                                            NVARCHAR2(1333)

OBJTYPE                                   NOT NULL NVARCHAR2(1)

OP                                        NOT NULL NVARCHAR2(1)

XML_FORMAT                                NOT NULL NUMBER(10)

XML                                                BLOB

XML_2                                              BLOB

WHO                                                NVARCHAR2(127)

Thanks in advance.

Gustavo Prado

[Former Member · Accepted solution]

Hi Gustavo,

Please check the sap note if you haven't yet.

1799613 - SLD Change Log clean up tool

Also, relying on conventional method may be slow, but than you will have SAP to blame for.

This also ensures the consistencies of data is maintained.

Regards,

Prithviraj.

[gustavo_prado · Accepted solution]

Hi Prithviraj,

I thought creating a pl/sql script the process could be faster. I was monitoring the session and there was just a dml command, the DELETE filtering by tstamp.

So, i'll check this note and try to clean this object.

Thanks.

Regards,

Gustavo Prado