SQL> select * from syscat.tables;
Exception in thread "Thread-25" java.lang.NullPointerException
select * from syscat.views;
This topic has been locked.
3 replies Latest Post - 2009-09-11T03:09:39Z by apprajen
Pinned topic DB2 UDB 9.7 LUW clpplus 'select * from syscat.tables' fails
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-09-11T03:09:39Z at 2009-09-11T03:09:39Z by apprajen
apprajen 270002EBWU4 PostsACCEPTED ANSWER
Re: DB2 UDB 9.7 LUW clpplus 'select * from syscat.tables' fails2009-09-09T11:00:36Z in response to SystemAdminBernard,
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.
SystemAdmin 110000D4XK8 PostsACCEPTED ANSWER
Re: DB2 UDB 9.7 LUW clpplus 'select * from syscat.tables' fails2009-09-10T15:56:20Z in response to apprajenHello,
The selects give:
db2 'select count(*) from syscat.tables where STATISTICS_PROFILE is null'
db2 'select count(*) from syscat.tables where STATISTICS_PROFILE is not null'
apprajen 270002EBWU4 Posts