Loaddb Reference
The loaddb tool lets you interact with the database to perform various tasks, such as backing up the database or uploading content. This reference lists the commands to perform these tasks.
loaddb.{bat,sh}
-Dlc.port=port# -Dlc.protocol=https -Dlc.host=fully-qualified-domain-name
command
loaddb.bat
-Dlc.port=8443 -Dlc.protocol=https -Dlc.host=mycomputer.global.mycompany.com
loadpub
The following table lists the available commands to use with the loaddb tool. The default command for the loaddb tool is UPGRADE.
| Command | Description |
|---|---|
| fix_audits | Adjusts the Content Delivery aggregated audit server. If the CDs have the problem, the non-aggregated audits on the CDs can also be fixed by running the following:
|
| genapi | Recreates the API topics in the documentation folder from the current code-base. This will include any API documentation that has been updated in patches.
|
| loadpac | Installs and uploads a documentation package. Creates a log file called loadpac.log in the ContentDelivery_home/logs directory. |
| loadpub | Uploads a publication from a directory of XML or data files. Creates a log file called loadpub.log in the ContentDelivery_home/logs directory. |
| loadtopic | The loadtopic option is used for topic upload or prepare. The target will upload topic files from a folder, and then do a single topic prepare.
Loaddb with the loadtopic option
All files in the single_topic folder are first uploaded using web/pub.xql?action=upload_start&type=topic, upload_resource&type=topic, followed by After all files are uploaded into the holding area, single topic prepare is invoked using web/pub.xql?action=prepare_topic with the
|
| optimize | Defragments the Lucene index. As you load and delete publications over time, the Lucene index can become fragmented. Defragmenting the Lucene index can improve performance and reduce memory consumption during search operations. |
| ADDCONFIG | Sets a global configuration value. This allows an administrator to change some of the global configuration values.
|
| AUDITEXTRACT | Extracts the audit XML files from the Content Delivery database to the ContentDelivery_home/extract/audits directory. |
| BACKUP | Creates a backup of the Content Delivery database.
Usage:
This command supports these options:
|
| CHECKDB | Runs a manual database consistency checking, rather than having to wait for the scheduled backup. The backup configuration in conf.xml supports scheduled backups with database consistency checking. However, running the loaddb BACKUP command does not perform database consistency checking.
This command supports these options:
|
| DELETECONFIG | Deletes a global configuration value. This allows an administrator to delete a global configuration value.
|
| INSTALL | Re-installs the database and removes all references to publications. Creates a log file called INSTALL.log in the ContentDelivery_home/logs directory.
|
| PATCH | Loads a single file into the Content Delivery database. File is loaded from the ContentDelivery_home/db folder. Supports the -Dpatch.dir and -Dpatch.file arguments. |
| RESTORE | Restores a backup of the Content Delivery database.
This command supports these options:
|
| UNPROXY | Removes a proxy setting (proxy.url) from a Content Delivery installation.
|
| UPGRADE | Upgrades the database with the latest set of files from the db folder. Typically, UPGRADE is used to update the skin files. Specifying this command creates a log file called UPGRADE.log in the ContentDelivery_home/logs. This is the default command. |
The following table lists the available options to use with the loaddb tool.
| Option | Use with Command | Description |
|---|---|---|
| -Dlc.db | BACKUP | The specified the starting-point collection inside the database that you want to act on. Example:
The full
*.zip file will be a back up of
collection (and all of its sub collections, if any exist).
If you do not specify -Dlc.db, it defaults to
, which is the whole database.
|
| -Dlc.context | All | Web application context, used to form the application URL. The default is derived from local configuration, usually /ContentDelivery
|
| -Dlc.file | BACKUP, RESTORE | Name of a backup ZIP files to create during a backup, or load during a RESTORE. |
| -Dlc.filter | loadpub | Filename of the XML resource to use as the filter file for the publication. |
| -Dlc.host | All | Host name of the Content Delivery instance in which to connect. The default is localhost. Install a certificate to JAVA directly with all options.
|
| -Dlc.install | loadpub | Set to true to make the publication visible. If set to false the publication's visible value will not be changed. The default is false. |
| -Dlc.package | loadpac | Name of a package file (.pac) or path to a directory that contains multiple .pac files. |
| -Dlc.port | All | Port number to connect to. The default is derived from the local configuration. |
| -Dlc.protocol | All | The network protocol to use for the connection. Should be either http or https. The default is http. Install a certificate to JAVA directly with all options. |
| -Dlc.pswd | RESTORE | -Dlc.pswd="admin_password" specifies the local administrator password. By default, no password is specified. |
| -Dlc.pubdir | loadpub | Directory where data is located to upload to the database.
To specify multiple input directories, separate the list by commas, for example:
|
| -Dlc.publang | loadpub | Publication language. The default is en. |
| -Dlc.pubname | loadpub | Name of the publication. |
| -Dlc.tempdir | BACKUP, CONSISTENCY_CHECK | Location for temporary files created during a backup. |
| -Dlc.toc | loadpub | Filename of the XML resource to use as the publication's top level TOC. This file must exist in the directories specificed by the -Dlc.pubdir argument. |
| -Dlc.zip | BACKUP, CHECKDB | Specifying -Dlc.zip=no creates a backup of the original database to a folder rather than to a zip file. The default is yes. |
| -Dpatch.dir | All | -Dpatch.dir=folder specifies the folder from which to load the patched file. This folder must start with db/ and is always local to the db/ folder. |
| -Dpatch.file | All | -Dpatch.file=file specifies the file to load into the XML database, which is located in the folder denoted by -Dpatch.dir |