Getting exception in Java application with error code "DB2 SQL error: SQLCODE: -901"

[jyoti202]

Hi,
Need help for this as i have been looking for it but could not get any results.
We are using java as front end and DB2 as backend, i m getting the exception while executing a particular query with following error description:

DB2 SQL error: SQLCODE: -901, SQLSTATE: 58004, SQLERRMC: sqlno_itr_plan::next [300]:rc( 0)

SQLCODE: -901 this error code says "Non severe System error"

This query was working fine till now but recently it has started throwing error.
My query is a search query and it works fine for blank search but as we enter any search criteria it gives the above error.
Query is some what like this:

SELECT * FROM ( SELECT TEMP1.*,ROW_NUMBER() OVER() AS ROW_NUM FROM ( select distinct
------------- some more AND conditions -----------------)
AND exists (SELECT 1 FROM SESSION.tmpDepartment WHERE divisioncode = A.divisioncode AND loccd = A.loccd AND dptcd = A.dptcd) AND ltrim(rtrim(UPPER(A.dptcd))) like '%abc%' order by 1 ASC ) AS TEMP1 ) AS TEMP2 WHERE ((ROW_NUM -1) /5) + 1 = 1

Need your help.
Thanks to all those who will be replying.

[kalexin]

Hi,
Need help for this as i have been looking for it but could not get any results.
We are using java as front end and DB2 as backend, i m getting the exception while executing a particular query with following error description:

DB2 SQL error: SQLCODE: -901, SQLSTATE: 58004, SQLERRMC: sqlno_itr_plan::next [300]:rc( 0)

SQLCODE: -901 this error code says "Non severe System error"

This query was working fine till now but recently it has started throwing error.
My query is a search query and it works fine for blank search but as we enter any search criteria it gives the above error.
Query is some what like this:

SELECT * FROM ( SELECT TEMP1.*,ROW_NUMBER() OVER() AS ROW_NUM FROM ( select distinct
------------- some more AND conditions -----------------)
AND exists (SELECT 1 FROM SESSION.tmpDepartment WHERE divisioncode = A.divisioncode AND loccd = A.loccd AND dptcd = A.dptcd) AND ltrim(rtrim(UPPER(A.dptcd))) like '%abc%' order by 1 ASC ) AS TEMP1 ) AS TEMP2 WHERE ((ROW_NUM -1) /5) + 1 = 1

Need your help.
Thanks to all those who will be replying.

Is there an abend? A -901 error is normally caused by a prior error that prevents the current SQL being executed. Check to make sure there are no resources locked or pending commits.