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.

MaxNumberDatabasesCommandLinedbsrv7

5 posts in General Discussion Last posting was on 2002-10-08 14:31:52.0Z
edpereira Posted on 2002-10-08 12:37:41.0Z
Message-ID: <3DA2D195.5090201@netscape.net>
Date: Tue, 08 Oct 2002 14:37:41 +0200
From: edpereira <edalpereira@netscape.net>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.4.1) Gecko/20020314 Netscape6/6.2.2
X-Accept-Language: en-us
MIME-Version: 1.0
Subject: MaxNumberDatabasesCommandLinedbsrv7
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
Lines: 6
NNTP-Posting-Host: 158.76.114.215
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:560
Article PK: 2378

Hi All,
Does anyone know what is the maximum number of databases that can be
opened when issuing the command 'dbsrv7 C:\sybase\asa7\My7db1.db
C:\sybase\asa7\My7db2.db ...'


Regards
E.P.


Robert Waywell Posted on 2002-10-08 14:21:52.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <3DA2D195.5090201@netscape.net>
Subject: Re: MaxNumberDatabasesCommandLinedbsrv7
Date: Tue, 8 Oct 2002 10:21:52 -0400
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <wnmwYgtbCHA.302@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:557
Article PK: 2375

The max number from the command line is typically limited by the length of
the command line. You can always increase that by using the @file_name
parameter to specify parameters. The physical limit on the number of
databases that can be supported on a single server is (I believe) 128.


--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"edpereira" <edalpereira@netscape.net> wrote in message
news:3DA2D195.5090201@netscape.net...
> Hi All,
> Does anyone know what is the maximum number of databases that can be
> opened when issuing the command 'dbsrv7 C:\sybase\asa7\My7db1.db
> C:\sybase\asa7\My7db2.db ...'
>
>
> Regards
> E.P.
>


edpereira Posted on 2002-10-08 14:31:52.0Z
Message-ID: <3DA2EC58.9090002@netscape.net>
Date: Tue, 08 Oct 2002 16:31:52 +0200
From: edpereira <edalpereira@netscape.net>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.4.1) Gecko/20020314 Netscape6/6.2.2
X-Accept-Language: en-us
MIME-Version: 1.0
Subject: Re: MaxNumberDatabasesCommandLinedbsrv7
References: <3DA2D195.5090201@netscape.net> <wnmwYgtbCHA.302@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
Lines: 43
NNTP-Posting-Host: 158.76.114.215
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:556
Article PK: 2374

Hi,
Thank you.
Heres the info I got :
"
Maximum index entry size
No limit

Number of Databases per server
255

Number of columns per table
999 (using 4K pages)
"
Things are a bit different from the command line.
The info you gave me about the length of the command
line may be helpful.
I'll check that parameter.
Regards

Robert Waywell wrote:

> The max number from the command line is typically limited by the length of
> the command line. You can always increase that by using the @file_name
> parameter to specify parameters. The physical limit on the number of
> databases that can be supported on a single server is (I believe) 128.
>
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "edpereira" <edalpereira@netscape.net> wrote in message
> news:3DA2D195.5090201@netscape.net...
>
>>Hi All,
>>Does anyone know what is the maximum number of databases that can be
>>opened when issuing the command 'dbsrv7 C:\sybase\asa7\My7db1.db
>>C:\sybase\asa7\My7db2.db ...'
>>
>>
>>Regards
>>E.P.
>>
>>
>
>


Jason Hinsperger Posted on 2002-10-08 13:46:18.0Z
From: "Jason Hinsperger" <jason_hinsperger@NOSPAMhotmail.com>
References: <3DA2D195.5090201@netscape.net>
Subject: Re: MaxNumberDatabasesCommandLinedbsrv7
Date: Tue, 8 Oct 2002 09:46:18 -0400
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <e6VUhMtbCHA.198@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.141.17
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:559
Article PK: 2379

See "Size and Number Limitations" in the help file. It states the limit is
255 databases per server.

--
Jason Hinsperger
International and Sustaining Engineering
iAnywhere Solutions

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
--

"edpereira" <edalpereira@netscape.net> wrote in message
news:3DA2D195.5090201@netscape.net...
> Hi All,
> Does anyone know what is the maximum number of databases that can be
> opened when issuing the command 'dbsrv7 C:\sybase\asa7\My7db1.db
> C:\sybase\asa7\My7db2.db ...'
>
>
> Regards
> E.P.
>


edpereira Posted on 2002-10-08 14:08:03.0Z
Message-ID: <3DA2E6C3.6060206@netscape.net>
Date: Tue, 08 Oct 2002 16:08:03 +0200
From: edpereira <edalpereira@netscape.net>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.4.1) Gecko/20020314 Netscape6/6.2.2
X-Accept-Language: en-us
MIME-Version: 1.0
Subject: Re: MaxNumberDatabasesCommandLinedbsrv7
References: <3DA2D195.5090201@netscape.net> <e6VUhMtbCHA.198@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
Lines: 32
NNTP-Posting-Host: 158.76.114.215
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:558
Article PK: 2376

Hi,
Thank you for the info
I had it already :
"
Maximum index entry size
No limit

Number of Databases per server
255

Number of columns per table
999 (using 4K pages)
"

I think, unless there is a bug in SQL Anywhere, that you can reference
fewer databases than that when you launch(for instance) the following
command :
'dbsrv7 C:\sybase\asa7\My7db1.db...C:\sybase\asa7\My7db16.db'
The server raises an error if I try '... C:\sybase\asa7\My7db17.db'
It looks as if there were a limt(16 dbs(?))
Any ideas??
Many Thanks

Jason Hinsperger wrote:

> See "Size and Number Limitations" in the help file. It states the limit is
> 255 databases per server.
>
> --
> Jason Hinsperger
> International and Sustaining Engineering
> iAnywhere Solutions
>
> Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
> Developer Community at www.ianywhere.com/developer
> --
>
>
> "edpereira" <edalpereira@netscape.net> wrote in message
> news:3DA2D195.5090201@netscape.net...
>
>>Hi All,
>>Does anyone know what is the maximum number of databases that can be
>>opened when issuing the command 'dbsrv7 C:\sybase\asa7\My7db1.db
>>C:\sybase\asa7\My7db2.db ...'
>>
>>
>>Regards
>>E.P.
>>
>>
>
>