PH47521: EACH LINE CONTAINS X'0D' CR (CARRIAGE RETURN) AT THE END OF LINE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• THE STEP 5 (Create the required UDFs in?Db2 for z/OS) OF TOPIC
  "Installing and configuring SQL Tuning Services" FAILED DUE TO
  END OF LINE CONTAINS x'0D' CR (Carriage Return) AFTER CONVERT
  VIA ICONV.
  PROBLEM FILE AFTER INCONV:
  //*  Name = TMSCRUDF.
  66544D898474EDECDECC0
  11C0051450E034239446D
                      *  <- End of line has x'0D'
  

Local fix

• Remove code x'0D' and use the output file
  Commnad:
    tr -d "¥r" < ./TMSCRUDF.ICONV > TMSCRUDF.ICONV.output
  
  Note: -d ¥r ( backslash + r ) indicate the remove x'0D'
  (Carriage Return) from input file TMSCRUDF.ICONV
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * The sample JCL contains                                      *
  * carridge return, which makes job fail                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The sample JCL contains                                      *
  * carridge return, which makes job fail                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The sample JCL contains
  carridge return, which makes job fail
  

Problem conclusion

• Remove carridge return from all
  sample jobs
  

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:

  UI81582

Modules/Macros

• DSN5DTMS DSN5INSH
  

Fix information

• Fixed component name

  SQL TUNING SERV

• Fixed component ID

  5655R1406

Applicable component levels

• R110 PSY UI81582

     UP22/07/22 P F207

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.