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.

dbcc problem

2 posts in Migration Last posting was on 2001-01-05 05:34:37.0Z
PETE MA Posted on 2001-01-05 02:16:07.0Z
From: "PETE MA" <pete.ma@haeco.com>
Subject: dbcc problem
Date: Fri, 5 Jan 2001 10:16:07 +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: <AXnVC$rdAHA.290@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
NNTP-Posting-Host: 168.70.218.253
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:320
Article PK: 1067745

After upgrading to 11.9.2 from 11.0.3
We have the following mesages when doing dbcc

Your "at" job on haeco
"/var/spool/cron/atjobs/978624300.a"

produced the following output:

update statistic for database wcsdb error

Each stored procedure and trigger that uses table 'shifthr' will be
recompiled
the next time it is executed.
(return status = 0)
Each stored procedure and trigger that uses table 'jpbrt_prjctl' will be
recompiled the next time it is executed.
(return status = 0)
Each stored procedure and trigger that uses table 'log_wcswork_freq' will be
recompiled the next time it is executed.
(return status = 0)
Each stored procedure and trigger that uses table 'log_cxbdd_dtl' will be
recompiled the next time it is executed.
(return status = 0)
.....

Why?How can i solve it?
Thx

Pete


Anthony Mandic <am Posted on 2001-01-05 05:34:37.0Z
Date: Fri, 05 Jan 2001 16:34:37 +1100
From: Anthony Mandic <am@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: dbcc problem
References: <AXnVC$rdAHA.290@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <RiBm4stdAHA.87@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
Lines: 13
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:319
Article PK: 1067743


PETE MA wrote:
>
> After upgrading to 11.9.2 from 11.0.3
> We have the following mesages when doing dbcc
>
> Your "at" job on haeco
> "/var/spool/cron/atjobs/978624300.a"
>
> produced the following output:
>
> update statistic for database wcsdb error
>
> Each stored procedure and trigger that uses table 'shifthr' will be
> recompiled the next time it is executed.
> (return status = 0)

This is the standard message that is returned from sp_recompile.
Ignore it.

-am