Re: how to force disconnect user threads?

don't do onstat -z, that will zero out your metrics for the instance. it's onmode -z ----- Original Message ----- From: "gansvv" <gansvv@gmail.com> Sent: Mon, August 3, 2009 11:36 Subject:Re: how to force disconnect user threads? On Aug 3, 11:31 am, gansvv <gan...@gmail.com> wrote: > How can I force disconnect user threads from Informix IDS? > > Thanks. I think I got it. onstat -uand then onstat -zfor that session? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ----- End of original message -----

Thanks. But, it looks like its part of a bigger problem. My logical logs are full? Here is my onstat -m. Any help to bring the system out of full recovery mode is appreciated! ================================= informix@berlin:~$ onstat -m IBM Informix Dynamic Server Version 11.50.FC4DE -- Fast Recovery (CKPT REQ) -- Up 00:02:42 -- 149740 KbytesBlocked:CKPT Message Log File: /opt/app/informix/tmp/online.log 13:18:04 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 13:18:04 Warning: shared-memory connection file '/INFORMIXTMP/.inf.sqlexec' is overwritten. This file might belong to another instance of IDS server. If the service name of the IDS database server is not unique in the environment of the host computer where the database server resides, rename the service. 13:18:04 IBM Informix Dynamic Server Version 11.50.FC4DE SoftwareSerial Number AAA#B000000 13:18:05 IBM Informix Dynamic Server Initialized -- Shared MemoryInitialized. 13:18:05 Started 1 B-tree scanners. 13:18:05 B-tree scanner threshold set at 5000. 13:18:05 B-tree scanner range scan size set to -1. 13:18:05 B-tree scanner ALICE mode set to 6. 13:18:05 B-tree scanner index compression level set to med. 13:18:05 Physical Recovery Started at Page (1:8963). 13:18:05 Physical Recovery Complete: 1 Pages Examined, 1 Pages Restored. 13:18:05 Logical Recovery Started. 13:18:05 10 recovery worker threads will be started. 13:18:06 Logical Recovery has reached the transaction cleanup phase. 13:18:06 Logical Log Files are Full -- Backup is Needed ================================= It is a test machine, and so I tried to delete the logical logs. But is says: "This onparams operation is not supported during the transaction cleanup phase of fast recovery." I cannot shutdown the IDS, or do querying on the database! What should I do? On Aug 3, 12:21 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > don't do onstat -z, that will zero out your metrics for the instance. > it's onmode -z > > ----- Original Message ----- > From: "gansvv" <gan...@gmail.com> > Sent: Mon, August 3, 2009 11:36 > Subject:Re: how to force disconnect user threads? > > On Aug 3, 11:31 am, gansvv <gan...@gmail.com> wrote: > > How can I force disconnect user threads from Informix IDS? > > > Thanks. > > I think I got it. > > onstat -u> and then > > onstat -z> for that session? > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list > > ----- End of original message -----

gansvv wrote: > Thanks. But, it looks like its part of a bigger problem. My logical > logs are full? > > Here is my onstat -m. Any help to bring the system out of full > recovery mode is appreciated! > > ================================= > informix@berlin:~$ onstat -m > > IBM Informix Dynamic Server Version 11.50.FC4DE -- Fast Recovery (CKPT > REQ) -- Up 00:02:42 -- 149740 Kbytes> Blocked:CKPT > > Message Log File: /opt/app/informix/tmp/online.log > 13:18:04 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 13:18:04 Warning: shared-memory connection file '/> INFORMIXTMP/.inf.sqlexec' is overwritten. This file might > belong to another instance of IDS server. If the service name of the > IDS > database server is not unique in the environment of the host computer > where > the database server resides, rename the service. > 13:18:04 IBM Informix Dynamic Server Version 11.50.FC4DE Software> Serial Number AAA#B000000 > 13:18:05 IBM Informix Dynamic Server Initialized -- Shared Memory> Initialized. > > 13:18:05 Started 1 B-tree scanners. > 13:18:05 B-tree scanner threshold set at 5000. > 13:18:05 B-tree scanner range scan size set to -1. > 13:18:05 B-tree scanner ALICE mode set to 6. > 13:18:05 B-tree scanner index compression level set to med. > 13:18:05 Physical Recovery Started at Page (1:8963). > 13:18:05 Physical Recovery Complete: 1 Pages Examined, 1 Pages > Restored. > 13:18:05 Logical Recovery Started. > 13:18:05 10 recovery worker threads will be started. > 13:18:06 Logical Recovery has reached the transaction cleanup phase. > 13:18:06 Logical Log Files are Full -- Backup is Needed > =================================> > > It is a test machine, and so I tried to delete the logical logs. But > is says: > "This onparams operation is not supported during the transaction > cleanup phase of fast recovery." > > I cannot shutdown the IDS, or do querying on the database! > What should I do? > > > > > On Aug 3, 12:21 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: >> don't do onstat -z, that will zero out your metrics for the instance. >> it's onmode -z >> >> ----- Original Message ----- >> From: "gansvv" <gan...@gmail.com> >> Sent: Mon, August 3, 2009 11:36 >> Subject:Re: how to force disconnect user threads? >> >> On Aug 3, 11:31 am, gansvv <gan...@gmail.com> wrote: >>> How can I force disconnect user threads from Informix IDS? >>> Thanks. >> I think I got it. >> >> onstat -u>> and then >> >> onstat -z>> for that session? Backup your logical logs? That might be 'ontape -a' unless you use ON-Bar instead. If it won't come back up despite that -- or because you can't get ontape to run while the system is recovering, then contact IBM/Informix Tech Support.