Topic
6 replies Latest Post - ‏2013-06-03T20:53:11Z by Brian_Laube
efreid
efreid
16 Posts
ACCEPTED ANSWER

Pinned topic Error running SELECT * FROM SYSIBM.SYSTABLESPACESTATS

‏2013-04-19T15:59:47Z |

I'm getting the following error when I execute a SQL script selecting all columns of sysibm.systablespacestats or sysindexspacestats.  I'm not seeing any negative sqlcodes on the z/OS subsystem.  I'm seeing all the SELECT 1 FROM SYSIBM.SYSDUMMY1 WHERE 0=1 statements successfully executing on the host. 

Lastly, how do issues with Data Studio get turned in and worked.  Being a free product what is the support path?

select * from sysibm.systablespacestats

An internal error occurred during: "select * from sysibm.sysindexspacestats".
java.lang.NullPointerException
 

Thanks

  • David.Zhu
    David.Zhu
    66 Posts
    ACCEPTED ANSWER

    Re: Error running SELECT * FROM SYSIBM.SYSTABLESPACESTATS

    ‏2013-04-21T15:56:02Z  in response to efreid

    Hi,Efreid,

    Could you give us following information and then we can diagnose the problems?

    1.The Data Studio version you used.

    2.The DB2 version you used.

    3. The log files located at <workspace>/.metadata/.log*

    Thanks.

     

  • efreid
    efreid
    16 Posts
    ACCEPTED ANSWER

    Re: Error running SELECT * FROM SYSIBM.SYSTABLESPACESTATS

    ‏2013-04-23T21:11:02Z  in response to efreid

    David, thanks for your follow up.

    Data Studio 3.2

    DB2 v9 NFM

     

    Attachments

    • David.Zhu
      David.Zhu
      66 Posts
      ACCEPTED ANSWER

      Re: Error running SELECT * FROM SYSIBM.SYSTABLESPACESTATS

      ‏2013-04-24T12:03:54Z  in response to efreid

      Hi,Efreld,

      Thanks for your report this problem, I can receat you problem. I'm not sure whether you mind to wait  for the new release?

      Thanks.

      • efreid
        efreid
        16 Posts
        ACCEPTED ANSWER

        Re: Error running SELECT * FROM SYSIBM.SYSTABLESPACESTATS

        ‏2013-05-15T21:13:55Z  in response to David.Zhu

        Waiting for the next maintenance release would be acceptable.  I'm trying to get staff off of 3.1 but running into resistance.  They sure do like their 3.1 for some reason. 

        • David.Zhu
          David.Zhu
          66 Posts
          ACCEPTED ANSWER

          Re: Error running SELECT * FROM SYSIBM.SYSTABLESPACESTATS

          ‏2013-05-17T09:28:04Z  in response to efreid

          Hi,Efreld,

          Thanks for you understanding.  Could you send me what's the reason for your teammate resistant to upgrade to new version? Then I can look what we can help to resolve these resistance

          My mail address is zhuzhih@cn.ibm.com

           

          Thanks again.

  • Brian_Laube
    Brian_Laube
    5 Posts
    ACCEPTED ANSWER

    Re: Error running SELECT * FROM SYSIBM.SYSTABLESPACESTATS

    ‏2013-06-03T20:53:11Z  in response to efreid

    I have the exact same problem when doing 

    SELECT * FROM SYSIBM.SYSTABLESPACESTATS

    with IBM Data Studio Version 3.2

    My workaround solution is to change the "SELECT *" to SELECT the specific columns I am interested in seeing.  This works for me

    > Remember, IBM Data Studio has smart insert -> once it knows the table you are working on then you can hit ctrl-shift and the context sensitive help  pops up a window with columns of that table... this makes it quick to pick the column names...

     

    I assume there is some column type in SYSTABLESPACESTATS that IBM Data Studio has trouble displaying....

    (and yes, I am anxiously awaiting the new version of IBM Data Studio - partly to see this minor bug fixed)