Error 229 with XPS

We are running Informix XPS 8.21.UD2X2 on AIX 4.3.3.0. Recently I dropped a couple of tables and recreated them with the same permissions and then loaded the data back into them. Now we have a script that is getting stuck on a delete statement. The user has the same permissions on the table as the ones before I dropped the table. However, the script is now giving us and error 229: Could not open or create a temporary file. The user ID has deletepermissions, and the temp dbspace is out there. Here is the setting in the ONCONFIG: DBSPACETEMP TEMP # Default temp dbspaces Here is the temp dbspace: $onstat -d |grep temp 70076480 4 2001 7 7 N T informix tempdbs.1 70076548 5 2001 8 7 N T informix tempdbs.2 70076610 6 2001 9 7 N T informix tempdbs.3 700766d8 7 2001 10 7 N T informix tempdbs.4 70077f10 7 4 0 487424 486127 PO- /ifmx/ifmx00062.1.1/tempdbs.1 70095824 8 5 0 487424 486127 PO- /ifmx/ifmx00062.1.2/tempdbs.1 70095914 9 6 0 487424 486123 PO- /ifmx/ifmx00062.1.3/tempdbs.1 70095a04 10 7 0 487424 486121 PO- /ifmx/ifmx00062.1.4/tempdbs.1 70095af4 11 4 0 487424 487421 PO- /ifmx/ifmx00062.1.1/tempdbs.2 70095be4 12 5 0 487424 487421 PO- /ifmx/ifmx00062.1.2/tempdbs.2 70095cd4 13 6 0 487424 487421 PO- /ifmx/ifmx00062.1.3/tempdbs.2 70095dc4 14 7 0 487424 487421 PO- /ifmx/ifmx00062.1.4/tempdbs.2 70a21000 71 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.3 70a210f0 72 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.3 70a211e0 73 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.3 70a212d0 74 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.3 70a213c0 75 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.4 70a214b0 76 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.4 70a215a0 77 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.4 70a21690 78 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.4 70a21780 79 4 0 524287 524284 PO- /ifmx/ifmx00062.1.1/tempdbs.5 70a21870 80 5 0 524287 524284 PO- /ifmx/ifmx00062.1.2/tempdbs.5 70a21960 81 6 0 524287 524284 PO- /ifmx/ifmx00062.1.3/tempdbs.5 70a21a50 82 7 0 524287 524284 PO- /ifmx/ifmx00062.1.4/tempdbs.5 70a25000 139 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.6 70a250f0 140 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.6 70a251e0 141 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.6 70a252d0 142 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.6 70a253c0 143 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.7 70a254b0 144 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.7 70a255a0 145 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.7 70a25690 146 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.7 There is obviously plenty of space. Can anyone think of a reason why the user wouldn't be able to create or open a temporary file? The delete statement is something like this: delete from table1 where exists (select * from t2, t3, t4, t5 where...) Thanks in advance. Keith Schleicher IT Database Administrator Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com<mailto:2242108358@messaging.sprintpcs.com> Page: 2242108358@sprint.skytel.com<mailto:2242108358@sprint.skytel.com> For more information, use our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#Dat abaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Databas e+Management> This message, including any attachments, is the property of Sears Holdings Corporation and/or one of its subsidiaries. It is confidential and may contain proprietary or legally privileged information. If you are not the intended recipient, please delete it without reading the contents. Thank you.

The reason should be clear once you see the ISAM error. XPS is a different engine but it should raise the "second" error. Please run it in a tool that shows both errors and come back to us. Does it abort immediately or does it take a while? Regards On Nov 9, 2013 1:29 PM, "Schleicher, Keith" <Keith.Schleicher@searshc.com> wrote: > We are running Informix XPS 8.21.UD2X2 on AIX 4.3.3.0. Recently I dropped a > couple of tables and recreated them with the same permissions and then > loaded > the data back into them. Now we have a script that is getting stuck on a > delete statement. The user has the same permissions on the table as the > ones > before I dropped the table. However, the script is now giving us and error > 229: Could not open or create a temporary file. The user ID has delete> permissions, and the temp dbspace is out there. Here is the setting in the > ONCONFIG: > > DBSPACETEMP TEMP # Default temp dbspaces> > Here is the temp dbspace: > > $onstat -d |grep temp > 70076480 4 2001 7 7 N T informix tempdbs.1 > 70076548 5 2001 8 7 N T informix tempdbs.2 > 70076610 6 2001 9 7 N T informix tempdbs.3 > 700766d8 7 2001 10 7 N T informix tempdbs.4 > 70077f10 7 4 0 487424 486127 PO- /ifmx/ifmx00062.1.1/tempdbs.1 > 70095824 8 5 0 487424 486127 PO- /ifmx/ifmx00062.1.2/tempdbs.1 > 70095914 9 6 0 487424 486123 PO- /ifmx/ifmx00062.1.3/tempdbs.1 > 70095a04 10 7 0 487424 486121 PO- /ifmx/ifmx00062.1.4/tempdbs.1 > 70095af4 11 4 0 487424 487421 PO- /ifmx/ifmx00062.1.1/tempdbs.2 > 70095be4 12 5 0 487424 487421 PO- /ifmx/ifmx00062.1.2/tempdbs.2 > 70095cd4 13 6 0 487424 487421 PO- /ifmx/ifmx00062.1.3/tempdbs.2 > 70095dc4 14 7 0 487424 487421 PO- /ifmx/ifmx00062.1.4/tempdbs.2 > 70a21000 71 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.3 > 70a210f0 72 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.3 > 70a211e0 73 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.3 > 70a212d0 74 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.3 > 70a213c0 75 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.4 > 70a214b0 76 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.4 > 70a215a0 77 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.4 > 70a21690 78 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.4 > 70a21780 79 4 0 524287 524284 PO- /ifmx/ifmx00062.1.1/tempdbs.5 > 70a21870 80 5 0 524287 524284 PO- /ifmx/ifmx00062.1.2/tempdbs.5 > 70a21960 81 6 0 524287 524284 PO- /ifmx/ifmx00062.1.3/tempdbs.5 > 70a21a50 82 7 0 524287 524284 PO- /ifmx/ifmx00062.1.4/tempdbs.5 > 70a25000 139 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.6 > 70a250f0 140 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.6 > 70a251e0 141 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.6 > 70a252d0 142 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.6 > 70a253c0 143 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.7 > 70a254b0 144 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.7 > 70a255a0 145 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.7 > 70a25690 146 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.7 > > There is obviously plenty of space. Can anyone think of a reason why the > user > wouldn't be able to create or open a temporary file? The delete statement > is > something like this: > > delete from table1 > where exists > (select * from t2, t3, t4, t5 > where...)> > Thanks in advance. > > Keith Schleicher > IT Database Administrator > Cell: 224-210-8358 > Blackberry: > 2242108358@messaging.sprintpcs.com<mailto: > 2242108358@messaging.sprintpcs.com> > Page: 2242108358@sprint.skytel.com<mailto:2242108358@sprint.skytel.com> > > For more information, use our DBA Wiki page link below: > > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#Dat abaseManagement > < > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management > > > > This message, including any attachments, is the property of Sears Holdings > Corporation and/or one of its subsidiaries. It is confidential and may > contain > proprietary or legally privileged information. If you are not the intended > recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bf0d1b4c9f89704eac207ce

We figured out that the tempdbs fills up from the query. We don't have any= space to allocate to the dbserver, so we are looking at taking another app= roach to deleting the rows, whether it is changing the query or using somet= hing else. Keith Schleicher IT Database Administrator Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com Page: 2242108358@sprint.skytel.com=A0 For more information, use our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Ferna= ndo Nunes Sent: Saturday, November 09, 2013 12:43 PM To: ids@iiug.org Subject: Re: Error 229 with XPS [31904] The reason should be clear once you see the ISAM error. XPS is a different = engine but it should raise the "second" error.=20 Please run it in a tool that shows both errors and come back to us. Does it= abort immediately or does it take a while?=20 Regards On Nov 9, 2013 1:29 PM, "Schleicher, Keith" <Keith.Schleicher@searshc.com> wrote:=20 > We are running Informix XPS 8.21.UD2X2 on AIX 4.3.3.0. Recently I=20 > dropped a couple of tables and recreated them with the same=20 > permissions and then loaded the data back into them. Now we have a=20 > script that is getting stuck on a delete statement. The user has the=20 > same permissions on the table as the ones before I dropped the table.=20 > However, the script is now giving us and error > 229: Could not open or create a temporary file. The user ID has delete=20> permissions, and the temp dbspace is out there. Here is the setting in=20 > the > ONCONFIG:=20 >=20 > DBSPACETEMP TEMP # Default temp dbspaces >=20> Here is the temp dbspace:=20 >=20 > $onstat -d |grep temp > 70076480 4 2001 7 7 N T informix tempdbs.1 > 70076548 5 2001 8 7 N T informix tempdbs.2 > 70076610 6 2001 9 7 N T informix tempdbs.3 > 700766d8 7 2001 10 7 N T informix tempdbs.4 > 70077f10 7 4 0 487424 486127 PO- /ifmx/ifmx00062.1.1/tempdbs.1 > 70095824 8 5 0 487424 486127 PO- /ifmx/ifmx00062.1.2/tempdbs.1 > 70095914 9 6 0 487424 486123 PO- /ifmx/ifmx00062.1.3/tempdbs.1 > 70095a04 10 7 0 487424 486121 PO- /ifmx/ifmx00062.1.4/tempdbs.1 > 70095af4 11 4 0 487424 487421 PO- /ifmx/ifmx00062.1.1/tempdbs.2 > 70095be4 12 5 0 487424 487421 PO- /ifmx/ifmx00062.1.2/tempdbs.2 > 70095cd4 13 6 0 487424 487421 PO- /ifmx/ifmx00062.1.3/tempdbs.2 > 70095dc4 14 7 0 487424 487421 PO- /ifmx/ifmx00062.1.4/tempdbs.2 > 70a21000 71 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.3 > 70a210f0 72 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.3 > 70a211e0 73 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.3 > 70a212d0 74 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.3 > 70a213c0 75 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.4 > 70a214b0 76 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.4 > 70a215a0 77 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.4 > 70a21690 78 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.4 > 70a21780 79 4 0 524287 524284 PO- /ifmx/ifmx00062.1.1/tempdbs.5 > 70a21870 80 5 0 524287 524284 PO- /ifmx/ifmx00062.1.2/tempdbs.5 > 70a21960 81 6 0 524287 524284 PO- /ifmx/ifmx00062.1.3/tempdbs.5 > 70a21a50 82 7 0 524287 524284 PO- /ifmx/ifmx00062.1.4/tempdbs.5 > 70a25000 139 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.6 > 70a250f0 140 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.6 > 70a251e0 141 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.6 > 70a252d0 142 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.6 > 70a253c0 143 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.7 > 70a254b0 144 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.7 > 70a255a0 145 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.7 > 70a25690 146 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.7 >=20 > There is obviously plenty of space. Can anyone think of a reason why=20 > the user wouldn't be able to create or open a temporary file? The=20 > delete statement is something like this: >=20 > delete from table1 > where exists > (select * from t2, t3, t4, t5 > where...)>=20 > Thanks in advance.=20 >=20 > Keith Schleicher > IT Database Administrator > Cell: 224-210-8358 > Blackberry:=20 > 2242108358@messaging.sprintpcs.com<mailto:=20 > 2242108358@messaging.sprintpcs.com> > Page:=20 > 2242108358@sprint.skytel.com<mailto:2242108358@sprint.skytel.com> >=20 > For more information, use our DBA Wiki page link below:=20 >=20 >=20 >=20 http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement=20 > < > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Mana > gement > >=20 >=20 > This message, including any attachments, is the property of Sears=20 > Holdings Corporation and/or one of its subsidiaries. It is=20 > confidential and may contain proprietary or legally privileged=20 > information. If you are not the intended recipient, please delete it=20 > without reading the contents. Thank you. >=20 >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --047d7bf0d1b4c9f89704eac207ce=20 ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

Yes, I know why. Change DBSPACETEMP to the following and restart the engine: DBSPACETEMP tempdbs.1,tempdbs.2,tempdbs.3,tempdbs.4 Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Nov 9, 2013 at 5:28 AM, Schleicher, Keith < Keith.Schleicher@searshc.com> wrote: > We are running Informix XPS 8.21.UD2X2 on AIX 4.3.3.0. Recently I dropped a > couple of tables and recreated them with the same permissions and then > loaded > the data back into them. Now we have a script that is getting stuck on a > delete statement. The user has the same permissions on the table as the > ones > before I dropped the table. However, the script is now giving us and error > 229: Could not open or create a temporary file. The user ID has delete> permissions, and the temp dbspace is out there. Here is the setting in the > ONCONFIG: > > DBSPACETEMP TEMP # Default temp dbspaces> > Here is the temp dbspace: > > $onstat -d |grep temp > 70076480 4 2001 7 7 N T informix tempdbs.1 > 70076548 5 2001 8 7 N T informix tempdbs.2 > 70076610 6 2001 9 7 N T informix tempdbs.3 > 700766d8 7 2001 10 7 N T informix tempdbs.4 > 70077f10 7 4 0 487424 486127 PO- /ifmx/ifmx00062.1.1/tempdbs.1 > 70095824 8 5 0 487424 486127 PO- /ifmx/ifmx00062.1.2/tempdbs.1 > 70095914 9 6 0 487424 486123 PO- /ifmx/ifmx00062.1.3/tempdbs.1 > 70095a04 10 7 0 487424 486121 PO- /ifmx/ifmx00062.1.4/tempdbs.1 > 70095af4 11 4 0 487424 487421 PO- /ifmx/ifmx00062.1.1/tempdbs.2 > 70095be4 12 5 0 487424 487421 PO- /ifmx/ifmx00062.1.2/tempdbs.2 > 70095cd4 13 6 0 487424 487421 PO- /ifmx/ifmx00062.1.3/tempdbs.2 > 70095dc4 14 7 0 487424 487421 PO- /ifmx/ifmx00062.1.4/tempdbs.2 > 70a21000 71 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.3 > 70a210f0 72 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.3 > 70a211e0 73 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.3 > 70a212d0 74 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.3 > 70a213c0 75 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.4 > 70a214b0 76 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.4 > 70a215a0 77 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.4 > 70a21690 78 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.4 > 70a21780 79 4 0 524287 524284 PO- /ifmx/ifmx00062.1.1/tempdbs.5 > 70a21870 80 5 0 524287 524284 PO- /ifmx/ifmx00062.1.2/tempdbs.5 > 70a21960 81 6 0 524287 524284 PO- /ifmx/ifmx00062.1.3/tempdbs.5 > 70a21a50 82 7 0 524287 524284 PO- /ifmx/ifmx00062.1.4/tempdbs.5 > 70a25000 139 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.6 > 70a250f0 140 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.6 > 70a251e0 141 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.6 > 70a252d0 142 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.6 > 70a253c0 143 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.7 > 70a254b0 144 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.7 > 70a255a0 145 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.7 > 70a25690 146 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.7 > > There is obviously plenty of space. Can anyone think of a reason why the > user > wouldn't be able to create or open a temporary file? The delete statement > is > something like this: > > delete from table1 > where exists > (select * from t2, t3, t4, t5 > where...)> > Thanks in advance. > > Keith Schleicher > IT Database Administrator > Cell: 224-210-8358 > Blackberry: > 2242108358@messaging.sprintpcs.com<mailto: > 2242108358@messaging.sprintpcs.com> > Page: 2242108358@sprint.skytel.com<mailto:2242108358@sprint.skytel.com> > > For more information, use our DBA Wiki page link below: > > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#Dat abaseManagement > < > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management > > > > This message, including any attachments, is the property of Sears Holdings > Corporation and/or one of its subsidiaries. It is confidential and may > contain > proprietary or legally privileged information. If you are not the intended > recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e011827ae1cd52604eac86d94

You can use my dbdelete utility. It is included in the package utils2_ak which you can download from the IIUG Software Repository. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Nov 9, 2013 at 10:19 AM, Schleicher, Keith < Keith.Schleicher@searshc.com> wrote: > We figured out that the tempdbs fills up from the query. We don't have any= > space to allocate to the dbserver, so we are looking at taking another app= > roach to deleting the rows, whether it is changing the query or using > somet= > hing else. > > Keith Schleicher > IT Database Administrator > Cell: 224-210-8358 > Blackberry: 2242108358@messaging.sprintpcs.com > Page: 2242108358@sprint.skytel.com=A0 > > For more information, use our DBA Wiki page link below: > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= > t#DatabaseManagement > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Ferna= > ndo Nunes > Sent: Saturday, November 09, 2013 12:43 PM > To: ids@iiug.org > Subject: Re: Error 229 with XPS [31904] > > The reason should be clear once you see the ISAM error. XPS is a different > = > engine but it should raise the "second" error.=20 > > Please run it in a tool that shows both errors and come back to us. Does > it= > abort immediately or does it take a while?=20 > > Regards > On Nov 9, 2013 1:29 PM, "Schleicher, Keith" <Keith.Schleicher@searshc.com> > wrote:=20 > > > We are running Informix XPS 8.21.UD2X2 on AIX 4.3.3.0. Recently I=20 > > dropped a couple of tables and recreated them with the same=20 > > permissions and then loaded the data back into them. Now we have a=20 > > script that is getting stuck on a delete statement. The user has the=20 > > same permissions on the table as the ones before I dropped the table.=20 > > However, the script is now giving us and error > > 229: Could not open or create a temporary file. The user ID has delete=20> > permissions, and the temp dbspace is out there. Here is the setting in=20 > > the > > ONCONFIG:=20 > >=20 > > DBSPACETEMP TEMP # Default temp dbspaces > >=20> > Here is the temp dbspace:=20 > >=20 > > $onstat -d |grep temp > > 70076480 4 2001 7 7 N T informix tempdbs.1 > > 70076548 5 2001 8 7 N T informix tempdbs.2 > > 70076610 6 2001 9 7 N T informix tempdbs.3 > > 700766d8 7 2001 10 7 N T informix tempdbs.4 > > 70077f10 7 4 0 487424 486127 PO- /ifmx/ifmx00062.1.1/tempdbs.1 > > 70095824 8 5 0 487424 486127 PO- /ifmx/ifmx00062.1.2/tempdbs.1 > > 70095914 9 6 0 487424 486123 PO- /ifmx/ifmx00062.1.3/tempdbs.1 > > 70095a04 10 7 0 487424 486121 PO- /ifmx/ifmx00062.1.4/tempdbs.1 > > 70095af4 11 4 0 487424 487421 PO- /ifmx/ifmx00062.1.1/tempdbs.2 > > 70095be4 12 5 0 487424 487421 PO- /ifmx/ifmx00062.1.2/tempdbs.2 > > 70095cd4 13 6 0 487424 487421 PO- /ifmx/ifmx00062.1.3/tempdbs.2 > > 70095dc4 14 7 0 487424 487421 PO- /ifmx/ifmx00062.1.4/tempdbs.2 > > 70a21000 71 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.3 > > 70a210f0 72 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.3 > > 70a211e0 73 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.3 > > 70a212d0 74 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.3 > > 70a213c0 75 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.4 > > 70a214b0 76 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.4 > > 70a215a0 77 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.4 > > 70a21690 78 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.4 > > 70a21780 79 4 0 524287 524284 PO- /ifmx/ifmx00062.1.1/tempdbs.5 > > 70a21870 80 5 0 524287 524284 PO- /ifmx/ifmx00062.1.2/tempdbs.5 > > 70a21960 81 6 0 524287 524284 PO- /ifmx/ifmx00062.1.3/tempdbs.5 > > 70a21a50 82 7 0 524287 524284 PO- /ifmx/ifmx00062.1.4/tempdbs.5 > > 70a25000 139 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.6 > > 70a250f0 140 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.6 > > 70a251e0 141 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.6 > > 70a252d0 142 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.6 > > 70a253c0 143 4 0 512000 511997 PO- /ifmx/ifmx00062.1.1/tempdbs.7 > > 70a254b0 144 5 0 512000 511997 PO- /ifmx/ifmx00062.1.2/tempdbs.7 > > 70a255a0 145 6 0 512000 511997 PO- /ifmx/ifmx00062.1.3/tempdbs.7 > > 70a25690 146 7 0 512000 511997 PO- /ifmx/ifmx00062.1.4/tempdbs.7 > >=20 > > There is obviously plenty of space. Can anyone think of a reason why=20 > > the user wouldn't be able to create or open a temporary file? The=20 > > delete statement is something like this: > >=20 > > delete from table1 > > where exists > > (select * from t2, t3, t4, t5 > > where...)> >=20 > > Thanks in advance.=20 > >=20 > > Keith Schleicher > > IT Database Administrator > > Cell: 224-210-8358 > > Blackberry:=20 > > 2242108358@messaging.sprintpcs.com<mailto:=20 > > 2242108358@messaging.sprintpcs.com> > > Page:=20 > > 2242108358@sprint.skytel.com<mailto:2242108358@sprint.skytel.com> > >=20 > > For more information, use our DBA Wiki page link below:=20 > >=20 > >=20 > >=20 > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= > t#DatabaseManagement=20 > > < > > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Mana > > gement > > >=20 > >=20 > > This message, including any attachments, is the property of Sears=20 > > Holdings Corporation and/or one of its subsidiaries. It is=20 > > confidential and may contain proprietary or legally privileged=20 > > information. If you are not the intended recipient, please delete it=20 > > without reading the contents. Thank you. > >=20 > >=20 > >=20 > >=20 > > ***************************************************************************= > ****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > >=20 > >=20 > > --047d7bf0d1b4c9f89704eac207ce=20 > > > ***************************************************************************= > **** > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > This message, including any attachments, is the property of Sears Holdings > = > Corporation and/or one of its subsidiaries. It is confidential and may > cont= > ain proprietary or legally privileged information. If you are not the > inten= > ded recipient, please delete it without reading the contents. Thank you. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c264565ae1ec04eac872f1