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 <mccux1@hotmail.com> wrote in message news:<bu157u017f0@drn.newsguy.com>... > 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$1@ID-162943.news.uni-berlin.de>, Neil Truby says... > > > >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:neil.truby@ardenta.com > > > > > >"aaa" <mccux1@hotmail.com> wrote in message > >news:bu104k0mug@drn.newsguy.com... > >> 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. > >> > > > >