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

ying_zi_66 发表于 2006-08-23 17:11

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

IFMXDBA 发表于 2006-08-23 21:19

回复 1楼 ying_zi_66 的帖子

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 发表于 2006-08-24 17:15

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

IFMXDBA 发表于 2006-08-24 21:17

回复 3楼 ying_zi_66 的帖子

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 发表于 2006-08-25 22:48

dd是何含义?

ying_zi_66 发表于 2006-08-28 11:35

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

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

IFMXDBA 发表于 2006-08-28 23:42

回复 6楼 ying_zi_66 的帖子

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 发表于 2006-08-31 13:38

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

builder 发表于 2006-09-03 14:04

/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 off | on |

         -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 发表于 2006-09-06 10:16

果然好用！！！

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

:em02::handshake

页: [1] 2

Chinaunix's Archiver