IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 3 replies
  • Latest Post - ‏2009-09-11T03:09:39Z by apprajen
SystemAdmin
SystemAdmin
8 Posts

Pinned topic DB2 UDB 9.7 LUW clpplus 'select * from syscat.tables' fails

‏2009-09-09T05:54:27Z |
SQL> select * from syscat.tables;
Exception in thread "Thread-25" java.lang.NullPointerException
at com.ibm.clpplus.common.ProcessInput.execJDBC
(ProcessInput.java:3293)
at com.ibm.clpplus.common.ProcessInput$JDBCWorkerThread.run
(ProcessInput.java:3789)
select * from syscat.views;
works fine.
Bernard Dhooghe
Updated on 2009-09-11T03:09:39Z at 2009-09-11T03:09:39Z by apprajen
  • apprajen
    apprajen
    4 Posts

    Re: DB2 UDB 9.7 LUW clpplus 'select * from syscat.tables' fails

    ‏2009-09-09T11:00:36Z  
    Bernard,

    syscat.tables has a column by name 'statistics_profile' of type CLOB. Could you please check whether the value for this column is 'null' for any of the rows? We do have a known issue in this regard where a null value for a CLOB can cause this issue. This issue is being tracked and will be fixed.

    Thanks,
    Rajendran.
  • SystemAdmin
    SystemAdmin
    8 Posts

    Re: DB2 UDB 9.7 LUW clpplus 'select * from syscat.tables' fails

    ‏2009-09-10T15:56:20Z  
    • apprajen
    • ‏2009-09-09T11:00:36Z
    Bernard,

    syscat.tables has a column by name 'statistics_profile' of type CLOB. Could you please check whether the value for this column is 'null' for any of the rows? We do have a known issue in this regard where a null value for a CLOB can cause this issue. This issue is being tracked and will be fixed.

    Thanks,
    Rajendran.
    Hello,

    The selects give:

    db2 'select count(*) from syscat.tables where STATISTICS_PROFILE is null'

    1
    604

    db2 'select count(*) from syscat.tables where STATISTICS_PROFILE is not null'

    1
    0

    Bernard (Dhooghe)
  • apprajen
    apprajen
    4 Posts

    Re: DB2 UDB 9.7 LUW clpplus 'select * from syscat.tables' fails

    ‏2009-09-11T03:09:39Z  
    Hello,

    The selects give:

    db2 'select count(*) from syscat.tables where STATISTICS_PROFILE is null'

    1
    604

    db2 'select count(*) from syscat.tables where STATISTICS_PROFILE is not null'

    1
    0

    Bernard (Dhooghe)
    Bernard,

    Thank you for verifying this information for us. This is a known issue. We are tracking this issue and will be fixed.

    Thanks,
    Rajendran.