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.

Undocumented message from IQ 15.4

3 posts in General Discussion Last posting was on 2012-04-23 06:18:01.0Z
GS Posted on 2012-04-16 11:57:09.0Z
Sender: 7eb9.4f8c06e1.1804289383@sybase.com
From: GS
Newsgroups: sybase.public.iq
Subject: Undocumented message from IQ 15.4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f8c0915.7f05.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 16 Apr 2012 04:57:09 -0700
X-Trace: forums-1-dub 1334577429 172.20.134.41 (16 Apr 2012 04:57:09 -0700)
X-Original-Trace: 16 Apr 2012 04:57:09 -0700, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4485
Article PK: 246626

Can somebody explain these messages? Any glues?


I. 04/16 14:54:24. 0000141712 --+ Direct
filtered equijoin: (a.lon = b.lon)
I. 04/16 14:54:24. 0000141712 --+ Direct
filtered RHS effectively filtered: 1
I. 04/16 14:54:24. 0000141712 --+ Direct
filtered RHS indirectly filtered: 0
I. 04/16 14:54:24. 0000141712 --+ Direct
filtered RHS min selectivity: 0.0000
I. 04/16 14:54:24. 0000141712 --+ Direct
filtered equijoin: (a.lon = b.lon)
I. 04/16 14:54:24. 0000141712 --+ Direct
filtered RHS effectively filtered: 1
I. 04/16 14:54:24. 0000141712 --+ Direct
filtered RHS indirectly filtered: 0
I. 04/16 14:54:24. 0000141712 --+ Direct
filtered RHS min selectivity: 0.0000


dew Posted on 2012-04-19 19:08:56.0Z
Sender: 18e1.4f9023be.1804289383@sybase.com
From: dew
Newsgroups: sybase.public.iq
Subject: Re: Undocumented message from IQ 15.4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f9062c8.201c.1681692777@sybase.com>
References: <4f8c0915.7f05.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 19 Apr 2012 12:08:56 -0700
X-Trace: forums-1-dub 1334862536 172.20.134.41 (19 Apr 2012 12:08:56 -0700)
X-Original-Trace: 19 Apr 2012 12:08:56 -0700, 172.20.134.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4491
Article PK: 246631

> Can somebody explain these messages? Any glues?

The messages below are trace output for debugging IQ
optimizer issues. You should only get that output if certain
undocumented options (in this case, DML_Options4) are set to
a certain value.

The DML_Options4 option should normally be set to zero
unless Sybase support has recommended a different value for
you. If a support engineer from Sybase has recommended
setting DML_Options4 to a non-zero value, you should
probably contact Sybase, otherwise set it back to zero.

>
>
> I. 04/16 14:54:24. 0000141712 --+ Direct
> filtered equijoin: (a.lon = b.lon)
> I. 04/16 14:54:24. 0000141712 --+ Direct
> filtered RHS effectively filtered: 1
> I. 04/16 14:54:24. 0000141712 --+ Direct
> filtered RHS indirectly filtered: 0
> I. 04/16 14:54:24. 0000141712 --+ Direct
> filtered RHS min selectivity: 0.0000
> I. 04/16 14:54:24. 0000141712 --+ Direct
> filtered equijoin: (a.lon = b.lon)
> I. 04/16 14:54:24. 0000141712 --+ Direct
> filtered RHS effectively filtered: 1
> I. 04/16 14:54:24. 0000141712 --+ Direct
> filtered RHS indirectly filtered: 0
> I. 04/16 14:54:24. 0000141712 --+ Direct
> filtered RHS min selectivity: 0.0000


GS Posted on 2012-04-23 06:18:01.0Z
Sender: 68a1.4f94eddb.1804289383@sybase.com
From: GS
Newsgroups: sybase.public.iq
Subject: Re: Undocumented message from IQ 15.4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f94f419.6a98.1681692777@sybase.com>
References: <4f9062c8.201c.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 22 Apr 2012 23:18:01 -0700
X-Trace: forums-1-dub 1335161881 172.20.134.41 (22 Apr 2012 23:18:01 -0700)
X-Original-Trace: 22 Apr 2012 23:18:01 -0700, 172.20.134.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4493
Article PK: 246633

DML_Options4 was set to 0 in IQ 15.2 (no messages appeared)
and is permanently set to 0( messages appear) ,too.
Thank you for response, indeed.

> Can somebody explain these messages? Any glues?
>
> The messages below are trace output for debugging IQ
> optimizer issues. You should only get that output if
> certain undocumented options (in this case, DML_Options4)
> are set to a certain value.
>
> The DML_Options4 option should normally be set to zero
> unless Sybase support has recommended a different value
> for you. If a support engineer from Sybase has recommended
> setting DML_Options4 to a non-zero value, you should
> probably contact Sybase, otherwise set it back to zero.
>
> >
> >
> > I. 04/16 14:54:24. 0000141712 --+ Direct
> > filtered equijoin: (a.lon = b.lon)
> > I. 04/16 14:54:24. 0000141712 --+ Direct
> > filtered RHS effectively filtered: 1
> > I. 04/16 14:54:24. 0000141712 --+ Direct
> > filtered RHS indirectly filtered: 0
> > I. 04/16 14:54:24. 0000141712 --+ Direct
> > filtered RHS min selectivity: 0.0000
> > I. 04/16 14:54:24. 0000141712 --+ Direct
> > filtered equijoin: (a.lon = b.lon)
> > I. 04/16 14:54:24. 0000141712 --+ Direct
> > filtered RHS effectively filtered: 1
> > I. 04/16 14:54:24. 0000141712 --+ Direct
> > filtered RHS indirectly filtered: 0
> > I. 04/16 14:54:24. 0000141712 --+ Direct
> > filtered RHS min selectivity: 0.0000