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.

a sybase install programe problem?

3 posts in Windows NT Last posting was on 2001-03-27 21:32:58.0Z
davio yang Posted on 2001-03-27 02:00:05.0Z
From: "davio yang" <ydq@sumerp.com>
Subject: a sybase install programe problem?
Date: Tue, 27 Mar 2001 10:00:05 +0800
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <ts69LOmtAHA.53@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 203.93.129.202
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1034
Article PK: 1087641

I make a problem that can create object such as procedure ¡¢triggle¡£I save
the objects as sql document . I read the contents of the document
during the program execute process and execute the sql document .
at the first the amount of the objects is more than 3 hundreds ,the program
execute good .now
the amount of the objects is more than one thousand , the program don't
execute well , it
often be dead during the process .
I add the log and data device but it don't execute well.
what i should do? why ?


davio yang Posted on 2001-03-27 02:04:18.0Z
From: "davio yang" <ydq@sumerp.com>
References: <ts69LOmtAHA.53@forums.sybase.com>
Subject: Re: a sybase install program problem?
Date: Tue, 27 Mar 2001 10:04:18 +0800
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <uRnFiQmtAHA.198@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 203.93.129.202
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1033
Article PK: 1087640

Hello !
I make a program that can create object such as procedure ¡¢triggle¡£I save
the objects as sql document . I read the contents of the document
during the program execute process and execute the sql document .
at the first the amount of the objects is more than 3 hundreds ,the program
execute good .now
the amount of the objects is more than one thousand , the program don't
execute well , it
often be dead during the process .
I add the log and data device but it don't execute well.
what i should do? why ?

davio yang <ydq@sumerp.com> wrote in message
news:ts69LOmtAHA.53@forums.sybase.com...
> I make a problem that can create object such as procedure ¡¢triggle¡£I
save
> the objects as sql document . I read the contents of the document
> during the program execute process and execute the sql document .
> at the first the amount of the objects is more than 3 hundreds ,the
program
> execute good .now
> the amount of the objects is more than one thousand , the program don't
> execute well , it
> often be dead during the process .
> I add the log and data device but it don't execute well.
> what i should do? why ?
>
>


Bret Halford Posted on 2001-03-27 21:32:58.0Z
Message-ID: <3AC1070A.6EEB0BF2@sybase.com>
Date: Tue, 27 Mar 2001 14:32:58 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: a sybase install program problem?
References: <ts69LOmtAHA.53@forums.sybase.com> <uRnFiQmtAHA.198@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 45
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1022
Article PK: 1087628

If the script is dying, are there error messages being reported to the errorlog

(perhaps TIMESLICE or INFECTED WITH <signal> type errors?). If so,
please post the errors.

One possibility is that you may now be under-configured for "open objects".
Sometime after your server has been up and running for some time, run
sp_monitorconfig "open objects" and see if the output indicates "reuse".
If so, it may help to increase "open objects".

But do post any errormessages you are getting, regardless.

-bret

davio yang wrote:

> Hello !
> I make a program that can create object such as procedure ¡¢triggle¡£I save
> the objects as sql document . I read the contents of the document
> during the program execute process and execute the sql document .
> at the first the amount of the objects is more than 3 hundreds ,the program
> execute good .now
> the amount of the objects is more than one thousand , the program don't
> execute well , it
> often be dead during the process .
> I add the log and data device but it don't execute well.
> what i should do? why ?
>
> davio yang <ydq@sumerp.com> wrote in message
> news:ts69LOmtAHA.53@forums.sybase.com...
> > I make a problem that can create object such as procedure ¡¢triggle¡£I
> save
> > the objects as sql document . I read the contents of the document
> > during the program execute process and execute the sql document .
> > at the first the amount of the objects is more than 3 hundreds ,the
> program
> > execute good .now
> > the amount of the objects is more than one thousand , the program don't
> > execute well , it
> > often be dead during the process .
> > I add the log and data device but it don't execute well.
> > what i should do? why ?
> >
> >