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.

File too large

4 posts in Unix Last posting was on 2001-03-29 04:30:44.0Z
Huib_van_der_Bolt Posted on 2001-03-27 13:30:05.0Z
From: Huib_van_der_Bolt
Date: Tue, 27 Mar 2001 09:30:05 -0400
Newsgroups: sybase.public.sqlserver.unix
Subject: File too large
Message-ID: <3001AFFD8C7FCE50004A2A0F85256A1C.004A2A5A85256A1C@webforums>
Lines: 19
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.unix:692
Article PK: 1092782

Somebody in my team pointed out to me that sybase was not able to create
large dumpfiles (> 2GB). We are running ASE 11.9.2, on Sun Solaris 2.6.
Our filesystem supports largefiles
(output ulimit -a :
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 2097148
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 64
vmemory(kbytes) unlimited)

When we try to dump to a file we get the usual write error (File too large,
operating system error number 27). This happens on normal file systems and
also on veritas file systems.
The same problems occur when we try to create a file device, larger than
2GB. (basis_dsizecheck ...)

Can anybody tell me more about this problem ?


Anthony Mandic <amandic Posted on 2001-03-29 04:30:44.0Z
Date: Thu, 29 Mar 2001 14:30:44 +1000
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: File too large
References: <3001AFFD8C7FCE50004A2A0F85256A1C.004A2A5A85256A1C@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <#SLuGtAuAHA.208@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
Lines: 21
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:680
Article PK: 1092771


Huib_van_der_Bolt wrote:
>
> Somebody in my team pointed out to me that sybase was not able to create
> large dumpfiles (> 2GB). We are running ASE 11.9.2, on Sun Solaris 2.6.
> Our filesystem supports largefiles

The problem is with the backup server which wasn't compiled with
large file support in that version. There is a compatibility matrix
at Sybase's web site that lists the dump file sizes per version.

> When we try to dump to a file we get the usual write error (File too large,
> operating system error number 27). This happens on normal file systems and
> also on veritas file systems.
> The same problems occur when we try to create a file device, larger than
> 2GB. (basis_dsizecheck ...)

Same issue. Raw devices can be up to 32GB. Check the matrix mentioned
above.

-am © 2001


Germano Silva Posted on 2001-03-27 13:47:12.0Z
From: "Germano Silva" <germano-silva@home.com>
References: <3001AFFD8C7FCE50004A2A0F85256A1C.004A2A5A85256A1C@webforums>
Subject: Re: File too large
Date: Tue, 27 Mar 2001 08:47:12 -0500
Lines: 29
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: <kOfrNcstAHA.198@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
NNTP-Posting-Host: 128.148.240.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:690
Article PK: 1092780

As far as device sizes, I have created device sizes larger than 2GB, but
they have to be on RAW partitions, I'm sure if you create devices on
filesystems, the max is also 2GB. There's some technical documents on the
Sybase tech support site that talks about devices larger than 2GB.

<Huib_van_der_Bolt> wrote in message
news:3001AFFD8C7FCE50004A2A0F85256A1C.004A2A5A85256A1C@webforums...
> Somebody in my team pointed out to me that sybase was not able to create
> large dumpfiles (> 2GB). We are running ASE 11.9.2, on Sun Solaris 2.6.
> Our filesystem supports largefiles
> (output ulimit -a :
> time(seconds) unlimited
> file(blocks) unlimited
> data(kbytes) 2097148
> stack(kbytes) 8192
> coredump(blocks) unlimited
> nofiles(descriptors) 64
> vmemory(kbytes) unlimited)
>
> When we try to dump to a file we get the usual write error (File too
large,
> operating system error number 27). This happens on normal file systems and
> also on veritas file systems.
> The same problems occur when we try to create a file device, larger than
> 2GB. (basis_dsizecheck ...)
>
> Can anybody tell me more about this problem ?


Germano Silva Posted on 2001-03-27 13:36:29.0Z
From: "Germano Silva" <germano-silva@home.com>
References: <3001AFFD8C7FCE50004A2A0F85256A1C.004A2A5A85256A1C@webforums>
Subject: Re: File too large
Date: Tue, 27 Mar 2001 08:36:29 -0500
Lines: 30
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: <DSFrOWstAHA.198@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
NNTP-Posting-Host: 128.148.240.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:691
Article PK: 1092781

The max dump file size is in fact 2GB, but you can stripe dump into multiple
files to backup databases larger than 2GB, which is in fact faster, since it
writes to all files at the same time. That's how I backup my large
databases.

<Huib_van_der_Bolt> wrote in message
news:3001AFFD8C7FCE50004A2A0F85256A1C.004A2A5A85256A1C@webforums...
> Somebody in my team pointed out to me that sybase was not able to create
> large dumpfiles (> 2GB). We are running ASE 11.9.2, on Sun Solaris 2.6.
> Our filesystem supports largefiles
> (output ulimit -a :
> time(seconds) unlimited
> file(blocks) unlimited
> data(kbytes) 2097148
> stack(kbytes) 8192
> coredump(blocks) unlimited
> nofiles(descriptors) 64
> vmemory(kbytes) unlimited)
>
> When we try to dump to a file we get the usual write error (File too
large,
> operating system error number 27). This happens on normal file systems and
> also on veritas file systems.
> The same problems occur when we try to create a file device, larger than
> 2GB. (basis_dsizecheck ...)
>
> Can anybody tell me more about this problem ?