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.

Large .db size

2 posts in General Discussion Last posting was on 2003-07-22 01:01:22.0Z
Hal_Trufan Posted on 2003-07-21 18:44:58.0Z
From: Hal_Trufan
Date: Mon, 21 Jul 2003 14:44:58 -0400
Newsgroups: ianywhere.public.general
Subject: Large .db size
Message-ID: <77ECCEF059BCF9230066FE7985256D6A.0066FEA685256D6A@webforums>
Lines: 86
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1417
Article PK: 3650

I am experiencing a rapid increase in my database size. In two weeks it
has grown 500 megs. There are very few inserts and updates to this
database, it is mainly a repository to read from. Thus the large size
makes no sense.
In an attempt to determine the problem I deleted the largest table in the
database. I then viewed the log file and found 2 things. One, a message
saying, "Page size too small for this database" and Two, that the cache
size of the database was being increased multiple times (log file follows).
When I tried to increase the page size via, "create database 'temp.db'
page size 4096", an error message, "ASA Error -97: Database page size too
big" pops up.
I am unsure how to proceed and I'm hoping you can shed some light on the
subject.
Thank you,
-Hal Trufan


LOG FILE:
-------------
Database "temp" (temp.db) started at Fri Jul 11 2003 14:54
This database is licensed for use with:k
Application: anon
Company: anon
Page size too small for this database
Database server started at Fri Jul 11 2003 14:54
Trying to start SharedMemory link ...

SharedMemory link started successfully

Trying to start NamedPipes link ...

NamedPipes link started successfully

Trying to start TDS (TCPIP) link ...

Unable to start on default port; starting on port 49153 instead
TDS (TCPIP) link started successfully

Now accepting requests
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
Cache size adjusted to 209000K
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Cache size adjusted to 229580K
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Cache size adjusted to 246008K
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Cache size adjusted to 258112K
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
Cache size adjusted to 261136K
Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 15:07
Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 15:07


Craig Stoss Posted on 2003-07-22 01:01:22.0Z
From: "Craig Stoss" <cstoss@sybase.com>
References: <77ECCEF059BCF9230066FE7985256D6A.0066FEA685256D6A@webforums>
Subject: Re: Large .db size
Date: Mon, 21 Jul 2003 21:01:22 -0400
Lines: 115
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
Message-ID: <uEt753#TDHA.298@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: cstoss-pc.sybase.com 172.31.142.117
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1421
Article PK: 3655

Hal,

The error you are receiving is because you cannot create or start a database
on a server with started with a smaller size (which is by default the page
size of the database started on it).
From our docs:
"You attempted to start a database or create a write file for a database
with a page size that exceeds the maximum page size of the running server.
Either restart the server with this database named on the command line, or
restart the server with a larger page size."

To increase the starting cache size of an enginer use the -c switch on the
command line or in teh service parameters. To upgrade the page size of the
current database, you will need to follow an unload and reload procedure
such as the one suggested in Solution 2 of this doc
http://www.ianywhere.com/developer/technotes/db_page_size.html

I hope this helps,
Craig Stoss
Sybase Technical Support

<Hal_Trufan> wrote in message
news:77ECCEF059BCF9230066FE7985256D6A.0066FEA685256D6A@webforums...
> I am experiencing a rapid increase in my database size. In two weeks it
> has grown 500 megs. There are very few inserts and updates to this
> database, it is mainly a repository to read from. Thus the large size
> makes no sense.
> In an attempt to determine the problem I deleted the largest table in
the
> database. I then viewed the log file and found 2 things. One, a message
> saying, "Page size too small for this database" and Two, that the cache
> size of the database was being increased multiple times (log file
follows).
> When I tried to increase the page size via, "create database 'temp.db'
> page size 4096", an error message, "ASA Error -97: Database page size too
> big" pops up.
> I am unsure how to proceed and I'm hoping you can shed some light on the
> subject.
> Thank you,
> -Hal Trufan
>
>
> LOG FILE:
> -------------
> Database "temp" (temp.db) started at Fri Jul 11 2003 14:54
> This database is licensed for use with:k
> Application: anon
> Company: anon
> Page size too small for this database
> Database server started at Fri Jul 11 2003 14:54
> Trying to start SharedMemory link ...
>
> SharedMemory link started successfully
>
> Trying to start NamedPipes link ...
>
> NamedPipes link started successfully
>
> Trying to start TDS (TCPIP) link ...
>
> Unable to start on default port; starting on port 49153 instead
> TDS (TCPIP) link started successfully
>
> Now accepting requests
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
> Cache size adjusted to 209000K
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:56
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Cache size adjusted to 229580K
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:57
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Cache size adjusted to 246008K
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:58
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Cache size adjusted to 258112K
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 14:59
> Cache size adjusted to 261136K
> Starting checkpoint of "temp" (temp.db) at Fri Jul 11 2003 15:07
> Finished checkpoint of "temp" (temp.db) at Fri Jul 11 2003 15:07
>