0

I'm a newbie to sybase and could not find the clear answers on Sybase tutorials/docs

  • How many databases can one Sybase instance have? Oracle has one instance which corresponds to only one database, is it the same with Sybase ?
  • What is a master database, is it a db that holds metadata? Does each instance have one master database ?
  • What is a user database ? Is it similar to a tenant db in sap hana ?
2
  • 1
    which Sybase RDBMS are you referring to? (ASE? IQ? SQLAnywhere? Advantage?)
    – markp-fuso
    May 13, 2020 at 12:00
  • I'm referring to ASE May 13, 2020 at 12:04

1 Answer 1

1

ASE can have up to 32K dbs (includes various system dbs).

The master db holds server wide metadata (eg, logins, roles, configs, databases) and can also hold user data (though this is discouraged).

Other system databases include sybsystemprocs (collection of system stored procs and functions), tempdb (temporary scratch space; DBA can create additional temporary dbs), model (template used when creating a new database), sybsystemdb (used to manage distributed txns); there are several other system dbs that can exist depending on options/features the DBA enables.

Any other databases would fall under the heading of user databases.

And yeah, a user db would be similar to a HANA tenant db, though all ASE databases are accessed via the same host:port combo (HANA tenants have their own port if I recall correctly).

2
  • So, one instance can have more than one user database? Like Ms sql May 16, 2020 at 2:33
  • 2
    MSSQL's parent is ASE soooo ... MSSQL can have more than one user database just like ASE.:-)
    – markp-fuso
    May 16, 2020 at 2:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.