EBIFour.com > Training > Clarify QRGs > Cleo Log of Warehouse - Part 2

Cleo Log of Warehouse - Part 2

15th August 2017

In an earlier post we reviewed the batch files need to archive and unarchive data sets to the Cleo Log of Warehouse.

In this post we will review the configuration/property files on the Production Server and the Log of Warehouse Server

Production Server :: Archive

Tasks to be performed: Update storageManagerPath

# Data Archiver Properties
####

# JDBC Driver, URL, and credentials for connecting to Database.
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbc:postgresql://localhost:5432/postgres
jdbc.username=postgres
jdbc.password=extol

# Location of Storage Manager root
#
# NOTE: BE SURE TO FORMAT THE storageManagerPath CORRECTLY, SEE EXAMPLES
#       IF storageManagerPath IS INCORRECT, DATA WILL NOT BE ARCHIVED
#       CHECK LOG FOR ERRORS
#
# Windows Example: storageManagerPath=C:/Cleo/Clarify_4_Runtime_Workspace/storage/
# Linux Example: storageManagerPath=/opt/Cleo/Clarify_4_Runtime_Workspace/storage/
####
storageManagerPath=D:/EBI44_Server/storage/

# Location to write archives to and prefix for the zip files name
archiveDirectoryPath=./archives/
archiveNamePrefix=ClarifyLogData_

# Range is 0-9, comment out to use default compression.
# compressionLevel=6

# Size of the Buffered output stream
outputBufferSize=10000

# Size of the Thread Pool to use when initializing files for reading.
FileServiceThreadPoolSize=5

# Size of the Buffer to use when Reading files from the storage manager directory
FileReadBufferSize=2156

# The estimated number of records that will be dumped for a single day.
# Sizing this higher than the number of actual records should prevent needing to reallocate memory when dumping a table.
#
estimatedNumberOfRecords=20000

Log of Warehouse :: UnArchive

Note: the Paths have double backward slashes

Tasks to be performed: Update storageManagerPath and archiveZipPath 


# Data Unarchiver Properties
####

JDBC Driver, URL, and credentials for connecting to Database.
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbc:postgresql://localhost:5432/postgres
jdbc.username=postgres
jdbc.password=extol

#Full path to the location of zip file archives.

# archiveZipPath=C:\EXTOL\DataWarehouse\archives

####

archiveZipPath=C:\EXTOL\DataWarehouse\archives\
#Path updated for archiveZipPath by Sean Hoppe 8/9/17

# Location of Storage Manager root

# NOTE: BE SURE TO FORMAT THE storageManagerPath CORRECTLY, SEE EXAMPLES

# IF storageManagerPath IS INCORRECT, DATA WILL NOT BE UNARCHIVED

# CHECK LOG FOR ERRORS

# Windows Example: storageManagerPath=C:/Cleo/Clarify_4_Runtime_Workspace/storage/

# Linux Example: storageManagerPath=/opt/Cleo/Clarify_4_Runtime_Workspace/storage/

####

storageManagerPath=C:\EXTOL\Clarify_4_Runtime_Workspace\storage\
#Path updated for storageManagerPath by Sean Hoppe 8/9/17

# Verification or Insert mode flag.

# Use I for insert mode, or V for verification mode.

#

# modeFlag=I

# modeFlag=V

# Unzip storage manager data
#

# set unzipData to false if you wish move the zip file to the storage manager without unzipping the LOC contents.

# Setting this property to false will save on space and processing time for the unarchive.

#

# unzipData = true

# unzipData = false

unzipStorageManagerData = false


By: on