Hello ,
Im new to informix. well ive been facing a problem on my
DR server which is supposed to be a replica of the live server which
has disk mirroring. I am not sure of how far the replica is succeeded.
Well the prob. im facing is that i can execute a selecte query on my
informix tables , but when i try to insert or upate values in a table the
process just hangs. Can neone please tell me where i will get the inform.
about the errors ive tried seeing in the online logs which gives the info
"Checkpoint completed;duration was 0 seconds"
"checkpoint logUNiq 4584, logpos 0x499018"

can anyone tell me how i should be interpreting this log message and
why i am not able to insert any data.

Below is the output of onstat -d
Informix Dynamic Server Version 7.31.UD5 -- On-Line -- Up 2 days 18:28:47 -- 1259424 Kbytes
Blocked:LBU

Dbspaces
address number flags fchunk nchunks flags owner name
50c92150 1 1 1 1 N informix rootdbs
517b1f50 2 1 2 1 N informix plogdbs
51b21218 3 1 3 1 N informix llogdbs
51b212d8 4 2001 4 4 N T informix tempdbs
51b21398 5 1 8 12 N informix datdbs0
51b21458 6 1 20 12 N informix datdbs1
6 active, 2047 maximum

Chunks
address chk/dbs offset size free bpages flags pathname
50c92210 1 1 0 500000 498887 PO- /dev/vx/rdsk/datadg1/rlvrootdbs0
517b1350 2 2 0 300000 49947 PO- /dev/vx/rdsk/datadg2/rlvplogdbs0
517b1450 3 3 0 1000000 4947 PO- /dev/vx/rdsk/datadg1/rlvllogdbs0
517b1550 4 4 0 1000000 999947 PO- /dev/vx/rdsk/datadg3/rlvtempdbs0
517b1650 5 4 0 1000000 999997 PO- /dev/vx/rdsk/datadg3/rlvtempdbs1
517b1750 6 4 0 1000000 999997 PO- /dev/vx/rdsk/datadg3/rlvtempdbs2
517b1850 7 4 0 1000000 999997 PO- /dev/vx/rdsk/datadg3/rlvtempdbs3
517b1950 8 5 0 1000000 13 PO- /dev/vx/rdsk/datadg2/rlvdatdbs00
517b1a50 9 5 0 1000000 13 PO- /dev/vx/rdsk/datadg2/rlvdatdbs01
517b1b50 10 5 0 1000000 13 PO- /dev/vx/rdsk/datadg2/rlvdatdbs02
517b1c50 11 5 0 1000000 13 PO- /dev/vx/rdsk/datadg2/rlvdatdbs03
517b1d50 12 5 0 1000000 5 PO- /dev/vx/rdsk/datadg2/rlvdatdbs04
517b1e50 13 5 0 1000000 13 PO- /dev/vx/rdsk/datadg2/rlvdatdbs05
51b20018 14 5 0 1000000 5 PO- /dev/vx/rdsk/datadg2/rlvdatdbs10
51b20118 15 5 0 1000000 13 PO- /dev/vx/rdsk/datadg2/rlvdatdbs11
51b20218 16 5 0 1000000 413269 PO- /dev/vx/rdsk/datadg2/rlvdatdbs12
51b20318 17 5 0 1000000 999997 PO- /dev/vx/rdsk/datadg2/rlvdatdbs13
51b20418 18 5 0 1000000 999997 PO- /dev/vx/rdsk/datadg2/rlvdatdbs14
51b20518 19 5 0 1000000 999997 PO- /dev/vx/rdsk/datadg2/rlvdatdbs15
51b20618 20 6 0 1000000 329 PO- /dev/vx/rdsk/datadg3/rlvdatdbs20
51b20718 21 6 0 1000000 24 PO- /dev/vx/rdsk/datadg3/rlvdatdbs21
51b20818 22 6 0 1000000 148 PO- /dev/vx/rdsk/datadg3/rlvdatdbs22
51b20918 23 6 0 1000000 0 PO- /dev/vx/rdsk/datadg3/rlvdatdbs23
51b20a18 24 6 0 1000000 1 PO- /dev/vx/rdsk/datadg3/rlvdatdbs24
51b20b18 25 6 0 1000000 1 PO- /dev/vx/rdsk/datadg3/rlvdatdbs25
51b20c18 26 6 0 1000000 905 PO- /dev/vx/rdsk/datadg3/rlvdatdbs26
51b20d18 27 6 0 1000000 969437 PO- /dev/vx/rdsk/datadg3/rlvdatdbs27
51b20e18 28 6 0 1000000 999997 PO- /dev/vx/rdsk/datadg3/rlvdatdbs28
51b20f18 29 6 0 1000000 999997 PO- /dev/vx/rdsk/datadg3/rlvdatdbs29
51b21018 30 6 0 1000000 999997 PO- /dev/vx/rdsk/datadg3/rlvdatdbs30
51b21118 31 6 0 1000000 999997 PO- /dev/vx/rdsk/datadg3/rlvdatdbs31
31 active, 2047 maximum


Thanks

Question one: I infer that you are trying to do the insert on the replicant and not the primary?

Question two: If this is the case, do you have two way replication defined?

Question three: Anthing in the log (on either server)? "onstat -m"

Don't worry about the checkpoint messages - they are normal.

One more thing that I missed. Your server is blocked with reason LBU. Are your logs full?

Hi,
Yeah the log files were full.i executed the ontape -a command to
backup the logfiles on a dev device. But still aint sure what exactly
you meant by the replication.

thanks