ca.portal.admin

TSO access to idms 17.0 CV

Discussion created by ca.portal.admin on Dec 21, 2008
i finally got the CV to come up and stay up - but i cannot seem to get the supplied CLIST to work i know RHDCUCFT cannot execute from an authorized loadlib, so I copy RHDCUCFT to an non-authorized lib - and re-execute - nowit tells me it cannot find IDMSIDMS

so i copy IDMSIDMS to the non-apf loadlib, and nothng seems to work -

anyone got htis working?

Chris Hoelscher
Senior IDMS & DB2 Database Administrator Humana Inc
502-476-2538
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
"""Loss of significance"" Error"
"One of our java programs sometimes gets a ""Loss of significance"" error =
when attempting to store records to IDMS. Sometimes the record stores =
fine and other times it gets the error. The developer says that she has =
had it work and then not work. When I tried it it failed the first =
couple of times (see error message below), then it started working for =
no apparent reason and it worked fine the rest of the day. I can't =
figure out if this is a connection issue with IDMS or something else. =
The program opens and closes the database connection each time a record =
is stored. When the record stores successfully the IDMS log shows the =
transaction, when it fails IDMS shows nothing. ""Loss of significance"" =
appears to be related to certain arithmetic operations, but the =
developer says that she does not do any of those in her program. Any =
ideas on how to debug this would be appreciated. =20

From the web server log:


CREATE_ID VALUE : 018645
IDMS INSERT, SSN: 123456789
java.sql.SQLException: DB001001 T391 C-4M322: Loss of significance
at =
ca.idms.jdbc.IdmsJdbcObject.getSQLException(IdmsJdbcObject.java)
at =
ca.idms.jdbc.IdmsStatement.getSQLException(IdmsStatement.java)
at =
ca.idms.jdbc.IdmsJdbcObject.getSQLException(IdmsJdbcObject.java)
at =
ca.idms.jdbc.IdmsPreparedStatement.execUpdate(IdmsPreparedStatement.java)=

at =
ca.idms.jdbc.IdmsPreparedStatement.executeUpdate(IdmsPreparedStatement.ja=
va)
at =
us.sc.state.doc.intakeadmit.dao.db2.IntakeAdmitDAOImpl.insertIDMSIntakeAd=
mit(IntakeAdmitDAOImpl.java:788)
at =
us.sc.state.doc.intakeadmit.biz.logic.IntakeAdmitServiceImpl.saveIDMSInta=
keAdmit(IntakeAdmitServiceImpl.java:179)
at =
us.sc.state.doc.intakeadmit.ui.IntakeAdmitAction.save(IntakeAdmitAction.j=
ava:423)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at =
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:79)
at =
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at =
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.ja=
va:276)
at =
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)=

at =
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro=
cessor.java:421)
at =
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:2=
26)
at =
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at =
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at =
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat=
ionFilterChain.java:237)
at =
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte=
rChain.java:157)
at =
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve=
.java:214)
at =
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCon=
text.java:104)
at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:52=
0)
at =
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCont=
extValve.java:198)
at =
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve=
.java:152)
at =
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCon=
text.java:104)
at =
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorB=
ase.java:540)
at =
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCon=
text.java:102)
at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:52=
0)
at =
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:=
137)
at =
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCon=
text.java:104)
at =
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:=
118)
at =
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCon=
text.java:102)
at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:52=
0)
at =
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j=
ava:109)
at =
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCon=
text.java:104)
at =
org.josso.tc50.agent.SSOAgentValve.invoke(SSOAgentValve.java:495)
at =
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCon=
text.java:102)
at =
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:52=
0)
at =
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at =
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at =
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at =
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at =
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at =
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:6=
75)
at =
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at =
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:683)
at java.lang.Thread.run(Thread.java:810)
error DB001001 T391 C-4M322: Loss of significance
IDMS INSERT SUCCESS VALUE: 0
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
"""Loss of significance"" Error"
"One of our java programs sometimes gets a ""Loss of significance"" error when attempting to store records to IDMS. Sometimes the record stores fine and other times it gets the error. The developer says that she has had it work and then not work. When I tried it it failed the first couple of times (see error message below), then it started working for no apparent reason and it worked fine the rest of the day. I can't figure out if this is a connection issue with IDMS or something else. The program opens and closes the database connection each time a record is stored. When the record stores successfully the IDMS log shows the transaction, when it fails IDMS shows nothing. ""Loss of significance"" appears to be related to certain arithmetic operations, but the developer says that she does not do any of those in her program. Any ideas on how to debug this would be appreciated.

From the web server log:


CREATE_ID VALUE : 018645
IDMS INSERT, SSN: 123456789
java.sql.SQLException: DB001001 T391 C-4M322: Loss of significance
at ca.idms.jdbc.IdmsJdbcObject.getSQLException(IdmsJdbcObject.java)
at ca.idms.jdbc.IdmsStatement.getSQLException(IdmsStatement.java)
at ca.idms.jdbc.IdmsJdbcObject.getSQLException(IdmsJdbcObject.java)
at ca.idms.jdbc.IdmsPreparedStatement.execUpdate(IdmsPreparedStatement.java)
at ca.idms.jdbc.IdmsPreparedStatement.executeUpdate(IdmsPreparedStatement.java)
at us.sc.state.doc.intakeadmit.dao.db2.IntakeAdmitDAOImpl.insertIDMSIntakeAdmit(IntakeAdmitDAOImpl.java:788)
at us.sc.state.doc.intakeadmit.biz.logic.IntakeAdmitServiceImpl.saveIDMSIntakeAdmit(IntakeAdmitServiceImpl.java:179)
at us.sc.state.doc.intakeadmit.ui.IntakeAdmitAction.save(IntakeAdmitAction.java:423)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.josso.tc50.agent.SSOAgentValve.invoke(SSOAgentValve.java:495)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:810)
error DB001001 T391 C-4M322: Loss of significance
IDMS INSERT SUCCESS VALUE: 0
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
"Re: ""Loss of significance"" Error"
"Maybe this is usefull=2E Is the query dealing with null values,sometimes?=
=0D=0A=0D=0Ahttp://publib=2Eboulder=2Eibm=2Ecom/infocenter/db2v7luw/index=
=2Ejsp?topic=3D/com=2Ei=0D=0Abm=2Edb2v7=2Edoc/cpsqlrv1/ibmsqlr40=2Ehtm=0D=
=0A=0D=0ALutz Petzold=0D=0ATDM UDB/IDMS Support=0D=0A401-782-2265=0D=0APage=
860 366 0865 or Telalert=0D=0A =0D=0A =0D=0A=0D=0AThis e-mail may contain =
confidential or privileged information=2E If=0Ayou think you have received =
this e-mail in error, please advise the=0Asender by reply e-mail and then d=
elete this e-mail immediately=2E=0AThank you=2E Aetna
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
"Re: ""Loss of significance"" Error"
"Maybe this is usefull. Is the query dealing with null values,sometimes?

http://publib.boulder.ibm.com/infocenter/db2v7luw/index.jsp?topic=/com.i
bm.db2v7.doc/cpsqlrv1/ibmsqlr40.htm

Lutz Petzold
TDM UDB/IDMS Support
401-782-2265
Page 860 366 0865 or Telalert



This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
"Re: ""Loss of significance"" Error"
"The IDMS Log might be more revealing - depending on how you are
connecting there ought to be an IDMS JDBC Server Log on the midrange
and/or some information in the DC/LOG. If your JDBC connection is
through TCP/IP into IDMS then everything you want should be in the one
spot (in the IDMS/DC Log) - one of the advantages of taking advantage of
the new driver for JDBC Connections - hth - cheers - Gary =20


Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613
MailTo:cherlet.gary@saugov.sa.gov.au

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original
transmission and its contents. Confidentiality: This e-mail may contain
confidential information which also may be legally privileged. Only the
intended recipient(s) may access, use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are
those of the sender, not Justice Technology Services. Computer Viruses:
It is the recipient's responsibility to check the e-mail and any
attached files for viruses.

Outcomes