Quick Reference: DBA Cheat Sheets, T-Codes, CLI & Dynamic Views
High-density operational cheat sheet aggregating vital SAP Basis T-codes, dynamic monitoring views (SYS.M_*), Linux administration commands, instance port formulas, and filesystem paths for immediate field access.
BeginnerQuick Reference~12 min studyHANA 2.0 (All SPS)
Core Learning Objectives
- 1.Quickly cross-reference SAP Basis T-Codes (DB02, ST04, SM50, SM12, BDLS, SLICENSE).
- 2.Instant lookup for Dynamic Monitoring Views (M_SERVICE_MEMORY, M_BLOCKED_TRANSACTIONS, M_EXPENSIVE_STATEMENTS).
- 3.Review daily Linux maintenance CLI commands and port calculations.
Prerequisites:hana-fundamentals-overview
Definition & Architectural Rationale
Technical Definition:
A concentrated operational index designed for on-call triaging, live production troubleshooting, and fast reference during technical interviews.
Why this component exists:
DBAs need immediate, searchable access to command syntax, port formulas, and view definitions without reading 20-page manuals during active incidents.
Internal Working & Mechanics
1. Essential SAP Basis T-Codes:
- DB02: Database Performance, Table Sizes & Memory Cockpit
- ST04: DBA Cockpit & Performance Monitor
- SM50 / SM66: Local & Global Application Work Process Monitor (DIA, BGD, UPD)
- SM12: SAP Enqueue Lock Entries Management
- ST22: ABAP Short Dump Analysis (DBIF_RSQL_SQL_ERROR, TSV_TNEW_PAGE_ALLOC_FAILED)
- BDLS: Logical System Name Conversion post-refresh
- SLICENSE: SAP License Key Management
- SECSTORE: Secure Storage Configuration
- SM59: RFC Destination Management
2. Core Dynamic Monitoring Views (SYS.M_*):
- M_SERVICES: Host, active ports, process IDs, coordinator types
- M_SERVICE_MEMORY: Resident memory, Used memory, Effective Allocation Limit (GAL)
- M_HOST_RESOURCE_UTILIZATION: Host physical RAM, free RAM, swap used, CPU%
- M_ACTIVE_STATEMENTS: Statements currently executing in memory right now
- M_BLOCKED_TRANSACTIONS: Lock contention, holding connections, wait times
- M_EXPENSIVE_STATEMENTS: Statements exceeding duration/memory thresholds
- M_DELTA_MERGE_STATISTICS: Merge execution history, durations, error codes
- M_BACKUP_CATALOG: Full, differential, and redo log backup history
- M_SYSTEM_REPLICATION: HSR connection state, sync mode, backlog size
3. Port Quick Reference Matrix:
- 3<NR>13: SystemDB SQL Listener
- 3<NR>15: Default Tenant SQL Listener
- 3<NR>01: Nameserver Internal Port
- 3<NR>03: Indexserver Internal Port
- 5<NR>13: sapstartsrv HTTP
- 5<NR>14: sapstartsrv HTTPS
- 1128 / 1129: SAP Host Agent HTTP / HTTPS
Production Best Practices & Operational Risks
Mandatory Best Practices
- Bookmark this quick reference for fast lookup during high-stress production on-call rotations.
- Always use hdbsql with encrypted hdbuserstore keys instead of hardcoding passwords.