Skip to Content
V P

New Afaria Installation

db-error.jpgHello Team,

We currently have Afaria Server installed since SP4 to SP27 and we would like to decommission the servers. and created new servers.

For new servers do we need to Install the Afaria from SP04 to SP27 or just SP27 installation is fine ?

We have SQL17 db, we will copy from old server and connect on new server. Do we need any extra procedure here ?

Regards,

Vinayak

db-error.jpg (41.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 29 at 09:31 PM

    Hello VP,

    I highly recommend following our best practice moving Afaria server to another system. See following KBA for more details:

    https://launchpad.support.sap.com/#/notes/1990189

    Thanks,

    Aziz

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18 at 05:33 AM

    Hi VP,

    We provide following KBA.

    2338319 - Supported upgrade paths - Afaria

    > We have SQL17 db, we will copy from old server and connect on new server. Do we need any extra procedure here ?
    When you set up Afaria Server, you only choose this database. Of course it is necessary for you to start a database.

    FYI
    2363629 - About database(SQL Anywhere) support of Afaria 7 SP17
    Upgrade Step 3-4


    Thanks,
    Atsushi

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18 at 02:42 PM

    Can we setup new server with directly installating SP27 ? or need to start from SP04 to SP27 ?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi VP,

      You must create new database in conformity with database requirements. And you load data of original database in new database.

      1. Create a new database.(case-sensitivity = Ignore)
      Initialization utility (dbinit)
      Database Requirements
      Preparing an SAP SQL Anywhere Database

      For example:
      dbinit -p 8192 -z "UCA(CaseSensitivity=Ignore;AccentSensitivity=Respect)" -zn "UCA(CaseSensitivity=Ignore;AccentSensitivity=Respect)" -i -t "Afaria.log" "C:\temp\new\Afaria.db"

      2. Reload the data which unloaded an existing database to a new database.
      Unload utility (dbunload)

      For example:
      dbunload -c "UID=DBA;PWD=passwd;DBN=old;DBF=C:\temp\old\Afaria.db" -ac "UID=DBA;PWD=passwd;DBN=new;DBF=C:\temp\new\Afaria.db"

      If the new database must have the same file name as the original database, then use the DBN connection parameter to give each database a unique temporary name. The following command loads a copy of the old database into a new database that has the same file name Afaria.db.

      Thanks,
      Atsushi