Fixes are available
APAR status
Closed as program error.
Error description
Product name: IBM? Rational? Business Developer Program Version : 7.5.1.6 Description. SQL nullable indicators are erroneously being generated for the WHERE clause when generating on VSE systems after migrating from EGL v6 to RBD v7.5.x. Setting the isSQLNullable property to yes causes the WHERE clauses to also have the indicator variables added and causes performance issues with data access not seen in RBD v6. The same program generated to COBOL on the VSE with RBD 7.5.1.6 creates up to a 1 minute waiting time when data is retrieved from the DB2 tables which in V6 was almost instant.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * **************************************************************** The nullable indicator was being generating on the SQL where clause for VSE systems, when the user specified that sqlnullable = yes. It should have been ignored. This causes a performance hit to VSE sql systems.
Problem conclusion
The software now ignores the nullable indicator for variables in the where clause.
Temporary fix
Comments
APAR Information
APAR number
PM41798
Reported component name
RBD EGL FOR COB
Reported component ID
5724S5001
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-06-16
Closed date
2012-03-15
Last modified date
2012-03-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
RBD EGL FOR COB
Fixed component ID
5724S5001
Applicable component levels
R751 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
27 October 2021