PH50193: SQLCODE = -304, ERROR DEFINING AN ARCHIVE ACTION INVOKING A STORED PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Optim users specifying an Archive Action invoking a stored
  procedure may experience an SQLCODE -304 error upon exiting
  the action definition input area:
  
  DSNT408I SQLCODE = -304, ERROR:  A VALUE WITH DATA TYPE INTEGER
  CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT
  WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION nn WITH DATA
  TYPE SMALLINT
  DSNT418I SQLSTATE   = 22003 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXROHB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -120  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF88'  X'00000000'  X'00000000'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users invoking a DB2 stored procedure via a  *
  *                 call statement within an Archive Action.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Due to an error in internal data        *
  *                      definition, Optim's invocation of a DB2 *
  *                      stored procedure necessitated through   *
  *                      an Archive Action call fails due to an  *
  *                      incorrect length in a host variable.    *
  ****************************************************************
  * RECOMMENDATION: Apply the provided fix.                      *
  ****************************************************************
  The DB2 catalog table SYSROUTINES columns ASUTIME and
  WLM_ENVIRONMENT data types increased in size.  Optim was not
  modified to support this change.
  

Problem conclusion

• Optim's data definitions for the ASUTIME and WLM_ENVIRONMENT
  have been amended to reflect the size changes of these columns.
  

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:

Modules/Macros

• FOP00203 FOP00303 FOP9APIM FOPCFPMN FOPCXLIB FOPD2    FOPD2V61
  FOPD2V71 FOPD2V81 FOPD2V85 FOPD2V91 FOPD2VA5 FOPD2VC5 FOPHSTM
  FOPMADDE FOPMAIN  FOPMARCN FOPMCMAI FOPMCOFN FOPMCOLA FOPMCOLP
  FOPMDDDL FOPMDMAI FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMIXMM
  FOPMMCMR FOPMMJBS FOPMMUNU FOPMMUTL FOPOMN   FOPRS10  FOPTOP76
  FOPTUO45 FOPZFMMN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI90272

     UP23/01/27 P F301

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.