Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    38

    Unanswered: Fragmented Tables

    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
    Last edited by Anu_R; 07-17-03 at 09:26.

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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 ?

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    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
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •