Hi ,
I use db2 V7.2 aix 4.3

for some reason I changed db2diag level from 3 to 4 and I am getting lot of massage in db2diaglog like:
Data TitleQLCA PID:43192 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -501 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlrrdi
sqlerrd : (1) 0xFFFF877E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)

Could you please help me what is this error ?

Thank you so much for your help

C:\Documents and Settings\Sathyaram>db2 ? sql0501n


SQL0501N The cursor specified in a FETCH or CLOSE statement is
not open.

Explanation:

The program attempted to either: (1) FETCH using a cursor, or (2)
CLOSE a cursor at a time when the specified cursor was not
open.

The statement cannot be processed.

User Response:

Check for a previous message (SQLCODE) that may have closed the
cursor. Note that after the cursor is closed, any fetches or
close cursor statements receive SQLCODE -501.

If no previous SQLCODEs have been issued, correct the
application program to ensure that the cursor is open when the
FETCH or CLOSE statement is executed.

sqlcode : -501

sqlstate : 24501


C:\Documents and Settings\Sathyaram>


QUOTE]Originally posted by M_RAS
Hi ,
I use db2 V7.2 aix 4.3

for some reason I changed db2diag level from 3 to 4 and I am getting lot of massage in db2diaglog like:
Data TitleQLCA PID:43192 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -501 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlrrdi
sqlerrd : (1) 0xFFFF877E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)

Could you please help me what is this error ?

Thank you so much for your help [/QUOTE]

[/QUOTE]

Thank you sathyaram_s for your help, before I post my question I had seen this description but I thought may be it has some irrelative answer, bucause this error does not damage my database.

anyway thank you again

mmm .. It doesn't damage your database ... But there is a serious application error which your application developer has to be informed ...


Thank you sathyaram_s for your help, before I post my question I had seen this description but I thought may be it has some irrelative answer, bucause this error does not damage my database.

anyway thank you again [/SIZE][/QUOTE]