IBM Support

JR28801: SQL0952N ON CLP OR SQL0902 RC="" IN CLI WHILE SELECTING CLOB FROM V8 CLIENT TO V9.5 SERVER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Trying to connect from DB2 V8 client on windows
    to db2 V9.5 server and INTRA_PARALLEL set to on.
    
    when client select a table with CLOB data, then it
    gets an SQL0952N on CLP,or a SQL0902c in CLI, after all rows are
    fetched.
    
    If INTRA_PARALLEL=OFF, then the query works fine on V8
    client and  V9 client and directly on the server (works always
    fine).
    
    If INTRA_PARALLEL=OFF, and an Eventmonitor is active, then he
    can see an SQL0902 in the event monitor logs, but this error is
    never routed to the application (running on V8, V9, or
    directly on the server).
    
    If INTRA_PARALLEL=ON, then the query works fine on V9 client
    and directly on the server, but returns SQL0952N on CLP with
    V8.1 and 8.2 client or SQL0902 RC="" in CLI with V8.1 and 8.2
    Client.
    

Local fix

Problem summary

  • ERROR DESCRIPTION:
    Trying to connect from DB2 V8 client on windows
    to db2 V9.5 server and INTRA_PARALLEL set to on.
    
    when client select a table with CLOB data, then it
    gets an SQL0952N on CLP,or a SQL0902c in CLI, after all rows are
    fetched.
    
    If INTRA_PARALLEL=OFF, then the query works fine on V8
    client and  V9 client and directly on the server (works always
    fine).
    
    If INTRA_PARALLEL=OFF, and an Eventmonitor is active, then he
    can see an SQL0902 in the event monitor logs, but this error is
    never routed to the application (running on V8, V9, or
    directly on the server).
    
    If INTRA_PARALLEL=ON, then the query works fine on V9 client
    and directly on the server, but returns SQL0952N on CLP with
    V8.1 and 8.2 client or SQL0902 RC="" in CLI with V8.1 and 8.2
    Client.
    

Problem conclusion

  • Problem was fixed in DB2 V9.5 FP1
    

Temporary fix

  • Make "INTRA_PARALLEL" OFF.
    

Comments

APAR Information

  • APAR number

    JR28801

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-03-25

  • Closed date

    2008-05-08

  • Last modified date

    2008-05-08

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

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 May 2008