PH56640: SELECT COUNT WITH DESCRIPTOR FIELD GENERATES SEVERAL ADABAS COMMANDS L2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When executing a query statement in an Adabas virtual table,
  for example:
  SELECT COUNT(NU_ID_FUNC) FROM DVSQL.T006900;
  Even if the field that's referenced in clause COUNT is a
  descriptor, behind the scenes the Adabas commands are doing
  several L2 (physical reads)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH56640                                 *
  *                      SELECT COUNT with descriptor field      *
  *                      generates several Adabas commands L2    *
  ****************************************************************
  PH56640
  SELECT COUNT with descriptor field generates several
  Adabas commands L2
  

Problem conclusion

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

• AVZCPRCL AVZCSQOP AVZCTSOP AVZCTVOP AVZOADTP AVZOBRSR AVZOBRTV
  AVZODMWR AVZOHOPA AVZOPPA  AVZPB    AVZSQ29D AVZSQ29N AVZSQ2BN
  AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLBN AVZSQLCN AVZSQLDN
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI94122

     UP23/10/25 P F310

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.