Adding space to temp dbspaces on Informix XPS

There isn't enough space in the temp dbspace for a certain job to run on our XPS 8.21.UD2X2 server. Here is our current setup: $onstat -d |grep temp 70076480 4 2001 7 5 N T informix tempdbs.1 70076548 5 2001 8 5 N T informix tempdbs.2 70076610 6 2001 9 5 N T informix tempdbs.3 700766d8 7 2001 10 5 N T informix tempdbs.4 70077f10 7 4 0 487424 486907 PO- /ifmx/ifmx00062.1.1/tempdbs.1 70095824 8 5 0 487424 486939 PO- /ifmx/ifmx00062.1.2/tempdbs.1 70095914 9 6 0 487424 486971 PO- /ifmx/ifmx00062.1.3/tempdbs.1 70095a04 10 7 0 487424 486907 PO- /ifmx/ifmx00062.1.4/tempdbs.1 70095af4 11 4 0 487424 487271 PO- /ifmx/ifmx00062.1.1/tempdbs.2 70095be4 12 5 0 487424 487271 PO- /ifmx/ifmx00062.1.2/tempdbs.2 70095cd4 13 6 0 487424 487271 PO- /ifmx/ifmx00062.1.3/tempdbs.2 70095dc4 14 7 0 487424 487271 PO- /ifmx/ifmx00062.1.4/tempdbs.2 70a25000 71 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.3 70a250f0 72 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.3 70a251e0 73 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.3 70a252d0 74 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.3 70a253c0 75 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.4 70a254b0 76 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.4 70a255a0 77 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.4 70a25690 78 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.4 70a25780 79 4 0 524287 524284 PO- /ifmx/ifmx00062.1.1/tempdbs.5 70a25870 80 5 0 524287 524284 PO- /ifmx/ifmx00062.1.2/tempdbs.5 70a25960 81 6 0 524287 524284 PO- /ifmx/ifmx00062.1.3/tempdbs.5 70a25a50 82 7 0 524287 524284 PO- /ifmx/ifmx00062.1.4/tempdbs.5 Here are the chunks I want to add: $ls -l /ifmx/ifmx00062.1.*/tempdbs.6 lrwxrwxrwx 1 informix informix 20 Mar 11 20:46 /ifmx/ifmx00062.1.1/tempdbs.6 -> /dev/ri062.01_20.1.1 lrwxrwxrwx 1 informix informix 20 Mar 11 20:51 /ifmx/ifmx00062.1.2/tempdbs.6 -> /dev/ri062.01_20.1.2 lrwxrwxrwx 1 informix informix 20 Mar 11 20:51 /ifmx/ifmx00062.1.3/tempdbs.6 -> /dev/ri062.01_20.1.3 lrwxrwxrwx 1 informix informix 20 Mar 11 20:51 /ifmx/ifmx00062.1.4/tempdbs.6 -> /dev/ri062.01_20.1.4 I tried running onspaces, but apparently that doesn't work. Can anyone help me with the command(s) to get these chunks added? Thanks in advance! Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com <mailto:2242108358@messaging.sprintpcs.com> Page: 2242108358@sprint.skytel.com <mailto:2242108358@sprint.skytel.com> 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.

I was able to find the commands to do this. Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com Page: 2242108358@sprint.skytel.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schleicher, Keith Sent: Sunday, March 11, 2012 9:20 PM To: ids@iiug.org Subject: Adding space to temp dbspaces on Informix XPS [26506] There isn't enough space in the temp dbspace for a certain job to run on our XPS 8.21.UD2X2 server. Here is our current setup: $onstat -d |grep temp 70076480 4 2001 7 5 N T informix tempdbs.1 70076548 5 2001 8 5 N T informix tempdbs.2 70076610 6 2001 9 5 N T informix tempdbs.3 700766d8 7 2001 10 5 N T informix tempdbs.4 70077f10 7 4 0 487424 486907 PO- /ifmx/ifmx00062.1.1/tempdbs.1 70095824 8 5 0 487424 486939 PO- /ifmx/ifmx00062.1.2/tempdbs.1 70095914 9 6 0 487424 486971 PO- /ifmx/ifmx00062.1.3/tempdbs.1 70095a04 10 7 0 487424 486907 PO- /ifmx/ifmx00062.1.4/tempdbs.1 70095af4 11 4 0 487424 487271 PO- /ifmx/ifmx00062.1.1/tempdbs.2 70095be4 12 5 0 487424 487271 PO- /ifmx/ifmx00062.1.2/tempdbs.2 70095cd4 13 6 0 487424 487271 PO- /ifmx/ifmx00062.1.3/tempdbs.2 70095dc4 14 7 0 487424 487271 PO- /ifmx/ifmx00062.1.4/tempdbs.2 70a25000 71 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.3 70a250f0 72 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.3 70a251e0 73 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.3 70a252d0 74 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.3 70a253c0 75 4 0 262144 262141 PO- /ifmx/ifmx00062.1.1/tempdbs.4 70a254b0 76 5 0 262144 262141 PO- /ifmx/ifmx00062.1.2/tempdbs.4 70a255a0 77 6 0 262144 262141 PO- /ifmx/ifmx00062.1.3/tempdbs.4 70a25690 78 7 0 262144 262141 PO- /ifmx/ifmx00062.1.4/tempdbs.4 70a25780 79 4 0 524287 524284 PO- /ifmx/ifmx00062.1.1/tempdbs.5 70a25870 80 5 0 524287 524284 PO- /ifmx/ifmx00062.1.2/tempdbs.5 70a25960 81 6 0 524287 524284 PO- /ifmx/ifmx00062.1.3/tempdbs.5 70a25a50 82 7 0 524287 524284 PO- /ifmx/ifmx00062.1.4/tempdbs.5 Here are the chunks I want to add: $ls -l /ifmx/ifmx00062.1.*/tempdbs.6 lrwxrwxrwx 1 informix informix 20 Mar 11 20:46 /ifmx/ifmx00062.1.1/tempdbs.6 -> /dev/ri062.01_20.1.1 lrwxrwxrwx 1 informix informix 20 Mar 11 20:51 /ifmx/ifmx00062.1.2/tempdbs.6 -> /dev/ri062.01_20.1.2 lrwxrwxrwx 1 informix informix 20 Mar 11 20:51 /ifmx/ifmx00062.1.3/tempdbs.6 -> /dev/ri062.01_20.1.3 lrwxrwxrwx 1 informix informix 20 Mar 11 20:51 /ifmx/ifmx00062.1.4/tempdbs.6 -> /dev/ri062.01_20.1.4 I tried running onspaces, but apparently that doesn't work. Can anyone help me with the command(s) to get these chunks added? Thanks in advance! Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com <mailto:2242108358@messaging.sprintpcs.com> Page: 2242108358@sprint.skytel.com <mailto:2242108358@sprint.skytel.com> 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. 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.