Re: Raw or Buffered device?

Paul Watson <paul@oninit.com> wrote in message news:<3F634E49.93BE0D28@oninit.com>... > [cutting] > > IT IS PERFECTLY SAFE to just bring the engine down, > > > remove the symbolic link to /dev/dbroot and replace it with an identically > > > named symbolic link to /dev/rdbroot! > > > > This how ever I do not agree with. Changing the symbolic link will > > result in error : > > > > Cannot open chunk '/opt/DBA/Informix/Links/730/risdi08/primary/root'. > > errno = 19 > > oninit: Fatal error in shared memory initialization > > > > because the (old) link itself is stored in the instances systam > > tables. So it would not be sufficient to 'simply' change the link. > > Robert A. Reissaus > > You can point the link to anywhere you want, the engine has no idea > where the link points to, only the link name He people, I didn't INVENT the error. It occurs! Again and again and again! On SCO, on HPUX, on AIX and on Linux. So stop the 'NONSENSE' remarks unless you can really prove I am wrong, then present the argument and after i have verified you remarks are true and I am wrong (which quite frankly would surprise me enormously) i will admit i am wrong. Robert A, Reissaus

Robert A. Reissaus wrote: > So stop the 'NONSENSE' > remarks unless you can really prove I am wrong, then present the > argument and after i have verified you remarks are true and I am wrong > (which quite frankly would surprise me enormously) i will admit i am > wrong. You know, you sound remarkably like my ex-wife... -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche

"Robert A. Reissaus" <r.a.reissaus@risdi.com> wrote in message news:87ad5966.0309141326.5ad3bd2e@posting.google.com... > Paul Watson <paul@oninit.com> wrote in message news:<3F634E49.93BE0D28@oninit.com>... > He people, I didn't INVENT the error. It occurs! Again and again and > again! On SCO, on HPUX, on AIX and on Linux. So stop the 'NONSENSE' > remarks unless you can really prove I am wrong, then present the > argument and after i have verified you remarks are true and I am wrong > (which quite frankly would surprise me enormously) i will admit i am > wrong. See below: 1. rootdbs' only chunk, /opt/informix/dbspaces5/rootdbs is a link to /dev/vgexceed_bcv/rrootdbs_5 2. I stop the instance 3. I remove /opt/informix/dbspaces5/rootdbs 4. I recreate /opt/informix/dbspaces5/rootdbs, this time as a link to /dev/vgexceed_bcv/rootdbs_5 5. I restart the engine, with no problems, chunk or otherwise, at all This was on HP-UX 11.11, IDS 9.21, but I've done the same on SCO OpenServer in the past. I can assure you that you are mistaken on this one. informix@hamilton[/exports/neil/dsinvlines] onstat -d Informix Dynamic Server 2000 Version 9.21.FC4 -- On-Line -- Up 6 days 13:01:42 -- 319668 Kbytes Dbspaces address number flags fchunk nchunks flags owner name c00000006019be58 1 0x1 1 1 N informix rootdbs c0000000601f0a58 2 0x1 2 1 N informix llogdbs c0000000601f0bd0 3 0x1 3 1 N informix physdbs c0000000601f0d48 4 0x1 4 1 N informix dbspace0 c00000006019c338 5 0x2001 5 1 N T informix tempdbs0 5 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname c00000006019c028 1 1 0 26624 10564 PO- /opt/informix/dbspaces5/rootdbs c0000000601f0438 2 2 0 307200 0 PO- /opt/informix/dbspaces5/llogdbs c0000000601f05c0 3 3 0 51200 0 PO- /opt/informix/dbspaces5/physdbs c0000000601f0748 4 4 0 806912 444684 PO- /opt/informix/dbspaces5/dbspace0 c0000000601f08d0 5 5 0 26624 26571 PO- /opt/informix/dbspaces5/tempdbs0 5 active, 2047 maximum informix@hamilton[/exports/neil/dsinvlines] ll /opt/informix/dbspaces5/rootdbs lrwxr-xr-x 1 root root 28 Nov 12 2002 /opt/informix/dbspaces5/rootdbs -> /dev/vgexceed_bcv/rrootdbs_5 informix@hamilton[/exports/neil/dsinvlines] onmode -k This will take Informix Dynamic Server 2000 OFF-LINE - Do you wish to continue (y/n)? y There are 0 user threads that will be killed. Do you wish to continue (y/n)? y informix@hamilton[/exports/neil/dsinvlines] rm /opt/informix/dbspaces5/rootdbs informix@hamilton[/exports/neil/dsinvlines] ln -s /dev/vgexceed_bcv/rootdbs_5 /opt/informix/dbspaces5/rootdbs informix@hamilton[/exports/neil/dsinvlines] ll /opt/informix/dbspaces5/rootdbs lrwxrwxrwx 1 informix informix 27 Sep 14 23:16 /opt/informix/dbspaces5/rootdbs -> /dev/vgexceed_bcv/rootdbs_5 informix@hamilton[/exports/neil/dsinvlines] oninit informix@hamilton[/exports/neil/dsinvlines] onstat -m Informix Dynamic Server 2000 Version 9.21.FC4 -- On-Line -- Up 00:00:15 -- 319668 Kbytes Message Log File: /opt/informix/online_5.log 23:16:45 Informix Dynamic Server 2000 Version 9.21.FC4 Software SerialNumber AAD#J130447 23:16:45 HPUX Version B.11.11 -> Using flag/select style KAIO 23:16:45 HP KAIO concurrent requests changed from 1000 to 2300 23:16:45 HPUX KAIO Segment locked addr=0x407ae000 size=201510912 23:16:46 HPUX KAIO Segment locked addr=0x4c7db000 size=125829120 23:16:46 Informix Dynamic Server 2000 Initialized -- Shared MemoryInitialized. 23:16:46 Physical Recovery Started at Page(3:25521). 23:16:46 Physical Recovery Complete: 0 Pages Examined 0 Pages Restored. 23:16:46 Logical Recovery Started. 23:16:46 10 recovery worker threads will be started. 23:16:49 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 23:16:50 Dataskip is now OFF for all dbspaces 23:16:50 On-Line Mode 23:16:50 Checkpoint Completed: duration was 0 seconds. 23:16:50 Checkpoint loguniq 38503, logpos 0x645018