Versions Compared

Old Version 1

changes.mady.by.user Chieko Sugizaki

Saved on

compared with

New Version Current

changes.mady.by.user Robert Andelin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Parasoft DTP requires a relational database. A DTP distribution is available that automatically installs and configures an embedded database server so you can immediately begin using DTP after installation. Most organizations, however, connect their DTP deployments can be connected to an external MySQL, PostgreSQL, or Oracle database server which provides greater flexibility and scalability. If you installed the embedded database distribution, you can still connect to an external database server if necessary (see Configuring the Database Connection). This section describes installing and configuring MySQL servers. Contact your Oracle or PostgreSQL administrator for details on installing and configuring those database servers. 

...

If data continuously loads in an explorer view, increase the value of the read_rnd_buffer_size variable.

If binary logging is enabled in MySQL, you must use the "ROW" or "MIXED" binary log format. The "STATEMENT" format will not work.

DTP does not ship with the MySQL, PostgreSQL, and Oracle JDBC drivers necessary to set up a database connection. Download the drivers and place them in the <DTP_DATA_DIR>/lib/thirdparty directory after completing the installation.

...

DTP Enterprise Pack, which includes Extension Designer, ships with it's its own embedded MongoDB. If you are installing DTP Enterprise Pack, and intend to use the embedded MongoDB, we recommend using an XFS file system in Linux per the MongoDB documentation.  or an NTFS file system in Windows, as per the MongoDB documentation and described in the excerpt below. If you are planning to use an external MongoDB instead, refer to the requirements for whatever version you intend to use.

Panel
titleFrom MongoDB Documentation

MongoDB on Linux

Kernel and File Systems

When running MongoDB in production on Linux, you should use Linux kernel version 2.6.36 or later, with either the
  • Linux/Unix: format your drives into XFS or EXT4
filesystem
  • . If possible, use XFS as it generally performs better with MongoDB.
    • With
the  is strongly recommended to
    • is strongly recommended to avoid performance issues
that may occur
    • found when using EXT4 with WiredTiger.

Asynchronous I/O Library

The libaio package, which is included in some Linux distributions, is required if you are using the DTP distribution for Linux that ships with an embedded database server. If the library is not already on your Linux system, install it using the appropriate package manager for your distribution. The following instructions are provided to help you install libaio on several common Linux distributions:

Red Hat and CentOS

sudo yum install libaio

Ubuntu

sudo apt-get install libaio1

Fedora

...

    • If using RAID, you may need to configure XFS with your RAID geometry.
  • Windows: use the NTFS file system. Do not use any FAT file system (i.e. FAT 16/32/exFAT).

Minimum Number of Database Connections

...

MySQLFor MySQL databases (5.6.x - 8.0.x), it is recommended that you use the latest version (8.0.x) of MySQL Java Connector.
PostgreSQLFor PostgreSQL database, it is recommended that you use the latest version (42.x) of JDBC driver.
Oracle

For Oracle databases, you will need to download the JDBC driver version recommended for your version of Oracle that will work with DTP:

Oracle 11.2 or 11gR2: ojdbc6.jar

  • Oracle 12.1 or 12cR1: ojdbc7.jar
  • Oracle 12.2 or 12cR2: ojdbc8.jar
  • Oracle 18.3: ojdbc8.jar
  • Oracle 19.x: ojdbc8.jar

Refer to the Oracle documentation for information on choosing the correct driver: https://www.oracle.com/database/technologies/faq-jdbc.html

...