IBM Support

LI73827: ADD ADDITIONAL DETAILS ABOUT LOAD UTILITY OPERATION TO THE LIST-HISTORY ENTRY.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Every time the Load utility is invoked, an entry is added to the
    history file (which is available using the List History
    operation).
    The information contained in this entry only describes a few
    aspects of the Load, and does not give any detailed information
    about  what options the Load executed with.
    
    
    The current output looks like:
    Op Obj Timestamp+Sequence Type Dev Earliest Log     Current Log
    BackupID
     -- --- ------------------              ----   --- ------------
         ------------    --------------
    
      L  T  20081005211209001            I        S0000000.LOG
    S0000000.LOG
     ---------------------------------------------------------------
    -------------
    
      "DSCIARA2"."T1" resides in 1 tablespace(s):
    
      00001 USERSPACE1
     ---------------------------------------------------------------
    -------------
    
        Comment: DB2
     Start Time: 20081005211209
       End Time: 20081005211211
         Status: A
     ---------------------------------------------------------------
    -------------
      EID: 2 Location: /home/dsciaraf/myfile.del
    
    This APAR addresses this lack of information by adding
    additional information 'DDL:' token to the list-history output
    that contains additional information about the Load.
    
     Op Obj Timestamp+Sequence Type Dev Earliest Log   Current Log
    Backup ID
     -- --- ------------------             ----   --- ------------
        ------------   --------------
    
      L  T  20081005211209001       I            S0000000.LOG
    S0000000.LOG
     ---------------------------------------------------------------
    -------------
    
      "DSCIARA2"."T1" resides in 1 tablespace(s):
    
      00001 USERSPACE1
     ---------------------------------------------------------------
    -------------
    
        Comment: DB2
     Start Time: 20081005211209
       End Time: 20081005211211
         Status: A
     ---------------------------------------------------------------
    -------------
      EID: 2 Location: /home/dsciaraf/myfile.del
      DDL: contains additional information about the Load.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * List History command load details                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ADD ADDITIONAL DETAILS ABOUT LOAD UTILITY OPERATION TO       *
    * THELIST-HISTORY ENTRY.Every time the Load utility is         *
    * invoked, an entry is added tothe  history file (which is     *
    * available using the List Historyoperation).The information   *
    * contained in this entry only describes a fewaspects of the   *
    * Load, and does not give any detailedinformationabout what    *
    * options the Load executed with.The current output looks      *
    * like:Op Obj Timestamp+Sequence Type Dev Earliest LogCurrent  *
    * Log   Backup ID-- --- -----------------------------  ----    *
    * ---------------        ------------     --------------L  T   *
    * 20081005211209001         I                                  *
    * S0000000.LOGS0000000.LOG--------------------------------------
    * resides in 1 tablespace(s):00001                             *
    * USERSPACE1----------------------------------------------------
    * DB2Start Time: 20081005211209End Time: 20081005211211Status: *
    * A-------------------------------------------------------------
    * 2 Location: /home/dsciaraf/myfile.delThis APAR addresses     *
    * this lack of information by addingadditional information     *
    * 'DDL:' token to the list-historyoutputthat contains          *
    * additional information about the Load.Op Obj                 *
    * Timestamp+Sequence Type Dev Earliest Log    CurrentLog       *
    * Backup ID-- --- ----------------------------- ----           *
    * ---------------     ------------   --------------L  T        *
    * 20081005211209001        I                                   *
    * S0000000.LOGS0000000.LOG--------------------------------------
    * resides in 1 tablespace(s):00001                             *
    * USERSPACE1----------------------------------------------------
    * DB2Start Time: 20081005211209End Time: 20081005211211Status: *
    * A-------------------------------------------------------------
    * 2 Location: /home/dsciaraf/myfile.delDDL: contains           *
    * additional information about the Load.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.5 FP6                                          *
    ****************************************************************
    

Problem conclusion

  • Added to V9.5 FP6
    Following added to list history output for load
    
     DDL: contains additional information about the Load.
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73827

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-10-07

  • Closed date

    2010-10-19

  • Last modified date

    2010-10-19

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

    LI73826

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

    IC66297 IC66298 IC66597

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

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:
19 October 2010