diff 7.30 -> 9.30 -> 9.40

Hi, I have a database with a procedure upper and lower on 7.30! I have done an export and wanna import now on 9,30/9.40. But I am not able to make an upper or lower procedure! What's up here? cu sven -----Ursprüngliche Nachricht----- Von: ART KAGEL, .... [mailto:KAGEL@bloomberg.net] Gesendet: Donnerstag, 26. Juni 2003 14:34 An: ids@iiug.org Betreff: Re: dbimport [1425] Post your onstat -d output and the dbimport commandline you used.. Art S. Kagel ----- Original Message ----- From: Anders Beng.... <anders.bengtsson@hkv.mil.se> At: 6/26 7:28 > I am on informix 7.3 > > I have dumped my database with dbexport > Then I changed the name of tempdspace to tempdbspace1 and created a new one > called tempdbspace2. > I then created two new chunks, tmpchunk1 and tmpchunk2, in the dbspaces. > > Then I dropped the database. > > When I'm trying to import it, it starts to import, but after a while it stops. > > The first chunk, chunk1, in the datadbs is full, nothing is written in the other > chunks, chunk2 and so on. > > In the dbimport - file I get the message "No space left on device". > > And, yes, there is no space left in chunk1, but why don' the import continues to > chunk2? > > Is it not possible to make a dbexport, then change the name of a dbspace, and > then make a dbimport? > > Thanks in advance.

in versions prior to 7.30 upper and lower were not part of informix sql. So users wrote their own upper and lower procedure for the same effect. Try to edit the dbexport sql file and remove procedures upper and lower. ----- Original Message ----- From: "Schuran, Sven" <sschuran@maske.de> To: <ids@iiug.org> Sent: Thursday, June 26, 2003 09:06 Subject: diff 7.30 -> 9.30 -> 9.40 [1426] > Hi, > I have a database with a procedure upper and lower on 7.30! > I have done an export and wanna import now on 9,30/9.40. > > But I am not able to make an upper or lower procedure! > > What's up here? > > cu sven > > > -----Ursprüngliche Nachricht----- > Von: ART KAGEL, .... [mailto:KAGEL@bloomberg.net] > Gesendet: Donnerstag, 26. Juni 2003 14:34 > An: ids@iiug.org > Betreff: Re: dbimport [1425] > > > > Post your onstat -d output and the dbimport commandline you used.. > > Art S. Kagel > ----- Original Message ----- > From: Anders Beng.... <anders.bengtsson@hkv.mil.se> > At: 6/26 7:28 > > > I am on informix 7.3 > > > > I have dumped my database with dbexport > > Then I changed the name of tempdspace to tempdbspace1 and created a new one > > called tempdbspace2. > > I then created two new chunks, tmpchunk1 and tmpchunk2, in the dbspaces. > > > > Then I dropped the database. > > > > When I'm trying to import it, it starts to import, but after a while it stops. > > > > The first chunk, chunk1, in the datadbs is full, nothing is written in the > other > > chunks, chunk2 and so on. > > > > In the dbimport - file I get the message "No space left on device". > > > > And, yes, there is no space left in chunk1, but why don' the import continues > to > > chunk2? > > > > Is it not possible to make a dbexport, then change the name of a dbspace, and > > then make a dbimport? > > > > Thanks in advance. > > > > > >

nice idea, but not possible, becauee these procedures are used by the application! -----Ursprüngliche Nachricht----- Von: rkusenet [mailto:rkusenet@sympatico.ca] Gesendet: Donnerstag, 26. Juni 2003 15:35 An: ids@iiug.org; Schuran, Sven Betreff: Re: diff 7.30 -> 9.30 -> 9.40 [1426] in versions prior to 7.30 upper and lower were not part of informix sql. So users wrote their own upper and lower procedure for the same effect. Try to edit the dbexport sql file and remove procedures upper and lower. ----- Original Message ----- From: "Schuran, Sven" <sschuran@maske.de> To: <ids@iiug.org> Sent: Thursday, June 26, 2003 09:06 Subject: diff 7.30 -> 9.30 -> 9.40 [1426] > Hi, > I have a database with a procedure upper and lower on 7.30! > I have done an export and wanna import now on 9,30/9.40. > > But I am not able to make an upper or lower procedure! > > What's up here? > > cu sven > > > -----Ursprüngliche Nachricht----- > Von: ART KAGEL, .... [mailto:KAGEL@bloomberg.net] > Gesendet: Donnerstag, 26. Juni 2003 14:34 > An: ids@iiug.org > Betreff: Re: dbimport [1425] > > > > Post your onstat -d output and the dbimport commandline you used.. > > Art S. Kagel > ----- Original Message ----- > From: Anders Beng.... <anders.bengtsson@hkv.mil.se> > At: 6/26 7:28 > > > I am on informix 7.3 > > > > I have dumped my database with dbexport > > Then I changed the name of tempdspace to tempdbspace1 and created a new one > > called tempdbspace2. > > I then created two new chunks, tmpchunk1 and tmpchunk2, in the dbspaces. > > > > Then I dropped the database. > > > > When I'm trying to import it, it starts to import, but after a while it stops. > > > > The first chunk, chunk1, in the datadbs is full, nothing is written in the > other > > chunks, chunk2 and so on. > > > > In the dbimport - file I get the message "No space left on device". > > > > And, yes, there is no space left in chunk1, but why don' the import continues > to > > chunk2? > > > > Is it not possible to make a dbexport, then change the name of a dbspace, and > > then make a dbimport? > > > > Thanks in advance. > > > > > >

It is a nice idea....if this is causing your import to fail removing it would atleast allow the import to complete. Then you could resolve the proc. issues afterwards. On the issue with the import failing...at what point is the import failing? Is it related to the data loading or index creations? "Schuran, Sven" <sschuran@maske. To: ids@iiug.org de> cc: Sent by: Subject: AW: diff 7.30 -> 9.30 -> 9.40 [1430] forum.subscriber @iiug.org 06/26/03 10:36 AM nice idea, but not possible, becauee these procedures are used by the application! -----Ursprüngliche Nachricht----- Von: rkusenet [mailto:rkusenet@sympatico.ca] Gesendet: Donnerstag, 26. Juni 2003 15:35 An: ids@iiug.org; Schuran, Sven Betreff: Re: diff 7.30 -> 9.30 -> 9.40 [1426] in versions prior to 7.30 upper and lower were not part of informix sql. So users wrote their own upper and lower procedure for the same effect. Try to edit the dbexport sql file and remove procedures upper and lower. ----- Original Message ----- From: "Schuran, Sven" <sschuran@maske.de> To: <ids@iiug.org> Sent: Thursday, June 26, 2003 09:06 Subject: diff 7.30 -> 9.30 -> 9.40 [1426] > Hi, > I have a database with a procedure upper and lower on 7.30! > I have done an export and wanna import now on 9,30/9.40. > > But I am not able to make an upper or lower procedure! > > What's up here? > > cu sven > > > -----Ursprüngliche Nachricht----- > Von: ART KAGEL, .... [mailto:KAGEL@bloomberg.net] > Gesendet: Donnerstag, 26. Juni 2003 14:34 > An: ids@iiug.org > Betreff: Re: dbimport [1425] > > > > Post your onstat -d output and the dbimport commandline you used.. > > Art S. Kagel > ----- Original Message ----- > From: Anders Beng.... <anders.bengtsson@hkv.mil.se> > At: 6/26 7:28 > > > I am on informix 7.3 > > > > I have dumped my database with dbexport > > Then I changed the name of tempdspace to tempdbspace1 and created a new one > > called tempdbspace2. > > I then created two new chunks, tmpchunk1 and tmpchunk2, in the dbspaces. > > > > Then I dropped the database. > > > > When I'm trying to import it, it starts to import, but after a while it stops. > > > > The first chunk, chunk1, in the datadbs is full, nothing is written in the > other > > chunks, chunk2 and so on. > > > > In the dbimport - file I get the message "No space left on device". > > > > And, yes, there is no space left in chunk1, but why don' the import continues > to > > chunk2? > > > > Is it not possible to make a dbexport, then change the name of a dbspace, and > > then make a dbimport? > > > > Thanks in advance. > > > > > >

Did u read my mail!!!! upper and lower functions are now built in informix. so even if you remove it, your applications will most likely continue to run. u just can't sit idle hoping something will happen on its own. u have to do something. for the last time I am outlining the steps 1. remove upper and lower procedures from the sql file. 2. load it. that will complete dbimport. 3. then try to create it thru dbaccess. 4. or better try to run without those procedures. ur application should run fine. ----- Original Message ----- From: "Schuran, Sven" <sschuran@maske.de> To: "rkusenet" <rkusenet@sympatico.ca> Sent: Thursday, June 26, 2003 11:44 Subject: AW: diff 7.30 -> 9.30 -> 9.40 [1430] I have tried really much, my database is import! But I need my upper and lower procedures, cause the appl needs them in that way. So what is your hint? -----Ursprüngliche Nachricht----- Von: rkusenet [mailto:rkusenet@sympatico.ca] Gesendet: Donnerstag, 26. Juni 2003 17:39 An: ids@iiug.org; Schuran, Sven Betreff: Re: diff 7.30 -> 9.30 -> 9.40 [1430] > nice idea, but not possible, becauee these procedures are used by the application! nothing will happen to them. upper and lower are still there as part of informix functions. or do this. remove those procedures from the dbexport sql file and then later on add it manually. see whether it rejects them at that time. the bottomling is that u need to get ur job done and have to try various options.