CA IDMS

TSO access to idms 17.0 CV

  • 1.  TSO access to idms 17.0 CV

    Posted 12-21-2008 04:38 PM
    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.