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.

Database DB file format

4 posts in Windows NT Last posting was on 2001-05-17 18:11:36.0Z
Sinisa Posted on 2001-05-10 18:11:10.0Z
From: Sinisa
Date: Thu, 10 May 2001 14:11:10 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Database DB file format
Message-ID: <ABE54AB789CB097D0063E66E85256A48.0063E67C85256A48@webforums>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:758
Article PK: 1087367

where can I find some information about structure of Sybase DB file format
(there are two files: DB and LOG).

Something like: there is 40 bytes in header ..., followed by tables
descriptions..., After tables descriptions are indexes which begins with
key word 0C 0D (hex) ..., after indexes are stored procedures codes, ...

MFT table on hard disk was corrupted and I am trying now to reconstruct db
file, but the file was fragmented. I think that description about db file
format would help me.

Thanks, Sinisa


Gigi Posted on 2001-05-17 18:11:36.0Z
From: Gigi
Date: Thu, 17 May 2001 14:11:36 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: Database DB file format
Message-ID: <375BE01EFA0812400063F09A85256A4F.006752A885256A48@webforums>
References: <ABE54AB789CB097D0063E66E85256A48.0063E67C85256A48@webforums>
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:723
Article PK: 1087330

sta te briga


Jim Egan Posted on 2001-05-11 02:12:53.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Database DB file format
Date: Thu, 10 May 2001 20:12:53 -0600
Message-ID: <MPG.1564f88f2a5b5a5398b345@forums.sybase.com>
References: <ABE54AB789CB097D0063E66E85256A48.0063E67C85256A48@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 21
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:750
Article PK: 1087357


Sinisa wrote...
> where can I find some information about structure of Sybase DB file format
> (there are two files: DB and LOG).
>
> Something like: there is 40 bytes in header ..., followed by tables
> descriptions..., After tables descriptions are indexes which begins with
> key word 0C 0D (hex) ..., after indexes are stored procedures codes, ...
>
> MFT table on hard disk was corrupted and I am trying now to reconstruct db
> file, but the file was fragmented. I think that description about db file
> format would help me.
>

For reconstruction of the .db file you should contact Tech Support. They do that sort of
thing.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


Bret Halford Posted on 2001-05-10 21:42:38.0Z
Message-ID: <3AFB0B4E.6309E186@sybase.com>
Date: Thu, 10 May 2001 15:42:38 -0600
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: Database DB file format
References: <ABE54AB789CB097D0063E66E85256A48.0063E67C85256A48@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 27
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:756
Article PK: 1087363

Hi Sinisa,

It sounds like you are actually describing Sybase Adaptive Server Anywhere
database devices. This isn't the right newsgroup to ask about ASA issues, try

sybase.public.sqlanywhere.general. This group is for ASE issues

(ASE devices consist of a series of 2048 byte pages, each page has a page
header of 32 bytes,
then contents that vary by type of page (DOL table vs allpages, data page,
index
page OAM page, GAM page, etc. Each page header contains the page number.)

-bret

Sinisa wrote:

> where can I find some information about structure of Sybase DB file format
> (there are two files: DB and LOG).
>
> Something like: there is 40 bytes in header ..., followed by tables
> descriptions..., After tables descriptions are indexes which begins with
> key word 0C 0D (hex) ..., after indexes are stored procedures codes, ...
>
> MFT table on hard disk was corrupted and I am trying now to reconstruct db
> file, but the file was fragmented. I think that description about db file
> format would help me.
>
> Thanks, Sinisa