PK95507: SPECIFYING AN INVALID SUBSYSTEM ON EXPORT PANEL HAA$EXPD COULD RESULT IN SQL ERROR MESSAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Specifying an invalid subsystem on EXPORT panel HAA$EXPD could
  result in one of the following SQL Error messages:
  -923, ERROR:  CONNECTION NOT ESTABLISHED: DB2 000C, REASON
  00F30006, TYPE , NAME
  -991, ERROR:  CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT
  CONNECT OR OPEN TO DB2.
  
  Automation Tool then becomes unusable and the user must exit
  Automation Tool and re-enter to be able to continue.
  KEY WORDS
  SQLCODE923 SQLCODE991
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Specifying an invalid subsystem on      *
  *                      EXPORT panel HAA$EXPD could result in   *
  *                      one of the following SQL Error          *
  *                      messages:                               *
  *                      -923, ERROR:  CONNECTION NOT            *
  *                       ESTABLISHED: DB2 000C, REASON          *
  *                       00F30006, TYPE , NAME                  *
  *                      -991, ERROR:  CALL ATTACH WAS UNABLE    *
  *                       TO ESTABLISH AN IMPLICIT               *
  *                       CONNECT OR OPEN TO DB2.                *
  *                      Automation Tool then becomes unusable   *
  *                      and the user must exit Automation Tool  *
  *                      and re-enter to be able to continue.    *
  ****************************************************************
  * 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:

Modules/Macros

• HAA#IOPF
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK51208

     UP09/10/23 P F910

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.