PM13408: ABEND S0C6 IN RECTRACE FILE WHEN IFCID 63 CONTAINS SQL STATEMENT LONGER THAN 2K

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Abend S0C6 occurs when executing RECTRACE FILE report against
  input data (i.e. IFCID 63 records) containing long SQLs (larger
  than 2K)
  
   SYSTEM COMPLETION CODE=0C6  REASON CODE=00000006
    TIME=11.53.02  SEQ=22781  CPU=0000  ASID=00A8
    PSW AT TIME OF ERROR  078D2000   81010103  ILC 2  INTC 06
      NO ACTIVE MODULE FOUND
      NAME=UNKNOWN
      DATA AT PSW  010100FD - 94509080  EC58C080  E49140C0
      AR/GR 0: A1351F16/00000780   1: 00000000/00000001
            2: 00000000/00000780   3: 00000000/22ECF2E0
            4: 00000000/000549C0   5: 00000000/00007778
            6: 00000000/00007558   7: 00000000/00000001
            8: 00000000/00054C40   9: 00000000/00053C41
            A: 00000000/00052C42   B: 00000000/00051C43
            C: 00000000/80050C44   D: 00000000/00053ED8
            E: 00000000/800510A8   F: 01000002/01010101
    END OF SYMPTOM DUMP
  
  ...
  
   ICE185A 0 AN S0C6  ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM
  OR AN EXIT (PHASE S 3)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: For very long statements (> 2K) the     *
  *                      FILE subcommand for BATCH RECTRACE      *
  *                      fails with 0C6 due to insufficient      *
  *                      memory allocation (for IFCID 63).       *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  PROBLEM SUMMARY: Batch RECTRACE FILE command fails with 0C6 for
  IFCID 63.
  
  PROBLEM CONCLUSION:
  Assure that the maximum length of an SQL statement
  text (5000 chars) can be handled in BATCH RECORD
  TRACE FILE.
  

Problem conclusion

• Assure that the maximum length of an SQL statement
  text (5000 chars) can be handled in BATCH RECORD
  TRACE FILE.
  
  KEYWORDS : BATCH RECTRACE FILE IFCID63
  

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:

  UK56622

Modules/Macros

• DGONFILE
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R420 PSY UK56622

     UP10/05/15 P F005

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.