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.
Note:

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.