How to know the existing external space ?
Hello,
We created several external spaces in our IDS instance with the onspaces
command :
onspaces -x <extspace name> -l <extspace directory>.
We forgot their name and their directory.
I did not find how to display these external spaces (name and directory)
with the onstat command.
Do you know the options with onstat to display these extspace
or do you have to use another command ?
Regards,
--
Franck Thomas
ConsultiX
franck.thomas@consult-ix.fr
Téléphone : 33 (0) 1 39 12 18 00
Mobile : 33 (0) 6 78 81 09 33
Fax : 33 (0) 1 39 12 18 18
there is not an onstat command to display external spaces. You
must run the following query:
select * from sysmaster:sysextspaces
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 06/27/2011 09:49:38 AM:
> [image removed]
>
> How to know the existing external space ? [24154]
>
> Franck THOMAS
>
> to:
>
> ids
>
> 06/27/2011 09:50 AM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> Hello,
>
> We created several external spaces in our IDS instance with the onspa=
ces
> command :
> onspaces -x <extspace name> -l <extspace directory>.>
> We forgot their name and their directory.
> I did not find how to display these external spaces (name and directo=
ry)
> with the onstat command.
>
> Do you know the options with onstat to display these extspace
> or do you have to use another command ?
>
> Regards,
>
> --
> Franck Thomas
> ConsultiX
> franck.thomas@consult-ix.fr
> T=E9l=E9phone : 33 (0) 1 39 12 18 00
> Mobile : 33 (0) 6 78 81 09 33
> Fax : 33 (0) 1 39 12 18 18
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.=
>=
select * from sysmaster:sysextspaces;
Art
Art S. Kagel
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 Mon, Jun 27, 2011 at 12:49 PM, Franck THOMAS <franck.thomas@consult-ix.fr
> wrote:
> Hello,
>
> We created several external spaces in our IDS instance with the onspaces
> command :
> onspaces -x <extspace name> -l <extspace directory>.>
> We forgot their name and their directory.
> I did not find how to display these external spaces (name and directory)
> with the onstat command.
>
> Do you know the options with onstat to display these extspace
> or do you have to use another command ?
>
> Regards,
>
> --
> Franck Thomas
> ConsultiX
> franck.thomas@consult-ix.fr
> Téléphone : 33 (0) 1 39 12 18 00
> Mobile : 33 (0) 6 78 81 09 33
> Fax : 33 (0) 1 39 12 18 18
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3071c7ba04d75804a6b4c733