Oninit cdi / Archive
Talk to an expert →

RE: DBSPACETEMP Problem.

Posted in 2000

Topics: Storage & Space Management, Server Administration, Platform-Specific Issues

Sinha, Niraj — — source: Informix-list mailing list archive (1991-1998)

Have you tried editing the onconfig file. Make sure that you do not have spaces between the two tmpdbspaces . It should : tmpdsb1,tmpdbs2 Niraj -----Original Message----- From: Steven Mastandrea [mailto:stevem@cstech.com] Sent: Tuesday, December 12, 2000 9:24 PM To: informix-list@iiug.org Subject: DBSPACETEMP Problem. I am having a problem with Informix Dynamic Server Version 7.31.UC2 on a Solaris 2.6 machine. I have created 2 1g temporary chunks called temp1 and temp2, whose onstat profile is listed below: c296e50 3 2001 3 1 N T informix temp1 c296f10 4 2001 4 1 N T informix temp2 I changed the DBSPACETEMP variable using onmonitor to be temp1:temp2, saved the changes and reinitialized the server (via onmode -ky;oninit). However, the temp spaces are not used. I tested by doing a 'select * from orders into temp duh' and watched the free space for the chunks, and informix is using the root dbspace instead of the temp spaces. No errors are reported in the online.log file about being an invalid tempspace, and the online.log does confirm that the DBSPACETEMP parameter was changed. I also tried setting DBSPACETEMP to just temp1 and still got the same problem. Does anyone have any ideas what is causing this problem or what I need to do to alleviate the problem? Thanks, --Steven ----------------------------------------------------- Steven Mastandrea stevem@cstech.com Database Administrator 847.397.7300 CSTech, Inc. Schaumburg, IL

↪ replying to Sinha, Niraj
hanna_shaw@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

There is a limitation for chunk size in Informix. It's 2GB. Did you mean you created 21GB temp spaces which splited into only 2 chunks? Then the chunk size is bigger than the limitation. So the server can't recognize and use them. In article <91821h$62s$1@news.xmission.com>, "Sinha, Niraj" <niraj.sinha@BondBook.com> wrote: > > Have you tried editing the onconfig file. Make sure that you do not have > spaces between the two tmpdbspaces . It should : > tmpdsb1,tmpdbs2 > > Niraj > > -----Original Message----- > From: Steven Mastandrea [mailto:stevem@cstech.com] > Sent: Tuesday, December 12, 2000 9:24 PM > To: informix-list@iiug.org > Subject: DBSPACETEMP Problem. > > I am having a problem with Informix Dynamic Server Version 7.31.UC2 > on a Solaris 2.6 machine. I have created 2 1g temporary chunks called > temp1 and temp2, whose onstat profile is listed below: > > c296e50 3 2001 3 1 N T informix temp1 > c296f10 4 2001 4 1 N T informix temp2 > > I changed the DBSPACETEMP variable using onmonitor to be > temp1:temp2, saved the changes and reinitialized the server > (via onmode -ky;oninit). However, the temp spaces are not used. > > I tested by doing a 'select * from orders into temp duh' > and watched the free space for the chunks, and informix is using the > root dbspace instead of the temp spaces. > > No errors are reported in the online.log file about > being an invalid tempspace, and the online.log does confirm that the > DBSPACETEMP parameter was changed. > > I also tried setting DBSPACETEMP to just temp1 and still got the > same problem. > > Does anyone have any ideas what is causing this problem or what I > need to do to alleviate the problem? > > Thanks, > > --Steven > > ----------------------------------------------------- > Steven Mastandrea stevem@cstech.com > Database Administrator 847.397.7300 > CSTech, Inc. Schaumburg, IL > > Sent via Deja.com http://www.deja.com/

Glossary