PM03472: SQL PERFORMANCE ANALYZER TABLESPACE FAILED WITH ISPS108

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When ALTER Table spaces used by SQL Performance Analyzer, the
  job is failed with:
  
  Function : ADB21SAJ, LINE 581: FTCLOSE NAME(ADBTS10RL)
  Retcode : 20 *
  Zerrmsg : ISPS108
  Zerrsm : Invalid length
  Zerrlm : Parameter 'NAME' exceeds the allowable length.
  

Local fix

• No Work Around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 using RDEF Table space.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Dialog error "ISPS108 - Parameter       *
  *                      'NAME' exceeds the allowable length" is *
  *                      produced under the following            *
  *                      conditions:                             *
  *                      Panel ADB21SAJ is setup with            *
  *                      1. "Combine job steps"=NO               *
  *                      2. "Unload Method"=H                    *
  *                      3. "Member name or prefix"=ADBTS        *
  *                          is (5 chars)                        *
  *                      4. Number of tables being processed     *
  *                         is greater than 9.                   *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Dialog error "ISPS108 - Parameter 'NAME' exceeds the allowable
  length" is produced under the following conditions:
  
  Panel ADB21SAJ is setup with
  1. "Combine job steps"=NO
  2. "Unload Method"=H
  3. "Member name or prefix"=ADBTS (5 chars)
  4. Number of tables being processed is greater than 9.
  

Problem conclusion

• Incident is now 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:

Modules/Macros

•    ADB21SAJ ADB21SAR ADB55
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK53736

     UP10/01/28 P F001

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.