Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2016
    Posts
    20

    Unanswered: Error - The chunk specified already exists.

    Hi ,


    As discussed , I am getting an warning/error messages on both dbspace .

    CFRSV50251001DB<informix></informix>onspaces -a datadbs_4 -p /datavega/inst0003/data/datadbs_4 -o 170917888 -s 59768832
    The chunk specified already exists.

    CFRSV50251001DB<informix></informix>onspaces -a datadbs_16 -p /datavega/inst0003/data/datadbs_16 -o 288358400 -s 2172649472
    The chunk specified already exists.

    Below are the existing dbsapce details for the reference.

    CFRSV50251001DB<informix></informix>onstat -d

    IBM Informix Dynamic Server Version 12.10.FC7W1 -- On-Line (CKPT INP) -- Up 61 days 18:23:17 -- 29541104 Kbytes

    Dbspaces
    address number flags fchunk nchunks pgsize flags owner name
    700000022580028 1 0x60001 1 1 4096 N B informix rootdbs0003
    700000022aaeba0 2 0x42001 2 2 4096 N TB informix tempdbs0003
    700000022aaede0 3 0x60001 3 1 4096 N B informix logdbs0003
    700000024eea028 4 0x60001 4 1 4096 N B informix physdbs0003
    700000024eea268 5 0x60001 5 4 4096 N B informix datadbs_4
    700000024eea4a8 6 0x60001 6 4 16384 N B informix datadbs_16
    6 active, 2047 maximum

    Chunks
    address chunk/dbs offset size free bpages flags pathname
    700000022580268 1 1 0 512000 399535 PO-B-- /datavega/inst0003/data/rootdbs0003
    700000024eeb028 2 2 0 4096000 4091751 PO-B-- /datavega/inst0003/data/tempdbs0003
    700000024eec028 3 3 0 256000 947 PO-B-- /datavega/inst0003/data/logdbs0003
    700000024eed028 4 4 0 768000 8 PO-B-- /datavega/inst0003/data/physdbs0003
    700000024eee028 5 5 0 76546048 1061775 PO-B-- /datavega/inst0003/data/datadbs_4
    700000024eef028 6 6 0 38338560 310235 PO-B-- /datavega/inst0003/data/datadbs_16
    700000024ef0028 7 5 76546048 28835840 2323 PO-B-- /datavega/inst0003/data/datadbs_4
    700000024ef1028 8 6 153354240 5898240 4 PO-B-- /datavega/inst0003/data/datadbs_16
    700000024ef2028 9 5 105381888 13107200 20 PO-B-- /datavega/inst0003/data/datadbs_4
    700000024ef3028 10 6 176947200 26214400 70676 PO-B-- /datavega/inst0003/data/datadbs_16
    700000024ef4028 11 2 4096000 1146880 1146877 PO-B-- /datavega/inst0003/data/tempdbs0003
    700000024ef5028 12 5 118489088 52428800 28867902 PO-B-- /datavega/inst0003/data/datadbs_4
    700000024ef6028 13 6 281804800 6553600 4514573 PO-B-- /datavega/inst0003/data/datadbs_16
    13 active, 32766 maximum

    informix></datavega/inst0003/data>ls -l
    total 0
    lrwxrwxrwx 1 root system 20 Sep 26 2014 datadbs_16 -> /dev/rdatadbs0003_16
    lrwxrwxrwx 1 root system 19 Sep 26 2014 datadbs_4 -> /dev/rdatadbs0003_4
    lrwxrwxrwx 1 informix informix 16 Sep 25 2014 logdbs0003 -> /dev/rlogdbs0003
    lrwxrwxrwx 1 informix informix 17 Sep 25 2014 physdbs0003 -> /dev/rphysdbs0003
    lrwxrwxrwx 1 informix informix 17 Sep 25 2014 rootdbs0003 -> /dev/rrootdbs0003
    lrwxrwxrwx 1 informix informix 17 Sep 25 2014 tempdbs0003 -> /dev/rtempdbs0003


    Request you to please help me to resolve this issue .

    Thanks

    prashant

  2. #2
    Join Date
    May 2008
    Posts
    36
    Hi,
    you gave the offsets in the wrong unit. onstat mostly shows everything in pages, but utilities want everthing in KB.
    So, next chunks offset in onspaces is :

    ((offset of last chunk)+(size of last chunk)) * (pagesize of dbspace)


    In this case
    170917888 * 4 = 683671552
    288358400 * 16 = 4613734400

Posting Permissions

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