Unix Technical Forum

restore question

This is a discussion on restore question within the DB2 forums, part of the Database Server Software category; --> I ever remember there's some question very similar appeared some days ago, but I failed to get the final ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 06:56 PM
Hardy
 
Posts: n/a
Default restore question

I ever remember there's some question very similar appeared some days ago,
but I failed to get the final answer.

update DB2 7.1(WSE) to 8.1(WSE) on R6000, after backup and install the 8.1
DB2, when try to restore the database we met with error below:

sql2519N the db was restored but the restored db was not migreted to the
corrent release error -1006 with tokens "3 j" is returned
sqlstate=24501

then we run migrate,

sql1006n returned, saying the code page "xxx" of the application does not
match teh code 'xxx' of the database.
sqlstate=24501

then we set the db2codepage and db2country, but it doesn't work.

I googled the web and get some tips like below:
1. enlarge the log file
2. install the latest fixpack

I don't know why 1 is suggested, and we plan to do 2 when call the customer
next time but not feel sure it will work.

It seems to be a common question? for I google many questions on similar
scenario.

Your help will be highly appreciated Thanks in advance!


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 06:58 PM
db2 admin
 
Posts: n/a
Default Re: restore question


:It seems to be a common question? for I google many questions on similar
:scenario.
:
:Your help will be highly appreciated Thanks in advance!
:

I don't know if it will help, but the links I use for
db2 q&a are:

1) The manuals (from
http://www.software.ibm.com/data/db2/library)

2) The Certification Guides

I've found other books on UDB to be very basic or
lacking in administration help.

I'd also suggest you subscribe to DB2EUG mailing list
(db2eug@herethey.com) where you'll get additional help.

More info is at
http://www2.herethey.com:8888/mailman/listinfo/db2eug


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:22 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com