Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Sample Conf.properties File

Sample Conf.properties File

You might configure the conf.properties file similar to the sample file below.
#The port on which Data Archive starts. Default is 8080. informia.applicationPort=8000 #Enables Data Archive to use SSL authentication. #informia.sslEnabled=Y #Specifies whether the keystore password is encrypted. #informia.isKeyStorePassEncrypted=true #Specifies the file path to the keystore. #informia.sslKeystoreFile=path to keystore #Specifies the keystore password. #informia.sslKeystorePass=password for keystore #Specifies whether to validate the keystore. #informia.validateKeystore=false #Sets the browser session timeout value, in minutes. Default is 10. informia.applicationSessionTimeout=20 #Sets the maximum active Java threads to run at a time. Default is 10. informia.maxActiveAMThread=10 #Displays quartz log messages. Default is N. #informia.showQuartzLog=Y #Maximum numbers of cached AM statements. Default is 100. #informia.maxCachedStatements=100 #ORACLE EXPORT IMPORT ATTRIBUTES #Location of the Oracle client installed on the ILM application server. #informia.oracleClientPath= #DB2 EXPORT IMPORT ATTRIBUTES #Uncomment this parameter to use export/import Utilities for IBM DB2. The value points to the location of the IBM DB2 Connect client. For example: \home\user\sqllib #informia.db2ClientPath #Attribute for DB2 EXPORT IMPORT ATTRIBUTES. Use for AS400 and mainframe only. #informia.importUtilName=IMPORT #Temporary folder for export/import used with the above attribute. #informia.TempDirectory #Temporary folder on the IBM DB2 server for use by import/export utilities to store LOB values. #informia.exportLobLocation #Data Discovery Attributes #Enables XSL debugging. Default is N. #informia.xslDebugMode=Y #Loads the storage library. Verify the relevent storage files are in the given path. Default is N. #informia.loadStorageLib=Y #If set to Y, the server will not display the main Applimation web site on the login screen. Default is N. informia.intranetMode=N #Enables row count validation before a delete. Default is N. #informia.validateRowCountBeforeDelete=N #Archive to external storage email attributes. Default from_addr and to_addr will be picked up if no entity or pfv-specific entries are given. #entity_-8_from_addr=From_Entity_-8 #entity_-8_to_addr=To_Entity_-8 #entity_-12_from_addr=From_Entity_-12 #entity_-12_to_addr=To_Entity_-12 #pfv_100_from_addr=From_Pfv_100 #pfv_100_to_addr=To_Pfv_100 from_addr=ILMAdministrator to_addr=ILMAdministrator #Uses the given value, which must be unique, as row and column separators. #informia.bcp.columnSeparator=%@% #informia.bcp.rowSeparator=%#%# #Enables archive to external storage in serial mode. #informia.discovery.serialMode=Y # #informia.discovery.issueDelete=N Defines the metadata connection for the Data Discovery portal. informia.dataDiscoveryMetadataQuery=AMHOME # #informia.dataDiscoveryIgnoreJobIdQuery=Y # #informia.maxDiscoveryRows=100 #Appends the job ID to Data Discovery queries, so that the Data Discovery feature does not display the table more than once. #informia.dataDiscoveryAppendJobIdPredicate=false # #informia.dataDiscoverySimpleQueryConstruct=false #Data Archive Quick Restore Attributes #informia.MonitorQuickTxnRestoreQueue: Controls the behavior of the monitor thread used to poll the status of restore jobs triggered by an external API. #Values: #Y: Monitor process polls the progress. You can access data from jsp/TxnRestoreApiUtil.jsp. #N: Monitor process does not poll the progress. #Default is Y. #informia.MonitorQuickTxnRestoreQueue=N #IP address of the ILM application server. #informia.applicationHostname=<IP address> #Enables the embedded web server to bind to multiple IP addresses. #informia.bindTomcatToMultipleIPAddress=N #LDAP Properties #Enables LDAP authentication. #authenticationMethod=LDAP #Enables LDAP SSL authentication. #ldap.useSSL=true #Enables LDAP role synchronization. #ldap.syncRoles=true #LDAP Attribute Mapping Properties #Maps to the ILM user name "AM_USERS.USER_NAME." #ldap.attribute.userName=uid #Default is "uid" for Sun LDAP and "sAMAccountName" for Active Directory. #Maps to the ILM full user name "AM_USERS.FULL_NAME." #ldap.attribute.fullName=cn #Default is "uid" for Sun LDAP and "displayName" for Active Directory. #Maps to the user email address "AM_USERS.EMAIL_ADDRESS." #ldap.attribute.email=mail #Default is "mail" for both Sun LDAP and Active Directory. #Maps to the organization email address "AM_USERS.ORGANIZATION_NAME." #ldap.attribute.organizationName #No default value. If this property is not set then the user's organization name will be set to "LDAP User." #Group member attribute name. #ldap.attribute.member=member #Default is "uniqueMember" for Sun LDAP and "member" for Active Directory. #Name of the attribute that represents the groups the user is a member of. #ldap.attribute.ismemberof=isMemberOf #Default is "isMemberOf" for Sun LDAP and "memberOf" for Active Directory. #Name of the object class representing a group. #ldap.attribute.groupclassname #Default is "groupOfUniqueNames" for Sun LDAP and "group" for Active Directory. #LDAP paging support. Controls the number of entries returned in a single page. A value of 0 disables paging. #ldap.pageSize=500 #Controls whether to drop interim tables when terminating a job. Default is false. #informia.dropInterimTablesOnTerminate=false #Data Discovery Properties #Appends the applimation_job_id predicate to child table query WHERE clauses. #Default is false when the metadata source is AMHOME. Otherwise the default is true. #informia.dataDiscoveryAppendJobIdPredicate=true # Enables row level security in AMHOME mode (informia.dataDiscoveryMetadataQuery=AMHOME). # informia.dataDiscoverySearchUsingNPASecurity=true # Controls whether restore cycles will use an APPEND hint in CTD insert as select statements. Default is false. # Note that using APPEND will require an exclusive lock on the ERP table and "ORA-02049: timeout: distributed transaction waiting for lock errors" might occur. # informia.useAppendHintForRestore=false # Use DBA_* or ALL_* views when you create the seamless access layer. Default is DBA_* views. # For a value of true, access to the following DBA views is required: # Seamless access user: DBA_DEPENDENCIES, DBA_SYNONYMS, DBA_OBJECTS, DBA_POLICIES # Source user: DBA_VIEWS, DBA_TAB_COLUMNS #informia.useDbaViewsInSeamlessAccess=true # Specifies the default retention period for the archive folder. # 0 Immediate expiration allowed. # -1 Infinite retention applies. # nd|D|m|M|y|Y Positive integer with d, or m, or y suffix (case insensitive). # For example, 500d means 500 days; 24m means 24 months; and 10y means 10 years. #informia.defaultArchiveAreaRetention=-1 # Queries the database catalog from the database drivers provider's implementation of the API. Use with legacy platforms. # Y uses the driver providers implementation of JDBC API to query database object information. # N uses the universal approach of querying the database object information. Default is N. # informia.useDriverProvidedMetadata = Y #Controls renaming of the archive target staging directory. #informia.attachmentRenameDir=Y #Enables Oracle Cardinality hints. Oracle Cardinality hints can improve performace. #informia.privacyEnableCardinalityHint=Y #Enables security in JSP-based API to manage jobs. #Provide host entries separated by a comma. #validHosts=host1, 192.168.168.97, dev.* #Displays the host and port number on every line of the applimation.log file. #informia.appendHostAndPortInLog=N #Determines if you want to retain trailing spaces in archived data for VARCHAR fields when you query data from the Data Vault. #informia.retainTrailingSpaces=N #Uncomment to turn off bulk extraction select statements from the ILM engine. Disable only at the request of Informatica Global Customer Support. #informia.bulkExtractionMode=N # informia.virtualView.colSeparatorConstant=&COL_SEPARATOR #Enables you to load tables with row length greater than 100,000,000 bytes. #informia.fasLoadAdditionalAttributes=<entry key="maxSourceLineLength">512000000</entry> #Restricts the concatenated column length in bulk extract mode. Default is 3000 bytes. #informia.bulkModeMaxConcatenatedColumnLength=3000 #Enables you to use an URL to view the Data Discovery portal application view for entities. #informia.appViewGetAllowed=Y # Legal Hold Query Options # Prevents legal hold child table queries from running in parallel. Default is false. # legalhold.useWithClauseForChildTableQuery=true # Number of npa_unique_record_index values in the IN list of legal hold child table queries. Default is 100. # legalhold.numUniqueIdsInWhereClause=100 # Number of tables that the Import Metadata from Database job commits to the database at each commit interval. # informia.miningCommitCount=10000 # DB2 HPU Export Utility Configuration #Location of the IBM DB2 HPU utility root directory. #informia.db2HPUPath=/opt/IBM/DB2TOOLS/HighPerformanceUnload42 #IBM DB2 utility that Data Archive uses to export data. #informia.exportUtilName=HPU # #informia.db2Extension=DEL #Statement that is inserted after the load file name of the import command. #informia.db2ImpStart= #Statement that is inserted before the insert statement of the import command. #informia.db2ImpMiddle= #Statement that is inserted after the insert statement of the import command. #informia.db2ImpLast= #Statement that is inserted after the unload file name of the export command. #informia.db2ExpStart= #Statement that is inserted after the select statement of the export command. #informia.db2ExpLast= #Optional. Character that identifies the column separator for the IBM DB2 HPU utility to export data. Configure to one byte length. #informia.hpu.columnSeparator= #Optional. Character that identifies the row separator for the IBM DB2 HPU utility to export data. Configure to one byte length. #informia.hpu.rowSeparator= # Creates threading tables as index organized tables. Default is true. # informia.createDFSThreadingTableAsIOT=true # Creates an index on the APPLIMATION_ROWNUM column if tables are not created as index organized tables. Default is true. # informia.createIndexOnDFSThreadingTable=true #Enables DFS pause and resume functionality. #informia.DFS.PauseResume=Y # Set property to false in order to keep the transaction xml (app view) for debugging purposes. # informia.dataDiscovery.deleteTransactionXML=true # Disables the trend graph calculation for large datasets in the DGA Administrator Dashboard. # informia.disableTrendGraph=Y # Adds the partition column name to partitioned tables. informia.partition.ilm.column=ILM_PART_COLUMN #If set to N, this property preserves native partitioning (no redefinition). #informia.partitionDbmsRedef=N # #informia.fasLoadProcessingThreads= -a 0x00 -k 4 -j 1 -x # Default is - " -k 4 -j 1" # #informia.maxBcpGroupSize=1024 #Default is 1024. # #informia.sctPremissionCommand=chmod 664 #Defines the task timeout of FAS server. If unset, default is 3000(ms). #informia.fasServerTaskTimeout=120000 # Determines if an additional row separator is required for BCP file generation when the retirement job uses an SAP function module to generate BCP files for data in transparent HR and STXL tables, ADK files, and attachments. Default is N. informia.isSapOnWindows=Y # Determines the maximum number of large files such as BLOB or CLOB files, to store in a folder in the BCP directory.The size of each file is determined by the informia.LoaderDatFileMaxSizeLimit property. Default is 100000. informia.bcp.maxLOBFilesInADir = 100000 # List of special characters in table or column names. informia.bcp.specialChars = / \\ $ ( ) = & ^ @ # % ! * # Enables access layer role assignment to partitions. #informia.enableAccessLayer=N # Allows Microsoft SQL Server to treat varbinary with a length less than 2000 characters as varchar. informia.sqlServerVarBinaryAsVarchar=Y # Executes the run procedure in archive from history. #informia.proceduresToExecute.inArchiveFromHistory=java://com.applimation.archive.dao.impl.MoveFileDAOImpl #Defines the maximum number of errors that the Data Vault Service migration process can generate before the migration process stops loading data into the Data Vault. Default is 4. #informia.fasMigrationErrorThresholdCount=4 #Defines the migration extract partition group size. Default is 3. #informia.fasMigrationExtractPartitionGroupCount=3 #Defines the maximum allowed error count before aborting the Data Vault Loader job. Default is 4. #informia.fasLoaderErrorThresholdCount=4 #Defines the size limit of megalob files in MB. Default is 1024 MB. #informia.LoaderDatFileMaxSizeLimit=1024 # Set the below property to N to stop using the InsertAsSelect in CTD and GC step. Default is Y. #informia.insertAsSelectFlag=Y # Runs DGA Data Collection as the admin user or application user. Default is true. # informia.dga.useAdminUser=true #Specifies the encoding technique used by Tomcat. #informia.httpCharacterEncoding=UTF-8 #Stores the NULL character used by the Data Vault Service to load NULL data into table columns in the Data Vault. Default is enabled. To disable the property, use the # character to comment out the property. informia.NULLRepresentationInBcp=\u007F #Loads the Data Visualization option so that users can create reports and dashboards. Set this property to Y or N. Default is Y. #informia.loadDataVisualization=N #Overrides the default RMI port used to connect to the Data Visualization server. Default is 1129. #informia.visualizationPort=1129 #Overrides the default RMI host used to connect to the Data Visualization server. Default is localhost. #informia.visualizationHost=localhost

0 COMMENTS

We’d like to hear from you!