PM63044: DB2 ADMIN TOOL FOR Z/OS GEN or DDL line commands fail with SQL Code -302 when commands used remotely from DB2 V9 to DB2 v10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN or DDL line commands
  issued on panel ADB21O 'Stored Procedures' fails with a SQLCODE
  -302 / SQLCODEN302 when using DDF to access a DB2 for z/OS V10
  CM, ENFM or NFM from DB2 for z/OS V9 NFM
  .
  Additional Symptoms:
  .
   Processing Stored Procedure xxxx
  .
  ADB1649E ADB2REY:  Unexpected sqlcode in : Insert adbgen SP
   DSNT408I SQLCODE = -302, ERROR:  THE VALUE OF INPUT VARIABLE OR
  PARAMETER
            NUMBER 7 IS INVALID OR TOO LARGE FOR THE TARGET COLUMN
  OR THE
            VALUE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use DB2 CONNECT via the line        *
  *                 command 'CO - Connect to remote subsystem'   *
  *                 on panel ADB2DDF 'Distributed DB2 Systems'   *
  *                 to connect to DB2 10 Compatibility Mode      *
  *                 (CM), Enable New Function Mode (ENFM), New   *
  *                 Function Mode (NFM) and Generate (GEN) a     *
  *                 Native Stored Procedure (NSP) or function.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN or DDL line commands issued on      *
  *                      panel ADB21O 'Stored Procedures' fails  *
  *                      with a SQLCODE=-302 / SQLCODEN302       *
  *                      when using DDF to access DB2 10         *
  *                      CM, ENFM or NFM modes from DB2 9        *
  *                      NFM.                                    *
  *                                                              *
  *                      Additional Symptoms:                    *
  *                                                              *
  *                      Processing Stored Procedure             *
  *                      >stored_procedure_name<                 *
  *                                                              *
  *                      ADB1649E ADB2REY:                       *
  *                      Unexpected sqlcode                      *
  *                      in : Insert adbgen SP                   *
  *                                                              *
  *                      DSNT408I SQLCODE = -302,                *
  *                      ERROR:  THE VALUE OF INPUT              *
  *                      VARIABLE OR PARAMETER NUMBER 7 IS       *
  *                      INVALID OR TOO LARGE FOR THE            *
  *                      TARGET COLUMN OR THE TARGET             *
  *                      VALUE.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Using DB2 CONNECT to connect DB2 10 CM, ENFM, NFM mode and GEN
  on a stored procedure or function caused an SQLCODE=-302 /
  SQLCODEN302 error:
  
  DSNT408I SQLCODE = -302,
  ERROR:  THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER 7 IS
  INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET
  VALUE.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK79467

Modules/Macros

•    ADB2REY
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK79467

     UP12/06/13 P F206

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.