[IQUG] [iqug] RE: start_server command hangs

Anil Chaudhary anilk.chaudhary at gmail.com
Thu May 2 05:18:47 MST 2013


Dear

i am using sybase asiq 12.7 simplex

Based on personal experience keep -gc (check point interval in mintes)
value mentioned in configuration file as low as possible because at the
time of restoration syabse uses these check points.



On 2 May 2013 04:53, Mumy, Mark <mark.mumy at sap.com> wrote:

>  For IQ 12.7 you would need to follow the process for simplex or
> multiplex.  Much easier for simplex than for MPX.  And significantly easier
> in IQ 15/16 than in 12.  But, yes, there are ways to prune the log.****
>
> ** **
>
> Mark****
>
> * *
>
> *Mark Mumy, *Technical Director, Enterprise Systems Group, *SAP**
> *M +1 347-820-2136 | E mark.mumy at sap.com****
>
> ** **
>
> https://sap.na.pgiconnect.com/I825063****
>
> Conference tel: 18663127353,,7090196396#****
>
>
> [image: Description: Description: Description: Description: Description:
> sap_09_logo.JPG]****
>
> ** **
>
> *From:* iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] *On Behalf
> Of *Julie Nishimura
> *Sent:* Wednesday, May 01, 2013 4:46 PM
> *To:* Baker, Chris
> *Cc:* iqug at iqug.org; iqug at googlegroups.com; iqug at dssolutions.com
> *Subject:* Re: [IQUG] start_server command hangs****
>
> ** **
>
> Chris, usually we run full backup on weekly basis, and incrementals on
> daily. Our log file is around 1.5 gb as average. I wonder is there any
> command which I can use to keep our log file smaller?****
>
> ** **
>
> Thanks for your help,****
>
> Julie****
>
> ** **
>
> *From:* iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org<iqug-bounces at iqug.org>]
> *On Behalf Of *Baker, Chris
> *Sent:* Tuesday, April 30, 2013 4:34 PM
> *To:* Julie Nishimura
> *Cc:* iqug at iqug.org; iqug at googlegroups.com; iqug at dssolutions.com
> *Subject:* Re: [IQUG] start_server command hangs****
>
> ** **
>
> When was the last time you ran dbbackup and just truncated your .log file?
> ****
>
> *Chris Baker* | Solution Advisor Expert | Enterprise Systems Group | SAP
> 8 King Street East, Suite 1400, Toronto, Ontario, M5C 1B5, Canada
> T +1 647-426-0673 <+1%20647-426-0673> | M +1 647-224-2033<+1%20647-224-2033> |
> TF +1 866-716-8860 <+1%20866-716-8860>****
>
> c.baker at sap.com | www.sap.com****
>
>  ****
>
> https://sap.na.pgiconnect.com/I826572****
>
> Conference tel: 18772524916,,9648565377#****
>
>  ****
>
>
> On 2013-04-30, at 7:21 PM, "Julie Nishimura" <jnishimura at shopzilla.com>
> wrote:****
>
>  Hello everybody,****
>
> Our 12.7 server ran out of main space previously while performing weekly
> regular backup. DBA on call killed all db processes and issued start_asiq
> command. The recovery took more than 3 hours, this is the end of last
> srvlog file:****
>
>  ****
>
> I. 04/28 03:27:08. Starting database "iqpr04" (/opt/iq/db/iqpr04.db) at
> Sun Apr 28 2013 03:27****
>
> I. 04/28 03:27:09. Database recovery in progress****
>
> I. 04/28 03:27:09.     Last checkpoint at Sat Apr 27 2013 13:00****
>
> I. 04/28 03:27:09.     Checkpoint log...****
>
> I. 04/28 03:27:17.     Transaction log: iqpr04.log...****
>
> I. 04/28 06:33:24.     Rollback log...****
>
> I. 04/28 06:33:24.     Checkpointing...****
>
> I. 04/28 06:33:24. Starting checkpoint of "iqpr04" (iqpr04.db) at Sun Apr
> 28 2013 06:33****
>
> I. 04/28 06:33:29. Finished checkpoint of "iqpr04" (iqpr04.db) at Sun Apr
> 28 2013 06:33****
>
> I. 04/28 06:33:29. Recovery complete****
>
>  ****
>
>  ****
>
> This is how the end of iqmsg file looks like:****
>
>  ****
>
> I. 04/28 06:33:24. 0000000003 RcvPlaybck****
>
> I. 04/28 06:33:24. 0000000000 RcvyCmpl****
>
> I. 04/28 06:33:24. 0000000000 Chk****
>
> I. 04/28 06:33:27. 0000000000 ChkDone [NumTxnCP: 119856]****
>
> I. 04/28 06:33:27. 0000000000 PostChk****
>
> I. 04/28 06:33:29. 0000000000 Collation ISO_BINENG, Case Ignore, Blank
> Padding On, Comparisons are Conditioned****
>
> I. 04/28 06:33:29. 0000000000 CloseDatabase****
>
>  ****
>
>  ****
>
> No files have been changes since 6:33 am – neither iqmsg, nor log, nor db,
> not srvlog and stderr logs.****
>
>  ****
>
> If I grep ps –ef processes, I still see multiple processes****
>
>  ****
>
>  ****
>
> sybiq    11505 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11506 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11507 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11508 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11509 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11510 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11511 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11512 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11513 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11514 11106  9 03:27 ?        00:29:18 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    11515 11106  0 03:27 ?        00:00:00 asiqsrv12
> @/opt/iq/db/params.cfg -n iqpr04 -x tcpip{port=2314} /opt/iq/db/iqpr04.db
> ****
>
> sybiq    16668 22914  0 08:46 pts/2    00:00:00 ps –ef****
>
>  ****
>
>  ****
>
> Is the process just hanging? Should I stop it and try to restart again?
> Thanks****
>
>  ****
>
> iqhq001.shopzilla.laxhq:/opt/iq/db>./start_server****
>
>  ****
>
>  ****
>
> Starting server iqpr04 on iqhq001 at port 2314 (04/28 03:27:07)****
>
>  ****
>
> Run Directory       : /opt/iq/db****
>
> Server Executable   : /opt/iq/ASIQ-12_7/bin/asiqsrv12****
>
> Server Output Log   : /opt/iq/ASIQ-12_7/logfiles/iqpr04.187.srvlog****
>
> Server Version      : 12.7.0/ESD 5****
>
> Open Client Version : 15.0/P-EBF13571 ESD #4****
>
> User Parameters     : '@/opt/iq/db/params.cfg' '-n' 'iqpr04' '-x'
> 'tcpip{port=2314}' '/opt/iq/db/iqpr04.db'****
>
> Default Parameters  : -hs -gn 55****
>
>  ****
>
>  ****
>
>  ****
>
> =============================================================****
>
> IQ server starting with:****
>
>      50 connections         (       -gm )****
>
>      25 cmd resources       ( -iqgovern )****
>
>     341 threads             (     -iqmt )****
>
>     512 Kb thread stack size   (   -iqtss  )****
>
>   174592 Kb thread memory size ( -iqmt * -iqtss )****
>
>       4 IQ number of cpus  ( -iqnumbercpus )****
>
> =============================================================****
>
>  ****
>
> I. 04/28 03:27:08.      Adaptive Server IQ****
>
> I. 04/28 03:27:08.       Version 12.7****
>
> I. 04/28 03:27:08.        (64bit mode)****
>
> I. 04/28 03:27:08. Copyright 1992-2008 by Sybase, Inc. All rights reserved
> ****
>
> I. 04/28 03:27:08.****
>
> I. 04/28 03:27:08. 4 logical processor(s) on 2 physical processor(s)
> detected.****
>
> I. 04/28 03:27:08. Running on Linux 2.6.9-89.ELsmp #1 SMP Mon Apr 20
> 10:33:05 EDT 2009 x****
>
> I. 04/28 03:27:08. 49152K of memory used for caching****
>
> I. 04/28 03:27:08. Minimum cache size: 49152K, maximum cache size: 262012K
> ****
>
> I. 04/28 03:27:08. Using a maximum page size of 4096 bytes****
>
> I. 04/28 03:27:08. Starting database "iqpr04" (/opt/iq/db/iqpr04.db) at
> Sun Apr 28 2013 03:27****
>
> I. 04/28 03:27:09. Database recovery in progress****
>
> I. 04/28 03:27:09.     Last checkpoint at Sat Apr 27 2013 13:00****
>
> I. 04/28 03:27:09.     Checkpoint log...****
>
> I. 04/28 03:27:17.     Transaction log: iqpr04.log...****
>
> I. 04/28 06:33:24.     Rollback log...****
>
> I. 04/28 06:33:24.     Checkpointing...****
>
> I. 04/28 06:33:24. Starting checkpoint of "iqpr04" (iqpr04.db) at Sun Apr
> 28 2013 06:33****
>
> I. 04/28 06:33:29. Finished checkpoint of "iqpr04" (iqpr04.db) at Sun Apr
> 28 2013 06:33****
>
> I. 04/28 06:33:29. Recovery complete****
>
>
> ****
>
>  ****
>
>  ****
>
>  ****
>
>  ****
>
>  _______________________________________________
> IQUG mailing list
> IQUG at iqug.org
> http://iqug.org/mailman/listinfo/iqug****
>
>   --
> You received this message because you are subscribed to the Google Groups
> "iqug" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to iqug+unsubscribe at googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Thanks & Regards
Anil
---------------------------------------------------------------------------------------
Anil Kumar Chaudhary
Senior Software Engineer
Data Warehousing / Passenger Reservation Systems (PRS)
Centre For Railway Information Systems(CRIS)
Chanakyapuri, New Delhi INDIA
e-mail:chaudhary.anil at cris.org.in
web:http://www.cris.org.in
Voice :+91-11-24104525   XT:354
Mobile:+91-8130797464
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20130502/5307c845/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2409 bytes
Desc: not available
URL: <http://iqug.org/pipermail/iqug/attachments/20130502/5307c845/attachment-0001.jpg>


More information about the IQUG mailing list