APAR status
Closed as fixed if next.
Error description
Creating a BTS index in 11.50.xC6 and later versions is much slower than in 11.50.xC5 and earlier versions. There are much more pages written to temporary smartblob spaces in 11.50.xC6/xC7 than in versions before. Example 1000000 rows, field email char(50) contains unique email addresses From onstat -D 11.50.FC4/FC5 11.50.FC6/FC7 time 00:04:50.130 05:50:26.125 SBSPACE page Wr 36544 36552 SBSPACETEMP page Wr 95306 22959217 From onstat -p 11.50.FC4/FC5 11.50.FC6/FC7 time 00:04:50.130 05:50:26.125 dskreads 71 216945 pagreads 71 217306 bufreads 4866975 2847490695 dskwrits 133217 22997709 pagwrits 173136 23037208 bufwrits 2642647 777519207 lockreqs 3559187 2275247122 usercpu 252.92 15561.88 syscpu 2.78 179.35
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * all users of bts with 11.50.xc6 and later * **************************************************************** * PROBLEM DESCRIPTION: * * This is a performance issue related to the introduction of * * the multivp support in 11.50.xC6 * **************************************************************** * RECOMMENDATION: * * upgrade to a new release containing this fix. * ****************************************************************
Problem conclusion
Temporary fix
Comments
http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp For download information, go to: http://www.ibm.com/support/fixcentral
APAR Information
APAR number
IC72536
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-11-11
Closed date
2011-09-27
Last modified date
2011-09-27
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RB15 PSN
UP
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
27 September 2011