Professional Web Applications Themes

backup status - IBM DB2

Dear all, I am running DB2 v7 in AIX. After I issued a db2 backup command, the command prompt hanged. I log on another term and check. No backup image file is generated, but when I issue "db2 list application show detail", I found a connection is made to the db with status "performing a backup". I try to "db2 force application (app-id) to break the backup connection but fail, I would like to ask : 1) how to check the backup command status (check if it is running or hang) 2) any command to break the backup process after ...

  1. #1

    Default backup status

    Dear all,

    I am running DB2 v7 in AIX.

    After I issued a db2 backup command, the command prompt hanged. I log on
    another term and check. No backup image file is generated, but when I issue
    "db2 list application show detail", I found a connection is made to the db
    with status "performing a backup".

    I try to "db2 force application (app-id) to break the backup connection but
    fail, I would like to ask :

    1) how to check the backup command status (check if it is running or hang)
    2) any command to break the backup process after I issue the backup command.


    Thanks a lot !!


    Deacon Guest

  2. #2

    Default Re: backup status

    "Deacon" <com> wrote in message news:<blul1j$netvigator.com>... 

    Hi,

    Check the db2diag.log to check what is happening. It will be in the
    directory <instancehome>/sqllib/db2dump/db2diag.log

    use tail to check the last few lines to see what's it complaining
    about.

    Regards,
    -Manoj
    Manoj Guest

  3. #3

    Default Re: backup status

    Hi,

    Did you submit your DB2 backup command from prompt. Sometimes the
    telnet session may expire if its idle for long time and still show a
    connection to database. Always submit backup as a background process,
    use either 'nohup' or 'at now' or 'crontab'.

    Where is your backup going disk or TSM ? If disk then you can see the
    size of backup image growing, if its going to TSM you may login to TSM
    and monitor or ask TSM admin to see if the backup is running fine.

    I hope this helps.

    Sunila


    com (Manoj Rajshekar) wrote in message news:<google.com>... 
    >[/ref]
    Sunila Guest

  4. #4

    Default Re: backup status

    Deacon <com> wrote: 

    You're saying that the backup hangs before it even creates the backup
    image? That's very strange. The backup target is opened very early in
    the process, far before anything happens that could cause the command
    to appear to hang.

    What is the exact command that you're running?
     

    a. Watch the backup file and see if it continues to get bigger.
    b. Set diaglvl=4 and watch db2diag.log. An entry is made at the start of
    each tablespace that's processed.
     

    Ctrl-C. This won't work if the backup is stalled because of lock
    contention or if it's making a noninterruptable system call, but for most
    general purposes it will do.

    dave
    David Guest

Similar Threads

  1. Question how to take backup ip pinging status in command prompt
    By 9742902606 in forum Brainstorming Area
    Replies: 0
    Last Post: August 28th, 04:55 AM
  2. Bug Status
    By Richard in forum ASP.NET Security
    Replies: 0
    Last Post: November 26th, 03:25 PM
  3. Status Bar
    By Josh in forum FileMaker
    Replies: 5
    Last Post: August 22nd, 04:04 AM
  4. loop - begin backup, end backup Oracle 8.1.7
    By Matthias Arth in forum Oracle Server
    Replies: 1
    Last Post: December 27th, 08:53 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