Professional Web Applications Themes

Onunload - Informix

Are there any potential problems running onunload to move a complete database from one instance to another on identical hardware. I have already seen that new datatypes for version 9 are not transferred. Anything else? Any help much appreciated. Malcolm...

  1. #1

    Default Onunload

    Are there any potential problems running onunload to move a complete
    database from one instance to another on identical hardware.
    I have already seen that new datatypes for version 9 are not
    transferred. Anything else?

    Any help much appreciated.

    Malcolm
    malcolm Guest

  2. #2

    Default Re: Onunload

    In message <google.com>, malcolm
    <com> writes 

    And indexes either detached, or in a dbspace other than that the
    database was created in, need assigning a new dbspace with the '-fi'
    load option. There is now an SQL at oninit.com to find them....

    Also I think you would have problems if the versions of IDS were
    different as onunload output data pages.

     

    A better idea I now think is to use dbexport...... :-(

     

    --
    Five Cats
    Email to: cats_spam at uk2 dot net
    Five Guest

  3. #3

    Default Re: Onunload

    "malcolm" <com> wrote in message
    news:google.com... 

    Which release of IDS?
    Most demand that you have identical dbspace names available on the target
    instance as the source. The dbspace override flag is only effective for
    data.


    Neil Guest

  4. #4

    Default Re: Onunload

    In message <c4s111$2m6qdh$news.uni-berlin.de>, Neil Truby
    <com> writes 
    >
    >Which release of IDS?
    >Most demand that you have identical dbspace names available on the target
    >instance as the source. The dbspace override flag is only effective for
    >data.[/ref]

    As I have been finding recently, you have to use the '-fi' flags to deal
    with indexes elsewhere. The customer is reloading tomorrow so watch
    this space, but we found 167 indexes (or so) not in the database dbspace
    so there are a lot of lines starting '-fi' in the script they are going
    to run.... 

    --
    Five Cats
    Email to: cats_spam at uk2 dot net
    Five Guest

Similar Threads

  1. Why no onLoad or onUnload on _root?
    By Carl Fink webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: January 28th, 08:01 PM
  2. There are ONUNLOAD limits?
    By Rafael in forum Informix
    Replies: 2
    Last Post: January 10th, 09:18 PM
  3. Onunload & onload question
    By Matthew Tan in forum Informix
    Replies: 3
    Last Post: October 22nd, 07:33 AM
  4. onload/onunload all tables EXCEPT ones specified
    By Steve N. in forum Informix
    Replies: 2
    Last Post: October 11th, 12:08 AM
  5. onunload event
    By RobGT in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 10th, 01:17 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139