Unix Technical Forum

RESTORE PROBLEM FROM DB2 V8.2 TO V9

This is a discussion on RESTORE PROBLEM FROM DB2 V8.2 TO V9 within the DB2 forums, part of the Database Server Software category; --> Did restore from an OFFLINE backup under V8.2 to new db in V9. OS=Windows 2000 Server Can not migrate. ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:36 AM
Mikael Arhelger
 
Posts: n/a
Default RESTORE PROBLEM FROM DB2 V8.2 TO V9

Did restore from an OFFLINE backup under V8.2 to new db in V9.

OS=Windows 2000 Server

Can not migrate. Receive error:
SQL0270N Function not supported (Reason code = "75"). SQLSTATE=42997

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 08:37 AM
Shashi Mannepalli
 
Posts: n/a
Default Re: RESTORE PROBLEM FROM DB2 V8.2 TO V9

Did u try this (i assume so ..checking)


75 Disable automatic statistics collection for this database by
setting the database configuration parameters AUTO_STATS_PROF and
AUTO_PROF_UPD to OFF.



?

cheers..
Shashi Mannepalli


Mikael Arhelger wrote:
> Did restore from an OFFLINE backup under V8.2 to new db in V9.
>
> OS=Windows 2000 Server
>
> Can not migrate. Receive error:
> SQL0270N Function not supported (Reason code = "75"). SQLSTATE=42997


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 08:38 AM
Mikael Arhelger
 
Posts: n/a
Default Re: RESTORE PROBLEM FROM DB2 V8.2 TO V9

Dear Shashi,

Tks for replying but no, I did not (I am not an experienced DBA).
However, I am going back to 8.2 (actually I am suppose to go back to
8.1) for my app: SAP B1. It is not yet approved / supported by V9. I
wonder but I guess I have to accept this.

Cheers.

Mikael

Shashi Mannepalli wrote:
> Did u try this (i assume so ..checking)
>
>
> 75 Disable automatic statistics collection for this database by
> setting the database configuration parameters AUTO_STATS_PROF and
> AUTO_PROF_UPD to OFF.
>
>
>
> ?
>
> cheers..
> Shashi Mannepalli
>
>
> Mikael Arhelger wrote:
> > Did restore from an OFFLINE backup under V8.2 to new db in V9.
> >
> > OS=Windows 2000 Server
> >
> > Can not migrate. Receive error:
> > SQL0270N Function not supported (Reason code = "75"). SQLSTATE=42997


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 06:03 AM.


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