function_level

Use the function_level command to report the spatial functions that are installed on a Db2 subsystem.

Authorization

The user ID under which the command is invoked must have DBADM authority.

Command syntax

DSN5SCLP /function_level SUBSYSTEM -REPORT filename

Parameter descriptions

All parameters are required and case-sensitive unless otherwise indicated.

filename: Identifies the name of the file or data set where the report output will be written. You can specify an absolute file name, or 'D'.
If you specify an absolute file name, the report is written to a text file in z/OS® UNIX System Services. If you specify 'D', the report is written to the data set that is specified for the DD name FUNCLVL.

Examples

Example 1: The following example shows how to specify an absolute file name and have the output of the function_level command written to a text file:

DSN5SCLP /function_level   DALLAS -REPORT   /tmp/functionlevel.txt

Example 2: The following example shows how to have the output of the function_level command written to the data set that is specified for DD name FUNCLVL. First, you must allocate a sequential, fixed-block 80 record format data set. Then, to the job that invokes the DSN5SCLP program, add the DD name FUNCLVL and specify the data set name.

In this example, assume that you allocated data set 'USER.SPATIAL.REPORT' for DD name FUNCLVL:

//FUNCLVL   DD  DSN=USER.SPATIAL.REPORT, DISP=SHR

  Invoke DSN5SCLP with the option REPORT = D

  DSN5SCLP /function_level   DALLAS -REPORT  D

The following output shows a sample of the report:

STOB00088ZMB:    1                     
ST_UNIONAGGR7:   1                     
STCV00055GMV:    1                     
DB2GSE.DSN5SK48: 0                     
DB2GSE.DSN5SK30: 0                     
SDE, TYPE = P:   0                     
SDE, TYPE = F:   0                     
Count DB2GSE:    1244                     
Count SYSPROC:   13                     
                    
LIST ALL DB2GSE FUNCTIONS NAMESSCHEMAS,SPECIFICNAMES AS BELLOW      
NAME                  SCHEMA      SPECIFICNAME                     
--------------------  ----------  ------------------------------    
BLOB                  DB2GSE      BLOB                     
BLOB                  DB2GSE      BLODRMWKFJFPSIF    
...

LIST ALL STORED PROCEDURES NAMESSTART WITH 'ST_'                     
NAME                     
------------------------------------------------------               
ST_ALTER_COORDSYS                     
ST_ALTER_SRS                     
ST_CREATE_COORDSYS                     
ST_CREATE_INDEX                     
ST_CREATE_SRS                    
ST_CREATE_SRS_2                  
ST_DROP_COORDSYS                 
ST_DROP_INDEX                    
ST_DROP_SRS                     
ST_EXPORT_SHAPE                  
ST_IMPORT_SHAPE                  
ST_REGISTER_SPATIAL_COLUMN       
ST_UNREGISTER_SPATIAL_COLUMN