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.

[Fwd: Stored Procedure under Parallelism]

2 posts in Windows NT Last posting was on 2000-01-05 14:26:00.0Z
Raymond Posted on 2000-01-05 14:21:08.0Z
Message-ID: <38735354.78CD06C3@i-cable.com>
Date: Wed, 05 Jan 2000 22:21:08 +0800
From: Raymond <ray_leung@i-cable.com>
Reply-To: ray_leung@i-cable.com
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: [Fwd: Stored Procedure under Parallelism]
Content-Type: multipart/mixed; boundary="------------46FB982872AB46F9EC14C0E5"
Newsgroups: sybase.public.sqlserver.nt
Lines: 37
NNTP-Posting-Host: ip091231.i-cable.com 203.83.91.231
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2741
Article PK: 1090127

Any body can help me?


Eric McGrane Posted on 2000-01-05 14:26:00.0Z
Message-ID: <38735478.F185F181@sybase.com>
Date: Wed, 05 Jan 2000 09:26:00 -0500
From: Eric McGrane <mcgrane@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: ray_leung@i-cable.com
Subject: Re: [Fwd: Stored Procedure under Parallelism]
References: <38735354.78CD06C3@i-cable.com>
Content-Type: multipart/mixed; boundary="------------D5F59C1B4C258A010AFD123F"
Newsgroups: sybase.public.sqlserver.nt
Lines: 51
NNTP-Posting-Host: mcgrane-nt.sybase.com 157.133.126.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2740
Article PK: 1090126

Raymond,

I am not sure I understand your question. Are you saying that the select when
run as a parallel query returns a 208, object not found, error? If that is
the case, and this is reproducible, I would contact Tech Support. I just did
a quick check for bugs, very quickly so I may have missed one, and I didn't
find anything.

Regards,
E

Raymond wrote:

> Any body can help me?
>
> ------------------------------------------------------------------------
>
> Subject: Stored Procedure under Parallelism
> Date: Tue, 28 Dec 1999 22:35:46 +0800
> From: Raymond <ray_leung@i-cable.com>
> Newsgroups: sybase.public.sqlserver.performance+tuning
>
> Hi,
>
> I have install ASE on a server with 4 CPU and configure as following
>
> parallel degree = 4,
> max scan parallel = 4,
> number of worker process = 20
>
> Does it affect the following statement of a stored procedure under
> parallelism
>
> create table #tmp_1
> insert #tmp_1 ...
> select * from #tmp_1 ....
> drop #tmp_1
>
> I want to confirm will the table be dropped after insert? And cause
> "Select Error, #tmp_1 does not exist" message return from ASE server
> under parallelism?
>
> Thanks for attention......
>
> Raymond


Download VCard mcgrane.vcf