KBA00021081

You can increase the record limit on Flex searches from the default of 999 to a larger number by following the instructions on this article.

You can accomplish this task by adding to the Flex Script, or by creating a custom environment.
How to accomplish this in the Flex Script (it is important that you create a backup of the Spillman Script before modifying it):

• If you are comfortable with the command line and using a Linux/UNIX text editor you can use this step. Otherwise, you will want to setup a custom environment described in the next section.
• If using Linux/UNIX you will need to open a session to your server by typing sh on the Flex command line, or by using Putty

Once you have an open session you will need to enter the Flex environment by typing: spillman -s

• Navigate to the Flex script. It is normally located in /usr/local/bin/spillman
• You can also type which spillman and the path to the script will be output to the screen
  
  
  
  NOTE: ALWAYS make a backup when working with the spillman script. If something gets entered in wrong or inadvertently removed, you could cause an issue for users when they try to login. Use the below command to make a copy - just replace what is in < > with current info.
  
  $ sudo cp /usr/local/bin/spillman /usr/local/bin/spillman.bak.<date>

• Now that you are in the proper directory type: vim spillman
• With the Spillman script open you will need to modify it by adding the following variable:
  RECORDLIMIT=100000
  export RECORDLIMIT
• The preceding will increase the record limit to 100,000 records. You can substitute the 100,000 with any number, however, it would be a better idea to narrow down your search criteria instead of increasing the record limit
• Once this is saved in the script you will need to log out of Flex for it to take effect

Setting up a custom environment

• The variables in the Spillman Script will apply to all users in the system. Setting up a custom environment will allow you to set a record limit for certain groups or users and not the entire system
  This method can be used on Windows, UNIX, and Linux
• First, navigate to the apenvnam table and add the RECORDLIMIT variable
  
  
   
• Next, navigate to the apenvval table and add the value Description Set RECORDLIMIT
• In the Value field you will enter the record limit
  
  
   
• Next, navigate to the apenvcfg table. The code can be called whatever you desire. Then go to the Environment Variables field and click the lookup arrow to select the variable that was setup in the apenvnam table
• It should be similar to the following:
  
  
   
• Next, navigate to the apcfgtyp table. Here you will specify a Configuration Type Code. This code can be called whatever you desire
• You will use the following:
  
  
  

The final step will be in the syenv table. This is where all of the previously entered information will converge:

• In this table you will also specify who this custom variable applies to
• This is similar to a sypriv, you specify whether this variable applies to a user, a group, or the world (all users). You then enter the user ID, group ID, or a 0 for world
• In the Configuration Type field you will use the Configuration Type that you specified in the apcfgtyp table
• In the Prompt User(s) on Login field you should select N
• You will then choose the Configuration Values that you specified in the apenvcfg table
• These entries should also be similar to the following:
  
  
   
• Users must log out and back in for the change to take effect