The application is pointing me to the link below which discusses update
statistics. Is it normal that we should perform stats on the catalog
database(s). I've never thought to do that nor have I not seen it done.
Should I perform a low, medium, or high?
APPLICATION:
I found a post on the web that refers to this error and how someone
fixed it.
I recommend you schedule update statistics processes to whole database
tables using criteria levels recommended by Informix and also run update
statistics for its procedures, but you should take off the tables from
you
daily update statistics process which are being referenced inside stored
procedures.
Here is the post.
http://www.iiug.org/forums/ids/index.cgi/noframes/read/1566
It looks like this is an Informix bug (bug # 173595) that has been fixed
in Informix 10.00.xC9E.
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/co
m.ibm.relnotes.doc/xc9E/idse_defects_10.0.html
[9/8/09 9:46:50:738 CDT] 7a565769 SystemOut U [2009-09-08
09:46:50,736] [log(LogWriterLog4JImpl:?] ERROR -
com.sears.storeswb.utils.PortalCategoryUtils Error getting content query
SELECT DISTINCT
cnt.OID,DM_TITLE,c.SR_DOC_NEWS_ALERT,SR_DOC_NEWS_START,DM_CREATION_TIME,
DM_LAST_MOD_TIME,DM_DOC_TYPE,u.USER_ID FROM SR_DOC_CATEGORY_MAP cnt
,outer SR_USER_CNT_LOG u, SR_DOC_NEWS_CH c WHERE path_name like
'/fls/news/%' and fmt_dept='fls-store ' and dm_doc_type=
'sr_portal_news' and cnt.oid=c.oid and cnt.oid=u.content_id and
(current >= c.sr_doc_news_start and c.sr_doc_news_end >= current) and
u.store_id=102 and u.content_type_id=1011 and u.user_id=8632 ORDER BY
c.SR_DOC_NEWS_ALERT desc, DM_CREATION_TIME descjava.sql.SQLException:
Cannot read system catalog (systables).
at com.informix.jdbc.IfxSqli.a(IfxSqli.java(Compiled Code))
at com.informix.jdbc.IfxSqli.E(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java(Compi
led Code))
at
com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java(Compi
led Code))
at
com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java(
Compiled Code))
at
com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java(Inlined Compiled
Code))
at
com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java(Co
mpiled Code))
at
com.ibm.ejs.cm.cache.StatementCache.reallyPrepareStatement(StatementCach
e.java(Compiled Code))
at
com.ibm.ejs.cm.cache.StatementCache.prepareStatement(StatementCache.java
(Compiled Code))
at
com.ibm.ejs.cm.pool.ConnectO.prepareStatement(ConnectO.java(Compiled
Code))
at
com.ibm.ejs.cm.pool.ConnectO.prepareStatement(ConnectO.java(Inlined
Compiled Code))
at
com.ibm.ejs.cm.proxy.ConnectionProxy.prepareStatement(ConnectionProxy.ja
va(Compiled Code))
at
com.sears.storeswb.utils.PortalCategoryUtils.getItemsFromDB(Unknown
Source)(Compiled Code)
at
com.sears.storeswb.utils.PortalCategoryUtils.getPortalContentArrayList(U
nknown Source)(Inlined Compiled Code)
at
com.sears.storeswb.action.news.NewsLinksAction.perform(Unknown
Source)(Compiled Code)
at
org.apache.struts.action.ActionServlet.processActionPerform(ActionServle
t.java(Inlined Compiled Code))
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java(Compil
ed Code))
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compil
ed Code))
at
com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compile
d Code))
at
com.ibm.servlet.dynacache.CacheProxyServlet.service(CacheProxyServlet.ja
va(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecy
cleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a(Compiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.include(WebAppRequ
estDispatcher.java(Compiled Code))
at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java(C
ompiled Code))
at
portal.news._newsBody_jsp_1._jspService(_newsBody_jsp_1.java(Compiled
Code))
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compil
ed Code))
at
com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compile
d Code))
at
com.ibm.servlet.dynacache.CacheManager.handleServlet(CacheManager.java(I
nlined Compiled Code))
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServle
t.java(Compiled Code))
at
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java(Comp
iled Code))
at
org.apache.jasper.runtime.JspServlet.service(JspServlet.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecy
cleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a(Compiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.include(WebAppRequ
estDispatcher.java(Compiled Code))
at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java(C
ompiled Code))
at
org.apache.struts.taglib.template.GetTag.doStartTag(GetTag.java(Compiled
Code))
at
portal.common._template_jsp_1._jspService(_template_jsp_1.java(Compiled
Code))
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compil
ed Code))
at
com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compile
d Code))
at
com.ibm.servlet.dynacache.CacheManager.handleServlet(CacheManager.java(I
nlined Compiled Code))
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServle
t.java(Compiled Code))
at
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java(Comp
iled Code))
at
org.apache.jasper.runtime.JspServlet.service(JspServlet.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecy
cleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a(Compiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.include(WebAppRequ
estD
[9/8/09 9:46:50:739 CDT] 7a565769 SystemOut U
ispatcher.java(Compiled Code))
at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java(C
ompiled Code))
at
org.apache.struts.taglib.template.InsertTag.doEndTag(InsertTag.java(Comp
iled Code))
at
portal.news._news_jsp_0._jspService(_news_jsp_0.java(Compiled Code))
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compil
ed Code))
at
com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compile
d Code))
at
com.ibm.servlet.dynacache.CacheManager.handleServlet(CacheManager.java(I
nlined Compiled Code))
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServle
t.java(Compiled Code))
at
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java(Comp
iled Code))
at
org.apache.jasper.runtime.JspServlet.service(JspServlet.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleSe
rvlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a(Compiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequ
estDispatcher.java(Compiled Code))
at
org.apache.struts.action.ActionServlet.processActionForward(ActionServle
t.java(Compiled Code))
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java(Compil
ed Code))
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compil
ed Code))
at
com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compile
d Code))
at
com.ibm.servlet.dynacache.CacheProxyServlet.service(CacheProxyServlet.ja
va(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecy
cleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a(Compiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequ
estDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Co
mpiled Code))
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvo
ker.java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cach
edInvocation.java(Compiled Code))
at
com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cach
eableInvocationContext.java(Compiled Code))
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Servlet
RequestProcessor.java(Compiled Code))
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEList
ener.java(Compiled Code))
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnectio
n.java(Compiled Code))
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(
Compiled Code))
at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
getNextException(): java.sql.SQLException: ISAM error: key value locked
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java(Inlined
Compiled Code))
at com.informix.jdbc.IfxSqli.a(IfxSqli.java(Compiled Code))
at com.informix.jdbc.IfxSqli.E(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java(Compi
led Code))
at
com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java(Compi
led Code))
at
com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java(
Compiled Code))
at
com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java(Inlined Compiled
Code))
at
com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java(Co
mpiled Code))
at
com.ibm.ejs.cm.cache.StatementCache.reallyPrepareStatement(StatementCach
e.java(Compiled Code))
at
com.ibm.ejs.cm.cache.StatementCache.prepareStatement(StatementCache.java
(Compiled Code))
at
com.ibm.ejs.cm.pool.ConnectO.prepareStatement(ConnectO.java(Compiled
Code))
at
com.ibm.ejs.cm.pool.ConnectO.prepareStatement(ConnectO.java(Inlined
Compiled Code))
at
com.ibm.ejs.cm.proxy.ConnectionProxy.prepareStatement(ConnectionProxy.ja
va(Compiled Code))
at
com.sears.storeswb.utils.PortalCategoryUtils.getItemsFromDB(Unknown
Source)(Compiled Code)
at
com.sears.storeswb.utils.PortalCategoryUtils.getPortalContentArrayList(U
nknown Source)(Inlined Compiled Code)
at
com.sears.storeswb.action.news.NewsLinksAction.perform(Unknown
Source)(Compiled Code)
at
org.apache.struts.action.ActionServlet.processActionPerform(ActionServle
t.java(Inlined Compiled Code))
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java(Compil
ed Code))
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compil
ed Code))
at
com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compile
d Code))
at
com.ibm.servlet.dynacache.CacheProxyServlet.service(CacheProxyServlet.ja
va(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecy
cleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a(Compiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebApp
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
<mailto:2244650553@messaging.sprintpcs.com>
Page via Skytel: 2244650553@sprint.skytel.com
<mailto:2244650553@sprint.skytel.com>
Informix or MySQL Primary: 9110210@skytel.com
<mailto:9110210@skytel.com>
Informix or MySQL Secondary: 7276872@skytel.com
<mailto:7276872@skytel.com>
" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************