RE: Migration & Chunkpaths (DSA 7.24)

Posted in 1999

Tallent, Phil — Wed, 22 Sep 1999 10:16:37 -0400 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF0504.07FD66DE Content-Type: text/plain; charset="iso-8859-1" We do copy backs constantly from PRD to QAT so we have the same situation. The soft link works fine but to make sapdba useable you need to set the following variable "SAPDBA_RAWDEV" to the old path. An example would be export SAPDBA_RAWDEV=/informix/PRD/sapdata. Our new path is /informix/QAT/sapdata. We have used a tool from SAP to changed the path in the reserved pages but it is not worth the trouble to do it that way. Thanks Phil Tallent SAP Administration Informix DBA (423)-510-7701 FAX (423) 510-7895 email: phil.tallent@brachs.com <mailto:phil.tallent@brachs.com> -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, September 21, 1999 5:06 PM To: informix-list@iiug.org Subject: Re: Migration & Chunkpaths (DSA 7.24) No can do. Actually the primary chunk is NOT changed, just ask onstat -d! It is just that when the engine starts up and reads the OTHER link, as specified in $ONCONFIG it reads the chunklist table from there, closes the ROOTDBS file specified in $ONCONFIG and reopens the chunks as named in the reserved page chunklist table. You cannot modify the chunk table yourself without detailed knowledge of the IDS disk structures, Informix tech support has no tool to rename chunks, and tech support will NOT alter any disk structure without a tested and proven tool. Art S. Kagel Andreas Bettin wrote: > > Hello! > > OS: Digital Unix 4.0E > DB: DSA 7.24.FC4X1 > Appl.: SAP R/3 > > My problem after migration to a new system with ontape: > > We have a archive restored into a new system. On the old system the > chunks > was reside in /informix/PN1/sapdata/physdev{n}. Because of > SAP-Restrictions, > we had changed the chunks to /informix/PMM/sapdata/physdev{n}. > > To restore the data on the new system, we have softlinked PMM to PN1. > Restore was successfully and system is running without problems. > > Now, we need to change the chunk-path's from /informix/PN1 to > /informix/PMM > in the database, because the tool "sapdba" see that all chunks in the > PMM path > not used by the db. > > The primary chunk to rootdbs was successfully changed in the onconfig. > > Can anyone give me suggestions/tipps or can help me? > > Tks in advance! > > Andreas Bettin > DBA Pneuhage / Germany ------_=_NextPart_001_01BF0504.07FD66DE Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Migration & Chunkpaths (DSA 7.24)</TITLE> </HEAD> <BODY> <UL><UL> We do copy backs constantly from PRD to QAT so = we have the same situation. The soft link works fine but to make sapdba = useable you need to set the following variable = "SAPDBA_RAWDEV" to the old path. An example would be export = SAPDBA_RAWDEV=3D/informix/PRD/sapdata. Our new path is = /informix/QAT/sapdata. We have used a tool from SAP to changed the path = in the reserved pages but it is not worth the trouble to do it that = way. Thanks Phil Tallent SAP = Administration Informix DBA (423)-510-7701 FAX (423) = 510-7895 email: = <A HREF=3D"mailto:phil.tallent@brachs.com">phil.tallent@brachs.com</A> <UL><UL><UL><UL> <A NAME=3D"_MailData">-----Original = Message-----</A> From:   Art S. = Kagel [<A = HREF=3D"mailto:kagel@bloomberg.net">mailto:kagel@bloomberg.net</A>]</FON= T> Sent:   Tuesday, September 21, 1999 5:06 PM To:     informix-list@iiug.org Subject:       = Re: Migration = & Chunkpaths (DSA 7.24) No can do.  Actually the primary chunk is = NOT changed, just ask onstat -d! It is just that when the engine starts up and = reads the OTHER link, as specified in $ONCONFIG it reads the chunklist = table from there, closes the ROOTDBS file specified in $ONCONFIG and = reopens the chunks as named in the reserved page chunklist table.  You = cannot modify the chunk table yourself without detailed knowledge of the IDS disk = structures, Informix tech support has no tool to rename chunks, and tech = support will NOT alter any disk structure without a tested and proven = tool. Art S. Kagel Andreas Bettin wrote: > > Hello! > > OS: Digital Unix 4.0E > DB: DSA 7.24.FC4X1 > Appl.: SAP R/3 <BR

RE: Migration & Chunkpaths (DSA 7.24)

Related threads

Your privacy choices