Logs growths and Log policies in MDM over SQL

[Former Member]

Hello everyone:

we are running MDM over SQL, and we have run couple of times already in our repositories get "frozen" due to lack of log space (SQL databse log files)

Is any best practiques, or any informaiton avialble by SAP acording how to configure the SQL logs to minimizate that cases ?

also I will like to ask if there is any information about how much is the impacts of loading data vs change existing data taking into acount the log increase

thanks in advance

[Former Member]

Hello Pedro

I dont mean your question about configuration SQL or about SAP MDM?

SAP MDM can work with different SQL Servers Oracle, MS SQL, DB2, Max DB and thats SQL Servers have own configuration parameters for log file management.

In SAP MDM you can manage log files path when create new DBMS connection (path where log files will save) in SAP MDM Console or set that path and some another parameters mds.ini file SAP MDM Server:

Log SQL Errors

Log SQL Modifications

Log Protocol Transactions

Log Dir

Lexicon Dir

DEBUG\UseAssert

Archive Dir

Accelerator Dir

Modifications Dir

RELEASE\UseAssert

Workflow Detailed Report

Trace Level

More about thats parameters you can read at:

http://help.sap.com/saphelp_mdm550/helpdata/en/8e/9f9c427055c66ae10000000a155106/frameset.htm

and

http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0677c82b40a2ee10000000a11466f/frameset.htm

Regards

Kanstantsin