Database requirements

The database stores all the data retrieved from the clients. Before installing the BigFix server, ensure that the database requirements are met. A pre-upgrade check Fixlet is available to perform a set of checks to verify if the BigFix server can be successfully upgraded to V9.5.X. A log file is created in the BigFix server directory containing details about the executed steps. If these checks fail, a preupgrade-Version 9.5.X-<datetime>.err log file is created in the BigFix server directory. If these checks end successfully, a preupgrade-Version 9.5.X.out log file is created in the BigFix server directory. X is the modification level. This task is not relevant only when all the checks are completed successfully.

  • The BigFix server on Windows systems supports the following configurations:

    • Local or remote SQL Server 2008, 2008 R2, 2012, 2014 or 2016.
      Important: When installing or upgrading BigFix, the user account performing the installation or upgrade must have sysadmin server role in SQL Server. When working with a remote instance of SQL, the AD domain service account must have dbo rights, that is db_owner on the BFEnterprise and BESReporting databases. Start with sysadmin server role to perform the installation or upgrade, then back off the privileges to db_owner after the product is up and running.
  • The BigFix server on Red Hat Enterprise Linux systems supports the following configurations:

    • If the DB2 server is installed locally: DB2 10.5 Enterprise server Edition 64-bit or Workgroup Server Edition 64-bit.
    • If the DB2 server is installed remotely: HCL Data Server client 10.5.
    To check if you have a server or a client installed and to verify the DB2 edition, you can run the db2licm -l command. On the computer where the DB2 server is installed, you receive a detailed report, if only the client is installed you receive an empty report. To check which DB2 version is installed, run the db2level command.

The DB2 instance names used to install the BES Root Server cannot contain the following special characters: blanks, tabs \t, returns \n and ; & | " ' < >.

Database passwords must contain only ASCII characters, otherwise the installation might fail.

Note: To successfully install the BigFix server on Linux systems, ensure that you unset the DB2 registry variable DB2_COMPATIBILITY_VECTOR. This variable should be set to null.

For more information about the supported database versions, see BigFix 9.5 - System Requirements.