Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    55

    Unanswered: Apparent contention issue with DB2 backup

    We are having what appear to be contention issues when running db2 backups.

    DB2 is version 8.1.1 running on AIX5.1

    The scripted backups fail. The scripts issues a list applications, receives a clear signal and tries to start the backup which then fails with
    SQL1035N The database is currently in use.

    The diaglog shows repeated occurrences of
    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0xFFFFFBF5".

    and

    ADM1510W A file sharing violation has occurred while accessing log file
    "S0008397.LOG". Another process may be using this file. DB2 will try to
    delete it later.


    The active log directory is
    /db2log/scioltpp/scdoltpp/NODE0000

    The archive log directory is
    /db2backup/SCDOLTPP

    The database image copy directory is
    /db2bck

    Mincommit is set to 1.

    Seems to be a contention issue. Any thoughts on what we could look at would be appreciated.

    Thanks
    Gerry
    datapro01@yahoo.com

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by SnowCrash7
    We are having what appear to be contention issues when running db2 backups.

    DB2 is version 8.1.1 running on AIX5.1

    The scripted backups fail. The scripts issues a list applications, receives a clear signal and tries to start the backup which then fails with
    SQL1035N The database is currently in use.

    The diaglog shows repeated occurrences of
    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0xFFFFFBF5".

    and

    ADM1510W A file sharing violation has occurred while accessing log file
    "S0008397.LOG". Another process may be using this file. DB2 will try to
    delete it later.


    The active log directory is
    /db2log/scioltpp/scdoltpp/NODE0000

    The archive log directory is
    /db2backup/SCDOLTPP

    The database image copy directory is
    /db2bck

    Mincommit is set to 1.

    Seems to be a contention issue. Any thoughts on what we could look at would be appreciated.

    Thanks
    Gerry
    datapro01@yahoo.com
    What error does your script get, and what's the command it's issuing, the BACKUP?

    File sharing violation - could it be some contention with your userexit? Or a filesystem backup perhaps?
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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