Verify the Limit on the Number of Open Files on Data Repository Hosts

Upgrading › How to Upgrade CA Performance Management Data Aggregator - Command Line › Verify the Limit on the Number of Open Files on Data Repository Hosts

Verify the Limit on the Number of Open Files on Data Repository Hosts

Verify that the user that is installing Data Repository has a value of at least 65536 on the number of open files. Set this value permanently.

Note: In a cluster environment, the value for the number of open files must be the same on all nodes.

Follow these steps:

As the root user or a sudo user, log in to each computer where you are going to install Data Repository. Open a command prompt and type the following command to verify that the number of open files is set properly:
```
ulimit -n
```
The command returns the ulimit number. This number must be at least 65536.
If this number is not at least 65536, do the following steps:
1. Open a command prompt and type the following command to change the ulimit for the open files limit to at least 65536:
```
ulimit -n ulimit_number
```
  For example:
```
ulimit -n 65536
```
2. Open the /etc/security/limits.conf file on each computer where you are going to install Data Repository and add the following lines:
```
# Added by Vertica
* soft nofile 65536
# Added by Vertica
* hard nofile 65536
# Added by Vertica
*       soft    fsize   unlimited
# Added by Vertica
*       hard    fsize   unlimited
```
3. Type the following command on each computer where you are going to install Data Repository:
```
service sshd restart
```
  Note: If you do not have restart as an argument, type the following commands to stop and start sshd:
```
service sshd stop
```
```
service sshd start
```
4. To verify that the number of open files is set properly on each computer where you are going to install Data Repository, type the following command:
```
ulimit -n
```
  The command returns the ulimit number that you specified earlier.
5. (Cluster installations only) Log in as the root user or a sudo user. Ssh from one node to another node and confirm that the number of open files is set properly on each computer:
```
ulimit -n
```
  The command returns the ulimit number that you specified earlier.
  
  The user that is installing Data Repository must have a ulimit value of at least 65536. The ulimit value is set permanently. This value remains set, even if the computer where Data Repository is installed is rebooted.
6. If the ulimit value is not set to at least 65536 on any of the hosts, do the following step on that host:
  Open the /etc/security/limits.conf file and add the following lines:
```
# Added by Vertica
* soft nofile 65536
# Added by Vertica
* hard nofile 65536
```
The limit on the number of open files on Data Repository hosts is verified.

More information:

How to Upgrade CA Performance Management Data Aggregator - Command Line