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.

Utility to update or reinitialize data page header

2 posts in Windows NT Last posting was on 2000-08-14 12:31:32.0Z
Jaco Grobler Posted on 2000-08-14 11:23:59.0Z
From: "Jaco Grobler" <jacog@pillar.co.za>
Subject: Utility to update or reinitialize data page header
Date: Mon, 14 Aug 2000 13:23:59 +0200
Lines: 417
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: <FqXUUNeBAHA.270@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: na.sdn.net.za 216.5.0.238
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1744
Article PK: 1089217

Hi All

I am experiencing problems on a database running at one of out customers.
The database transaction log keeps on growing although it is supposed to
maintain itself with tresholds etc. It got to a point that the database
locked up because the tran log was full. This is the point where I was
called in.

Using DBCC i discovered several allocation errors, most of which the fix
option sorted out. By the way this problem existed several backups back but
no proper dba function exists at the site to pick up these problems early
enough.

When i try to do a manual dump tran i receive the following error


Attached are the output from several dbcc. As you can see the problem is
with page nr 709545. This page is not currently allocated to any object,
neither is the extent on which it is located or the allocation unit for that
extent.

However the page header for this page still indicate that it is allocated to
objid 8 (syslogs). I believe this to be the reason that checkallocation and
checktable dbcc's do not report a error before executing a dump tran, since
they propbably check linkage from the objid level and objid 8 does not have
any extents allocated to it at this stage. It seems however that dump tran
scans the page headers and picks up this page, attempts to dump it but can
not get to it due to the fact that no linkage exists to it from the object.

I urgently require a method by which to change the objid on page 709545 to
zero (0) so that the transaction log can be dumped as normal.

Any and all suggestion will be greatly appreciated

Jaco Grobler


Jason Froebe Posted on 2000-08-14 12:31:32.0Z
From: "Jason Froebe" <jfroebe@sybase.com>
References: <FqXUUNeBAHA.270@forums.sybase.com>
Subject: Re: Utility to update or reinitialize data page header
Date: Mon, 14 Aug 2000 07:31:32 -0500
Lines: 55
Organization: Sybase, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <GSQZR0eBAHA.280@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 158.159.8.33
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1743
Article PK: 1089215

see my response in
news://forums.sybase.com/sybase.public.sqlserver.backup+recovery

"Jaco Grobler" <jacog@pillar.co.za> wrote in message
news:FqXUUNeBAHA.270@forums.sybase.com...
> Hi All
>
> I am experiencing problems on a database running at one of out customers.
> The database transaction log keeps on growing although it is supposed to
> maintain itself with tresholds etc. It got to a point that the database
> locked up because the tran log was full. This is the point where I was
> called in.
>
> Using DBCC i discovered several allocation errors, most of which the fix
> option sorted out. By the way this problem existed several backups back
but
> no proper dba function exists at the site to pick up these problems early
> enough.
>
> When i try to do a manual dump tran i receive the following error
>
>
> Attached are the output from several dbcc. As you can see the problem is
> with page nr 709545. This page is not currently allocated to any object,
> neither is the extent on which it is located or the allocation unit for
that
> extent.
>
> However the page header for this page still indicate that it is allocated
to
> objid 8 (syslogs). I believe this to be the reason that checkallocation
and
> checktable dbcc's do not report a error before executing a dump tran,
since
> they propbably check linkage from the objid level and objid 8 does not
have
> any extents allocated to it at this stage. It seems however that dump tran
> scans the page headers and picks up this page, attempts to dump it but can
> not get to it due to the fact that no linkage exists to it from the
object.
>
> I urgently require a method by which to change the objid on page 709545 to
> zero (0) so that the transaction log can be dumped as normal.
>
> Any and all suggestion will be greatly appreciated
>
> Jaco Grobler
>
>
>
>
>
>