IC87911: CLPPLUS DISPLAYS SERVER OUTPUT MESSAGES MULTIPLE TIMES.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This is an issue in CLPPlus where it is not flushing the
    messages after writing it on to the console.
    
    For example, the following code
    ----------
    SQL> set serveroutput on
    SQL> begin
    2 for i in 1..30 loop
    3 dbms_output.put_line('Count '||i);
    4 end loop;
    5 end;
    6 /
    ----------
    
    Gives the following output:
    ----------
    Count 1
    <snip>
    Count 25
    Count 1
    <snip>
    Count 25
    Count 27
    Count 28
    Count 29
    Count 30
    DB250000I: The command completed successfully.
    SQL>
    ----------
    i.e. We see the first 25 lines duplicated.
    
    The reason for this is, CLPPlus fetches server output messages
    in a chunk of 25 at a time. After each fetch CLPPlus is supposed
    to clear the list of messages which are already displayed on the
    screen, but it fails to do so, hence we see the duplicate
    messages on screen after every fetch.
    
    N.B. The above example also shows APAR IC82246: Consecutive
    calls to DBMS_OUTPUT.GET_LINES() skips a line in between each
    call, since CLPPlus depends on DBMS_OUTPUT.GET_LINES procedure
    to retrieve the server output messages from buffer.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * CLPPlus users.                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v10.1 Fixpack 2                               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 v10.1 Fixpack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87911

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-04

  • Closed date

    2012-12-17

  • Last modified date

    2012-12-17

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

    IC82334

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC87911

Modified date:

2012-12-17

Translate my page

Machine Translation

Content navigation