It's all about the answers!

Ask a question

Server Rename activity with MS-SQL DB is taking longer time to complete for DNG


Sunil Deshpande (1310) | asked May 19 '21, 6:06 a.m.

 Hello,

     We are creating one Staging environment as Production and started the Server Rename activity for new Env. on CLM 6.0.5. But it is taking longer time ( More than 6 Days) to complete for DNG.
              We are using MS-SQL DB with CLM 6.0.5 repository and server rename activity is started on 12th Wednesday May 2021 but CCM and QM are completed 100% but RM is stuck at 20% since that day.
Sql is Consuming 99%-100% CPU utilization.

is there any solution for the RM?

Application server RAM -32 GB
MS-SQL DB server RAM - 32 GB.

Thanks in advance 


Comments
Bartosz Chrabski commented May 19 '21, 6:17 a.m.
Sunil,

I suggest open an official IBM PMR (ticket) and talking with the support team about MSSQL DB.

One answer



permanent link
sreenath v (78167) | answered May 19 '21, 7:47 a.m.
HI Sunil,

This usually happens for RM Application its because of so much of data contains in it. So when we did it with DB2 we increased log primary size.Provide double of the value it has now.

So please check with DB team to increase RM log primary size.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.