PH00335: Enhance Db2 for z/OS command line processor (CLP) to accept username/credentials as options when the running a SQL file.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The current CLP on USS only supports the username/credential
  input parameters in interactive mode. When end users or callers
  execute CLP to run a SQL file, the username/credential has to be
  put explicitly in the SQL file, which may cause security leak.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 and 12 for z/OS users who plan                    *
  * to use Db2 command line processor (CLP)                      *
  * to run a SQL file.                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR provides a new function to                         *
  * the Db2 command line processor (CLP)                         *
  * by accepting username and credentials                        *
  * (like RACF PassTicket or password) as                        *
  * options when invoking CLP to run a                           *
  * SQL file.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The current CLP on USS only supports the username/credential
  input parameters in interactive mode. When end users or callers
  execute CLP to run a SQL file, the username/credential has to be
  put explicitly in the SQL file, which may cause security leak.
  

Problem conclusion

• TBA
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI57980 UI57981

Modules/Macros

• DSNCLP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI57980

     UP18/09/05 P F809  

• RB10 PSY UI57981

     UP18/09/05 P F809  

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.