PH36590: WHEN USING -F PARAMETER WITH ARSODF, AN INVALID BUNDLE QUERY CAUSES ARSODF TO END UNEXPECTEDLY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using the ?f option will ensure that the selection criteria
  specified in the SQL statement of the report bundle definition
  is found in the available report before creating the report
  bundle processing request.
  
  However, If an ODF bundle with
  Report Build=Query has an invalid DB2 query that causes a DB2
  error, then the ARSODF STC will end.
  
  For example, if the
  bundle query is
  
  WHERE INDEX01 = '11'
  
  but INDEX01 does not
  exist in the application group associated with the bundle then
  the following errors maybe seen in ARSODF STC output:
  
  ARS0013E
  DB Error: {DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=HY010
  ERRLOC=7:33:4 -- SQLSTATE=HY010, SQLCODE=-99999,
  File=arsodfdb.c,
  Line=6859
  ARS1107E An error occurred.
  Contact your system administrator and/or consult the System
  Log. File=SYS20343.T122202.RA000.ARGODF.SR
  CCMS.H01(ARGODF),
  Line=3796
  ARS7950E Unexpected fatal error encountered,
  function is DISTRIBUTION, return code is 6.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All ODF 10.1 and above users.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: ODF is shutting down when the -f        *
  *                      parameter is used and an invalid sql    *
  *                      statement is specified in the report    *
  *                      bundle definition.                      *
  ****************************************************************
  ODF is issuing a commit during the sql precheck processing and
  losing its cursor position causing an sql error that terminates
  ODF.
  

Problem conclusion

• ODF is modified to not issue the commit and maintain the
  correct cursor position.
  

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:

  UI76412 UI76415

Modules/Macros

• ARGODFDB ARGSYS   ARNODFDB ARNSYS
  

Fix information

• Fixed component name

  CM OD Z/OS, OD/

• Fixed component ID

  5655H3900

Applicable component levels

• RA10 PSY UI76412

     UP21/07/27 P F107

• RA50 PSY UI76415

     UP21/07/27 P F107

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.