APAR status
Closed as program error.
Error description
When retrieving nodes on z/OS DB2 through the JCR, the path retrieval is very slow. It took 35 seconds to retrieve 276 nodes with paths and 2 seconds to retrieve 276 noes without paths. WCM queries can be optimised to not get the paths when not needed. One example of this is getting the sitearea descendents for a menu query.
Local fix
Problem summary
Users Affected: All Java edition LWWCM users Problem Description:Getting the path of items is slow in the JCR when running on z/OS DB2.
Problem conclusion
JCR has a different implementation for the path retrieval on DB2 z/OS due to the constraints of that platform. This implementation has a performance impact. It is possible for WCM to avoid getting the paths for nodes. Retrieval of paths should be avoided where possible. The majority of WCM queries will now not get the paths for the nodes. The paths will only be retrieved when needed. Interim fixes for this APAR are available from Fix Central at: 6.0.1.3 http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde r?brandid=2&productid=Workplace%20Web%20Content%20Management&fix es=6.0.1.3-WCM-PK61499 6.0.1.2 http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde r?brandid=2&productid=Workplace%20Web%20Content%20Management&fix es=6.0.1.2-WCM-PK61499 You will need to cut/paste the entire URL into a browser to resolve the address.
Temporary fix
Comments
APAR Information
APAR number
PK61499
Reported component name
WRKPLC WEB CON
Reported component ID
5724I2900
Reported release
601
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-02-22
Closed date
2008-02-26
Last modified date
2008-04-08
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
WRKPLC WEB CON
Fixed component ID
5724I2900
Applicable component levels
R60F PSY
UP
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.1","Edition":"","Line of Business":{"code":null,"label":null}}]
Document Information
Modified date:
10 September 2020