Prev: emacs sql-mode interacting with emacs telnet buffer
Next: I need a SQL/PSM programmer in January
From: dolphin on 20 Dec 2009 17:31
Hi,

I was asked to restore db2 from netbackup. By following the procedure
from the netbackup, the following 2 steps were ran:

(1) db2 restore db <db_name> load /usr/openv/netbackup/bin/nbdb2.sl
(2) db2 rollforward db <db_name> to end of logs and stop

Step (1) was successful but step (2) has been running since 2 days ago
and still waiting for the prompt to returm.

Queries:
- How to find out step (2) is working
- Which file is being restore
- Any other advice

Thanks in advance.

PS: I have no knowledge in DB2
From: Frederik Engelen on 21 Dec 2009 03:54
On Dec 20, 11:31 pm, dolphin <yc282...(a)yahoo.com.sg> wrote:
> Hi,
>
> I was asked to restore db2 from netbackup. By following the procedure
> from the netbackup, the following 2 steps were ran:
>
> (1) db2 restore db <db_name> load /usr/openv/netbackup/bin/nbdb2.sl
> (2) db2 rollforward db <db_name> to end of logs and stop
>
> Step (1) was successful but step (2) has been running since 2 days ago
> and still waiting for the prompt to returm.
>
> Queries:
> - How to find out step (2) is working
> - Which file is being restore
> - Any other advice
>
> Thanks in advance.
>
> PS: I have no knowledge in DB2

Hello,

Use this: db2 list utilities show detail

Some additional info:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.ha.doc/doc/t0011701.html

Kind regards,

Frederik Engelen
 | 
Pages: 1
Prev: emacs sql-mode interacting with emacs telnet buffer
Next: I need a SQL/PSM programmer in January