PK42584: V810 COMPATIBILITY MODE CM USING ADMIN ICS LINE COMMAND IMAGE COPY STATUS FOR THE DATABASE GET SQL -416 SQLCODEN416

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When in DB2 V8 compat mode only ( compatibility mode CM ).
  User in Admin Tools in Panel ADB21D (" Databases ") and issues
  Line command ICS - Image Copy Status for a given database, the
  user gets
   error message:
  DSNT408I SQLCODE = -416. Error: An operand of a union contains a
  long string.
  .
  No problems with V8 new function mode or DB2 V7.
  SQL -416 SQLCODEN416 sqlcode416 sqlcode
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: V810 compatibility mode CM using ADMIN  *
  *                      ICS line command image copy status for  *
  *                      the database get SQL -416 SQLCODEN416.  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• The problems have been fixed.
  

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

•    ADB21D
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK29146

     UP07/10/17 P F710

• R720 PSY UK29147

     UP07/10/17 P F710

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.