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 chceckalloc msg 15082

2 posts in General Discussion Last posting was on 2009-09-08 21:57:40.0Z
rick_806 Posted on 2009-09-08 20:59:53.0Z
Sender: 159e.4aa6c45e.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.general
Subject: dbcc chceckalloc msg 15082
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4aa6c5c9.15cb.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Sep 2009 13:59:53 -0700
X-Trace: forums-1-dub 1252443593 10.22.241.41 (8 Sep 2009 13:59:53 -0700)
X-Original-Trace: 8 Sep 2009 13:59:53 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28279
Article PK: 77521

ASE 12.5.4

Hi,

I see a few of these errors on new server, are they
spurious? DB is not in single user mode.

Msg 15082, Level 18, State 1:
Server 'SYBASE', Line 1:
There are 4907 OAM entries with zero used/unused page
counts. Run DBCC
CHECKALLOC FIX on objid 428528560 indid 0.
Data level: 1. 20 Data pages allocated and 31
Extents allocated.

Thx,
Rick_806


Jason L. Froebe Posted on 2009-09-08 21:57:40.0Z
From: "Jason L. Froebe" <jason.froebe@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: dbcc chceckalloc msg 15082
References: <4aa6c5c9.15cb.1681692777@sybase.com>
In-Reply-To: <4aa6c5c9.15cb.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: <4aa6d354$1@forums-1-dub>
Date: 8 Sep 2009 14:57:40 -0700
X-Trace: forums-1-dub 1252447060 10.22.241.152 (8 Sep 2009 14:57:40 -0700)
X-Original-Trace: 8 Sep 2009 14:57:40 -0700, vip152.sybase.com
Lines: 27
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28280
Article PK: 77525


rick_806 wrote:
> ASE 12.5.4
>
> Hi,
>
> I see a few of these errors on new server, are they
> spurious? DB is not in single user mode.
>
> Msg 15082, Level 18, State 1:
> Server 'SYBASE', Line 1:
> There are 4907 OAM entries with zero used/unused page
> counts. Run DBCC
> CHECKALLOC FIX on objid 428528560 indid 0.
> Data level: 1. 20 Data pages allocated and 31
> Extents allocated.
>
> Thx,
> Rick_806

Nope, not likely to be spurious. You will have to run dbcc checkalloc
or dbcc tablealloc with fix to correct them durin your next scheduled
maintenance window. Leaving them for now shouldn't really hurt anything.

Jason

http://www.froebe.net/blog