FLMCSPDB DB2 Bind/Free translator

Purpose

This is the DB2® Bind/Free translator to be used for binding and freeing DB2 plans. It is necessary to create a DB2 CLIST that will specify the DBRMs to be bound with the DB2 plan, as well as the name of the DB2 plan. An example of these can be found in SCLM support for workstation builds.

Parameters

The following guidelines apply when specifying parameters:

The order of the parameters is not important.
See the language definitions provided by SCLM for the actual usage of the parameters for the translator.

The following keyword parameters are expected as input for the translator:

ALTPROJ: The variable name for the alternate project name. This parameter is required, and must be set to @@FLMALT.
DBRMTYPE: The type name where the DBRMs are stored. This parameter is required.
Note: The FLMDBALC CLIST is run by the FLMCSPDB translator to allocate the DBRM type to the DBRMLIB ddname.
FUNCTN: The SCLM function invoking the translator: BUILD, COPY, or PURGE. This parameter is required.
GROUP: The variable name for the build group name. This parameter is required, and must be set to @@FLMGRP.
MEMBER: The variable name for the DBRM member name. This parameter is required, and must be set to @@FLMMBR.
OPTION: The operation to be performed with the DB2 Plan: BIND or FREE. This parameter is required.
PROJECT: The variable name for the project name. This parameter is required, and must be set to @@FLMPRJ.
SCLMINFO: The variable name for the SCLM internal pointer. This parameter is required, and must be set to @@FLMINF.
TOGROUP: The variable name for the group to promote to. This parameter is required, and must be set to @@FLMTOG. This variable is ignored for FUNCTN=BUILD.

Purpose

Parameters

Return codes