Re: dbexport / dbimport

dbexport -ss will include lock modes, extent sizes etc.What's the problem with the raw devices exactly? Is it that you have the chunk path as the raw device name itself? If so, use a symbolic link as the chunk name instead - it'll save heartache somewhere along the line. bsagonda@my-deja.com wrote in message <841tpf$f27$1@nnrp1.deja.com>... > hie guys i am running Informix 7.30 on HP-UX 10.20, i have i 15Gig >database which i want to export becauze the system tables have very >large extent sizes and that some of the dbspaces are sitting on raw >device names which could be a problem. >My question is how can i include the extent sizes and lockmodes of my >tables in the export sql file, and how can i solve my problem of the >large system table extents and raw device names. > >Thanking you all in advance. > >-- >Blessing K. Sagonda >Networks >Ok Zimbabwe > > >Sent via Deja.com http://www.deja.com/ >Before you buy.

Those are good suggestions... In our installation, to get rid of multiple extents of the system tables, we also massage the sql file from the dbexport. We insert alters for the next size for all the system tables just after the grant dba statement. This, when properly done, will get you down to 2 extents. Good luck Neil Truby <ntruby@netcomuk.co.uk> wrote in message news:8424g9$ola$1@taliesin2.netcom.net.uk... > dbexport -ss will include lock modes, extent sizes etc.> What's the problem with the raw devices exactly? Is it that you have the > chunk path as the raw device name itself? If so, use a symbolic link as the > chunk name instead - it'll save heartache somewhere along the line. > > bsagonda@my-deja.com wrote in message <841tpf$f27$1@nnrp1.deja.com>... > > hie guys i am running Informix 7.30 on HP-UX 10.20, i have i 15Gig > >database which i want to export becauze the system tables have very > >large extent sizes and that some of the dbspaces are sitting on raw > >device names which could be a problem. > >My question is how can i include the extent sizes and lockmodes of my > >tables in the export sql file, and how can i solve my problem of the > >large system table extents and raw device names. > > > >Thanking you all in advance. > > > >-- > >Blessing K. Sagonda > >Networks > >Ok Zimbabwe > > > > > >Sent via Deja.com http://www.deja.com/ > >Before you buy. > >