DB2- Connection disabled

maniv.dk · #1 (**permalink**) 01-04-12, 02:57

Hi,
My objective is to do backup operation and i have done following steps.

1.db2cmd db2stop force
2.db2cmd db2start
3.db2cmd db2 backup db TestDB user db2admin using pa$$w0rd to "C:\"
after execurting this, the backup was completed successfully. But when i try to connect to my database for executing an query.... it throws an error,
"Connectioin is disabled"

Inner exception was : IsKeepAlive(Exception)

is any one has any idea on this ?

przytula_guy · #2 (**permalink**) 01-04-12, 03:02

do backup operation ..
you execute restore ??
probably the db is in rollforward pending
try to connect and you will see the message - execute rollforward..

maniv.dk · #3 (**permalink**) 01-04-12, 04:09

Quote:

Originally Posted by przytula_guy

do backup operation ..
you execute restore ??
probably the db is in rollforward pending
try to connect and you will see the message - execute rollforward..

Sorry earlier when i pasted the code, i added restore comment. Now i have updated in the forum...

przytula_guy · #4 (**permalink**) 01-04-12, 04:24

can you do a local connect ? what is the message when doing local connect
maybe this is only a problem for remote connections ?
related to listener...tcpip..
try : start - db2cmd - db2 connect to xxx

Internet Services

Web Development

Digital Marketing

Consumer Tech