RE: Parallel index build....(how much tempspace)

P.p.s.... The timing of the 6 messages in online.log came out as follows, so perhaps it's not a "one message for each dbspace" issue?... (I was not awake at the time the SAP upgrade team hit the problem... This is all "after the fact" research)... 23:03:51 WARNING: Not enough temp space for parallel index build. Space required = 6188720 pages; space available = 4193792 pages. Partial index build started. 23:50:24 WARNING: Not enough temp space for parallel index build. Space required = 6188720 pages; space available = 4170192 pages. Partial index build started. Thu Jan 20 00:09:11 2005 00:09:11 WARNING: Not enough temp space for parallel index build. Space required = 6188720 pages; space available = 4170192 pages. Partial index build started. 00:32:59 WARNING: Not enough temp space for parallel index build. Space required = 6188720 pages; space available = 4170192 pages. Partial index build started. 01:21:42 WARNING: Not enough temp space for parallel index build. Space required = 6188720 pages; space available = 4168592 pages. Partial index build started. 01:40:26 WARNING: Not enough temp space for parallel index build. Space required = 6188720 pages; space available = 4168592 pages. Partial index build started. -----Original Message----- From: Sebastian, Norma J. Sent: Thursday, January 20, 2005 1:49 PM To: Sebastian, Norma J.; informix-list@iiug.org Subject: RE: Parallel index build....(how much tempspace) P.s.... These are the indices on the large table. At this time, I don't know if SAP is trying to rebuild all or less-than-all of them. create unique index "sapr3".zztl01a___0 on "sapr3".zztl01a (rclnt,gl_sirid) using btree in psapzztli1 ; create index "sapr3".zztl01a___1 on "sapr3".zztl01a (rcntr,racct,rfarea) using btree in psapzztli2 ; create unique index "sapr3".zztl01a___2 on "sapr3".zztl01a (rclnt,docnr,ryear,docct,rbukrs,rldnr,docln) using btree in psapzztli2 ; create index "sapr3".zztl01a___3 on "sapr3".zztl01a (rclnt,refdocnr,refryear,refdocct,rbukrs,rldnr,refdocln) using btree in psapzztli1 ; Thanks, NJ -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Sebastian, Norma J. Sent: Thursday, January 20, 2005 11:55 AM To: informix-list@iiug.org Subject: Parallel index build....(how much tempspace) Hi, Responses from this group of wise folks is generally faster than RTFM :) Having said that, ... I submit my issue... I have IDS 9.40.FC3XD, on solaris 9. System Configuration: Sun Microsystems sun4u Sun Fire 880 System clock frequency: 150 MHz Memory size: 16384 Megabytes ======= CPUs ============================ Run E$ CPU CPU Brd CPU MHz MB Impl. Mask --- ----- ---- ---- ------- ---- A 0 1200 8.0 US-III+ 11.1 B 1 1200 8.0 US-III+ 11.1 A 2 1200 8.0 US-III+ 11.1 B 3 1200 8.0 US-III+ 11.1 C 4 1200 8.0 US-III+ 11.1 D 5 1200 8.0 US-III+ 11.1 C 6 1200 8.0 US-III+ 11.1 D 7 1200 8.0 US-III+ 11.1 I have 4 temp dbspaces at 2 GB each. They are all listed in my $ONCONFIG for DBSPACETEMP. We have SAP. We are upgrading from SAP R/3 to SAP Enterprise. I have a table (ZZTL01A) round-robin frag'd into 6 dbspaces of 12 GB each. These are accompanied by 2 index dbspaces, one of 16 GB, and one of 12 GB. During the SAP upgrade, it rebuilds an index on the large table. During the index rebuild, IDS gives 6 of these messages: 01:40:26 WARNING: Not enough temp space for parallel index build. Space required = 6188720 pages; space available = 4168592 pages. Partial index build started. Since I am getting 6 messages, I assume I have one index sort/build thread active per dbspace the table is in (6 frags). To help the engine process this faster, 1) Is my best bet to grow the 4 temp dbspaces and leave it at that? 2) Or grow the 4 tempdbspaces plus add 2 more (such that I have 6 temp dbspaces...one for each sort thread)? 3) Or leave the 4 temp dbspaces alone, but add a 5th, very large one? I have seen option 3 be helpful when I was in a "hurry up and do something" mode, but now that there is time to figure this out... I am leaning toward option 2. What do ya'll think? Thanks for the input, Norma Jean ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================ sending to informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================ sending to informix-list