Question & Answer
Question
The CTE0105 memory allocation error can occur at index update time if a large amount of data is being indexed on an AIX 32 bit instance.
Cause
The default setting for MAXDATA of 2 for the executable "cteprupx" used during index update processing can be too small and must eventually be increased.
Answer
The "cteprupx" executable is stored in the following directory:
<instance_owner_home_directory>/sqllib/adm
Change the MAXDATA setting using the "maxdata.ksh" tool that you can download from :
ftp://public.dhe.ibm.com/ps/products/db2extenders/tools
When you have installed the tool, make sure that no index update process is running, change to the directory where the "cteprupx" executable is located, create a backup copy of cteprupx, and then run the maxdata.ksh tool as follows:
maxdata.ksh cteprupx 8
This command sets MAXDATA to 8 256 segments which is the maximum.
Verify the setting using:
dump -ovH cteprupx
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Instance","Platform":[{"code":"PF002","label":"AIX"}],"Version":"8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPFH","label":"Db2 Net Search Extender"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Administration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21164030