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.

Disk Defragmenter

4 posts in Windows NT Last posting was on 1999-05-10 16:55:43.0Z
Bank of Montreal - Trade Finance Posted on 1998-03-17 19:56:56.0Z
Message-ID: <350ED585.2F2C0CAF@passport.ca>
Date: Tue, 17 Mar 1998 11:56:56 -0800
From: Bank of Montreal - Trade Finance <trade@passport.ca>
X-Mailer: Mozilla 4.04 [en] (Win16; I)
MIME-Version: 1.0
Subject: Disk Defragmenter
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5110
Article PK: 1092475

More information on my question of yesterday...
Disk Keeper is a disk defragmenter which would run overnight and
defrag/reorganize data files. I am told that there is a problem running
this with Oracle in that data is written to specific locations in the
files. If Sybase does the same thing, then running this would corrupt
the database.
Has anyone had any experience with this or know whetther there would be
a conflict because of the data location?


Jason Froebe Posted on 1999-05-10 16:55:43.0Z
Message-ID: <37370F8F.A2349850@sybase.com>
Date: Mon, 10 May 1999 11:55:43 -0500
From: Jason Froebe <jfroebe@sybase.com>
Reply-To: jfroebe@sybase.com
Organization: Sybase Inc.
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5 i686)
X-Accept-Language: en-US, en, en-GB, nl, ja
MIME-Version: 1.0
To: Bank of Montreal - Trade Finance <trade@passport.ca>
Subject: Re: Disk Defragmenter
References: <350ED585.2F2C0CAF@passport.ca>
Content-Type: multipart/mixed; boundary="------------59C68AEA638B2CE631C7A34F"
Newsgroups: sybase.public.sqlserver.nt
Lines: 46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:3781
Article PK: 1091171


Bank of Montreal - Trade Finance wrote:
>
> More information on my question of yesterday...
> Disk Keeper is a disk defragmenter which would run overnight and
> defrag/reorganize data files. I am told that there is a problem running
> this with Oracle in that data is written to specific locations in the
> files. If Sybase does the same thing, then running this would corrupt
> the database.
> Has anyone had any experience with this or know whetther there would be
> a conflict because of the data location?

Hi "Trade Finance",

It should be fine. Make sure the server is shutdown when you defrag the
drives. Why? Other than the fact that any writing to the drive will have the
defrag restart, you will discover any bugs with Disk Keeper or NT.

The actual physical location of the data is irrelevant on the drive. It does
not have to be contiguous space (for database device FILES - on VMS is needs to
be contiguous). This is true for unix as well as NT.

Jason


Download VCard jfroebe.vcf


Jeff Bearden Posted on 1999-05-06 01:37:51.0Z
Message-ID: <3730F26F.5ACA2C4C@beapsy1.his.uab.edu>
Date: Wed, 05 May 1999 20:37:51 -0500
From: Jeff Bearden <jbearden@beapsy1.his.uab.edu>
Organization: UABSAP
X-Mailer: Mozilla 4.51 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Disk Defragmenter
References: <350ED585.2F2C0CAF@passport.ca>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 16
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:3810
Article PK: 1091201

I have been successfull running DkLite for NT (FREE!) on a raid 5!

Bank of Montreal - Trade Finance wrote:

> More information on my question of yesterday...
> Disk Keeper is a disk defragmenter which would run overnight and
> defrag/reorganize data files. I am told that there is a problem running
> this with Oracle in that data is written to specific locations in the
> files. If Sybase does the same thing, then running this would corrupt
> the database.
> Has anyone had any experience with this or know whetther there would be
> a conflict because of the data location?


Tony Imbierski Posted on 1998-03-17 17:16:28.0Z
Message-ID: <350EAFEC.88D@sybase.com>
Date: Tue, 17 Mar 1998 17:16:28 +0000
From: Tony Imbierski <tonyi@sybase.com>
Reply-To: tonyi@sybase.com
Organization: Sybase Adaptive Server Engineering
X-Mailer: Mozilla 3.02 (WinNT; I)
MIME-Version: 1.0
Subject: Re: Disk Defragmenter
References: <350ED585.2F2C0CAF@passport.ca>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 41
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5109
Article PK: 1092472

Theoretically, I can't see there should be a problem with Sybase.

If you are using a file system device (ie your database device is an
ordinary NT file) then we don't record the physical disk blocks where
the file resides so we don't care if diskkeeper moves it. While the
database is active the file should be locked and that should prevent
diskkeeper moving it. Diskkeeper wouldn't rearrange the logical order of
data in the file, just the physical blocks on disk (if it rearranged
logical files, it would corrupt them).

If you are using raw partitions then diskkeeper should hopefully not
recognise the disk format and therefore not touch that disk at all.

However, as with anything, test it on your development system first!
What I have said above is only a best guess.

cheers,
tonyi

--
===============================================================
Tony Imbierski
Sybase Adaptive Server Engineering
Kernel & Platform Sustaining
---------------------------------------------------------------

===============================================================

Bank of Montreal - Trade Finance wrote:
>
> More information on my question of yesterday...
> Disk Keeper is a disk defragmenter which would run overnight and
> defrag/reorganize data files. I am told that there is a problem running
> this with Oracle in that data is written to specific locations in the
> files. If Sybase does the same thing, then running this would corrupt
> the database.
> Has anyone had any experience with this or know whetther there would be
> a conflict because of the data location?