急求助! "Bad primary chunk '/informix/index3chk12'"

ying_zi_66

执行oninit  时报"Bad primary chunk '/informix/index3chk12'"
请求高手指点.谢谢!!

IFMXDBA

try dd if=/informix/index3chk12 of=/dev/null bs=2048 count=100000. If it works fine, the chunk physically fine.  
onstat -d, check if the chunk was marked "PD-", ( primary offline ). Call IBM support, they have tools to simiply flip the chunk status flag.  
Or if you want restore, which is the finial solution.

ying_zi_66

非常感谢！！
    执行dd ..of...命令后，显示正常：100000＋0   records in/out ;查看onstat -d|grep index3chk12  为‘PD-’
    我想另建chunk  可无法具体查到是哪个表的索引（表及索引分散分布的），请指教。谢谢！！

IFMXDBA

if the chunk is not damaged physically, the easiest way is to call IBM support, they will help you patch the system to flip the chunk flag in system reserve page ( in rootdbs ).  It will just take you few minutes.
If want drop/re-create all the indexes stores in that chunk, you can try :-
1. oncheck -pe
or
2. oncheck -pT dbname:table
or
3.  query on sysindexes and systables

But the 'down' chunk is still there.  There are two way to get it online :-
1. call IBM support
2. restore from archive

sqlnet

dd是何含义?

ying_zi_66

非常感谢'IFMXDBA '的帮助!!  祝每天都有好心情!!


另回'sqlnet':  在操作系统 man  dd  就可以看到dd的含义了.

IFMXDBA

thanks, you are welcome.  BTW, is the problem solved ?  If so, could you please post out how do you solve the problem if you don't mind.  It may be helpful for others in this forum.  Thanks.

ying_zi_66

惭愧!
只是找到oncheck  后的ERROR表,重新建了一个.
没彻底解决.

builder

/usr/informix>>onspaces --

Usage:
onspaces  { -a spacename -p pathname -o offset -s size [-m path offset]  |

             -c { -d DBspace [-t] |  -b BLOBspace -g pagesize }
                     -p pathname -o offset -s size [-m path offset] |

             -d spacename [-p pathname -o offset] [-f] [-y] |

             -f[y] off [DBspace-list] | on [DBspace-list] |

             -m spacename {-p pathname -o offset -m path offset [-y] |
                           -f filename} |

             -r spacename [-y] |

             -s spacename -p pathname -o offset {-O | -D} [-y] }

    -a - Add a chunk to a DBspace or BLOBspace
    -c - Create a DBspace or BLOBspace
    -d - Drop a DBspace, BLOBspace or chunk
    -f - Change dataskip default for specified DBspaces
    -m - Add mirroring to an existing DBspace or BLOBspace
    -r - Turn mirroring off for a DBspace or BLOBspace
    -s - Change the status of a chunk

注意最后一个选项，呵呵

ying_zi_66

果然好用！！！

只短短一行命令，解决了困扰中的我，谢谢builder，非常感谢！！！
学海无崖，我需努力呀。。。