PI69583: SQ1BPKG PTFS FOR THE CURRENT QUERY ACCELERATION AND CURRENT GET_ACCEL_ARCHIVE SPECIAL REGISTERS NOT INSTALLED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSQ1BPKG abends with the following unexpected message.
  
  THE PTFS FOR THE CURRENT QUERY ACCELERATION AND CURRENT
  GET_ACCEL_ARCHIVE SPECIAL REGISTERS WERE NOT INSTALLED
  
  If you get a trace of DSQ1BPKG, you will see a SQLCODE -204 like
  the following:
  
     SQLCODE:   -204  SQLSTATE: 42704  SQLWARN(0..A): >
     SQLERRD (1):        -500 (2):           0 (3):
     SQLERRD (4):          -1 (5):           0 (6):
     SQLERRP: >DSNXOTL <  SQLERRM TOKENS: >Q.DSQ_RESERVED<
  
  To create the trace, EDIT SDSQEXCE(DSQ1BPKB) and change:
     TRACEP=''
  to
     TRACEP='-T'
  Then rerun the failing DSQ1BPKG using the modified DSQ1BPKB
  part.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V11.2 users installing  *
  *                 to servers accessed by three part names      *
  *                 only.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running QMF1120.SDSQSAPE(DSQ1BPKG) *
  *                      to a server accessed by three part name *
  *                      only, users may receive a RC8 on the    *
  *                      job due to error:                       *
  *                                                              *
  *                      DSQ1DEFS VARIABLE T3PARTNM IS YES       *
  *                      BINDING 3 PART NAME ONLY LIST OF        *
  *                      PACKAGES.                               *
  *                                                              *
  *                      THE PTFS FOR THE CURRENT QUERY          *
  *                      ACCELERATION AND                        *
  *                      CURRENT GET_ACCEL_ARCHIVE SPECIAL       *
  *                      REGISTERS WERE NOT INSTALLED.           *
  *                                                              *
  *                      PROCESSING TERMINATED....               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The QMF installation utility program, DSQ0BTDC, was erroneously
  using the Q.DSQ_RESERVED table to determine the existence of the
  CURRENT QUERY ACCELERATION and CURRENT GET_ACCEL_ARCHIVE
  special registers. Because this table will never exist at a
  server that is being used by QMF for three part name access,
  the program was unable to validate the registers and would
  always report them as not existing.
  

Problem conclusion

• The installation logic in QMF1120.SDSQEXCE(DSQ1BPKB) has been
  altered to bypass checking for the DB2 special registers. The
  special registers exist in DB2 11 and higher. The DB2 PTFs
  for these special registers in DB2 9 and DB2 10 are years old
  now. It is reasonable to bypass this checking.
  

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:

  UI41311 010PC2Ÿ 010PC2Ÿ

Modules/Macros

•    DSQ1BPKB
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB20 PSY UI41311

     UP16/10/01 P F609

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.