Fixes are available
APAR status
Closed as program error.
Error description
Environment: windows Product name: IBM? Rational? Business Developer Program Version : 8.5.1 Description. A performance issue is observed when calling functions associated with a data access application when trying to retrieve the value from a BLOB column of an SQLRecord. Steps to reproduce: a) Create a project with the Data Access application wizard targeting an applicable database which generates the associated EGL code artifacts. b) Define with a table which includes a BLOB column. c) Implement a function to retrieve the BLOB value, where typically containing over 1mb of data this will take over 1 minute to return the appropriate value, results.
Local fix
Problem summary
In RBD 8.5.1 and before, retrieve blob/clob column in sql statement is very slow.
Problem conclusion
In RBD 8.5.1.1,9.0 and after, retrieve blob/clob column in sql statement is faster than previous releases.
Temporary fix
Comments
APAR Information
APAR number
PM85554
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-03-26
Closed date
2013-10-28
Last modified date
2013-10-28
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
RATL BUS DEV
Fixed component ID
5724S5000
Applicable component levels
R850 PSY
UP
R900 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
06 January 2022