PK62536: DB2 VERSION 9 RUN UNDER SUPPORT FOR BTS V3R1

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR enables BTS V3R1 to run on DB2 Version 9(5635-DB2).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: BTS V3 USERS WITH DB2 V9                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR enables BTS V3R1 to run       *
  *                      with DB2 V9                             *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  This APAR enables BTS to run with DB2 V9.
  

Problem conclusion

Temporary fix

Comments

• The IMS BTS User's Guide and Reference ( SC18-7149-01 )
  will be updated with following changes:
  
  << 4.2.4 ./O Command >>
  
    < Add on YES of ./O SQLHX= >
    < Add on YES of ./O TSOSQLHX= >
  
  When the data is defined as variable length, the length(LL), of
  the data is included in the BTSOUT hex representation.
  
  
    < Change ./O SQLOBLN= >
  
  The length of LOB data type is always 0.
  Specifies the length of output data that is of LOB data type
  (large objects data type) that the customer would like to put
  on the BTSOUT or the TSO terminal display even if the LEN=
  operand on BTSOUT is 0.
  If this parameter is not specified, the output data of LOB data
  type is not put on the BTSOUT or the TSO terminal display.
  
  
  << 8.1.2.13 4085 >>
  
    < change >
  4085
  
  Explanation: Either a nonzero return code was returned from the
  DB2 message formatting routine, or a nonzero return code was
  returned when loading the DB2 message formatting routine
  DSNTIAR.
  System Action: BTS ends abnormally.
  
  User Response: Check the message BTS0131E or BTS0132E.  The
  return code from the DB2 message formatting routine is set to
  Register 15.  For details refer to
  
  - DB2 UDB for z/OS Application Programming and SQL Guide
  
  
  
  << 8.2.2 BTS messages >>
  
    < add >
  
  BTS0131E DSNTIAR FAILED. RC=xx
  
  Explanation: The DB2 message formatting routine (DSNTIAR)
  returned return code xx.
  System Action: After issuing this message, BTS ends with an
  abend code of U4085.
  User Response: The return code from the DB2 message formatting
  routine is set to Register 15. For details refer to
  
  - DB2 for z/OS  Application Programming and SQL Guide
  
  
  BTS0132E LOAD FAILED FOR DSNTIAR.
  
  Explanation: An error occurred in loading DSNTIAR.
  System Action: After issuing this message, BTS ends with an
  abend code of U4085.
  User response: Correct the JCL stream by specifying DB2
  SDSNLOAD library in the JOBLOB or STEPLIB.
  
  
  << C.2 DB2 SQL call trace >>
  
  < change the last section >
  
  - If customer using the LOB (large objects) data type specifies
    ./O SQLOBLN=, the BTS puts the LOB data type and the length as
    follows on the BTSOUT or the TSO terminal display.
      - If the ./O SQLOBLN=nn is specified
         - LEN= shows 0.
         - DATA= shows 'nn' size.
  

APAR Information

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

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

  UK35046

Modules/Macros

•    BTSDI    BTSMWRT0 BTSNPWRT BTSSHEX0 BTSSINT0
  BTSSINT1 BTSSQLTB BTSSVAR0 BTSTSON0 H22J310J
  

Fix information

• Fixed component name

  IMS BTS

• Fixed component ID

  5655A1400

Applicable component levels

• R310 PSY UK35046

     UP08/03/29 P F803

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.