What is the recommended maintence tasks for CLM V5 and V6

0	Mark Ireland (261●1●57●48) \| 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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Madan Kumar (11●1) | 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 (11●1) | 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 (11●1) | 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

It's all about the answers!

Related questions

What is the recommended maintence tasks for CLM V5 and V6

3 answers

Your answer