DB2PLAN (FTP cilent and server) statement

Use the DB2PLAN statement to specify the DB2® plan to be used by the FTP server.

Server
This setting applies when FILETYPE=SQL and a GET subcommand is processed.
Client
This setting applies when FILETYPE=SQL and a PUT subcommand is processed.

Syntax

Read syntax diagramSkip visual syntax diagram
   .-DB2PLAN EZAFTPMQ---.   
>>-+--------------------+--------------------------------------><
   '-DB2PLAN--plan_name-'   

Parameters

plan_name
The name of the DB2 plan bound in the DB2 subsystem.

Examples

Set the plan name to FTPPLAN:
DB2PLAN   FTPPLAN

Related topic