IBM Support

PI68754: NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • New function
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Distributed Data Facility (DDF) users.                   *
    * DB2 12 for z/OS.                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When performing a bind copy to a                             *
    * remote server from a DB2 for z/OS                            *
    * requester, ABEND04E-00D3442B                                 *
    * LOC=DSNLXGLM.DSNLXRCM:000A may occur.                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When performing a bind copy to a remote server from a DB2 for
    
    z/OS requester, ABEND04E-00D3442B LOC=DSNLXGLM.DSNLXRCM:000A
    
    may occur. DB2 for z/OS requester assumed that statement text
    
    for packages bound with old DBRMs is always in EBCDIC. This
    
    assumption resulted in parsing failure at the requester when
    
    statement text was in UNICODE.
    
    
    
    Following query can help identify packages affected:
    
    SELECT SUBSTR(PS.NAME,1,30), SUBSTR(PS.COLLID,1,30) AS COLLID,
    
    PK.TYPE                                      AS PACKAGE_TYPE,
    
    SUBSTR(PS.VERSION,1,30)                      AS VERSION,
    
    HEX(PS.CONTOKEN)                             AS CONTOKEN,
    
    HEX(SUBSTR(PS.STMTBLOB,43,1))                AS DBRMTYPE,
    
    HEX(SUBSTR(PS.STMTBLOB,1,100))               AS DBRMOPT,
    
    PK.PCTIMESTAMP                               AS PRECOMPTS,
    
    PK.PDSNAME                                   AS DBRMPDS,
    
    PK.BINDTIME                                  AS BINDTS,
    
    PS.SECTNO                                    AS SECTNO
    
    FROM SYSIBM.SYSPACKSTMT  PS, SYSIBM.SYSPACKAGE PK WHERE
    
    PK.NAME   = PS.NAME AND PS.SECTNO = 0    AND
    
    PS.STMTNO = 0       AND PS.SEQNO  = 0    AND
    
    PK.TYPE                           = ' '  AND
    
     VARBINARY(SUBSTR(STMTBLOB,43,1))  <>
    
     VARBINARY(EBCDIC_STR('1'));
    

Problem conclusion

  • Code has been corrected to use statement's CCSID when performing
    
    bind copy to a remote location using packages bound with old
    
    DBRMs.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI68754

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-06

  • Closed date

    2016-10-05

  • Last modified date

    2016-11-02

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

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

    UI41442

Modules/Macros

  • DSNLXRCM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI41442

       UP16/10/21 P F610

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.



Document information

More support for: DB2 for z/OS

Software version: 12.0

Reference #: PI68754

Modified date: 02 November 2016