Professional Web Applications Themes

[Q] how to drop all the databases and instance? - Informix

We have Informix On-LIne 5.10 on AIX server. All of the Informix data on SSA disk array. We plan to replace the SSA disk array and need delete all of the databases (include rootdb and p_log and l_log). Can anyone tell me how to do it from dbaccess and tbmonitor? Thanks....

  1. #1

    Default [Q] how to drop all the databases and instance?

    We have Informix On-LIne 5.10 on AIX server. All of the Informix data on SSA
    disk array. We plan to replace the SSA disk array and need delete all of the
    databases (include rootdb and p_log and l_log). Can anyone tell me how to do it
    from dbaccess and tbmonitor?

    Thanks.

    aaa Guest

  2. #2

    Default Re: [Q] how to drop all the databases and instance?

    Er, can you explain more precisely what you're doing?
    You will have the old and the new array attached at the same time?

    I don't think onmonitor and dbaccess are the tools you'll want.
    dd and rm sound more likely.

    Are you using soft links for your chunk names (please post output from
    tbstat -d)

    --
    Neil Truby t:01932 724027
    Director m:07798 811708
    Ardenta Limited e:com


    "aaa" <com> wrote in message
    news:newsguy.com... 
    SSA 
    the 
    do it 


    Neil Guest

  3. #3

    Default Re: [Q] how to drop all the databases and instance?

    Thanks for help. The way we plan to do are:

    1. use tbunload to backup all databases

    2. remove all databases includes rootdb, p_log, l_log and instance

    3. remove all disk partitions on AIX which define for databases

    4. take out old SSA disk array

    5. put new disk array

    6. Initialize database

    7. restore databases

    We know how to "initialize and load databases", but we still have problem on
    remove all databases.


    Thanks,

    In article <bu136t$c8t16$news.uni-berlin.de>, Neil Truby says... 
    >SSA 
    >the 
    >do it 
    >
    >[/ref]

    aaa Guest

  4. #4

    Default Re: [Q] how to drop all the databases and instance?

    You'd be better off:

    1. Using tbtape to back up the database to tape
    2. Use rm to remove the Informix chunk names (hence the request for you to
    post the output from tbstat to check you are using links)
    3. Take out old array
    4. Put in new array.
    5. Re-link Informix chunks to new disk areas
    6. Use tbtape to restore the new database.

    You simply don't need to bother with tbunload and rebuilding the server.
    Unless you want to for some other reason.

    Neil



    "aaa" <com> wrote in message
    news:newsguy.com... 
    on 
    says... [/ref][/ref]
    on [/ref][/ref]
    of [/ref][/ref]
    to 
    > >
    > >[/ref]
    >[/ref]


    Neil Guest

  5. #5

    Default Re: [Q] how to drop all the databases and instance?

    As Neil suggests, you'd be better off using tbtape to backup and
    restore.

    Just a couple of things to add:

    - I assume you're keeping your version of OnLine. If you're changing
    it then neither tbtape nor tbunload can be assumed to work - you'll
    have to use dbexport / dbimport, which of course requires you to have
    plenty of filesystem space.

    - If you use tbtape the chunk device names on the target for the
    restore need to be identical to those the on the backed up system. The
    usual way to accomplish this is by way of symbolic links. Don't forget
    to make them owned by informix / informix and 660 (not root/ other and
    777 like one site I saw recently! :-O ).

    - How thoroughly do you want to get rid of the old data? If you just
    want to make it inaccessible to OnLine then tbinit -iy will zap it. If
    you need to shred the contents then you'll need to copy something over
    the chunks - build filesystems on them, dd stuff to them, or
    something. Extremely unlikely to be necessary though.

    Andy




    aaa <com> wrote in message news:<newsguy.com>... [/ref]
    > SSA [/ref]
    > the [/ref]
    > do it 
    > >
    > >[/ref][/ref]
    Andy Guest

Similar Threads

  1. Administrative Instance now looks like Instance Manager
    By Data_Gladiator in forum Coldfusion Server Administration
    Replies: 2
    Last Post: November 10th, 09:48 PM
  2. Replies: 4
    Last Post: May 17th, 10:55 PM
  3. Trying to track an instance's position relative to the stage - instance is inside an MC
    By _posted.by\(Vern\); in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: January 20th, 04:52 AM
  4. Federated Databases, joins across databases etc
    By Benjamin Stewart in forum IBM DB2
    Replies: 2
    Last Post: August 1st, 03:05 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