PM18507: ADB2INC NOT FOUND WHEN CURRENT SQLID DIFFERENT THAN USERID %ADB2INC GIVES RC OF 20. FFA10 GA PRODUCT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using DB2 Administration Tool for z/OS and ADB2CUST
  options are as follows:
  DB2 security exit type               ==> AUTH
  (STD,SAMPLE,AUTH,NOCALL,OWN)
  .
  :aopt.I
  :adescr.- DB2I   DB2 Interactive
  :aispf.SELECT CMD(%DSNECPRI SSID(&DB2SYS)) NEWAPPL(DSNE) PAS
  SLIB
  :anewat.YES
  .
  Using current SQLID different from USERID can result in
  message error:
  %ADB2INC                GIVES RC OF                         20
   PG=%ADB2INCP11=        0P13=00000001P14=00000101
   P2=%ADB2INC
   P3=00000008 P4=FFFFFFFF P5=00000028 P6=FFFFFFFF
  P71=FFFFFFFFP72=FFFFFFFFP73=FFFFFFFFP74=FFFFFFFF
  %ADB2INC                GIVES RC OF                         20
  RETURN CODE 20 FROM TSO-LINK,REASON CODE(DEC):   40
  -COMMAND NOT FOUND
  .
  Then panel ADB2DID's message:
  ADB2DID n ----------------- SQL Authorization ID Warning
  .
  You are about to enter a new DB2 function. Be aware that your
  current SQL ID  will be changed.
  .
  SQL ID now                 : ADMF001
  .
  SQL ID in the new function : SYSADM
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration for z/OS who     *
  *                 change SQLID and use AUTH in ADB2CUST        *
  *                 customization.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      When using DB2 Administration Tool for  *
  *                      z/OS and ADB2CUST options are as        *
  *                      follows:                                *
  *                                                              *
  *                      DB2 security exit type  ==> AUTH        *
  *                      (STD,SAMPLE,AUTH,NOCALL,OWN)            *
  *                      .                                       *
  *                      :aopt.I                                 *
  *                      :adescr.- DB2I   DB2 Interactive        *
  *                      :aispf.SELECT CMD(%DSNECPRI SSID(&DB2SY *
  *                       NEWAPPL(DSNE) PASSLIB                  *
  *                      :anewat.YES                             *
  *                      .                                       *
  *                      Using current SQLID different from      *
  *                      USERID can result in message error:     *
  *                                                              *
  *                      %ADB2INC   GIVES RC OF              20  *
  *                      PG=%ADB2INC P11=        0 P13=00000001  *
  *                      P14=00000101 P2=%ADB2INC  P3=00000008   *
  *                      P4 =FFFFFFFF  P5=00000028  P6=FFFFFFFF  *
  *                      P71=FFFFFFFFP 72=FFFFFFFF P73=FFFFFFFF  *
  *                      P74=FFFFFFFF                            *
  *                      %ADB2INC GIVES RC OF                20  *
  *                                                              *
  *                      RETURN CODE 20 FROM TSO-LINK,REASON     *
  *                      CODE(DEC):   40  -COMMAND NOT FOUND     *
  *                      .                                       *
  *                      Then panel ADB2DID's message:           *
  *                      ADB2DID n ----------------- SQL         *
  *                      Authorization ID Warning                *
  *                      .                                       *
  *                      You are about to enter a new DB2        *
  *                      function. Be aware that your            *
  *                      current SQL ID  will be changed.        *
  *                      .                                       *
  *                      SQL ID now                 : ADMF001    *
  *                      .                                       *
  *                      SQL ID in the new function : SYSADM     *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Changing the SQLID results in an error:
  rc20 and reason code 40.
  

Problem conclusion

• The problem has been fixed in module ADB2DID.
  

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:

  UK61711

Modules/Macros

•    ADB2DID
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK61711

     UP10/11/02 P F011

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.