Adding chunks
A user on IDS 9.3/AIX could no longer add chunks, getting "Unable to extend 2 reserved pages for Chunk descriptor page in ROOT chunk", despite free space, because his initial root chunk was only 30MB. Replies explained that all reserved/extended reserve pages must live in the *first* chunk of rootdbs (check free space with oncheck -pe), so extra rootdbs chunks don't help; freeing space by moving logical/physical logs out of that chunk was suggested. With the logs already elsewhere, the consensus fix was to dbexport (or use HPL for speed), rebuild the instance with a much larger initial rootdbs (512MB+) plus separate log/data dbspaces, then reimport. A side discussion about HPL express-mode load errors was left unresolved.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hey all -- Running IDS 9.3 on AIX. My initial root chunk was 30 MB, now have 3 chunks totalling 120MB. Plenty of space now. I have also successfully added several 1GB and 2GB chunks to my dbspaces. But now when I try to continue adding chunks to my dbspaces, I am getting this message: "Unable to extend 2 reserved pages for Chunk descriptor page in ROOT chunk." Guess I have run out of reserved pages with such a small initial root chunk. I originally sized the server appropriately, and then the customer unexpectedly increased the space needed by an order of 10. I haven't found specific documentation telling me what I can do to resolve this so that I can continue adding chunks. I'm nowhere close to running out of disk space on my partitions, and as I first mentioned, the root chunk has plenty of room. Thanks for any help! Rahn Rahn Payne Rehab Manager, Inc. (903) 823-1171 rpayne@rehabmgr.com efax: (508) 445-0537
Hello Rahn,
All reserved pages and extended reserve pages must be in the first chunk of
the rootdbs. I would run oncheck -pe and see how how many free pages there
are in the first chunk of the rootdbs.
Cheers,
Hans
___________________________________________
Hans Siebrand
Asia Pacific Team Lead
DB2 UDB Engine Team
Software Group
IBM Australia
p) +61 2 9333 6150
f) + 61 2 9954 4458
e) siebrand@au1.ibm.com
w) http://www.ibm.com/software/data/db2
___________________________________________
"Rahn Payne"
<rpayne@rehabmgr. To: ids@iiug.org
com> cc:
Sent by: Subject: Adding chunks [1292]
forum.subscriber@
iiug.org
06/06/2003 06:28
AM
Hey all --
Running IDS 9.3 on AIX. My initial root chunk was 30 MB, now have 3 chunks
totalling 120MB. Plenty of space now. I have also successfully added
several 1GB and 2GB chunks to my dbspaces. But now when I try to continue
adding chunks to my dbspaces, I am getting this message:
"Unable to extend 2 reserved pages for Chunk descriptor page in ROOT
chunk."
Guess I have run out of reserved pages with such a small initial root
chunk. I originally sized the server appropriately, and then the customer
unexpectedly increased the space needed by an order of 10. I haven't found
specific documentation telling me what I can do to resolve this so that I
can continue adding chunks. I'm nowhere close to running out of disk space
on my partitions, and as I first mentioned, the root chunk has plenty of
room.
Thanks for any help!
Rahn
Rahn Payne
Rehab Manager, Inc.
(903) 823-1171
rpayne@rehabmgr.com
efax: (508) 445-0537
It's not usual to see more than one chunk
assigned to rootdbs, I would
recommend you to create the first rootdbs chunk bigger than the others.
You don't need more than one chunk for this, because the data will be stored
in specific dbspaces.
Sonia
----- Original Message -----
From: "Hans Siebrand " <siebrand@au1.ibm.com>
To: <ids@iiug.org>
Sent: Thursday, June 05, 2003 4:23 PM
Subject: Re: Adding chunks [1293]
>
>
>
>
> Hello Rahn,
>
> All reserved pages and extended reserve pages must be in the first chunk
of
> the rootdbs. I would run oncheck -pe and see how how many free pages
there
> are in the first chunk of the rootdbs.
>
> Cheers,
> Hans
> ___________________________________________
>
> Hans Siebrand
> Asia Pacific Team Lead
> DB2 UDB Engine Team
> Software Group
> IBM Australia
>
> p) +61 2 9333 6150
> f) + 61 2 9954 4458
> e) siebrand@au1.ibm.com
> w) http://www.ibm.com/software/data/db2
> ___________________________________________
>
>
>
> "Rahn Payne"
> <rpayne@rehabmgr. To: ids@iiug.org
> com> cc:
> Sent by: Subject: Adding chunks
[1292]
> forum.subscriber@
> iiug.org
>
>
> 06/06/2003 06:28
> AM
>
>
>
>
>
>
> Hey all --
> Running IDS 9.3 on AIX. My initial root chunk was 30 MB, now have 3
chunks
> totalling 120MB. Plenty of space now. I have also successfully added
> several 1GB and 2GB chunks to my dbspaces. But now when I try to continue
> adding chunks to my dbspaces, I am getting this message:
>
> "Unable to extend 2 reserved pages for Chunk descriptor page in ROOT
> chunk."
>
> Guess I have run out of reserved pages with such a small initial root
> chunk. I originally sized the server appropriately, and then the customer
> unexpectedly increased the space needed by an order of 10. I haven't
found
> specific documentation telling me what I can do to resolve this so that I
> can continue adding chunks. I'm nowhere close to running out of disk
space
> on my partitions, and as I first mentioned, the root chunk has plenty of
> room.
>
> Thanks for any help!
>
> Rahn
>
> Rahn Payne
> Rehab Manager, Inc.
> (903) 823-1171
> rpayne@rehabmgr.com
> efax: (508) 445-0537
>
>
>
>
>
>
>
>
>
>
Just in case.
Are your physical and/or logical logs in rootdbs and on the first chunk
?
If so, take them out from there. You'll get some more free space.
Regards,
Víctor Fabián Miramontes
DBA Proyecto SAP
Cencosud S.A.
TE: 054-11-4733-1000 int. 4153
>>> "Sonia Guerra" <sguerra@merkafon.com> 06/06 1:48 PM >>>
It's not usual to see more than one chunk assigned to rootdbs, I would
recommend you to create the first rootdbs chunk bigger than the
others.
You don't need more than one chunk for this, because the data will be
stored
in specific dbspaces.
Sonia
----- Original Message -----
From: "Hans Siebrand " <siebrand@au1.ibm.com>
To: <ids@iiug.org>
Sent: Thursday, June 05, 2003 4:23 PM
Subject: Re: Adding chunks [1293]
>
>
>
>
> Hello Rahn,
>
> All reserved pages and extended reserve pages must be in the first
chunk
of
> the rootdbs. I would run oncheck -pe and see how how many free
pages
there
> are in the first chunk of the rootdbs.
>
> Cheers,
> Hans
> ___________________________________________
>
> Hans Siebrand
> Asia Pacific Team Lead
> DB2 UDB Engine Team
> Software Group
> IBM Australia
>
> p) +61 2 9333 6150
> f) + 61 2 9954 4458
> e) siebrand@au1.ibm.com
> w) http://www.ibm.com/software/data/db2
> ___________________________________________
>
>
>
> "Rahn Payne"
> <rpayne@rehabmgr. To: ids@iiug.org
> com> cc:
> Sent by: Subject: Adding
chunks
[1292]
> forum.subscriber@
> iiug.org
>
>
> 06/06/2003 06:28
> AM
>
>
>
>
>
>
> Hey all --
> Running IDS 9.3 on AIX. My initial root chunk was 30 MB, now have 3
chunks
> totalling 120MB. Plenty of space now. I have also successfully
added
> several 1GB and 2GB chunks to my dbspaces. But now when I try to
continue
> adding chunks to my dbspaces, I am getting this message:
>
> "Unable to extend 2 reserved pages for Chunk descriptor page in
ROOT
> chunk."
>
> Guess I have run out of reserved pages with such a small initial
root
> chunk. I originally sized the server appropriately, and then the
customer
> unexpectedly increased the space needed by an order of 10. I
haven't
found
> specific documentation telling me what I can do to resolve this so
that I
> can continue adding chunks. I'm nowhere close to running out of
disk
space
> on my partitions, and as I first mentioned, the root chunk has plenty
of
> room.
>
> Thanks for any help!
>
> Rahn
>
> Rahn Payne
> Rehab Manager, Inc.
> (903) 823-1171
> rpayne@rehabmgr.com
> efax: (508) 445-0537
>
>
>
>
>
>
>
>
>
>
Hans, Sonia and Victor -- thanks for the tips. My physical and logical logs
are in their own spaces. Are dynamically allocated logical logs created in
the initial root chunk? If not, I think the thing to do is to dbexport
everything and start over with a much bigger initial root chunk. It's a
fair amount of work but I don't see an alternative. What I thought was
going to be a 4GB system turned into a 30GB nightmare, and I only learned
that a little at a time. I appreciate all of the feedback!
Rahn
----- Original Message -----
From: Victor Mir.... <VMiramon@cencosud.com.ar>
To: <ids@iiug.org>
Sent: Friday, June 06, 2003 1:29 PM
Subject: Re: Adding chunks [1295]
> Just in case.
> Are your physical and/or logical logs in rootdbs and on the first chunk
> ?
> If so, take them out from there. You'll get some more free space.
>
> Regards,
>
>
>
> Víctor Fabián Miramontes
> DBA Proyecto SAP
> Cencosud S.A.
> TE: 054-11-4733-1000 int. 4153
>
>
> >>> "Sonia Guerra" <sguerra@merkafon.com> 06/06 1:48 PM >>>
> It's not usual to see more than one chunk assigned to rootdbs, I would
> recommend you to create the first rootdbs chunk bigger than the
> others.
>
> You don't need more than one chunk for this, because the data will be
> stored
> in specific dbspaces.
>
> Sonia
>
> ----- Original Message -----
> From: "Hans Siebrand " <siebrand@au1.ibm.com>
> To: <ids@iiug.org>
> Sent: Thursday, June 05, 2003 4:23 PM
> Subject: Re: Adding chunks [1293]
>
>
> >
> >
> >
> >
> > Hello Rahn,
> >
> > All reserved pages and extended reserve pages must be in the first
> chunk
> of
> > the rootdbs. I would run oncheck -pe and see how how many free
> pages
> there
> > are in the first chunk of the rootdbs.
> >
> > Cheers,
> > Hans
> > ___________________________________________
> >
> > Hans Siebrand
> > Asia Pacific Team Lead
> > DB2 UDB Engine Team
> > Software Group
> > IBM Australia
> >
> > p) +61 2 9333 6150
> > f) + 61 2 9954 4458
> > e) siebrand@au1.ibm.com
> > w) http://www.ibm.com/software/data/db2
> > ___________________________________________
> >
> >
> >
> > "Rahn Payne"
> > <rpayne@rehabmgr. To: ids@iiug.org
>
> > com> cc:
> > Sent by: Subject: Adding
> chunks
> [1292]
> > forum.subscriber@
> > iiug.org
> >
> >
> > 06/06/2003 06:28
> > AM
> >
> >
> >
> >
> >
> >
> > Hey all --
> > Running IDS 9.3 on AIX. My initial root chunk was 30 MB, now have 3
> chunks
> > totalling 120MB. Plenty of space now. I have also successfully
> added
> > several 1GB and 2GB chunks to my dbspaces. But now when I try to
> continue
> > adding chunks to my dbspaces, I am getting this message:
> >
> > "Unable to extend 2 reserved pages for Chunk descriptor page in
> ROOT
> > chunk."
> >
> > Guess I have run out of reserved pages with such a small initial
> root
> > chunk. I originally sized the server appropriately, and then the
> customer
> > unexpectedly increased the space needed by an order of 10. I
> haven't
> found
> > specific documentation telling me what I can do to resolve this so
> that I
> > can continue adding chunks. I'm nowhere close to running out of
> disk
> space
> > on my partitions, and as I first mentioned, the root chunk has plenty
> of
> > room.
> >
> > Thanks for any help!
> >
> > Rahn
> >
> > Rahn Payne
> > Rehab Manager, Inc.
> > (903) 823-1171
> > rpayne@rehabmgr.com
> > efax: (508) 445-0537
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
Hi bro
I'd do the following
- dbexport
- destroy current instance. create new instance with a large rootdbs (=>512MB)
- create additional dbspaces for data, logical & physical logs
- MOVE IMMEDIATELY logical & physical logs from rootdbs to new dbspaces
- dbimport data, as last step
hope it helps
greetings
As a slight modification . . .
You can use the HPL to unload and load data quicker than dbexport. If the
instance is small, then it might not be worth the effort, but if your tables
are large, then HPL could be worthwhile.
-----Original Message-----
From: ESTEBAN RIEZNIK [mailto:erieznikr@repsolypf.com]
Sent: Wednesday, June 11, 2003 4:51 PM
To: ids@iiug.org
Subject: Re: Adding chunks [1335]
Hi bro
I'd do the following
- dbexport
- destroy current instance. create new instance with a large rootdbs
(=>512MB)
- create additional dbspaces for data, logical & physical logs
- MOVE IMMEDIATELY logical & physical logs from rootdbs to new dbspaces
- dbimport data, as last step
hope it helps
greetings
"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel
Retail. This email message and all attachments may contain legally
privileged and confidential information intended solely for the use of the
addressee. If you are not the intended recipient, you should immediately
stop reading this message and delete it from the system. Any unauthorized
reading, distribution, copying, or other use of this message or its
attachments is strictly prohibited. All personal messages express solely the
sender's views and not those of WHSmith USA Travel Retail. This message may
not be copied or distributed without this disclaimer."
John,
How does HPL works when you take copy from one unix box to different unix
box, with same Informix verison, we go couple of errors while loading data
... any idea ?
IDS 9.30 UC3
AIX 5.1
Sushil.....
>From: "John Carlson " <John_Carlson@whsmithusa.com>
>To: ids@iiug.org
>Subject: RE: Adding chunks [1344] Date: Thu, 12 Jun 2003 09:28:43 -0400
>(EDT)
>Received: from ace.iiug.org ([216.177.38.212]) by mc10-f22.bay6.hotmail.com
>with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12 Jun 2003 06:35:36 -0700
>Received: from ace.iiug.org (localhost [127.0.0.1])by ace.iiug.org
>(8.12.8p1/8.12.8) with ESMTP id h5CDX8Hu026458;Thu, 12 Jun 2003 09:33:11
>-0400 (EDT)
>Received: (from nobody@localhost)by ace.iiug.org (8.12.8p1/8.12.8/Submit)
>id h5CDShGm026290;Thu, 12 Jun 2003 09:28:43 -0400 (EDT)
>X-Message-Info: QIy1oIULmHeZ0Z8YVLJR2rW+uLaxt5dD
>Message-Id: <200306121328.h5CDShGm026290@ace.iiug.org>
>Apparently-To: forum.subscriber@iiug.org
>Sender: forum.subscriber@iiug.org
>Precedence: bulk
>Return-Path: nobody@ace.iiug.org
>X-OriginalArrivalTime: 12 Jun 2003 13:35:36.0522 (UTC)
>FILETIME=[81876AA0:01C330E7]
>
>As a slight modification . . .
>
>You can use the HPL to unload and load data quicker than dbexport. If the
>instance is small, then it might not be worth the effort, but if your
>tables
>are large, then HPL could be worthwhile.
>
>-----Original Message-----
>From: ESTEBAN RIEZNIK [mailto:erieznikr@repsolypf.com]
>Sent: Wednesday, June 11, 2003 4:51 PM
>To: ids@iiug.org
>Subject: Re: Adding chunks [1335]
>
>
>Hi bro
>
>I'd do the following
>- dbexport
>- destroy current instance. create new instance with a large rootdbs
>(=>512MB)
>- create additional dbspaces for data, logical & physical logs
>- MOVE IMMEDIATELY logical & physical logs from rootdbs to new dbspaces
>- dbimport data, as last step
>
>hope it helps
>greetings
>
>
>"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel
>Retail. This email message and all attachments may contain legally
>privileged and confidential information intended solely for the use of the
>addressee. If you are not the intended recipient, you should immediately
>stop reading this message and delete it from the system. Any unauthorized
>reading, distribution, copying, or other use of this message or its
>attachments is strictly prohibited. All personal messages express solely
>the
>sender's views and not those of WHSmith USA Travel Retail. This message may
>not be copied or distributed without this disclaimer."
>
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
Don't have exact error with me right now, but it was
something like :
"Error on line 5000 cannot load data"
The message was same and it occured every 4 to 5 k lines, table had 3
million records, data was good because the same table was downloaded via
"unload" and loaded with "load" successfully.
Sushil....
>From: John Carlson <John_Carlson@whsmithusa.com>
>To: 'Sushil Shirodkar' <sushilps@hotmail.com>
>CC: ids@iiug.org
>Subject: RE: Adding chunks [1344]
>Date: Thu, 12 Jun 2003 10:03:25 -0400
>MIME-Version: 1.0
>Received: from whsnt04.whsmithusa.com ([12.155.203.39]) by
>mc8-f35.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12 Jun
>2003 07:03:13 -0700
>Received: by whsnt04.whsmithusa.com with Internet Mail Service
>(5.5.2656.59)id <MAS1ZMJH>; Thu, 12 Jun 2003 10:03:29 -0400
>X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP
>Message-ID:
><4D23B231674CD411A877009027EE702C020065A3@whsnt04.whsmithusa.com>
>X-Mailer: Internet Mail Service (5.5.2656.59)
>Return-Path: John_Carlson@whsmithusa.com
>X-OriginalArrivalTime: 12 Jun 2003 14:03:13.0201 (UTC)
>FILETIME=[5CFC9210:01C330EB]
>
>What type of errors?
>
>-----Original Message-----
>From: Sushil Shirodkar [mailto:sushilps@hotmail.com]
>Sent: Thursday, June 12, 2003 9:49 AM
>To: John Carlson
>Cc: ids@iiug.org
>Subject: RE: Adding chunks [1344]
>
>
>John,
>
>How does HPL works when you take copy from one unix box to different unix
>box, with same Informix verison, we go couple of errors while loading data
>... any idea ?
>
>IDS 9.30 UC3
>AIX 5.1
>
>
>Sushil.....
>
>
> >From: "John Carlson " <John_Carlson@whsmithusa.com>
> >To: ids@iiug.org
> >Subject: RE: Adding chunks [1344] Date: Thu, 12 Jun 2003 09:28:43
>-0400
> >(EDT)
> >Received: from ace.iiug.org ([216.177.38.212]) by
> >mc10-f22.bay6.hotmail.com
> >with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12 Jun 2003 06:35:36 -0700
> >Received: from ace.iiug.org (localhost [127.0.0.1])by ace.iiug.org
> >(8.12.8p1/8.12.8) with ESMTP id h5CDX8Hu026458;Thu, 12 Jun 2003 09:33:11
> >-0400 (EDT)
> >Received: (from nobody@localhost)by ace.iiug.org (8.12.8p1/8.12.8/Submit)
> >id h5CDShGm026290;Thu, 12 Jun 2003 09:28:43 -0400 (EDT)
> >X-Message-Info: QIy1oIULmHeZ0Z8YVLJR2rW+uLaxt5dD
> >Message-Id: <200306121328.h5CDShGm026290@ace.iiug.org>
> >Apparently-To: forum.subscriber@iiug.org
> >Sender: forum.subscriber@iiug.org
> >Precedence: bulk
> >Return-Path: nobody@ace.iiug.org
> >X-OriginalArrivalTime: 12 Jun 2003 13:35:36.0522 (UTC)
> >FILETIME=[81876AA0:01C330E7]
> >
> >As a slight modification . . .
> >
> >You can use the HPL to unload and load data quicker than dbexport. If
> >the instance is small, then it might not be worth the effort, but if
> >your tables are large, then HPL could be worthwhile.
> >
> >-----Original Message-----
> >From: ESTEBAN RIEZNIK [mailto:erieznikr@repsolypf.com]
> >Sent: Wednesday, June 11, 2003 4:51 PM
> >To: ids@iiug.org
> >Subject: Re: Adding chunks [1335]
> >
> >
> >Hi bro
> >
> >I'd do the following
> >- dbexport
> >- destroy current instance. create new instance with a large rootdbs
> >(=>512MB)
> >- create additional dbspaces for data, logical & physical logs
> >- MOVE IMMEDIATELY logical & physical logs from rootdbs to new dbspaces
> >- dbimport data, as last step
> >
> >hope it helps
> >greetings
> >
> >
> >"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA
> >Travel Retail. This email message and all attachments may contain
> >legally privileged and confidential information intended solely for the
> >use of the addressee. If you are not the intended recipient, you should
> >immediately stop reading this message and delete it from the system.
> >Any unauthorized reading, distribution, copying, or other use of this
> >message or its attachments is strictly prohibited. All personal
> >messages express solely the sender's views and not those of WHSmith USA
> >Travel Retail. This message may not be copied or distributed without
> >this disclaimer."
> >
>
>_________________________________________________________________
>Tired of spam? Get advanced junk mail protection with MSN 8.
>http://join.msn.com/?page=features/junkmail
>
>"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel
>Retail. This email message and all attachments may contain legally
>privileged and confidential information intended solely for the use of the
>addressee. If you are not the intended recipient, you should immediately
>stop reading this message and delete it from the system. Any unauthorized
>reading, distribution, copying, or other use of this message or its
>attachments is strictly prohibited. All personal messages express solely
>the
>sender's views and not those of WHSmith USA Travel Retail. This message may
>not be copied or distributed without this disclaimer."
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
express mode.
>From: John Carlson <John_Carlson@whsmithusa.com>
>To: 'Sushil Shirodkar' <sushilps@hotmail.com>
>CC: ids@iiug.org
>Subject: RE: Adding chunks [1344]
>Date: Thu, 12 Jun 2003 11:50:13 -0400
>MIME-Version: 1.0
>Received: from whsnt04.whsmithusa.com ([12.155.203.39]) by
>mc4-f7.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12 Jun
>2003 08:50:01 -0700
>Received: by whsnt04.whsmithusa.com with Internet Mail Service
>(5.5.2656.59)id <MAS1ZMWY>; Thu, 12 Jun 2003 11:50:17 -0400
>X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP
>Message-ID:
><4D23B231674CD411A877009027EE702C020065A4@whsnt04.whsmithusa.com>
>X-Mailer: Internet Mail Service (5.5.2656.59)
>Return-Path: John_Carlson@whsmithusa.com
>X-OriginalArrivalTime: 12 Jun 2003 15:50:01.0702 (UTC)
>FILETIME=[48C03860:01C330FA]
>
>Never have seen that before . . . deluxe or express mode?
>
>-----Original Message-----
>From: Sushil Shirodkar [mailto:sushilps@hotmail.com]
>Sent: Thursday, June 12, 2003 11:41 AM
>To: John Carlson
>Cc: ids@iiug.org
>Subject: RE: Adding chunks [1344]
>
>
>Don't have exact error with me right now, but it was something like :
>"Error
>on line 5000 cannot load data"
>
>The message was same and it occured every 4 to 5 k lines, table had 3
>million records, data was good because the same table was downloaded via
>"unload" and loaded with "load" successfully.
>
>Sushil....
>
>
>
> >From: John Carlson <John_Carlson@whsmithusa.com>
> >To: 'Sushil Shirodkar' <sushilps@hotmail.com>
> >CC: ids@iiug.org
> >Subject: RE: Adding chunks [1344]
> >Date: Thu, 12 Jun 2003 10:03:25 -0400
> >MIME-Version: 1.0
> >Received: from whsnt04.whsmithusa.com ([12.155.203.39]) by
> >mc8-f35.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12
>Jun
>
> >2003 07:03:13 -0700
> >Received: by whsnt04.whsmithusa.com with Internet Mail Service
> >(5.5.2656.59)id <MAS1ZMJH>; Thu, 12 Jun 2003 10:03:29 -0400
> >X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP
> >Message-ID:
> ><4D23B231674CD411A877009027EE702C020065A3@whsnt04.whsmithusa.com>
> >X-Mailer: Internet Mail Service (5.5.2656.59)
> >Return-Path: John_Carlson@whsmithusa.com
> >X-OriginalArrivalTime: 12 Jun 2003 14:03:13.0201 (UTC)
> >FILETIME=[5CFC9210:01C330EB]
> >
> >What type of errors?
> >
> >-----Original Message-----
> >From: Sushil Shirodkar [mailto:sushilps@hotmail.com]
> >Sent: Thursday, June 12, 2003 9:49 AM
> >To: John Carlson
> >Cc: ids@iiug.org
> >Subject: RE: Adding chunks [1344]
> >
> >
> >John,
> >
> >How does HPL works when you take copy from one unix box to different
> >unix box, with same Informix verison, we go couple of errors while
> >loading data ... any idea ?
> >
> >IDS 9.30 UC3
> >AIX 5.1
> >
> >
> >Sushil.....
> >
> >
> > >From: "John Carlson " <John_Carlson@whsmithusa.com>
> > >To: ids@iiug.org
> > >Subject: RE: Adding chunks [1344] Date: Thu, 12 Jun 2003 09:28:43
> >-0400
> > >(EDT)
> > >Received: from ace.iiug.org ([216.177.38.212]) by
> > >mc10-f22.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu,
> > >12 Jun 2003 06:35:36 -0700
> > >Received: from ace.iiug.org (localhost [127.0.0.1])by ace.iiug.org
> > >(8.12.8p1/8.12.8) with ESMTP id h5CDX8Hu026458;Thu, 12 Jun 2003
> > >09:33:11 -0400 (EDT)
> > >Received: (from nobody@localhost)by ace.iiug.org
> > >(8.12.8p1/8.12.8/Submit) id h5CDShGm026290;Thu, 12 Jun 2003 09:28:43
> > >-0400 (EDT)
> > >X-Message-Info: QIy1oIULmHeZ0Z8YVLJR2rW+uLaxt5dD
> > >Message-Id: <200306121328.h5CDShGm026290@ace.iiug.org>
> > >Apparently-To: forum.subscriber@iiug.org
> > >Sender: forum.subscriber@iiug.org
> > >Precedence: bulk
> > >Return-Path: nobody@ace.iiug.org
> > >X-OriginalArrivalTime: 12 Jun 2003 13:35:36.0522 (UTC)
> > >FILETIME=[81876AA0:01C330E7]
> > >
> > >As a slight modification . . .
> > >
> > >You can use the HPL to unload and load data quicker than dbexport.
> > >If the instance is small, then it might not be worth the effort, but
> > >if your tables are large, then HPL could be worthwhile.
> > >
> > >-----Original Message-----
> > >From: ESTEBAN RIEZNIK [mailto:erieznikr@repsolypf.com]
> > >Sent: Wednesday, June 11, 2003 4:51 PM
> > >To: ids@iiug.org
> > >Subject: Re: Adding chunks [1335]
> > >
> > >
> > >Hi bro
> > >
> > >I'd do the following
> > >- dbexport
> > >- destroy current instance. create new instance with a large rootdbs
> > >(=>512MB)
> > >- create additional dbspaces for data, logical & physical logs
> > >- MOVE IMMEDIATELY logical & physical logs from rootdbs to new
> > >dbspaces
> > >- dbimport data, as last step
> > >
> > >hope it helps
> > >greetings
> > >
> > >
> > >"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA
> > >Travel Retail. This email message and all attachments may contain
> > >legally privileged and confidential information intended solely for
> > >the use of the addressee. If you are not the intended recipient, you
> > >should immediately stop reading this message and delete it from the
> > >system. Any unauthorized reading, distribution, copying, or other use
> > >of this message or its attachments is strictly prohibited. All
> > >personal messages express solely the sender's views and not those of
> > >WHSmith USA Travel Retail. This message may not be copied or
> > >distributed without this disclaimer."
> > >
> >
> >_________________________________________________________________
> >Tired of spam? Get advanced junk mail protection with MSN 8.
> >http://join.msn.com/?page=features/junkmail
> >
> >"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA
> >Travel Retail. This email message and all attachments may contain
> >legally privileged and confidential information intended solely for the
> >use of the addressee. If you are not the intended recipient, you should
> >immediately stop reading this message and delete it from the system.
> >Any unauthorized reading, distribution, copying, or other use of this
> >message or its attachments is strictly prohibited. All personal
> >messages express solely the sender's views and not those of WHSmith USA
> >Travel Retail. This message may not be copied or distributed without
> >this disclaimer."
>
>_________________________________________________________________
>STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>"CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel
>Retail. This email message and all attachments may contain legally
>privileged and confidential information intended solely for the use of the
>addressee. If you are not the intended recipient, you should immediately
>stop reading this message and delete it from the system. Any unauthorized
>reading, distribution, copying, or other use of this message or its
>attachments is strictly prohibited. All personal messages express solely
>the
>sender's views and not those of WHSmith USA Travel Retail. This message may
>not be copied or distributed without this disclaimer