551: Transfer aborted: SQL not available. Attempt to open plan plan_name failed (code)

Explanation

FTP attempted to process a SQL request, but was unable to open FTP's DB2® subsystem plan named plan_name

System action

No data is sent. FTP continues.

User response

If FTP SQL support should be available, contact your system programmer for FTP. If a SQL query was not intended, issue 'SITE filetype=' command to change the filetype from 'SQL' to 'SEQ' or 'JES' before the next FTP retrieve command.

System programmer response

Ensure that a BIND was done for plan plan name and that execute authorization was granted for the plan.

Note: If you used a plan name other than EZAFTPMQ for the EZAFTPMQ DBRM, your FTP.DATA file must contain a DB2PLAN statement to specify the plan name that the FTP server is to use. See DB2 Messages and Codes for a detailed explanation of code.
Parent topic: 551 reply codes