SEO

#1 (**permalink**) 02-27-2008, 07:36 AM

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

#2 (**permalink**) 02-27-2008, 07:37 AM

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

#3 (**permalink**) 02-27-2008, 07:38 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

RESTORE PROBLEM FROM DB2 V8.2 TO V9