Fixes are available
APAR status
Closed as program error.
Error description
You may encounter error SQL0429N if you have over 32K tables and running Auto Runstats with SET STATISTICS PROFILE option. Sample Runstats command ran under Auto Runstats: db2 runstats on table "TABSCHEMA"."TABNAME" with distribution on all columns default num_freqvalues 100 num_quantiles 200 and detailed indexes all allow write access set profile. Sample error logged in db2diag.log ---------------------------------------------------------------- ------ 2009-07-02-10.32.11.826667-300 I107285A474 LEVEL: Error PID : 364570 TID : 1164 PROC : db2acd 0 INSTANCE: db2ecp NODE : 000 APPID : *LOCAL.db2ecp.090702153136 FUNCTION: DB2 UDB, Automatic Table Maintenance, Atm::process_tables, probe:360 MESSAGE : ZRC=0xFFFFFE53=-429 DATA #1 : <preformatted> AutoStats: [IBM][CLI Driver][DB2/AIX64] SQL0429N The maximum number of concurrent LOB locators has been exceeded. SQLSTATE=54028 ---------------------------------------------------------------- ------
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users having over 32K tables and running Auto Runstats with * * SET STATISTICS PROFILE option in V9.1 * **************************************************************** * PROBLEM DESCRIPTION: * * You may encounter error SQL0429N if you have over 32K * * tables * * and running Auto Runstats with SET STATISTICS PROFILE * * option. * **************************************************************** * RECOMMENDATION: * * Apply fixpak 9 or above. * ****************************************************************
Problem conclusion
The issue is first fixed in FP9.
Temporary fix
Comments
APAR Information
APAR number
IZ57365
Reported component name
DB2 EDE AIX
Reported component ID
5724N7600
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-08-06
Closed date
2010-05-10
Last modified date
2010-05-10
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
DB2 EDE AIX
Fixed component ID
5724N7600
Applicable component levels
R910 PSY
UP
R950 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
10 May 2010