JR54067: PROVISION TO DISPLAY 'COPY' COMMAND SENT TO DB2API VIA DB2 CONNECTOR

IBM InfoSphere Information Server, Version 11.5.0.1 (Fix Pack 1)

APAR status

• Closed as program error.

Error description

• DB2Connector upon realizing the load method as Named Pipe(s),
  creates a load structure and invoke db2Load API with this
  structure. When we set the property Non-Recoverable Load = YES,
  we set the value of iNonrecoverable in db2LoadIn structure to
  SQLU_NON_RECOVERABLE_LOAD;and set the value of piCopyTargetList
  in db2Load structure to NULL. Thereby invoking a NON-Recoverable
   Load only.
  
  Adding an environment variable, which when set, would write
  extra messages to the log during the Non-Recoverable load
  operation. This helps in better capture of information.
  

Local fix

Problem summary

• Provision to display 'COPY' command sent to DB2API via
  DB2Connector
  

Problem conclusion

• DB2Connector upon realizing the load method as Named Pipe(s),
  creates a load
    structure and invoke db2Load API with this structure. When we
  set the
    property Non-Recoverable Load = YES, we set the value of
  iNonrecoverable in
    db2LoadIn structure to SQLU_NON_RECOVERABLE_LOAD;and set the
  value of
    piCopyTargetList in db2Load structure to NULL. Thereby
  invoking a
    NON-Recoverable Load only.
  
  A new environment variable "CC_DB2_DISPLAY_RECOVERABLE_MODE" has
   been added, which
    when set will add additional messages to the Director log.
  
    The messages that will be added based on the selection of
  Non-Recoverable Load and
    No Copy parameters are as follows:
    iNonRecoverable is set to SQLU_NON_RECOVERABLE_LOAD and
  CopyTargetList is NULL.
    iNonRecoverable is set to SQLU_RECOVERABLE_LOAD and
  CopyTargetList is NULL.
    iNonRecoverable is set to SQLU_RECOVERABLE_LOAD and
  CopyTargetList is not NULL.
  

Temporary fix

Comments

APAR Information

• 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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R850 PSY

     UP

• R870 PSY

     UP

• R910 PSY

     UP

• R912 PSY

     UP

• RB30 PSY

     UP

• RB31 PSY

     UP