|
DB2 RESTORE FAIL
|
|||
---|---|---|---|
#18+
Добрый день. подскажите как быть. что это такое? ни подключений к БД нет ни активности! и каждая команда очень долго выполняется! при попытке удаления БД ошибка та-же. db2 => connect to TEST Database Connection Information Database server = DB2/AIX64 10.5.1 SQL authorization ID = DB2INST1 Local database alias = TEST db2 => quiesce database immediate force connections DB20000I The QUIESCE DATABASE command completed successfully. db2 => force application all DB20000I The FORCE APPLICATION command completed successfully. DB21024I This command is asynchronous and may not be effective immediately. db2 => terminate DB20000I The TERMINATE command completed successfully. $ db2 deactivate db test DB20000I The DEACTIVATE DATABASE command completed successfully. $ db2 RESTORE DATABASE TEST LOAD /usr/openv/netbackup/bin/nbdb2.sl64 TAKEN AT 20170412154232 into TEST redirect& [1] 4390940 $ SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. QLSTATE=57019 [1]+ Exit 4 db2 RESTORE DATABASE TEST LOAD /usr/openv/netbackup/bin/nbdb2.sl64 TAKEN AT 20170412190132 into TEST redirect $ db2 connect reset SQL1024N A database connection does not exist. SQLSTATE=08003 $ db2 quiesce instance db2inst1 restricted access immediate force connections SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "80". SQLSTATE=57033 $ db2 quiesce instance db2inst1 restricted access immediate force connections SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "80". SQLSTATE=57033 $ db2_kill Application ipclean: Removing DB2 engine and client IPC resources for db2inst1. $ db2_kill db2nkill: DB2 member 0 with PID 9961708 does not exist. $ db2start 04/13/2017 13:18:59 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. $ db2 force application all;db2 quiesce instance db2inst1 restricted access immediate force connections DB20000I The FORCE APPLICATION command completed successfully. DB21024I This command is asynchronous and may not be effective immediately. SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "80". SQLSTATE=57033 $ db2stop force 04/13/2017 13:34:17 0 0 SQL1064N DB2STOP processing was successful. SQL1064N DB2STOP processing was successful. Спасибо. ... |
|||
:
Нравится:
Не нравится:
|
|||
13.04.2017, 13:36 |
|
DB2 RESTORE FAIL
|
|||
---|---|---|---|
#18+
Amiri, Не надо в скрипте запускать db2 restore в background. Если хотите выполнить восстановление: db2 quiesce instance db2inst1 restricted access immediate force connections db2 RESTORE DATABASE TEST LOAD /usr/openv/netbackup/bin/nbdb2.sl64 TAKEN AT 20170412154232 into TEST redirect Причем, если уж выполнили с redirect, то где команды: - SET TABLESPACE CONTAINERS / SET STOGROUP PATHS - db2 restore db ... continue после этого? ... |
|||
:
Нравится:
Не нравится:
|
|||
14.04.2017, 17:17 |
|
DB2 RESTORE FAIL
|
|||
---|---|---|---|
#18+
Mark Barinstein, Спасибо. ... |
|||
:
Нравится:
Не нравится:
|
|||
17.04.2017, 10:09 |
|
DB2 RESTORE FAIL
|
|||
---|---|---|---|
#18+
Здравствуйте. Подскажите пожалуйста, есть продуктивный сервер с базой на котором установлена Maximo asset management, есть вновь установленный на который нужно накатить базу с продуктивного. Имена баз должны совпадать? Если они должны совпадать но не совпадают можно ли изменить имя базы данных на новом сервере так чтоб Максимо не перестала работать? Какой командой накатить базу с продуктива на новый сервер? ... |
|||
:
Нравится:
Не нравится:
|
|||
13.06.2017, 12:17 |
|
|
start [/forum/topic.php?fid=43&gotonew=1&tid=1600438]: |
0ms |
get settings: |
9ms |
get forum list: |
9ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
81ms |
get topic data: |
9ms |
get first new msg: |
6ms |
get forum data: |
2ms |
get page messages: |
41ms |
get tp. blocked users: |
1ms |
others: | 275ms |
total: | 439ms |
0 / 0 |