Re^3: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4

In case your dbas need information on the Config file. In particular, look at:

-iqgovern Number of concurrent queries (default is 2*num_cpu+10)
-gm Number of connections that can be active at one time

You might be running into blocking locks if the parallel runs of your Perl code are hitting the same pages.

As far as Perl goes, you may want to enable DBI Tracing to determine if there is something funky going on.

Jason L. Froebe

Comment on Re^3: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4

Replies are listed 'Best First'.
Re^4: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4 by cmahajan (Initiate) on Jun 20, 2013 at 01:34 UTC
I'm going to enable DBI tracing and will check the trace file for any hints. Will update the results here.	[reply]
Re^4: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4 by cmahajan (Initiate) on Jun 25, 2013 at 02:47 UTC
I enabled DBI Tracing in my script and here's the error message I got in the trace file. I was lucky enough that the issue occurred shortly after I added the tracing code in my code. From the error message I believe that this is related to the network configuration on my Unix machine (IBM AIX). Any ideas on how to go about fixing this? =================================== -> FETCH for DBD::Sybase::db (DBI::db=HASH(0x30844064)~INNER 'Driver') ERROR: 50 'OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (5) NUMBER = (28) Server bhedw_dev, database Message String: ct_results(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received. OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (50) Server bhedw_dev, database Message String: ct_cmd_drop(): user api layer: external error: The connection has been marked dead. ===================================	[reply]
Re^5: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4 by jfroebe (Parson) on Sep 19, 2013 at 13:08 UTC
Try running the query from isql or dbisql. isql will handle t-sql and dbisql will handle Watcom-SQL. Jason L. Froebe Blog, Tech Blog	[reply]