SAP Note 1082952 - Two (or more) schemas in an MaxDB instance

Component : MaxDB -

Solution : https://service.sap.com/sap/support/notes/1082952 (SAP Service marketplace login required)

Summary :
This SAP Note provides guidelines for managing systems with an additional schema beyond the default, detailing necessary adjustments to ensure equivalent performance levels. Key procedures involve incorporating the secondary schema into DB59 and DB13C or DBACOCKPIT for monitoring and maintenance purposes, and explicitly updating optimizer statistics using transaction DB13C or DBACOCKPIT to maintain system efficiency. The note also underlines continuous updates and careful integration to adapt to system changes effectively. Relevant terms include Java schema, double-stack, and optimizer statistics.

Key words :
standard database user, livecache onedb system, terms java schema, schedule update statistics, java schema, livecache schema, update statisticsif, sap system, oltp schema, default schema

Related Notes :

1050755A1S with MaxDB: Performance problems in live update
927882FAQ: SAP MaxDB Update Statistics
870690Using DB13C to update statistics for remote MaxDB instances
588515Authorizations for database access in MaxDB/liveCache CCMS
431508SAP WebAS - using DB13C or DB13 for SAP DB systems