Hi,

I am using Informix OnLine 5.0x.

I have some queries:

(1) What is the equivalent of onstat -g ses in this version of informix (The onstat -g ses command displays a list of the sessions currently running in the system). Do we have such a command?

(2) Syntax for creating Fragmented tables

(3) How to create a temp dbspace?

Please help if you know answer to even one question.

Thanks!
Anu_R

1)
The closest equivalent to 'onstat -g ses' might be 'tbstat -u'.

2)
fragmented tables are not available in 5.x, they have been
introduced with version 7 of IDS

3)
Hmm, not sure. Is there no '-t' flag in the tbspaces command ?

I am using Informix Dynamic Server Version 7.31.UC5

Usage:
onspaces { -a spacename -p pathname -o offset -s size [-m path offset] |

-c { -d DBspace [-t] | -b BLOBspace -g pagesize }
-p pathname -o offset -s size [-m path offset] |

-d spacename [-p pathname -o offset] [-f] [-y] |

-f[y] off [DBspace-list] | on [DBspace-list] |

-m spacename {-p pathname -o offset -m path offset [-y] |
-f filename} |

-r spacename [-y] |

-s spacename -p pathname -o offset {-O | -D} [-y] }

-a - Add a chunk to a DBspace or BLOBspace
-c - Create a DBspace or BLOBspace
-d - Drop a DBspace, BLOBspace or chunk
-f - Change dataskip default for specified DBspaces
-m - Add mirroring to an existing DBspace or BLOBspace
-r - Turn mirroring off for a DBspace or BLOBspace
-s - Change the status of a chunk