B204 SQL - DB2 subsystem "DB2Q" does not exist

mugil · New User Joined: 19 May 2010 Posts: 1 Location: chennai

Hi,

I am facing 'B204 SQL - DB2 subsystem "DB2Q" does not exist' error when i try to run an easytrieve program which handles a cursor in it. i did check my DB2 panel. i found DB2S as my subsystem ID.

The above mentioned error is followed by 'B204 SQL - CHANGING TO "PARTIAL" SQL SYNTAX CHECKING'

below is the job log:

12 *
13 SQL INCLUDE LOCATION * FROM DNBA.TABLE1
13 *******B204 SQL - DB2 SUBSYSTEM "DB2Q" DOES NOT EXIST
13 *******B204 SQL - CHANGING TO "PARTIAL" SQL SYNTAX CHECKING
14 SQL INCLUDE LOCATION * FROM DNBA.TABLE2
14 *******B204 SQL - DB2 CATALOG NOT AVAILABLE DUE TO ATTACH FAILURE
15 *
16 SQL DECLARE CURS01 CURSOR FOR +
16 *******B204 SQL - DB2 SUBSYSTEM "DB2Q" DOES NOT EXIST
16 *******B204 SQL - CHANGING TO "PARTIAL" SQL SYNTAX CHECKING
SELECT A.COD_PERSONA || ';' || +
, A.COD_CENTRO_INS || ';' || +
, B.COD_P1 +
FROM DNBA.TABLE1 A, +
DNBA.TABLE2 B +
WHERE A.COD_F = :W-INPUT1 +
WITH UR

here DNBA is the table owner.

can anybody please help on this?

Thanks,
Mugil

enrico-sorichetti · Posted: Wed May 19, 2010 4:26 pm

dbzTHEdinosauer · Posted: Wed May 19, 2010 4:29 pm

especially since: