Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2011
    Posts
    6

    Unanswered: When I was taking online backup I got following error .

    DB2 9.1 & Fp 4a & AIX -5.3

    When I was taking online backup I got below error.I have increase the locktime parameter and REC_HIS_RETENTN also but still I am getting same error.

    could you please help on this one and how to correct the problem ?


    db2 backup db SAMPLE online use tsm include logs without prompting

    SQL2048N An error occurred while accessing object "db2rhist.asc". Reason
    code: "2".

  2. #2
    Join Date
    Jun 2011
    Posts
    6

    db2rhist file is missing.

    I didn't find file (db2rhist.asc) on NODE0000/SQL00001/ on this directory.

    What can I do now ?

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You can restore the history file from a recent backup.

  4. #4
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    just run db2 list history backup all for xxx twice

    it will re-create the history file automatically

  5. #5
    Join Date
    Jun 2011
    Posts
    6

    db2rhist.asc file is corrupted due to filesystem is full.

    I have moved the two files(db2rhist.bak&db2rhist.asc) to some other directory. After I issued the history command . history command create these two files. later I ran online backup is executing fine.


    IBM SQL2161N error reported for db2rhist.asc - United States


    Thanks
    Lokesh.M

  6. #6
    Join Date
    Jun 2011
    Posts
    6

    db2 list history backup all for xxx twice

    Thanks for your help.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    db2rhist.bak is backup of db2rhist.asc
    always first try to rename .asc file and rename .bak to .asc
    if this does not help : have file created again or use restore for history file
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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