Does my oncheck -cI db:table hungs?

Hi All, The user is performing a delete from the table and encountered error 245. Upon checking it showed i need to run "oncheck" to verify if the index is corrupted. I performed "oncheck -cI dbname:table. I can't find if my process is hunged or still running. Please see below output status from "onstat -g ses session_id" tid name rstcb flags curstk status 927897 oncheck 700000085a7d4a8 ---P--- 5056 join wait(join_tcb: 927898) 927898 oncheckm 700000085a540a8 Y------ 5232 cond wait(packet_cond) 971312 xchg_1.0 700000085a73d68 Y------ 1568 cond wait(packet_cond) 971313 xchg_2.0 700000085a62a68 ----R-- 4384 sleeping(Forever) 971315 psortpro 700000085a4d2a8 Y------ 1280 cond wait(backend:0) 971316 psortpro 700000085a4b048 Y------ 1280 cond wait(backend:1) Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 44681 V 70000008de72028 417792 307640 413 13 44681_SORT_ V 70000008e2bc028 253952 102096 189 91 name free used name free used overhead 0 352 scb 0 144 opentable 0 11384 filetable 0 5424 misc 0 1824 log 0 25296 temprec 0 3480 blob 0 520 keys 0 368 ralloc 0 10112 gentcb 0 16648 ostcb 0 3408 sort 0 11168 tbutility 0 144 sqscb 0 10736 srtmembuf 0 135336 rdahead 0 1120 xchg_desc 0 1256 xchg_port 0 608 xchg_packet 0 272 xchg_group 0 368 xchg_priv 0 288 scan_desc 0 480 sort_desc 0 992 btmrg_desc 0 752 hashfiletab 0 3312 osenv 0 2304 oncheck 0 144 sqtcb 0 6800 fragman 0 1144 shmblklist 0 5824 The question is, does my "oncheck -cI db_name:table hungs or still executing? my Informix DB is v. 9.4UC6. What is the "onstat" parameter i can use in order to check if the process is still running and not hunged?

follow up question... => oncheck -cI db:tab_history Validating indexes for db:informix.tab_history... Index tab_hist_x1 Index tab_hist_x2 Index fragment in DBspace dbidx09 Index tab_hist_x3 Index fragment in DBspace dbidx09 How can i check if this still running? it's been running for 4 hours now... Thanks a lot. I hope someone respond in my inquiry. Regards,

Run 'onstat -u -r 5' and grep for the session id you should see IO progress over time if it is not hung. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Mar 30, 2012 at 5:54 AM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > The user is performing a delete from the table and encountered error 245. > Upon > checking it showed i need to run "oncheck" to verify if the index is > corrupted. I performed "oncheck -cI dbname:table. I can't find if my > process > is hunged or still running. Please see below output status from "onstat -g > ses > session_id" > > tid name rstcb flags curstk status > 927897 oncheck 700000085a7d4a8 ---P--- 5056 join wait(join_tcb: 927898) > 927898 oncheckm 700000085a540a8 Y------ 5232 cond wait(packet_cond) > 971312 xchg_1.0 700000085a73d68 Y------ 1568 cond wait(packet_cond) > 971313 xchg_2.0 700000085a62a68 ----R-- 4384 sleeping(Forever) > 971315 psortpro 700000085a4d2a8 Y------ 1280 cond wait(backend:0) > 971316 psortpro 700000085a4b048 Y------ 1280 cond wait(backend:1) > > Memory pools count 2 > name class addr totalsize freesize #allocfrag #freefrag > 44681 V 70000008de72028 417792 307640 413 13 > 44681_SORT_ V 70000008e2bc028 253952 102096 189 91 > > name free used name free used > overhead 0 352 scb 0 144 > opentable 0 11384 filetable 0 5424 > misc 0 1824 log 0 25296 > temprec 0 3480 blob 0 520 > keys 0 368 ralloc 0 10112 > gentcb 0 16648 ostcb 0 3408 > sort 0 11168 tbutility 0 144 > sqscb 0 10736 srtmembuf 0 135336 > rdahead 0 1120 xchg_desc 0 1256 > xchg_port 0 608 xchg_packet 0 272 > xchg_group 0 368 xchg_priv 0 288 > scan_desc 0 480 sort_desc 0 992 > btmrg_desc 0 752 hashfiletab 0 3312 > osenv 0 2304 oncheck 0 144 > sqtcb 0 6800 fragman 0 1144 > shmblklist 0 5824 > > The question is, does my "oncheck -cI db_name:table hungs or still > executing? > my Informix DB is v. 9.4UC6. What is the "onstat" parameter i can use in > order > to check if the process is still running and not hunged? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b3390db3a371204bc74f8dc