Informix - Problem description
Problem IT33846 | Status: Closed |
SCHEDULER TASKS IN TENNANT/NON TENNANT ENVIRONMENT WITH SESSION LIMITS MAY FAIL WITH EXCEEDING SESSION LIMITS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
In database server where a mix of tennant and non tennant databases exists scheduler tasks like the AUS refresher or the AUS evaluator may raise errors exceeding limits even the tasks are run as Informix ( DBA ) user 02:16:35 Session SID=772205 User UID=500 NAME=informix PID=0 has exceeded the session limit of 1000 locks. 02:16:35 SCHAPI: last statement UPDATE STATISTICS HIGH FOR TABLE pharmako_vers:informix.sysprocbody(procid,datakey,seqno,data) RESOLUTION 0.50 DISTRIBUTIONS ONLY FORCE | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * In database server where a mix of tennant and non tennant * * databases exist * * scheduler tasks like the AUS refresher or the AUS evaluator * * may raise errors exceeding * * limits even the tasks that are run as Informix ( DBA ) user. * * * * 02:16:35 Session SID=772205 User UID=500 NAME=informix PID=0 * * has * * exceeded the session limit of 1000 locks. * * 02:16:35 SCHAPI: last statement UPDATE STATISTICS HIGH FOR * * TABLE * * pharmako_vers:informix.sysprocbody(procid,datakey,seqno,data * * ) * * RESOLUTION 0.50 DISTRIBUTIONS ONLY FORCE * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * In database server where a mix of tennant and non tennant * * databases exist * * scheduler tasks like the AUS refresher or the AUS evaluator * * may raise errors exceeding * * limits even the tasks that are run as Informix ( DBA ) user. * * * * 02:16:35 Session SID=772205 User UID=500 NAME=informix PID=0 * * has * * exceeded the session limit of 1000 locks. * * 02:16:35 SCHAPI: last statement UPDATE STATISTICS HIGH FOR * * TABLE * * pharmako_vers:informix.sysprocbody(procid,datakey,seqno,data * * ) * * RESOLUTION 0.50 DISTRIBUTIONS ONLY FORCE * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.08.2020 04.02.2021 04.02.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |