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.

Setup a new Afaria DB

3 posts in General Last posting was on 2012-06-15 21:57:17.0Z
Tony Posted on 2012-06-14 06:26:49.0Z
Sender: 3e55.4fd9838c.1804289383@sybase.com
From: Tony
Newsgroups: ianywhere.public.afaria.general
Subject: Setup a new Afaria DB
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fd98429.3e77.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 13 Jun 2012 23:26:49 -0700
X-Trace: forums-1-dub 1339655209 172.20.134.41 (13 Jun 2012 23:26:49 -0700)
X-Original-Trace: 13 Jun 2012 23:26:49 -0700, 172.20.134.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.afaria.general:497
Article PK: 831

I have only just got Afaria and tried one install that
failed.
Can someone point me to some documentation which has
instructions/commands on how to setup an SQLAnywhere DB for
Afaria.
The Afaria 7 install manual just says to set the DB up but
not how to.
Thanks
Tony


Mahendra Bhandari Posted on 2012-06-15 09:42:09.0Z
Sender: ead.4fdb0278.1804289383@sybase.com
From: Mahendra Bhandari
Newsgroups: ianywhere.public.afaria.general
Subject: Re: Setup a new Afaria DB
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fdb0371.ed9.1681692777@sybase.com>
References: <4fd98429.3e77.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 15 Jun 2012 02:42:09 -0700
X-Trace: forums-1-dub 1339753329 172.20.134.41 (15 Jun 2012 02:42:09 -0700)
X-Original-Trace: 15 Jun 2012 02:42:09 -0700, 172.20.134.41
Lines: 67
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.afaria.general:498
Article PK: 835

Hi,

If you plan to use Sybase iAnywhereSQLAnywhere database with
Afaria, create the database for operations, and an
associated user to provide a user context to access the
database. The database name should remain the same
throughout the Afaria server installation and configuration
process.
1. Create a database. Use default configuration settings
with the exception of these attributes:
• Install jConnect metadata support – disabled.
• Page size – 8192 KB minimum.
2. Create a database user for the Afaria service to use for
database access. Assign the database administrator (DBA)
authority to the user.
3. Connect to the new database using these network database
server properties:
• Identification – database user name and password that
you created for Afaria database access.
• Database – indicate the Afaria database server name
and start line “dbsrv11.exe,” as well as the database
name and file.
Do not start the database using start line
“dbeng11.exe,” which is for non-network database servers
and does not support enough database connections for the
Afaria service. Sybase strongly recommends that you have
only one instance of dbsrv11.exe per
database. Configuring the iAnywhere SQL Anywhere Database
for Operations. For Sybase iAnywhere SQL Anywhere
operations, prepare your database environment for
sustainability and availability.
To create aWindows service that automatically starts the
database whenever the Afaria server is restarted:

1. In Sybase Central, select the Services tab and run the
New Services wizard.
2. Name the service.
3. Select the Network Database Server service type.
4. Accept the default executable, dbsrv11.exe.
5. Specify the parameters to run only the TCP/IP network
driver (-x) for the database name
and path (-n).
For example, -x tcpip -n afariadb c:\afaria\afaria.db
6. Select default Local system account and Allow service to
interact with desktop for
running the service.
7. Select start-up type Automatic.
8. Select to restart the service now.
Upon completion of the wizard, create a system event to back
up and truncate the log.
Sybase recommends a log size of 50MB for an initial setting.


Hope this will help!!!

KR,
Mahendra Bhandari

> I have only just got Afaria and tried one install that
> failed.
> Can someone point me to some documentation which has
> instructions/commands on how to setup an SQLAnywhere DB
> for Afaria.
> The Afaria 7 install manual just says to set the DB up but
> not how to.
> Thanks
> Tony


TonyO Posted on 2012-06-15 21:57:17.0Z
Sender: 2df5.4fdbae90.1804289383@sybase.com
From: TonyO
Newsgroups: ianywhere.public.afaria.general
Subject: Re: Setup a new Afaria DB
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fdbafbd.2e35.1681692777@sybase.com>
References: <4fdb0371.ed9.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 15 Jun 2012 14:57:17 -0700
X-Trace: forums-1-dub 1339797437 172.20.134.41 (15 Jun 2012 14:57:17 -0700)
X-Original-Trace: 15 Jun 2012 14:57:17 -0700, 172.20.134.41
Lines: 90
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.afaria.general:499
Article PK: 836

I recognise this, isn't it a copy from the manual.. please
look for my comments below

> Hi,
>
> If you plan to use Sybase iAnywhereSQLAnywhere database
> with Afaria, create the database for operations, and an
> associated user to provide a user context to access the
> database. The database name should remain the same
> throughout the Afaria server installation and
> configuration process.
> 1. Create a database. Use default configuration settings
> with the exception of these attributes:
> • Install jConnect metadata support – disabled.
> • Page size – 8192 KB minimum.

I did this using a command prompt command

> 2. Create a database user for the Afaria service to use
> for database access. Assign the database administrator
> (DBA) authority to the user.
How do I do that? apart from the command above

> 3. Connect to the new database using these network
> database server properties:
> • Identification – database user name and password
that
> you created for Afaria database access.
> • Database – indicate the Afaria database server name
> and start line “dbsrv11.exe,” as well as the database
> name and file.
Did that
> Do not start the database using start line
> “dbeng11.exe,” which is for non-network database
servers
> and does not support enough database connections for the
> Afaria service. Sybase strongly recommends that you have
> only one instance of dbsrv11.exe per
> database. Configuring the iAnywhere SQL Anywhere Database
> for Operations. For Sybase iAnywhere SQL Anywhere
> operations, prepare your database environment for
> sustainability and availability.
I am using SQL 12 not 11 as it comes with SUP 2.1.2

> To create aWindows service that automatically starts the
> database whenever the Afaria server is restarted:
did that and have the service defined but won't start until
a program calls it
>
> 1. In Sybase Central, select the Services tab and run the
> New Services wizard.
Waht is Sybase Central? I am installing afaria so there is
nothing more than the install program

> 2. Name the service.
> 3. Select the Network Database Server service type.
> 4. Accept the default executable, dbsrv11.exe.
> 5. Specify the parameters to run only the TCP/IP network
> driver (-x) for the database name
> and path (-n).
> For example, -x tcpip -n afariadb c:\afaria\afaria.db
> 6. Select default Local system account and Allow service
> to interact with desktop for
> running the service.
> 7. Select start-up type Automatic.
I have this working

> 8. Select to restart the service now.
> Upon completion of the wizard, create a system event to
> back up and truncate the log.
> Sybase recommends a log size of 50MB for an initial
> setting.
>
>
> Hope this will help!!!
>
> KR,
> Mahendra Bhandari

would it be possible for you to give command prompt commands
for doing this?
>
> > I have only just got Afaria and tried one install that
> > failed.
> > Can someone point me to some documentation which has
> > instructions/commands on how to setup an SQLAnywhere DB
> > for Afaria.
> > The Afaria 7 install manual just says to set the DB up
> > but not how to.
> > Thanks
> > Tony