IDS 9.4 taking time to shutdown

Hi All, I would like to ask about why IDS 9.4UC6 is taking time to shutdown. It's has replication. When i perform a restart of the primary it takes me 1 to 1.5 hours to shutdown the primary database. onmode -c; >>>>> This takes a lot, 1 hour. onmode -ky; >>>> kill and yes to all sessions. I would like to ask what is db_prping process. I am suspecting this is the process that holds the shutting down of the instance. Upon checking on forums, it's a replication session. Is there a way to make the shutdown faster? Here's the output from my server IDS 9.4UC6. 3029a790 ---P--- 12 informix - 0 0 0 0 3 3029ada8 ---PR-B 13 informix - 0 0 0 1720432438 760127 3029b3c0 Y--P--D 15 informix - 30842540 0 0 87890 10124 3029b9d8 ---P--D 5287 informix - 0 0 0 0 0 3029bff0 ---P--D 5288 informix - 0 0 0 0 29 3029cc20 Y--P--D 23 informix - a08a92c 0 0 0 0 3029d238 ---P--D 20 informix - 0 0 0 0 2 ------------------ =>onstat -g ses 5287 IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line (Prim) (CKPT REQ) -- Up 13 days 22:31:13 -- 2232320 KbytesBlocked:CKPT session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 5287 informix - 0 - 1 16384 15040 off tid name rstcb flags curstk status 5887 dr_prpin 3029b9d8 ---P--D 544 ready Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 5287 V 61b2f020 16384 1344 20 3 name free used name free used overhead 0 1648 scb 0 96 opentable 0 280 filetable 0 40 log 0 2160 gentcb 0 576 ostcb 0 2528 sqscb 0 5872 sql 0 40 hashfiletab 0 280 sqtcb 0 1472 fragman 0 48

Jack, I would suspect that onmode -c is what is holding you up given the string of commands you provided. If a checkpoint is blocked, the first thing I would do is try to find out why. Begin my looking at onstat -u for an "X" in position 5 (in a critical section) and go from there. Afraid I cannot speak for the " db_prping" part of your question. Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Tuesday, September 03, 2013 9:00 AM To: ids@iiug.org Subject: IDS 9.4 taking time to shutdown [31332] Hi All, I would like to ask about why IDS 9.4UC6 is taking time to shutdown. It's has replication. When i perform a restart of the primary it takes me 1 to 1.5 hours to shutdown the primary database. onmode -c; >>>>> This takes a lot, 1 hour. onmode -ky; >>>> kill and yes to all sessions. I would like to ask what is db_prping process. I am suspecting this is the process that holds the shutting down of the instance. Upon checking on forums, it's a replication session. Is there a way to make the shutdown faster? Here's the output from my server IDS 9.4UC6. 3029a790 ---P--- 12 informix - 0 0 0 0 3 3029ada8 ---PR-B 13 informix - 0 0 0 1720432438 760127 3029b3c0 Y--P--D 15 informix - 30842540 0 0 87890 10124 3029b9d8 ---P--D 5287 informix - 0 0 0 0 0 3029bff0 ---P--D 5288 informix - 0 0 0 0 29 3029cc20 Y--P--D 23 informix - a08a92c 0 0 0 0 3029d238 ---P--D 20 informix - 0 0 0 0 2 ------------------ =>onstat -g ses 5287 IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line (Prim) (CKPT REQ) -- Up 13 days 22:31:13 -- 2232320 Kbytes Blocked:CKPT session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 5287 informix - 0 - 1 16384 15040 off tid name rstcb flags curstk status 5887 dr_prpin 3029b9d8 ---P--D 544 ready Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 5287 V 61b2f020 16384 1344 20 3 name free used name free used overhead 0 1648 scb 0 96 opentable 0 280 filetable 0 40 log 0 2160 gentcb 0 576 ostcb 0 2528 sqscb 0 5872 sql 0 40 hashfiletab 0 280 sqtcb 0 1472 fragman 0 48 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi Dan, Thank you for the hint you provided. I'll check it out why is the cause why the checkpoint is unable to complete. Will send an update if there's any progress on this issue. Thanks again. Appreciate your help. Regards, Jack