It's all about the answers!

Ask a question

What is the recommended maintence tasks for CLM V5 and V6


Mark Ireland (26115748) | asked Feb 15 '16, 8:54 a.m.
Hi,

What regular maintenance tasks should we be doing for CLM please?

This is on a websphere windows server, using DB2 on Linux.

Best wishes

Mark

3 answers



permanent link
Madan Kumar (111) | answered Feb 17 '16, 5:19 a.m.
 Hi Mark

We don't recommend users to run these commands unless there are some specific issues.

repotools -deleteJFSResources 
repotools -compactdb
repotools -reindex
Database Reorg and Runstats

For maintenance activities in CLM we suggest backup information mentioned in this URI:
https://jazz.net/wiki/bin/view/Deployment/BackupCLM

For running any any repotools command, please raise a PMR with Support.

Thanks & Regards,
Madan


Comments
Mark Ireland commented Feb 17 '16, 5:55 a.m.

Hi,

We run the IBM shared service and as such our databases grow with projects coming and going.
The DB's and indexes are being updated constantly. We need a way to remove and clean up old data, along with ensuring that the servers run at optimal efficiency.

Best wishes

Mark.


permanent link
Madan Kumar (111) | answered Feb 17 '16, 12:29 a.m.
 Hi Mark

As regular maintenance tasks, please ensure the following:

1) Ensure you take full offline backup of CLM databases on DB2 server on a daily basis.
When taking the backup, you should stop the WAS profiles hosting CLM applications.

E.g. db2 BACKUP DATABASE jts TO C:\Installers\DB2\Newbackup
Repeat this for all the other CLM databases.

2) Parallely take complete folder backups of JTS_HOME\server directory so that the indices folders are backed up when Databases are backed up.

3) You could take Websphere profile backup using this step on a weekly basis:

START WAS profile hosting CLM, and then cd to 
<WAS_INSTALLATION_ROOT>/AppServer/profiles/<PROFILENAME>/bin folder
Then Run the Command --backupConfig.bat <Backup_File_Name_Date_WITH_PATH>.zip

Thanks & Regards,
Madan





Comments
Mark Ireland commented Feb 17 '16, 4:43 a.m.

HI,

Many thanks, we already do all this. My question was more directed to Repotools commands etc run on a regular basis to perform reindex, or deletes etc.
Also, do you recommend any DB activities?

Many thanks

Mark.


permanent link
Madan Kumar (111) | answered Feb 19 '16, 3:17 a.m.
 Hi Mark

Please raise a PMR to check on removing and cleaning up old data.

Thanks & Regards,
Madan

Comments
Mark Ireland commented Mar 31 '16, 10:08 a.m.

Does anybody have a set task list for DB2 maintenance tasks?

re-orgs etc etc

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.