PI71841: PANEL ADB2US OPT 'OO' RETURNS 'NOVALUE CONDITION FOR HASLOBS'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Selecting Option "OO" (Online reorg) in Panel ADB2US may end
  with the following error message:
  
  ****************************************************************
  ***************
  *+
               ;*
  *+
               ;*
  *+ ;Function :+ADB2U , LINE 1724: If (haslobs   = 'YES')  & ,
      /* has LO;*
  *+             B columns             */
               ;*
  *+ ;Retcode  :+8
               ;*
  *+
               ;*
  *+ ;Zerrmsg  :+
               ;*
  *+ ;Zerrsm   :+Novalue condition raised for variable HASLOBS
               ;*
  *+ ;Zerrlm   :+Error executing EXEC - now terminating
               ;*
  *+
               ;*
  *+
               ;*
  *+
               ;*
  ****************************************************************
  ***************
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'UT' line command to        *
  *                 generate an Online REORG.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generating an online REORG results in   *
  *                      a 'Novalue condition raised' error.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When specifying the 'UT' line command and then option 'OO' to
  generate an Online REORG utility on panel ADB2US 'Table Space
  Utilities', the following error is observed:
  
  Novalue condition raised for variable HASLOBS
  

Problem conclusion

• Problem has been 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:

  UI45198 UI45199

Modules/Macros

•    ADB2M1S
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI45198

     UP17/03/07 P F703

• RB20 PSY UI45199

     UP17/03/07 P F703

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.