Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    2

    Angry Unanswered: SQL2025N An I/O error "5"

    Can anyone point me in the direction of explanations for the SQL2025 error numbers? I'm specifically interested in I/O error "5" this time but a link to a document giving other codes would be useful for the future.
    Full message is:-
    SQL2025N An I/O error "5" occurred on media "\\.\tape0".

    This is on an NT server, 10 hours into the online backup. Any help appreciated.

  2. #2
    Join Date
    Apr 2002
    Posts
    13
    Go to the following URL which will take you to the IBM documentation web site for DB2 UDB:

    http://www-4.ibm.com/cgi-bin/db2www/...bs.d2w/en_main


    All SQL error messages can be found under "Message Reference" section.

    The following is the cut and paste from the manual for SQLCODE 2025:

    ==============================================
    SQL2025N An I/O error "<code>" occurred on media "<dir/devices>".
    Cause: An I/O error occurred while accessing a file on the specified media.

    The utility stops processing.

    Action: Record the error return code. Determine whether the I/O error can be corrected.
    ==============================================

    Also, if you have access to DB2 CLP, then you can get explanation for any SQLCODE by entering the following command from the db2 => prompt:

    ? sqlcode

    where sqlcode can be any SQLCODE.
    For example, to get the messages for SQL2025N, enter the following:

    ? SQL2025N

    Hope this helps
    Anil.
    Last edited by dbfocris; 04-30-02 at 12:46.

  3. #3
    Join Date
    Apr 2002
    Posts
    2
    Go to the following URL which will take you to the IBM documentation web site for DB2 UDB:

    ==============================================
    SQL2025N An I/O error "<code>" occurred on media "<dir/devices>".
    Cause: An I/O error occurred while accessing a file on the specified media.

    Hope this helps
    Anil.
    Anil,

    Thanks, but I already have access to the SQL explanations, I'm just not finding "An I/O error occurred while accessing a file..." very helpful so I was trying to find out what, specifically, "An I/O error "5"..." meant.

    Cheers,

    Mike.

Posting Permissions

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