Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

IQ core dumps repeatedly on Solaris 10

10 posts in General Discussion Last posting was on 2012-09-26 20:15:36.0Z
Larry Gale Posted on 2012-02-07 19:31:51.0Z
Sender: 6422.4f317b1b.1804289383@sybase.com
From: Larry Gale
Newsgroups: sybase.public.iq
Subject: IQ core dumps repeatedly on Solaris 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f317c27.6444.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 7 Feb 2012 11:31:51 -0800
X-Trace: forums-1-dub 1328643111 172.20.134.41 (7 Feb 2012 11:31:51 -0800)
X-Original-Trace: 7 Feb 2012 11:31:51 -0800, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4459
Article PK: 246599

We are running Sybase IQ 15.3 on Solaris 10. We have been
having problems for months with the IQ server core dumping
when running a perfectly legal query.

We upgraded from 15.1 to 15.3, since that's what Sybase
suggested when we had this problem under IQ 15.1, but it
still hasn't eliminated the problem.

Has anybody else experienced issues with IQ core dumping?
This has been going on for months, and Sybase tech support
hasn't found a solution.

Larry Gale
galel@musc.edu


Manish Negandhi [TeamSybase] Posted on 2012-02-08 13:38:32.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.iq
References: <4f317c27.6444.1681692777@sybase.com>
Subject: Re: IQ core dumps repeatedly on Solaris 10
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f327ad8$1@forums-1-dub>
Date: 8 Feb 2012 05:38:32 -0800
X-Trace: forums-1-dub 1328708312 10.22.241.152 (8 Feb 2012 05:38:32 -0800)
X-Original-Trace: 8 Feb 2012 05:38:32 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4460
Article PK: 246602

Is there any error messages in msg or serverlog files ? any stack traces ?

Manish Negandhi
[TeamSybase]

<Larry Gale> wrote in message news:4f317c27.6444.1681692777@sybase.com...
> We are running Sybase IQ 15.3 on Solaris 10. We have been
> having problems for months with the IQ server core dumping
> when running a perfectly legal query.
>
> We upgraded from 15.1 to 15.3, since that's what Sybase
> suggested when we had this problem under IQ 15.1, but it
> still hasn't eliminated the problem.
>
> Has anybody else experienced issues with IQ core dumping?
> This has been going on for months, and Sybase tech support
> hasn't found a solution.
>
> Larry Gale
> galel@musc.edu


peta62 Posted on 2012-02-08 22:38:31.0Z
From: peta62 <no@mail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: IQ core dumps repeatedly on Solaris 10
References: <4f327ad8$1@forums-1-dub> <4f32d2df.261f.1681692777@sybase.com> <4f32e3e3$1@forums-1-dub>
In-Reply-To: <4f32e3e3$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f32f967@forums-1-dub>
Date: 8 Feb 2012 14:38:31 -0800
X-Trace: forums-1-dub 1328740711 10.22.241.152 (8 Feb 2012 14:38:31 -0800)
X-Original-Trace: 8 Feb 2012 14:38:31 -0800, vip152.sybase.com
Lines: 65
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4463
Article PK: 246603

Hello,
I am curious too, you wrote "perfectly legal query", does it mean it is
one and the same ? If yes can you reproduce it in another environment ?
Regrds,
Peter

On 2/8/2012 10:06 PM, IQRules wrote:
> Just curious, you have weekly checkDB here and Hardware side is
> confirmed no issue ??
>
>
> On 2/8/2012 2:54 PM, Larry Gale wrote:
>> Yes, we've uploaded those to Sybase with our trouble tickets
>> (actually, our systems integrator, Telus Healthcare, has
>> been handling the tickets with Sybase). Multiple core
>> files, stack traces, message files, log files, etc., but
>> still no answer on what the problem is and why we continue
>> to experience crashes.
>>
>> But we still haven't been able to get any definitive answer
>> on why a legal query crashes the server, rather than saying
>> "sorry, can't parse that", or some similar message. We
>> upgraded to 15.3 in December 2011, and we've had multiple
>> crashes since then. We'd had similar problems on 15.1,
>> before we upgraded to 15.3, and were hoping the upgrade
>> would solve the problem, but it clearly has not.
>>
>> As a comparison, our main clinical data repository runs on
>> Sybase ASE. As far as I know, they've NEVER had the ASE
>> server crash on them, so we're really curious why IQ seems
>> so fragile.
>>
>> The lack of stability is frustrating to us and to our user
>> community. IQ is an amazing product for reporting; I've
>> never seen anything like this kind of speed, but it just
>> crashes so often that our management may lose confidence in
>> the product and look at other options.
>>
>>
>>> Is there any error messages in msg or serverlog files ?
>>> any stack traces ?
>>>
>>> Manish Negandhi
>>> [TeamSybase]
>>>
>>> <Larry Gale> wrote in message
>>>> news:4f317c27.6444.1681692777@sybase.com... We are
>>>> running Sybase IQ 15.3 on Solaris 10. We have been
>>>> having problems for months with the IQ server core
>>> dumping when running a perfectly legal query.>
>>>> We upgraded from 15.1 to 15.3, since that's what Sybase
>>>> suggested when we had this problem under IQ 15.1, but it
>>>> still hasn't eliminated the problem.
>>>>
>>>> Has anybody else experienced issues with IQ core
>>>> dumping? This has been going on for months, and Sybase
>>>> tech support hasn't found a solution.
>>>>
>>>> Larry Gale
>>>> galel@musc.edu
>>>
>>>
>


Larry Gale Posted on 2012-02-09 13:08:10.0Z
Sender: 5e27.4f33c3ef.1804289383@sybase.com
From: Larry Gale
Newsgroups: sybase.public.iq
Subject: Re: IQ core dumps repeatedly on Solaris 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f33c53a.5e5d.1681692777@sybase.com>
References: <4f32f967@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Feb 2012 05:08:10 -0800
X-Trace: forums-1-dub 1328792890 172.20.134.41 (9 Feb 2012 05:08:10 -0800)
X-Original-Trace: 9 Feb 2012 05:08:10 -0800, 172.20.134.41
Lines: 86
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4464
Article PK: 246604


> Hello,
> I am curious too, you wrote "perfectly legal query",
> does it mean it is one and the same ? If yes can you
> reproduce it in another environment ? Regrds,
> Peter
>

We have a development environment with the exact software
and hardware configuration, but with only a small (10%)
subset of our database from the production server.

The queries in question sometimes fail on the development
server, but others run successfully on the development
system. For those, we suspect the size of the dataset may
have an impact.

But our main concern is: even "bad" queries shouldn't cause
a production commercial database product to crash! At
worst, it should say "can't parse that query", or "result
set too large", or some similar warning, and then allow
other users to continue processing.

It's the apparent inability of Sybase Technical Support,
after two months, to still be unable to provide us a
solution to this problem. I'm hoping that by posting on
this forum, somebody with similar experiences may be able to
elucidate.

>
> On 2/8/2012 10:06 PM, IQRules wrote:
> > Just curious, you have weekly checkDB here and Hardware
> > side is confirmed no issue ??
> >
> >
> > On 2/8/2012 2:54 PM, Larry Gale wrote:
> >> Yes, we've uploaded those to Sybase with our trouble
> tickets >> (actually, our systems integrator, Telus
> Healthcare, has >> been handling the tickets with Sybase).
> Multiple core >> files, stack traces, message files, log
> files, etc., but >> still no answer on what the problem is
> and why we continue >> to experience crashes.
> >>
> >> But we still haven't been able to get any definitive
> answer >> on why a legal query crashes the server, rather
> than saying >> "sorry, can't parse that", or some similar
> message. We >> upgraded to 15.3 in December 2011, and
> we've had multiple >> crashes since then. We'd had similar
> problems on 15.1, >> before we upgraded to 15.3, and were
> hoping the upgrade >> would solve the problem, but it
> clearly has not. >>
> >> As a comparison, our main clinical data repository runs
> on >> Sybase ASE. As far as I know, they've NEVER had the
> ASE >> server crash on them, so we're really curious why
> IQ seems >> so fragile.
> >>
> >> The lack of stability is frustrating to us and to our
> user >> community. IQ is an amazing product for reporting;
> I've >> never seen anything like this kind of speed, but
> it just >> crashes so often that our management may lose
> confidence in >> the product and look at other options.
> >>
> >>
> >>> Is there any error messages in msg or serverlog files
> ? >>> any stack traces ?
> >>>
> >>> Manish Negandhi
> >>> [TeamSybase]
> >>>
> >>> <Larry Gale> wrote in message
> >>>> news:4f317c27.6444.1681692777@sybase.com... We are
> >>>> running Sybase IQ 15.3 on Solaris 10. We have been
> >>>> having problems for months with the IQ server core
> >>> dumping when running a perfectly legal query.>
> >>>> We upgraded from 15.1 to 15.3, since that's what
> Sybase >>>> suggested when we had this problem under IQ
> 15.1, but it >>>> still hasn't eliminated the problem.
> >>>>
> >>>> Has anybody else experienced issues with IQ core
> >>>> dumping? This has been going on for months, and
> Sybase >>>> tech support hasn't found a solution.
> >>>>
> >>>> Larry Gale
> >>>> galel@musc.edu
> >>>
> >>>
> >
>


IQRules Posted on 2012-02-09 14:56:45.0Z
From: IQRules <iqrules@noname.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0) Gecko/20120129 Thunderbird/10.0
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: IQ core dumps repeatedly on Solaris 10
References: <4f32f967@forums-1-dub> <4f33c53a.5e5d.1681692777@sybase.com>
In-Reply-To: <4f33c53a.5e5d.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f33dead$1@forums-1-dub>
Date: 9 Feb 2012 06:56:45 -0800
X-Trace: forums-1-dub 1328799405 10.22.241.152 (9 Feb 2012 06:56:45 -0800)
X-Original-Trace: 9 Feb 2012 06:56:45 -0800, vip152.sybase.com
Lines: 93
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4465
Article PK: 246605

Is this with EMC SAN storage, LVM in use?
And at IQ side, do you have the Max_temp_Space_per_Connection setting ?
Or how big of the temp db space sizing?

On 2/9/2012 8:08 AM, Larry Gale wrote:
>> Hello,
>> I am curious too, you wrote "perfectly legal query",
>> does it mean it is one and the same ? If yes can you
>> reproduce it in another environment ? Regrds,
>> Peter
>>
> We have a development environment with the exact software
> and hardware configuration, but with only a small (10%)
> subset of our database from the production server.
>
> The queries in question sometimes fail on the development
> server, but others run successfully on the development
> system. For those, we suspect the size of the dataset may
> have an impact.
>
> But our main concern is: even "bad" queries shouldn't cause
> a production commercial database product to crash! At
> worst, it should say "can't parse that query", or "result
> set too large", or some similar warning, and then allow
> other users to continue processing.
>
> It's the apparent inability of Sybase Technical Support,
> after two months, to still be unable to provide us a
> solution to this problem. I'm hoping that by posting on
> this forum, somebody with similar experiences may be able to
> elucidate.
>
>>
>> On 2/8/2012 10:06 PM, IQRules wrote:
>>> Just curious, you have weekly checkDB here and Hardware
>>> side is confirmed no issue ??
>>>
>>>
>>> On 2/8/2012 2:54 PM, Larry Gale wrote:
>>>> Yes, we've uploaded those to Sybase with our trouble
>> tickets>> (actually, our systems integrator, Telus
>> Healthcare, has>> been handling the tickets with Sybase).
>> Multiple core>> files, stack traces, message files, log
>> files, etc., but>> still no answer on what the problem is
>> and why we continue>> to experience crashes.
>>>>
>>>> But we still haven't been able to get any definitive
>> answer>> on why a legal query crashes the server, rather
>> than saying>> "sorry, can't parse that", or some similar
>> message. We>> upgraded to 15.3 in December 2011, and
>> we've had multiple>> crashes since then. We'd had similar
>> problems on 15.1,>> before we upgraded to 15.3, and were
>> hoping the upgrade>> would solve the problem, but it
>> clearly has not.>>
>>>> As a comparison, our main clinical data repository runs
>> on>> Sybase ASE. As far as I know, they've NEVER had the
>> ASE>> server crash on them, so we're really curious why
>> IQ seems>> so fragile.
>>>>
>>>> The lack of stability is frustrating to us and to our
>> user>> community. IQ is an amazing product for reporting;
>> I've>> never seen anything like this kind of speed, but
>> it just>> crashes so often that our management may lose
>> confidence in>> the product and look at other options.
>>>>
>>>>
>>>>> Is there any error messages in msg or serverlog files
>> ?>>> any stack traces ?
>>>>>
>>>>> Manish Negandhi
>>>>> [TeamSybase]
>>>>>
>>>>> <Larry Gale> wrote in message
>>>>>> news:4f317c27.6444.1681692777@sybase.com... We are
>>>>>> running Sybase IQ 15.3 on Solaris 10. We have been
>>>>>> having problems for months with the IQ server core
>>>>> dumping when running a perfectly legal query.>
>>>>>> We upgraded from 15.1 to 15.3, since that's what
>> Sybase>>>> suggested when we had this problem under IQ
>> 15.1, but it>>>> still hasn't eliminated the problem.
>>>>>>
>>>>>> Has anybody else experienced issues with IQ core
>>>>>> dumping? This has been going on for months, and
>> Sybase>>>> tech support hasn't found a solution.
>>>>>>
>>>>>> Larry Gale
>>>>>> galel@musc.edu
>>>>>
>>>>>
>>>
>>


Abhijit Jadhav Posted on 2012-05-09 06:58:18.0Z
Sender: 7333.4faa0e09.1804289383@sybase.com
From: Abhijit Jadhav
Newsgroups: sybase.public.iq
Subject: Re: IQ core dumps repeatedly on Solaris 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4faa158a.74bc.1681692777@sybase.com>
References: <4f317c27.6444.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 8 May 2012 23:58:18 -0700
X-Trace: forums-1-dub 1336546698 172.20.134.41 (8 May 2012 23:58:18 -0700)
X-Original-Trace: 8 May 2012 23:58:18 -0700, 172.20.134.41
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4502
Article PK: 246642

Larry,

Sorry to hear that. I was in the same boat for more than 3
months and finally we were able find out the root cause of
issue and work around to get rid of server crash. My two
different profile production servers used to crash n number
of times in business hours. :)

Here we go, There are so many reasons that Sybase IQ sever
can be crashed!!! In our one case there was issue with FP3
optimised indexes. Sybase Tech Support provided CORE_OPTION
to change behaviour of optimiser. In second case the issue
was with client .Net application, Server used to crash on
passing double NaN variable which was theoratically bad
application program. In the second case Sybase ODBC driver
is unable to throw error on handeling Double, but in either
case Sybase IQ Server should not crash!!!

To resolve the issue, You need to find out and Sybase
Technical Support help. You need to find out which queries
causing the server crash.
1. Enable request level logging and load the file after
crash, see what was happening at the time of crash.
2. Check .iqmsg file at the time of crash (last load
statement, and other information is recorded)
3. Check .srvlog file at the time of crash (see any errors)
4. Do you have large core files? if yes try to analyse those
with utilities like pstack, gdb (bt)
5. Once is find the SP or code causing issue, then try
inserting messages in to the code to find out exact piece of
SQL causing the issue.

Hope this helps.

Regards,
Abhijit

> We are running Sybase IQ 15.3 on Solaris 10. We have been
> having problems for months with the IQ server core dumping
> when running a perfectly legal query.
>
> We upgraded from 15.1 to 15.3, since that's what Sybase
> suggested when we had this problem under IQ 15.1, but it
> still hasn't eliminated the problem.
>
> Has anybody else experienced issues with IQ core dumping?
> This has been going on for months, and Sybase tech support
> hasn't found a solution.
>
> Larry Gale
> galel@musc.edu


Manish Negandhi [TeamSybase] Posted on 2012-05-14 04:56:05.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.iq
References: <4f317c27.6444.1681692777@sybase.com> <4faa158a.74bc.1681692777@sybase.com>
Subject: Re: IQ core dumps repeatedly on Solaris 10
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fb09065$1@forums-1-dub>
Date: 13 May 2012 21:56:05 -0700
X-Trace: forums-1-dub 1336971365 10.22.241.152 (13 May 2012 21:56:05 -0700)
X-Original-Trace: 13 May 2012 21:56:05 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4504
Article PK: 246644

Sybase provides you a script to collect diagnostic information while
escalating issues to Tech Support. When you escalate any problems to tech
support, you can use getiqinfo.sh on Unix or getiqinfo.bat on Windows The
script can be found in IQ-15_*/bin64 directory

-HTH
Manish Negandhi
[TeamSybase]

<Abhijit Jadhav> wrote in message
news:4faa158a.74bc.1681692777@sybase.com...
> Larry,
>
> Sorry to hear that. I was in the same boat for more than 3
> months and finally we were able find out the root cause of
> issue and work around to get rid of server crash. My two
> different profile production servers used to crash n number
> of times in business hours. :)
>
> Here we go, There are so many reasons that Sybase IQ sever
> can be crashed!!! In our one case there was issue with FP3
> optimised indexes. Sybase Tech Support provided CORE_OPTION
> to change behaviour of optimiser. In second case the issue
> was with client .Net application, Server used to crash on
> passing double NaN variable which was theoratically bad
> application program. In the second case Sybase ODBC driver
> is unable to throw error on handeling Double, but in either
> case Sybase IQ Server should not crash!!!
>
> To resolve the issue, You need to find out and Sybase
> Technical Support help. You need to find out which queries
> causing the server crash.
> 1. Enable request level logging and load the file after
> crash, see what was happening at the time of crash.
> 2. Check .iqmsg file at the time of crash (last load
> statement, and other information is recorded)
> 3. Check .srvlog file at the time of crash (see any errors)
> 4. Do you have large core files? if yes try to analyse those
> with utilities like pstack, gdb (bt)
> 5. Once is find the SP or code causing issue, then try
> inserting messages in to the code to find out exact piece of
> SQL causing the issue.
>
> Hope this helps.
>
> Regards,
> Abhijit
>
>
>> We are running Sybase IQ 15.3 on Solaris 10. We have been
>> having problems for months with the IQ server core dumping
>> when running a perfectly legal query.
>>
>> We upgraded from 15.1 to 15.3, since that's what Sybase
>> suggested when we had this problem under IQ 15.1, but it
>> still hasn't eliminated the problem.
>>
>> Has anybody else experienced issues with IQ core dumping?
>> This has been going on for months, and Sybase tech support
>> hasn't found a solution.
>>
>> Larry Gale
>> galel@musc.edu


Dennis Grant Posted on 2012-09-26 20:15:36.0Z
Sender: 5fce.50635e8d.1804289383@sybase.com
From: Dennis Grant
Newsgroups: sybase.public.iq
Subject: Re: IQ core dumps repeatedly on Solaris 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50636268.6027.1681692777@sybase.com>
References: <4fb09065$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 26 Sep 2012 13:15:36 -0700
X-Trace: forums-1-dub 1348690536 172.20.134.41 (26 Sep 2012 13:15:36 -0700)
X-Original-Trace: 26 Sep 2012 13:15:36 -0700, 172.20.134.41
Lines: 72
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4552
Article PK: 246694

We had similar problem with queries crashing the server.
Setting this option solved our problem:

SET OPTION PUBLIC.Core_Options13=33554432;

> Sybase provides you a script to collect diagnostic
> information while escalating issues to Tech Support. When
> you escalate any problems to tech support, you can use
> getiqinfo.sh on Unix or getiqinfo.bat on Windows The
> script can be found in IQ-15_*/bin64 directory
>
> -HTH
> Manish Negandhi
> [TeamSybase]
>
> <Abhijit Jadhav> wrote in message
> news:4faa158a.74bc.1681692777@sybase.com...
> > Larry,
> >
> > Sorry to hear that. I was in the same boat for more than
> > 3 months and finally we were able find out the root
> > cause of issue and work around to get rid of server
> > crash. My two different profile production servers used
> > to crash n number of times in business hours. :)
> >
> > Here we go, There are so many reasons that Sybase IQ
> > sever can be crashed!!! In our one case there was issue
> > with FP3 optimised indexes. Sybase Tech Support provided
> > CORE_OPTION to change behaviour of optimiser. In second
> > case the issue was with client .Net application, Server
> > used to crash on passing double NaN variable which was
> > theoratically bad application program. In the second
> > case Sybase ODBC driver is unable to throw error on
> > handeling Double, but in either case Sybase IQ Server
> should not crash!!! >
> > To resolve the issue, You need to find out and Sybase
> > Technical Support help. You need to find out which
> > queries causing the server crash.
> > 1. Enable request level logging and load the file after
> > crash, see what was happening at the time of crash.
> > 2. Check .iqmsg file at the time of crash (last load
> > statement, and other information is recorded)
> > 3. Check .srvlog file at the time of crash (see any
> > errors) 4. Do you have large core files? if yes try to
> > analyse those with utilities like pstack, gdb (bt)
> > 5. Once is find the SP or code causing issue, then try
> > inserting messages in to the code to find out exact
> > piece of SQL causing the issue.
> >
> > Hope this helps.
> >
> > Regards,
> > Abhijit
> >
> >
> >> We are running Sybase IQ 15.3 on Solaris 10. We have
> been >> having problems for months with the IQ server core
> dumping >> when running a perfectly legal query.
> >>
> >> We upgraded from 15.1 to 15.3, since that's what Sybase
> >> suggested when we had this problem under IQ 15.1, but
> it >> still hasn't eliminated the problem.
> >>
> >> Has anybody else experienced issues with IQ core
> dumping? >> This has been going on for months, and Sybase
> tech support >> hasn't found a solution.
> >>
> >> Larry Gale
> >> galel@musc.edu
>
>