Professional Web Applications Themes

Roll forward pending - IBM DB2

falg form: DB2 Version 7.2( fix pack 8) Windows 2000 server I have an online database backup up with no logs file How do I (or can I) stop the roll forward pending from data base restore...

  1. #1

    Default Roll forward pending

    falg form: DB2 Version 7.2( fix pack 8) Windows 2000 server
    I have an online database backup up with no logs file
    How do I (or can I) stop the roll forward pending from data base restore



    Tony Do Guest

  2. #2

    Default Re: Roll forward pending


    Unfortunately you cannot ...

    Maybe IBM support can do it for you

    Cheers

    Sathyaram

    Originally posted by Tony Do
    > falg form: DB2 Version 7.2( fix pack 8) Windows 2000 server
    > I have an online database backup up with no logs file
    How do I (or can I) stop the roll forward pending from data base
    restore

    --
    DB2 discussion also at [url]http://www.dbforums.com/f8[/url]


    Posted via [url]http://dbforums.com[/url]
    sathyaram_s Guest

  3. #3

    Default Re: Roll forward pending

    hi
    this works on a linux system with version 7.1
    db2 "rollforward database mydb to end of logs on nodes"

    stefan


    "Tony Do" <tonysomewhere.onearth> wrote in message
    news:beisf1$6vr$1merki.connect.com.au...
    > falg form: DB2 Version 7.2( fix pack 8) Windows 2000 server
    > I have an online database backup up with no logs file
    > How do I (or can I) stop the roll forward pending from data base restore
    >
    >
    >

    Stefan Amann Guest

  4. #4

    Default Re: Roll forward pending

    You will have to ship the LOGCTL.LFH file/s from the database
    directory(ies) to IBM support to reset. However, if this is a
    production database, you will have to export out the data and rebuild
    the db.
    cchattoraj Guest

Similar Threads

  1. Pending drafts (NONE) not allowing config changes
    By Ross F in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: August 7th, 02:39 PM
  2. Messages for groupphp.net are in pending
    By Gibier Jean-Charles in forum PHP Development
    Replies: 0
    Last Post: September 10th, 09:23 AM
  3. How to know if read is pending on pipe
    By Helmut Leininger in forum AIX
    Replies: 1
    Last Post: September 8th, 07:54 AM
  4. Check pending state
    By Prakash in forum IBM DB2
    Replies: 1
    Last Post: August 30th, 12:31 AM
  5. Netbackup, and pending requests
    By Daniel in forum Sun Solaris
    Replies: 2
    Last Post: June 26th, 10:32 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139