Table of Contents

Search

  1. Introduction
  2. Samples and Examples
  3. Tools and Utilities
  4. SDK Resources

Sample Database Performance Test Properties File

Sample Database Performance Test Properties File

The following sample
TestIO.properties
file contains configuration for testing the database performance:
################################################################### #### Properties for Oracle Database database_type=oracle hostname=localhost port=1521 servicename=orcl.informatica.com username=mdm_sample2 password=!!cmx!! ## if jdbcUrl is provided, above hostname, port and servicename will not be used to calculate jdbcUrl #jdbcUrl=jdbc:oracle:thin:@//localhost:1521/orcl.informatica.com ################################################################### #### Properties for sqlserver Database #database_type=SqlServer #hostname=psv28mdmqa1 #port=1433 #databasename=cmx_ors #username=cmx_ors #password=INFAdba1 ## if jdbcUrl is provided, above hostname, port, databasename, username and password will not be used to calculate jdbcUrl #jdbcUrl=jdbc:sqlserver://psv28mdmqa1:1433;databaseName=cmx_ors;user=cmx_ors;password=INFAdba1 ################################################################### #### Properties for DB2 Database #database_type=DB2 #hostname=psraxmdmqa1 #port=60000 #databasename=MDM10 #username=cmx_ors #password=INFAdba1 ## if jdbcUrl is provided, above hostname, port and databasename will not be used to calculate jdbcUrl #jdbcUrl=jdbc:db2://psraxmdmqa1:60000/MDM10 ################################################################### #### properties unrelated to database connection ## no of records to insert no_of_records=1000 ## name of the file in which all the results will go from this utility output_result_filename=c:/temp/TestIO_result.log ################################################################### INFORMATICA_TESTIO_MAX_UPDATE_DELETE_ROWS=200000 INFORMATICA_TESTIO_MAX_THREADS=10 INFORMATICA_TESTIO_COMMIT_RECORDS=500

0 COMMENTS

We’d like to hear from you!