Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    5

    Unanswered: Cant Insert data

    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
    Last edited by informixfan; 03-27-04 at 09:18.

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177

    Re: Cant Insert data

    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.
    Fred Prose

  3. #3
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    One more thing that I missed. Your server is blocked with reason LBU. Are your logs full?
    Fred Prose

  4. #4
    Join Date
    Mar 2004
    Posts
    5

    Prob.Solved

    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

Posting Permissions

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