PK88142: SQLCODE -991 ON EXPORT OR UPDATE OF ANY PROFILE (OBJECT, UTILITYOR JOB PROFILE)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following issues are resolved on export of any profile:
  a) On exporting any profile (Object, Utility, or Job Profile),
  if an invalid 'EXPORT SSID' is keyed into this field and F3 out
  of the export panel, and now trying to Update or Export the
  profile again would cause the ISPF panel to fail on Pgm:
  GGC#IOPF with a SQLCODE -991
  *
  b)  On exporting any profile (Object, Utility, or Job Profile),
  if 'Export to Data Set' and 'Create Export Data Set' is set to
  'Y' and if the 'Dataset Name' given already exist we get a
  GGCM185E message. Now if we change the dataset name to a dataset
  that does not exist this would cause the ISPF panel to fail with
  message 'Data truncation occurred  Data for CHAR format variable
  "XDATASET" was too long'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Change Accumulation Tool.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following issues are resolved on    *
  *                      export of any profile:                  *
  *                      a. On exporting any profile (Object,    *
  *                      Utility, or Job Profile), if an         *
  *                      invalid 'EXPORT SSID' is keyed into     *
  *                      this field and F3 out of the export     *
  *                      panel, and now trying to Update or      *
  *                      Export the profile again would cause    *
  *                      the ISPF panel to fail on Pgm:          *
  *                      GGC#IOPF with a SQLCODE -991            *
  *                      b.  On exporting any profile (Object,   *
  *                      Utility, or Job Profile), if 'Export    *
  *                      to Data Set' and 'Create Export Data    *
  *                      Set' is set to 'Y' and if the           *
  *                      'Dataset Name' given already exist we   *
  *                      get a GGCM185E message. Now if we       *
  *                      change the dataset name to a dataset    *
  *                      that does not exist this would cause    *
  *                      the ISPF panel to fail with message     *
  *                      'Data truncation occurred  Data for     *
  *                      CHAR format variable "XDATASET" was     *
  *                      too long'                               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK50035

Modules/Macros

•    GGC$BUTR GGC$EXPD GGC$EXPF GGC$JPRD GGC$JPRU
  GGC$OPRC GGC$OPRD GGC#IOPF GGC#JPRI
  

Fix information

• Fixed component name

  DB2 CHANGE ACCU

• Fixed component ID

  5655F5500

Applicable component levels

• R210 PSY UK50035

     UP09/09/17 P F909

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.