PH24978: IMS SPUFI JBP HAS SOME CONVERSION FIELD PROBLEMS AND ISSUES UNNECESSARY CHECKPOINT CALL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When issuing SELECT statement using IMS SPUFI JBP to an IMS
  database, there are the following problems:
  - If IMS database segment contains decimal field and its data
    does not match the DBD FIELD definition it shows blank(s). It
    is different from the result of IMS Explorer.
  - If IMS database segment contains fields which use internal
    converter or external converter and the converted data
    exceeds the original field size, whole data is not displayed.
  - Unnecessary checkpoint call is issued even though the IMS
    database is not changed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM IMS Administration Tool for     *
  *                 z/OS (FMID=HALC110) who use IMS SPUFI        *
  *                 function in the SQL language JBP             *
  *                 environment.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: IMS SPUFI JBP has some conversion field *
  *                      problems and issues unnecessary         *
  *                      checkpoint call.                        *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  When issuing SELECT statement using IMS SPUFI JBP to an IMS
  database, there are the following problems:
   - Unnecessary checkpoint call is issued even though the IMS
     database is not changed.
   - If IMS database segment contains a decimal field and its data
     is not match to the DBD FIELD definition, it shows blank.
   - If IMS database segment contains fields which use internal
     converter or external converter and the converted data
     exceeds the original field size, whole data is not displayed.
  

Problem conclusion

• IMS SPUFI JBP has been fixed as follows:
   - Unnecessary checkpoint call is no longer issued.
   - When showing unmatched data to a decimal field, it shows
     "NULL" as its data to notice unmatched data is stored.
     Also, a new message ATYJ214W is issued.
   - When showing fields which use internal converter or external
     converter, whole data is displayed as the result of the query
     even if the converted data exceeds the original field size.
  
  If you run IMS SPUFI using COBOL, apply the PTF of APAR PH24458.
  
  ========================
  = DOCUMENTATION CHANGE =
  ========================
  The documentation "IBM IMS Administration Tool for z/OS
  V1R1, User's Guide (SC27-9011-03)" is changed to add a new
  message.
  
  Troubleshooting > Messages and codes > Messages (ATYA - ATYZ)
  
  ATYJ214W DATA CONVERSION FAILED IN 1 OR MORE COLUMNS
  
  Explanation
  
  Failed to convert some portions of data using the converter that
  is defined to the DBD. The data conversion failed in one or more
  columns due to inconsistency between the type definition and
  data format. This data is in the records obtained by running a
  SELECT statement.
  
  System action
  
  Processing continues. The result of the SQL statement is stored
  in the IMS SPUFI output. The failed data is stored as "NULL".
  
  User response
  
  To identify the failed data, select COBOL for the language
  environment and rerun the SELECT statement. When COBOL is
  selected, the original data in the database is displayed in
  hexadecimal format. Use the hexadecimal data to identify the
  failed data. After you identify the failed data, ensure that the
  data is correct - if not, modify the data so that the type
  definition and data format match.
  

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:

  UI69493

Modules/Macros

• ATYJLIB
  

Fix information

• Fixed component name

  IMS ADMIN TOOL

• Fixed component ID

  5655CAT00

Applicable component levels

• R110 PSY UI69493

     UP20/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.