In order to use StorageFS with a database, please set in [COMMON SETTINGS] section the parameter StorageType = 3. The following database vendors are supported: Oracle-JDBC, MSSQL, H2 (based on MySQL) [STORAGEFSDB] Parameter Value Description Defaults ArchPath Defines the path, where documents will be stored. Can be specified per ContentRepository by adding a trailing "_<ContentRepository>" Example: ArchPath_T1 = /opt/storage/T1 Multiple path configurations are possible by adding a "#<number>" between ArchPath and potential trailing repository specification. Example: ArchPath#1_T1 = /opt/storage1/T1 ArchPath#2_T1 = /opt/storage2/T1 Please note that every defined ArchPath needs to be existent as well as it has to be accessible for the user KGS store is running on. ContainerCachePath Cachepath for Containeroptin ContainerMaxDocSizeMB Integer Documents with a size more than this limit (in MB) will be stored as a single file (not in a container). 500 ContainerMaxMB Integer Size limit for a container. 0 ContainerMaxFiles Integer 0 = Containermode disabled Can be specified per ContentRepository by adding “_<ContRep>”. Example: ContainerMaxFiles_T1=500 1000 ContainerCacheMaxTime Integer Maximum time in seconds after a container will be closed when no new archiving request arrives. 3600 ContRepInPath true / false Repository ID in document filing structure TRUE EnableComponentMove true / false Move files instead of copying to ArchPath. If this option is being enabled it increases the performance if the working directory of the ContentServer and the defined ArchPath are on the same hard disk. FALSE EnableFileDelete true / false If file delete is not enabled, the dataset in the database will be deleted by a delete request, but the corresponding component file remains in the filesystem. TRUE EnableFilesWithExtension true / false Datafilenames with fileextention (depending on MIMEType) RetentionPeriod Integer Defines the amount of time (in months) from date of filing until which deletion should be prevented.. Retention periods can be set per ContRep and per document mime time. Example: RetentionPeriod_T1=36|application /x-alf=1000|application/x- reo=5|image/tiff=6 0 FolderDepth Integer For more information: STORAGEFSDB - Additional Information 2 FolderMax Integer Defines the maximal possible number of entries per Node. 1000 FolderMaxFiles Integer Defines the maximal possible number of files in a folder. 1000 FolderPrefix String / Char <yyyyMMdd> = Dateprefix in folderstructure. Example:\ArchPath\T1\20110825\0000\0000\document.pdf DB-URL String / Char Connection URL for the database. Sample for Oracle: jdbc:oracle:thin:@169.254.25.100:1521:KGSSTORE DB-Driver String / Char JDBC driver name. If (DB-URL not set) DB-USER String / Char Database username DB-PASSWORD String / Char Database user password The password will be encrypted after the first start. DB-TableNamePrefix_xx String / Char Prefix for database tables. ContRep DisableFullPath true / false True = document reference in database is relative to parameter ArchPath. Otherwise, the full path to the document will be stored. FALSE Repositories List of RepositoryIDs List of comma-separated Repository-ID’s. Repositories for which database tables may be created automatically. Sample: FI, T1 LockFiles true / false Lock files at the file system if retention is activated. TRUE IgnoreContRepID List of RepositoryIDs List of comma-separated RepositoryID’s. For this repository the key CSREPID will be ignored for database accesses, so the DocumentID will be the unique key to the document. ChangeRepositoryIDs List of RepositoryIDs Repository ID’s to change, comma-separated. This parameter works only in combination with parameter IgnoreContRepID. If a document is archived with one of these ID’s, the first access to this document with a different ContentRepID will over-write the repository information in the document info file. KGS Store will create a directory tree which depends on the parameter FolderDepth. In the lowest subfolder the document data file will be saved. KGS Store uses three tables for storing all needed component and document information Table: <Prefix_>DOCUMENT Field name Field value Type Description CSREPID (Index) VARCHAR(40) SAP ContentRepositoryID DOCID (Index) VARCHAR(40) SAP DocumentID ALVERS 4500 VARCHAR(4) ArchiveLink-Version 0031 / 0045 PROTECTION VARCHAR(4) SAP ProtectionFlag CREDATETIME DATE SAP creation timestamp MODDATETIME DATE SAP modification timestamp RETDATE CHAR(8) Retention Date BARCODE CHAR(40) SAP barcode (for future use) Table: <Prefix_>COMPONENT Field name Field value Type Description CSREPID (Index) VARCHAR(40) SAP ContentrepositoryID DOCID (Index) VARCHAR(40) SAP DocumentID COMPID (Index) VARCHAR(512) SAP CompID ALVERS 4500 VARCHAR(4) ArchiveLink-Version 0031 / 0045 CREDATETIME DATE SAP creation timestamp MODDATETIME DATE SAP modification timestamp RETDATE DATE Retentiondate APPVERS VARCHAR(80) SAP Application Version COMPTYPE VARCHAR(80) SAP Mimetype CHARSET VARCHAR(80) SAP Charset FILESIZE NUMBER FILEN VARCHAR(512) Filename in file system (if CONTAINERFILE is not empty, Filename of a ZIP Container) ORGFILEN VARCHAR(512) Original filename CONTAINERFILE VARCHAR(255) Filename in container (if container HASHALG VARCHAR(10) Hash algorithm HASKEY VARCHAR(128) Hash key HASHALGCONTFILE VARCHAR(10) Hash algorithm container file HASHKEYCONTFILE VARCHAR(128) Hash key container file Table: DOCUMENT_KEYS Field name Field value Type Description NAME (Index) VARCHAR(40) Key name VALUE (Index) VARCHAR(255) Key value CSREPID (Index) VARCHAR(40) SAP ContentrepositoryID DOCID (Index) VARCHAR(40) SAP DocumentID
[COMMON SETTINGS]Filesystem structure
Database structure
→ Configuration (Store) - EMC CENTERA DB (4) | Configuration (Store) - StorageTypes - ArchiveLink