Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Posts
    12

    Question Unanswered: Database release mismatch

    Hello Everyone,
    I restored a db2 database from the Main server to a backup server using the backup db and the Restore commands. The restore command was successfully completed.
    Now when i try to connect to the Backup database, it gives me the following error :- "SQL1091C The release number of the database is not valid. SQLSTATE=08004". I checked the version of the DB2 as well as the database and instance release level on both the servers, they are the same.
    Can any one throw some more light on this error.
    Thanks and reg
    gurudatt

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Have you checked for any fixpak conflicts.
    Do that and let me know.
    -Prashant G Dahalkar
    Prashant

  3. #3
    Join Date
    Feb 2002
    Posts
    12

    Thanks. DB version problem solved..

    Thanks a million, Prashant, for that solution. Actually, i was not aware that my previous dba had applied patch 2 for the db, hence the error.

    Actually i am a oracle dba and am new into db2. I am assigned a task to
    design and implement a backup strategy for a live PROD database. I am
    planning to go about it this way:-

    1> Put the database in Archive mode.

    2> Take complete online backup.

    3> Backup the archive logs generated everyday.

    4> After a period of 15 days, reset the archive logs by switching the USEREXIT and LOGRETAIN parameters on and off and repeat steps 2 onwards.

    I plan to reset the archive logs every 15 days as this would avoid a large
    recovery time incase of database crash. The last complete online backup would
    have to be restored and only logs of last 15 days would have to be applied.

    Could u please suggest me a beeter way or reseting logs (Oracle has ALTER DATABASe
    RESET LOGs command) .
    And is this a good strategy? I am also contemplating of implementing a inremental(Delta)
    strategy in parallel.

    Pls suggest.

    Thanks and regards
    Gurudatt.

  4. #4
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,
    Just now (04-10-2002 at 9.20 am IST) i checked your mail.
    I will suggest you the solution mostly by evening.
    Prashant
    Prashant

Posting Permissions

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