PM46206: SDO REPOSITORY PERFORMANCE ENHANCEMENT.

Fixes are available

APAR status

Closed as program error.

Error description

The SDO Repository application uses the findAllKeys(method-name)
for ejb-ql queries, which is taking a long time to complete.

Local fix

```
N/A
```

Problem summary

****************************************************************
* USERS AFFECTED:  All users of IBM WebSphere Application      *
*                  Server                                      *
*                  V6.1.0                                      *
****************************************************************
* PROBLEM DESCRIPTION: Performance problem in the Stored Data  *
*                      Objects (SDO) repository access.        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Stored Data Objects (SDO) is used by Webservices in System
Integration Bus (SIBus). These are used for storing and
retrieving the Web Service Definition Language (WSDL) files.
There was a performance hit while accessing just the names of
these entries.

Problem conclusion

While retrieving the names of the entries stored in the Stored
Data Objects repository, finder methods were used which is an
inefficient way of querying just a single column of the
repository. I replaced that finder method with a ejbSelect
method of Entity Bean, which improved the performance.

APAR PM46206 is currently targeted for inclusion in Service
Level (Fix Pack) 6.1.0.43 of WebSphere Application Server V6.1
and Fix Pack 8.0.0.2 of WebSphere Application Server V8.0.

The fix will also be delivered as sysrouted APAR PM52291 in
WebSphere Application Server V7.0 Fix Pack 7.0.0.21.

Please refer to URL:
//www.ibm.com/support/docview.wss?rs=404&uid=swg27006970
for Fix Pack availability.

Temporary fix

Comments

APAR Information

APAR number
PM46206
Reported component name
WEBSPHERE FOR Z
Reported component ID
5655I3500
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-08-23
Closed date
2011-11-15
Last modified date
2012-04-03

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

PM52291

Fix information

Fixed component name
WEBSPHERE FOR Z
Fixed component ID
5655I3500

Applicable component levels

R610 PSY UK76696
UP12/03/18 P F203

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS7K4U","label":"WebSphere Application Server for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
27 October 2021

Tips

PM46206: SDO REPOSITORY PERFORMANCE ENHANCEMENT.

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

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

Fixed component ID

Applicable component levels

R610 PSY UK76696

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.

Document Information

Share your feedback

Need support?