Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: Error SQL0501 after I change levele 3 to 4

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Error SQL0501 after I change levele 3 to 4

    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]
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Re: Error SQL0501 after I change levele 3 to 4

    Originally posted by sathyaram_s
    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]

    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

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Error SQL0501 after I change levele 3 to 4

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


    Originally posted by M_RAS
    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]
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •