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.

OAM errors on Database after powerfailure

7 posts in General Discussion Last posting was on 2010-12-21 19:50:30.0Z
LEE Posted on 2010-12-15 13:55:08.0Z
Sender: 6f88.4d08c89b.1804289383@sybase.com
From: Lee
Newsgroups: sybase.public.ase.general
Subject: OAM errors on Database after powerfailure
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d08c8bc.6f90.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Dec 2010 05:55:08 -0800
X-Trace: forums-1-dub 1292421308 10.22.241.41 (15 Dec 2010 05:55:08 -0800)
X-Original-Trace: 15 Dec 2010 05:55:08 -0800, 10.22.241.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29813
Article PK: 79042

TABLE: TPDISPLAY OBJID =
1024722703

INDID=1 FIRST=2305896 ROOT=2307891 SORT=1

The missing OAM entry has been inserted.

Server Message: Number 15083, Severity 10

Server 'SAFPUR3CDBS01', Line 1:

109 OAM entries with zero used/unused page counts have been
deleted for objid 1024722703 indid 0.

The oam counts for objid 1024722703 indid 0 are corrected.

Data level: 1. 645467 Data pages allocated
and 157085 Extents allocated.

Server Message: Number 15083, Severity 10

Server 'SAFPUR3CDBS01', Line 1:

3 OAM entries with zero used/unused page counts have been
deleted for objid 1024722703 indid 1.

The oam counts for objid 1024722703 indid 1 are corrected.

Indid : 1. 27965 Index pages
allocated and 6967 Extents allocated.

INDID=2 FIRST=2365000 ROOT=2326002 SOR


Bret Halford Posted on 2010-12-15 16:27:55.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: OAM errors on Database after powerfailure
References: <4d08c8bc.6f90.1681692777@sybase.com>
In-Reply-To: <4d08c8bc.6f90.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: <4d08ec8b$1@forums-1-dub>
Date: 15 Dec 2010 08:27:55 -0800
X-Trace: forums-1-dub 1292430475 10.22.241.152 (15 Dec 2010 08:27:55 -0800)
X-Original-Trace: 15 Dec 2010 08:27:55 -0800, vip152.sybase.com
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29814
Article PK: 79047

Did you have a question about this?

BTW, the 15083 messages are not errors. 0/0 entries
occur normally as space is deallocated from a table.
They are likely not connected at all with the power failure.

-bret

On 12/15/2010 6:55 AM, Lee wrote:
> TABLE: TPDISPLAY OBJID =
> 1024722703
>
> INDID=1 FIRST=2305896 ROOT=2307891 SORT=1
>
> The missing OAM entry has been inserted.
>
> Server Message: Number 15083, Severity 10
>
> Server 'SAFPUR3CDBS01', Line 1:
>
> 109 OAM entries with zero used/unused page counts have been
> deleted for objid 1024722703 indid 0.
>
> The oam counts for objid 1024722703 indid 0 are corrected.
>
> Data level: 1. 645467 Data pages allocated
> and 157085 Extents allocated.
>
> Server Message: Number 15083, Severity 10
>
> Server 'SAFPUR3CDBS01', Line 1:
>
> 3 OAM entries with zero used/unused page counts have been
> deleted for objid 1024722703 indid 1.
>
> The oam counts for objid 1024722703 indid 1 are corrected.
>
> Indid : 1. 27965 Index pages
> allocated and 6967 Extents allocated.
>
> INDID=2 FIRST=2365000 ROOT=2326002 SOR