This topic describes how to use CLI commands to manually add ASE repositories to a SAP ASE environment.  Discovery is the process by which the Delphix Engine identifies data sources and data dependencies on a remote environment. ASE repository discovery is done automatically when an environment is added to the Delphix Engine or when an already added environment is refreshed. In some cases, automatic discovery does not discover all of the repositories in a SAP ASE environment. These repositories may be added using manual discovery.

 Unlike automatically discovered instances, manually discovered instances are not automatically deleted if the environment is refreshed when the instance isn't running if the instance is no longer running and has no associated objects.

To manually discover an ASE repository you will need to:
  • Add an ASE environment
  • Use CLI to manually discover a repository

This feature can be useful in the following situations:

  • Security policies dictate a different database user name per ASE instance.

  • ASE instances that cannot be automatically discovered because they aren’t started with the “-s<servername>” argument.

  • Multiple $SYBASE installations on a single host. Automatic discovery works off of a single $SYBASE/interfaces file.

  • Wish to avoid refreshing the environment to discover new ASE instances.

  • Environment was originally discovered without the "Discover SAP ASE" box checked.

Creating an ASE Environment

Please refer to Adding an SAP ASE Environment for detailed steps.

Manually discovering a repository

In the following example we are using sc-dev3.dc2 as our example environment.

  1. Log into CLI and cd to repository menu:   
$ ssh delphix_admin@sc-dev3.dc2
sc-dev3.dc2> cd repository
sc-dev3.dc2 repository> 

    2. Add (manually discover) an ASE repository instance:

The values used in the following code block are specific to the example instance we are adding.
If not set as part of the create operation, credentials.password and dbUser default to the values provided when adding the environment. If these values were not provided when adding the environment, they must be set here.
sc-dev3.dc2 repository> create
sc-dev3.dc2 repository create *> ls
   type: ASEInstance
   credentials: (unset)
   dbUser: (unset)
   environment: (required)
   installationPath: (required)
   instanceName: (required)
   instanceOwner: (required)
   ports: (required)
   servicePrincipalName: (unset)
   version: (unset)
sc-dev3.dc2 repository create *> set credentials.type=PasswordCredential
sc-dev3.dc2 repository create *> set credentials.password=sybase
sc-dev3.dc2 repository create *> set dbUser=sa
sc-dev3.dc2 repository create *> set environment=sc-rhel64-sybase-ase-0
sc-dev3.dc2 repository create *> set installationPath=/opt/sybase/15-7
sc-dev3.dc2 repository create *> set instanceName=ASE1570_S1
sc-dev3.dc2 repository create *> set instanceOwner=sybase
sc-dev3.dc2 repository create *> set ports=5100
sc-dev3.dc2 repository create *> ls
   type: ASEInstance
       type: PasswordCredential (*)
       password: ******** (*)
   dbUser: sa (*)
   environment: sc-rhel64-sybase-ase-0 (*)
   installationPath: /opt/sybase/15-7 (*)
   instanceName: ASE1570_S1 (*)
   instanceOwner: sybase (*)
   ports: 5100 (*)
   servicePrincipalName: (unset)
   version: (unset)
sc-dev3.dc2 repository create *> commit
sc-dev3.dc2 repository> select ASE1570_S1
sc-dev3.dc2 repository 'ASE1570_S1'> ls
    type: ASEInstance
    name: ASE1570_S1
        type: PasswordCredential
        password: ********
    dbUser: sa
    discovered: false
    environment: sc-rhel64-sybase-ase-0   
    installationPath: /opt/sybase/15-7
    instanceName: ASE1570_S1
    instanceOwner: sybase
    instanceOwnerGid: 500
    instanceOwnerUid: 500
    internalVersion: 15.7 SP138
    linkingEnabled: true
    pageSize: 4096
    ports: 5100
    provisioningEnabled: true
    reference: ASE_INSTANCE-22
    servicePrincipalName: (unset)
    staging: false
    version: 15.7 SP138
sc-dev3.dc2 repository 'ASE1570_S1'> 

Related Topics