PH00879: PROVIDING THE ABILITY TO OVERRIDE THE DSN WHEN SPLITTING THE LOADFILES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When splitting the generated LOADFILES within DB2 Log Analysis
  Tool, the generated DSN contain the DB2 IDs of the table.
  These IDs most likely will be different in the development/test
  environment than the production environment. This makes it
  difficult to promote the JCL for executing Log Analysis Tool
  from the development/test environment to the product environment
  as the DSN will change. This APAR will provide a mapping table
  to map the DSN to the Table Names so the DSN can stay consistent
  between the different environments used.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ALA 350.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When splitting the generated LOADFILES  *
  *                      within DB2 Log Analysis                 *
  *                      Tool, the generated DSN contain the DB2 *
  *                      IDs of the table.                       *
  *                      These IDs most likely will be different *
  *                      in the development/test                 *
  *                      environment than the production         *
  *                      environment. This makes it              *
  *                      difficult to promote the JCL for        *
  *                      executing Log Analysis Tool             *
  *                      from the development/test environment   *
  *                      to the product environment              *
  *                      as the DSN will change. This APAR will  *
  *                      provide a mapping table                 *
  *                      to map the DSN to the Table Names so th *
  *                      DSN can stay consistent                 *
  *                      between the different environments used *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF
  

APAR Information

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

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

  UI59022

Modules/Macros

•    ALAAA5   ALAAA5G  ALAA72   ALAA73   ALABSQL
  ALAFA    ALAFRA   ALAFRPAT ALAFRPER ALAFRPEX ALAFRPMD ALAFRPMN
  ALAFRPNW ALAFRPOP ALAFRQGL ALAFRQGR ALAFRQGS ALAFRQIV ALAFRQUS
  ALAFRTV  ALAFRTVV ALAFR1   ALAFR1A  ALAFR1AV ALAFR1C  ALAFR1CS
  ALAFR1CV ALAFR1D  ALAFR1F  ALAFR1G  ALAFR1GV ALAFR1I  ALAFR1IV
  ALAFR1L  ALAFR1LS ALAFR1LT ALAFR1LV ALAFR1M  ALAFR1MA ALAFR1MP
  ALAFR1MV ALAFR1PV ALAFR1Q  ALAFR1QV ALAFR1V  ALAFR1X  ALAFR1XV
  ALAFR12  ALAFR2   ALAFR2M  ALAFR2V  ALAFR3   ALAFR6   ALAFR6A
  ALAFR6D  ALAFR6I  ALAFR6PR ALAFR6SN ALAFR6T  ALAFR6TV ALAFR6X
  ALAFR64  ALAFR8A  ALAFR8B  ALAFR9   ALAGEN1  ALAGLCS  ALAGLOAD
  ALAGLOAT ALAGLS   ALAGLSUM ALAGL2   ALAGL3   ALAGL4   ALAIF
  ALAINAX  ALAINC   ALAINCX  ALAIN4X  ALAIN4XR ALAIN5   ALAIN5D
  ALAIN5DX ALAIN5X  ALAISPMN ALALAUD  ALALDEL  ALALF1   ALASQL0
  ALASQL1  ALASQL1C ALASQL2  ALAZH941 ALAZT040 H237350J
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI59022

     UP18/10/17 P F810

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.