Enabling text search support in Db2 for z/OS

The Db2 for z/OS subsystem installer is typically responsible for enabling and customizing text search support for Db2 for z/OS. You must create the text search user-defined function and administration stored procedures, bind the packages, and populate the configuration tables.

Before you begin

Before you enable text search support, make sure that all of the following requirements are met:

All of the required Db2 PTFs must be applied.
One or more text search servers must be installed and configured.

Procedure

To enable text search support for Db2 for z/OS:

In the Db2 for z/OS installation panel DSNTIPR1, specify YES in the ADVANCED CONFIGURATION OPTIONS field.
In the DSNTIPRA panel, enter option 8 for "IBM® Text Search routines."
In the DSNTIPRJ panel, specify the WLM environment name for the routine, one or more authorization IDs that are to be granted EXECUTE access on the routine, and optionally, the ID that should own the package when it is bound.

Note: If you are migrating from Db2 12 to Db2 13 and had text search support enabled on Db2 12, specify the WLM environments that you used and the authorization IDs that have been granted access to use the text search routines.
Finish running the installation CLIST to customize the Db2 for z/OS installation and migration jobs.
Submit job prefix.NEW.SDSNSAMP(DSNTIJRT) to create the databases and routines for the text search feature.

Example

The following example shows generated output from job prefix.NEW.SDSNSAMP(DSNTIJRT) for text search routines. In this example, the package owner for the routine was not specified.

***********************************************************************
** IBM Text Search routines                                            
***********************************************************************
  SYSPROC.SYSTS_ALTER                                                  
    WLMENV(DSNWLM_GENERAL)                                             
    GRANTTO(PUBLIC)                                                    
                                                                       
  SYSPROC.SYSTS_CREATE                                                 
    WLMENV(DSNWLM_GENERAL)                                             
    GRANTTO(PUBLIC)                                                    
                                                                       
  SYSPROC.SYSTS_DROP                                                   
    WLMENV(DSNWLM_GENERAL)                                             
    GRANTTO(PUBLIC)                                                    
                                                                       
  SYSFUN.SYSTS_ENCRYPT                                                 
    WLMENV(DSNWLM_JAVA)                                                
    GRANTTO(PUBLIC)                                                    
                                                                       
  SYSPROC.SYSTS_RESTORE                                                
    WLMENV(DSNWLM_GENERAL)                                             
    GRANTTO(PUBLIC)                                                    
                                                                       
  SYSPROC.SYSTS_START                                                  
    WLMENV(DSNWLM_GENERAL)                                             
    GRANTTO(PUBLIC)                                                    
                                                                       
  SYSPROC.SYSTS_STOP                                                   
    WLMENV(DSNWLM_GENERAL)                                             
    GRANTTO(PUBLIC)                                                    
                                                                       
  SYSPROC.SYSTS_TAKEOVER                                               
    WLMENV(DSNWLM_GENERAL)                                             
    GRANTTO(PUBLIC)                                                    
                                                                       
  SYSPROC.SYSTS_UPDATE                                                 
    WLMENV(DSNWLM_GENERAL)                                             
    GRANTTO(PUBLIC)

Issue the following VARY MVS command from the console to refresh the WLM environment for the administration stored procedures:

VARY WLM,APPLENV=!wlmenv!,REFRESH

where !wlmenv! is the name of the WLM environment for running the administration stored procedures.

What to do next

Complete the following tasks: