|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
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: |
Commands i fired during restore is as follows:-
$ db2 restore db BTMUATDB taken at 20091028160615 into BTM216_2
SQL2529W Warning! Restoring to an existing database that is different from
the backup image database, and the alias name "BTM216_2" of the existing
database does not match the alias name "BTMUATDB" of the backup image, and the
database name "BTM216_2" of the existing database does not match the database
name "BTMUATDB" of the backup image. The target database will be overwritten
by the backup version. The Roll-forward recovery logs associated with the
target database will be deleted.
Do you want to continue ? (y/n) y
SQL2563W The restore process has completed successfully, but one or more
table spaces from the backup were not restored.
$ db2 connect to BTM216_2
SQL1117N A connection to or activation of database "BTM216_2" cannot be made
because of ROLL-FORWARD PENDING. SQLSTATE=57019
$ db2 rollforward dbBTM216_2
SQL0104N An unexpected token "dbBTM216_2" was found following "ROLLFORWARD".
Expected tokens may include: "DATABASE". SQLSTATE=42601
$ db2 rollforward db BTM216_2
Rollforward Status
Input database alias = BTM216_2
Number of nodes have returned status = 1
Node number = 0
Rollforward status = DB pending
Next log file to be read = S0001691.LOG
Log files processed = -
Last committed transaction = 2009-10-28-08.07.23.000000 UTC
$ db2 connect to BTM216_2
SQL1117N A connection to or activation of database "BTM216_2" cannot be made
because of ROLL-FORWARD PENDING. SQLSTATE=57019
$ db2 rollforward db BTM216_2 to end of logs and complete
SQL1271W Database "BTM216_2" is recovered but one or more table spaces are
off-line on node(s) "0".
$ db2 drop db BTM216_2
SQL1035N The database is currently in use. SQLSTATE=57019
|
Advertisement
| Hall of Fame |