Topic
  • 8 replies
  • Latest Post - ‏2013-08-14T17:16:08Z by 6628_Emily_Zhang
2MMB_Carlos_Ferrer
2MMB_Carlos_Ferrer
5 Posts

Pinned topic Data Studio ver 3.2.0.0 Issue

‏2013-08-06T19:34:14Z |

I installed Data Studio ver 3.2.0.0 on a windows 7 pc.  Did the typical install which was successful.  I could connect to our db2 for z/os version 9 successully.

Used IBM Data Server Driver for JDBC and SQLJ (JDBC 4.0) default.

We have 3 databases connections we access.  I ran tests on the 3 versions of our db2 databases.  On 2 I clicked on Stored procs from Schema and I could access access the stored procs and could execute them successfully. 

 

The third one is the same as the other 2 but when I tried to expand the stored procedures none of the stored procs none of the existing stored procs are showing up and the .log

!ENTRY com.ibm.datatools.core.connection.polling 2 0 2013-08-06 07:08:31.970
!MESSAGE Connection to TDCJDB2D is not valid. Some operations may not work as expected. Attempt to reconnect in progress...
!STACK 0
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.14.113] A communication error occurred during operations on the connection's underlying socket, socket input stream,
or socket output stream.  Error location: Reply.fill() - insufficient data (-1).  Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
 at com.ibm.db2.jcc.am.ed.a(Unknown Source)
 at com.ibm.db2.jcc.t4.a.a(Unknown Source)
 at com.ibm.db2.jcc.t4.a.a(Unknown Source)
 at com.ibm.db2.jcc.t4.x.b(Unknown Source)
 at com.ibm.db2.jcc.t4.x.c(Unknown Source)
 at com.ibm.db2.jcc.t4.x.c(Unknown Source)
 at com.ibm.db2.jcc.t4.x.v(Unknown Source)
 at com.ibm.db2.jcc.t4.y.b(Unknown Source)
 at com.ibm.db2.jcc.t4.b.h(Unknown Source)
 at com.ibm.db2.jcc.t4.b.isValidX_(Unknown Source)
 at com.ibm.db2.jcc.am.Connection.isValidX(Unknown Source)
 at com.ibm.db2.jcc.am.Connection.isDBValid(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.ibm.datatools.core.connection.polling.validation.DB2ConnectionValidator.validate(Unknown Source)
 at com.ibm.datatools.core.connection.polling.PollingConnectionJob.run(Unknown Source)
 at org.eclipse.core.internal.jobs.Worker.run(Unknown Source)

!ENTRY com.ibm.datatools.core.connection.polling 1 0 2013-08-06 07:08:31.970
!MESSAGE Connection attempt to TDCJDB2D is successful. A context refresh is recommended.

  • 6628_Emily_Zhang
    6628_Emily_Zhang
    12 Posts

    Re: Data Studio ver 3.2.0.0 Issue

    ‏2013-08-11T06:11:36Z  

    Hi Carlos,

    Thank you for reporting the issue!  We would need more information in order to investigate, for example, JCC trace and details of recreation steps.  Would you like to work with the support team to open a PMR so that we can collect more info for your use case scenario?

    Thanks!

    Emily

  • 2MMB_Carlos_Ferrer
    2MMB_Carlos_Ferrer
    5 Posts

    Re: Data Studio ver 3.2.0.0 Issue

    ‏2013-08-12T15:12:34Z  

    Hi Carlos,

    Thank you for reporting the issue!  We would need more information in order to investigate, for example, JCC trace and details of recreation steps.  Would you like to work with the support team to open a PMR so that we can collect more info for your use case scenario?

    Thanks!

    Emily

    I would like help y'all out.  How do I do the jcc trace?  Once I know how to do a jcc trace I will attach the results. 

    I have attached file with the information I have at hand.  Let me know if you need more information. 

     

    Thanks for your help.

  • 2MMB_Carlos_Ferrer
    2MMB_Carlos_Ferrer
    5 Posts

    Re: Data Studio ver 3.2.0.0 Issue

    ‏2013-08-12T19:44:03Z  

    I have added the jcc trace and attached them below.  Let me know what else y'all need.  Thanks

    Attachments

  • 6628_Emily_Zhang
    6628_Emily_Zhang
    12 Posts

    Re: Data Studio ver 3.2.0.0 Issue

    ‏2013-08-13T23:18:44Z  

    I would like help y'all out.  How do I do the jcc trace?  Once I know how to do a jcc trace I will attach the results. 

    I have attached file with the information I have at hand.  Let me know if you need more information. 

     

    Thanks for your help.

    Carlos,

    Based on the info here:

    • Mainframe DB2 log:

         DSNL027I  -DB2D SERVER DISTRIBUTED AGENT WITH  223                  

               LUWID=GA402506.C502.CBCD000E86BE=139                     

               THREAD-INFO=TDCJJC:ITD-204643:tdcjjc:db2jcc_application  

               RECEIVED ABEND=04E                                      

    The Info center says this: An X'04E' abend completion code indicates that DB2 detected an internal error and abended a DB2 internal task (TCB) or a user-connected task
    (Reference: http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2Ftpc%2Fdb2z_abendcompletioncodes.htm)

    It looks like a database issue.  Can you post a note at the z/OS server forum, or contact IBM support to open a PMR to the z/OS team?  They will request more DB2 z/OS trace information that is available on the server.

    Thanks!

    Emily

    Updated on 2013-08-13T23:19:24Z at 2013-08-13T23:19:24Z by 6628_Emily_Zhang
  • 6628_Emily_Zhang
    6628_Emily_Zhang
    12 Posts

    Re: Data Studio ver 3.2.0.0 Issue

    ‏2013-08-13T23:26:09Z  

    I have added the jcc trace and attached them below.  Let me know what else y'all need.  Thanks

    Carlos, did you only see empty folder under stored procedures folder?  Does it happen when expanding other folders, such as table, etc?

    Thanks!

    Emily

  • 2MMB_Carlos_Ferrer
    2MMB_Carlos_Ferrer
    5 Posts

    Re: Data Studio ver 3.2.0.0 Issue

    ‏2013-08-14T14:22:47Z  

    Carlos,

    Based on the info here:

    • Mainframe DB2 log:

         DSNL027I  -DB2D SERVER DISTRIBUTED AGENT WITH  223                  

               LUWID=GA402506.C502.CBCD000E86BE=139                     

               THREAD-INFO=TDCJJC:ITD-204643:tdcjjc:db2jcc_application  

               RECEIVED ABEND=04E                                      

    The Info center says this: An X'04E' abend completion code indicates that DB2 detected an internal error and abended a DB2 internal task (TCB) or a user-connected task
    (Reference: http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2Ftpc%2Fdb2z_abendcompletioncodes.htm)

    It looks like a database issue.  Can you post a note at the z/OS server forum, or contact IBM support to open a PMR to the z/OS team?  They will request more DB2 z/OS trace information that is available on the server.

    Thanks!

    Emily

    I am going to point that out to our DBAs.  Thanks.

  • 2MMB_Carlos_Ferrer
    2MMB_Carlos_Ferrer
    5 Posts

    Re: Data Studio ver 3.2.0.0 Issue

    ‏2013-08-14T14:29:40Z  

    Carlos, did you only see empty folder under stored procedures folder?  Does it happen when expanding other folders, such as table, etc?

    Thanks!

    Emily

    Hi Emily,

    The other ones are okay,  What I am going to do is install 3.1 version of Data Studio and see if that works.

  • 6628_Emily_Zhang
    6628_Emily_Zhang
    12 Posts

    Re: Data Studio ver 3.2.0.0 Issue

    ‏2013-08-14T17:16:08Z  

    Hi Emily,

    The other ones are okay,  What I am going to do is install 3.1 version of Data Studio and see if that works.

    Carlos, do you mean 4.1 version of Data Studio?

    Emily