Database Layer & DB Administration

When sizing the ABAP table buffers you find two different parameters for the 'table buffer.' What do zcsa/table_buffer_area and rtbb/buffer_length each control?

The storage team says the database sits on RAID with disk mirroring, so daily backups seem redundant. Why is that reasoning dangerous?

Match the cadence: how often should you refresh optimizer statistics, check the database fill level, and verify database object consistency?

After restoring last night's full database backup, the DBA still applies the transaction logs before releasing the system. What do the logs add, and what makes them usable?

You can add application server instances to handle more users, but the team wants to scale the database the same way by splitting its instance. Why does that not work?

Before installing an SAP system on a particular RDBMS and operating system combination, how do you confirm SAP actually supports that pairing, and why can't you just assume it?

How does an application server instance know which host to reach for the database, and why is that parameter set system-wide rather than per instance?

Optimizer statistics are fresh and indexes are consistent, yet you still must watch DB02 regularly for something else entirely. What is it, and what happens if you ignore it?

Why is a table pool like ATAB a good candidate to buffer entirely, when most large application tables are not?

You need to analyze current database activity and access to the database log. Which monitor do you open, and how does it differ from DB02 and DB03?

For everyday administration of just the local database, an admin opens DBACOCKPIT. When is DB50 the more fitting tool, and what is the real difference?

A hardware fault is suspected of corrupting data blocks. Why won't refreshing optimizer statistics or checking DB02 reveal it, and what is the only reliable method?

For database-specific administration performed outside the SAP system on an Oracle database, which is the best-known tool, and what does 'RDBMS-specific' imply for your non-Oracle systems?

A configuration table is buffered on the application server. In a system with several instances, why might one instance still return the old value after the table is changed, and which parameter governs the lag?

Beyond managing many databases from one screen, what security-and-load benefit does DBACOCKPIT deliver, and how?

A team assumes that to administer ten different databases they must open a session on each DB host. How does DBACOCKPIT change that, and what makes it possible?

A developer wants to drop into native SQL (EXEC SQL. ... ENDEXEC.) for ordinary application logic because it feels more direct. Why is this contraindicated, and where is native SQL actually appropriate?

You look for a pool table such as ATAB at the RDBMS level and cannot find it as its own table. What is a table pool, and how is a contained pool table actually identified?

You open the SAP NetWeaver Administrator (NWA) at host:port/nwa expecting to monitor the whole landscape, but only the local system appears. What did NWA replace, and what precondition were you missing?

A large archiving run just deleted millions of rows. Why is leaving the old optimizer statistics in place worse than having no statistics at all?

A new admin starts driving the daily admin routine from the System Administration Assistant (SSAA). What does SSAA offer, and why is building your routine on it the wrong call today?

You need to set up recurring database backups and statistics updates. Which transaction do you use, and how does its purpose differ from DB12?

After an upgrade, several reports suddenly run far slower. Before blaming optimizer statistics, what should you check in DB02 first, and why?

Both table pools and table clusters pack multiple logical tables into one physical table. What single property distinguishes a table cluster, and what data is it typically used for?

An SAP system is migrated to SAP HANA / S/4HANA. What happens to pooled and cluster tables, and what is the trap in assuming the pool/cluster concept is fully gone?

An ABAP program uses only Open SQL. Why does the same code run unchanged across different RDBMSs, and what component actually makes that possible?

Why can simply skipping a database backup cause data loss even with no hardware failure, and where do you confirm backups actually completed?