Results 1 to 2 of 2

Thread: Sqlcode : -984

  1. #1
    Join Date
    Jan 2002
    Location
    India
    Posts
    17

    Exclamation Unanswered: Sqlcode : -984

    Hello All,
    Could you please tell me what does SQLCODE -984 stands for.

    My DB2DIAG.LOG is as follows :
    Data TitleQLCA PID:43310 Node:000
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -984 sqlerrml: 0
    sqlerrmc:
    sqlerrp : sqlrrcmd
    sqlerrd : (1) 0xFFFFE60A (2) 0xFFFFFC2C (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:


    Also in DB2-UDB on AIX how does the log files work.? Will deletion of some of those log files will hamper my DB2.?

    Thanks and regards,
    Deven.
    Always Smile :
    It is a curve that can set a lot of things straight.

  2. #2
    Join Date
    Feb 2002
    Posts
    33
    Hi,

    The SQL0984 tells us there was a problem with a COMMIT or ROLLBACK. You can also check this yourself by issuing 'db2 ? sql0984' right from a CLP window. Looking further into the error message I see that sqlerrd[1] contains FFFFE60A. The SQL reference has additional information on how to interpret SQLCA entries, and the Troubleshooting Guide has details on the FFFFE60A.

    It looks like a file couldn't be found (e60a). Unfortunately we don't have the filename. Does this error occur frequently? Do you have details on the db2diag.log entries before and after this message?

    Thanks,
    Raj

Posting Permissions

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