IBM Support

PM45483: V9 NEW FUNCTION FOLLOW-ON TO PM40117 (PART 2)

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • V9 new function follow-on to PM40117 (part 2).
    IDAAV2R1/K
    ***************************************************************
    Additional Symptoms and Keywords:
    . ABEND04E AB04E S004E 04E
      04E-00D35011 00D35011 RC00D35011 DSNLZGLM DSNLZRCD
      DSNLZRCD:003F 003F ABNDID003F ABID003F VRADC003F
      An application at site1 opens a query to a remote site2
      server system. After all data has been fetched, a +100
      SQLCODE indication is returned by site2. DB2 z/OS at site1
      abends due to a parsing error.
    . Loop WAIT LP SQLCODE100 SQL100P SQL00100P
      An application at site1 opens a query to a remote site2
      server system. After all data has been fetched, a +100
      SQLCODE indication is returned by site2. DB2 z/OS at site1
      does not return the +100 indication back to the application.
      If the application executes SQL Fetch in a loop until a +100
      indication is received, the application may loop
      indefinitely. The problem occurs due to a parsing error.
    . SQLCODE -30020 SQL30020N SQLERRP DSNLXROP 241A (0100)
      DSNL031I MSGDSNL031I 00D3442F RC00D3442F DSNLXROP0079
      An application at site1 opens a query to a remote site2
      server system. The site1 error indicates that (descriptor)
      information returned by site2 for a query at SQL OPEN time
      is different from (descriptor) information returned by
      site2 at SQL PREPARE time, however the condition is valid.
      The condition is known to occur only if this APAR, PM45483,
      change is applied to a remote site2 DB2 z/OS server (which
      may now return the differing information) but the APAR
      change is not also applied to the DB2 z/OS site1 requester
      in order to tolerate the condition. The condition is also
      known to only occur if the remote DB2 z/OS site2 server
      uses accelerator services to satisfy the query. As a result,
      the condition can be solved by applying the APAR to the
      DB2 z/OS site1 requester system or by disabling use of
      accelerator services until the change can be applied to the
      DB2 z/OS site1 requester system. Use of accelerator services
      can be disabled by not utilizing the CURRENT QUERY
      ACCELERATION special register in the application, or via the
      QUERY_ACCELERATION configuration parameter at the remote
      site2 DB2 z/OS server.
    
    04E-00D35011 LOC=DSNLZLLM.DSNLZS00:0062
    00D35011 DSNLZS00 0062
    Abend occurrs during  constructing a DRDA reply for a failed
    OPEN SQLCODE413 -413
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 9 for z/OS who will         *
    *                 be using IDAA (IBM DB2 Analytics             *
    *                 Accelerator) will be affected.               *
    ****************************************************************
    * PROBLEM DESCRIPTION: IDAA support is being added by APARs    *
    *                      PM45482, PM45483, PM50764, and PM51075. *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    IDAA support is being added by APARs PM45482, PM45483, PM50764,
    and PM51075.  These APARs together provide the code in DB2 to
    support the use of IDAA.
    

Problem conclusion

Temporary fix

Comments

  • See the text of APAR PM45482 for more information about the
    IDAA support.
    
    Additional Keywords:
    IDAAV2R1/K
    ž**** AE12/01/20 FIX IN ERROR. SEE APAR PM56492  FOR DESCRIPTION
    ž**** PE12/02/13 PTF IN ERROR. SEE APAR PM56492  FOR DESCRIPTION
    ž**** AE12/02/14 FIX IN ERROR. SEE APAR PM58224  FOR DESCRIPTION
    ž**** PE12/03/27 FIX IN ERROR. SEE APAR PM58224  FOR DESCRIPTION
    ž**** PE12/04/06 FIX IN ERROR. SEE APAR PM61848  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PM45483

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-10

  • Closed date

    2011-11-08

  • Last modified date

    2012-08-13

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK73647

Modules/Macros

  • DSNFMDIR DSNFXDIR DSNLAGNX DSNLBABR DSNLCBFM
    DSNLCCDR DSNLCCNR DSNLCDG1 DSNLCDG2 DSNLCDP1 DSNLCKDS DSNLCLCN
    DSNLCMBE DSNLCMT1 DSNLCRTD DSNLCSRR DSNLDALB DSNLIENO DSNLIRTR
    DSNLSSST DSNLTACC DSNLTCCN DSNLTCM1 DSNLTCN2 DSNLTDSR DSNLTGBK
    DSNLTINT DSNLTRB1 DSNLTRN1 DSNLTSET DSNLTUOW DSNLTXAC DSNLVXID
    DSNLXCMT DSNLXCM2 DSNLXCQH DSNLXCQS DSNLXCQ6 DSNLXCQ7 DSNLXENV
    DSNLXGCS DSNLXGVR DSNLXHCN DSNLXHOC DSNLXHOP DSNLXMRF DSNLXMRS
    DSNLXOQS DSNLXPCA DSNLXPRS DSNLXRAX DSNLXRBF DSNLXRBT DSNLXRCL
    DSNLXRCM DSNLXRCN DSNLXRCX DSNLXRDT DSNLXREL DSNLXRFT DSNLXROP
    DSNLXRQX DSNLXRSL DSNLXRSQ DSNLXRSS DSNLXRUW DSNLXSET DSNLXSR
    DSNLXSRL DSNLXSRP DSNLXSRX DSNLXSSR DSNLXXSS DSNLZERR DSNLZHC0
    DSNLZHC1 DSNLZHP0 DSNLZHR0 DSNLZHR1 DSNLZMON DSNLZOSR DSNLZRCD
    DSNLZRDS DSNLZRPA DSNLZRPY DSNLZRSQ DSNLZRTM DSNLZR00 DSNLZSRD
    DSNLZS00 DSNWAACT DSNXDUTL DSNXECNT DSNXESPP DSNXESSR DSNX8API
    DSNX8CDA DSNX8DRD DSNX8EKG DSNX8SMF DSNX8STA DSNX8STO
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK73647

       UP11/11/24 P F111

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 August 2012