Exporting CDT

Users with the Developer role can export CDT files from your current environment, preferably from the master environment by using Self Service. By exporting configuration, you can quickly migrate database configurations from the master environment to the target environments. After you export CDT files, these files are available for import in all other environments and you do not have to select a target environment.

About this task

Note: When adding large tables to the IgnoreList during a CDT export, also add the related child tables. Excluding only the parent table may not prevent processing of dependent tables, which can result in export timeouts.

Procedure

Access Self Service with your IBMid.
From the Self Service menu, click Environments.
From the list of environments, select an environment.
In the Configuration tab, click Export CDT.
Enter the snippet in the CDT preferences XML field, and then click Export.

Note:
You must use SourceDatabase as SYSTEMDB and TargetDatabase as DEFAULTXMLDB.

When you specify these keywords, you do not have to provide the definition or details for the Source and Target databases in the CDT preferences XML file.

Example

<preferences>
    <configsynch>
        <Settings ReportsDir="">
            <AuditDeployment ValidateLockid="y" ValidateOldValues="y" ValidateRecordExistsBeforeDelete="y"/>
        </Settings>
        <SourceTargetPrefs>
            <SourceTargetPrefs>
                <SourceTargetPair SourceDatabase="SYSTEMDB" TargetDatabase="DEFAULTXMLDB">
                    <Transformations>
                    </Transformations>
                    <Ignore>
                     </Ignore>
                    <AppendOnly>
                    </AppendOnly>
                    <RecordFilter>
                    </RecordFilter>
                   </SourceTargetPair>
            </SourceTargetPrefs>
        </SourceTargetPrefs>
    </configsynch>
</preferences>

What to do next

You can view the export CDT report by clicking the process from the list. The ydkprefs.xml and the tag that you have entered for exporting the CDT are displayed in the log.