RESTORE PROBLEM FROM DB2 V8.2 TO V9

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mikael Arhelger - 07 Jul 2006 20:05 GMT

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

Reply to this Message

Shashi Mannepalli - 10 Jul 2006 15:02 GMT

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

> 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

Reply to this Message

Mikael Arhelger - 11 Jul 2006 19:44 GMT

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

> Did u try this (i assume so ..checking)
>
[quoted text clipped - 13 lines]
> > Can not migrate. Receive error:
> > SQL0270N Function not supported (Reason code = "75"). SQLSTATE=42997

Reply to this Message