xCP – Cleanup space

  1. Fire the following query and note the <r_object_id> of the latest version of xcp_atrifact_bundle
select r_object_id, namespace, r_version_label from xcp_artifact_bundle (all) where namespace='<namespace>’
  1. Fire the following query to delete all the older versions. Be very careful in noting the object ID. It should be the object ID of the latest version of the object.
delete xcp_artifact_bundle (all)  objects where namespace = ‘<namespace>’ and r_object_id != ‘<r_ojbect_id> noted in first query’
  1. Once the objects are deleted, run dm_DMClean job to purge the older objects and its content from repository by navigating to “Job Management” > Jobs. Select dm_DmClean job. Right click and run.
You can do the same clean up for the xcpui, xcpcommons and xCP core in the xcp_artifact_bundle.

xCP – logger configuration for search service

– Log4j configuration:
Add the following lines in the
        log4j.properties of the application found under <app server>\webapps\<app_name>\WEB-INF\classes:
        #XCP Search REST classes
log4j.logger.com.emc.xcp.rest.search=DEBUG
#For Real-Time Query
log4j.logger.com.emc.xcp.rest.search.realtime=DEBUG
#For Full-Text Query
log4j.logger.com.emc.xcp.rest.search.fulltext=DEBUG

D2 – Columns in doclist

1) D2 will check D2-Config -> Interface -> Display configuration first:
If the listed object type is in “Selected type” pane and the property is configured with a Dictionary, then D2 will follow the Dictionary.

User-added image

2) If there’s no Dictionary configured, D2 will look into the object type definition:
In Composer, open the target object type, and find the label in “Display” tab, the label defined will be displayed in D2 Doclist widget.
User-added image

Enable d2-client log in debug mode

1.  Navigate to the logback.xml file in the following location:
<Install path of Web Application Server>\webapps\D2\WEB-INF\classes
2.  Change the level from info and warn to debug.
3.  Change the value under the <root> tag from info to debug.
4.  Clear the old logs (after stopping the application server).
5.  Start the application server service.

Oracle Tuning

  1. Set CURSOR_SHARING to FORCE
  2. Use ALL_ROWS (default value for OPTIMIZER_MODE
  3. Tune PROCESSES
    1. As a rule of thumb, PROCESSES should be set to the double of the sum of maximum concurrent sessions of all content server instances.
    2. For example, if there are two instances each with concurrent_sessions set to 250, PROCESSES should be set to 2000 (2x2x250).
  4. Keep statistics up-to-date
    1. Oracle statistics are used by the query optimizer to choose the best execution plan for each SQL statement. A worse execution plan can be chosen with out-of-date statistics. To make sure the statistics are up-to-date, the following command can be executed in SQLPLUS as SYSDBA:
    2. exec DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'<repository>’, options=>’GATHER’, estimate_percent=><percentage, 30 is recommended>, method_opt=>’FOR ALL COLUMNS SIZE AUTO’, degree=><cpu cores>);

xCP Designer skip BAM and xPlore

1. Navigate to %xCPDesigner%/plugins folder

2. Find the jar file com.emc.xcp.builder.deployment.xms_xxx

3. Open the jar using 7-zip or someother and edit the file blueprint.xml file located at com\documentum\deployment\xms

4. remove search and bam services from the file

5. Restart xCP designer.

Now xCP Designer will not validate these 2 services.  Also perform the above steps in the xms server as well.

Note:  This might not be supported by EMC.

xCP Designer preview mode configurations

to start of metadata

Following configurations can be used with the preview mode.

Open xCPDesigner.ini file and add the below parameters based on the requirements.

-DdisplayWebbyView=true (to see server side errors in webby console)

-Dwebby.containerTimeout=30  (Specifies the timeout value)

-Dpreview.mode.debug=false (Provides additional log details)

-Dwebby.jvmArgument=”XX:PermSize=192m -XX:MaxPermSize=192m -Xms512m -Xmx832m”