Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kpenza

    Sendmail issue

    Thanks Mag0007 for the help... I have tried both the mailx user@hostname and mailx user but the mail kept to be in the deferred state. After a lot of searching in may places I decided to check the permission of the whole /usr file system of a working server and of the one which is not working...
  2. kpenza

    Sendmail issue

    People, I have a question regarding AIX 4.3.3, we have sendmail that relays email to our email system, thus it allows us to send administrative emails with output from crons etc. One of our systems is behaving a bit strange as it is not sending mails locally and when view the mail queue via...
  3. kpenza

    informix version numbers

    Thanks, very much olded for the information given.
  4. kpenza

    informix version numbers

    People, I need to determine the details of a release for example what 9.40.UC3x2 means. I know that in oracle 8.1.7.4.0 means 8---> Major database release number 1---> Database maintenance release number 7---> Application server release number 4---> Component specific release number 0--->...
  5. kpenza

    Performance question regarding LOB's storage

    When a table stores LOB's together table data does it hinder performance. On some other database recommand that BLOB/CLOB are saved inside a separate tablespace specifying the correct blobpage/page size. Does is same apply for oracle 8i.
  6. kpenza

    Question about table defragmentation

    People, I managed to find a method: If an index such as that of primary key is created named ALTER INDEX <idx_name> TO CLUSTER; This causes table to be reorganized by the index and automatically defragements the table. Afterwards ALTER INDEX <idx_name> TO NOT CLUSTER; Otherwise create an...
  7. kpenza

    Question about table defragmentation

    Thanks, for the suggestions the table has 5.4 million rows. I wish to avoid unloading and reloading again the tables. As there circa fifteen tables which are quite large, and I do not have too much free filesystem space.
  8. kpenza

    Question about table defragmentation

    I am running ids 9.30.uc2 on a linux machine, on one of other production servers. During maintaince job we noticed that there are a few tables that have over 110 extents. Is there there a way to defragment the table without going through an export and an import ? Any suggestions welcome.

Part and Inventory Search

Back
Top